Joomla Extensions Club 20,483 posts

[line49 Friend line49Join date: January 2014Posts: 7Downloads:0Uploads:0]

#194300

Hi,

Joomla 3.2.1, K2 2.6.7, JA K2 Filter 1.1.0

When I try to add values to extra fields I am getting the following error on Save:
1062 Duplicate entry ‘3-49-xfield-‘ for key ‘asset_idx’ SQL=INSERT INTO ms14j_jak2filter_taxonomy (`type`,`title`,`asset_id`,`option_id`,`labels`,`num_items`) VALUES (‘xfield’, ‘xfield: 3-49’, ‘3’, ‘49.238605’, ”, ‘0’)

I have latitude and longitude extra fields, it is the value of the latitude that is: 49.238605. Many of the items will have this value for latitude. Neither are required fields.

How do I avoid/fix this problem?

Thank you.

[HeR0 Friend HeR0Join date: August 2011Posts: 3626Downloads:0Uploads:61 Thanks: 33 Thanked: 588 times in 549 posts]

#520920

The issue relates to database, you could clear all data on ms14j_jak2filter_taxonomy and ms14j_jak2filter_taxonomy_map table then run index function again. If it does not help, please pm me your phpmyadmin credentials, I will help you out.

[line49 Friend line49Join date: January 2014Posts: 7Downloads:0Uploads:0]

#521141

Hi,

Clearing those 2 database tables did not help the problem. Still get the MySQL error when I try to add data to the Latitude extra field.

We now have 2 outstanding issues, the other one was reported here: http://www.joomlart.com/forums/topic/plugins-not-working-on-search-results-page/. The login info and ftp info is the same as what I sent you for the post above.

Thank you for your help.

To produce the error: Add a new listing, Save it, put some data into some extra fields like the address, price and Save, then try to add 49.238605 to the Latitude extra field, then Save. The MySQL error will display now.

[HeR0 Friend HeR0Join date: August 2011Posts: 3626Downloads:0Uploads:61 Thanks: 33 Thanked: 588 times in 549 posts]

#521208

@ Line49, please PM me cpanel info of your site, I will help to debug the root of issue.

[HeR0 Friend HeR0Join date: August 2011Posts: 3626Downloads:0Uploads:61 Thanks: 33 Thanked: 588 times in 549 posts]

#521489

@line49,

Sorry for my late reply, I have fixed issues on your site.
Kindly check again.

[Author]

Posts