Joomla Extensions Club 20,483 posts

[iafdesign Friend iafdesignJoin date: October 2013Posts: 9Downloads:0Uploads:0]

#207545

When I save a K2 item I get the following message:

1054 Unknown column 'labels' in 'field list' SQL=INSERT INTO bunk_jak2filter_taxonomy (`type`,`title`,`asset_id`,`option_id`,`labels`,`num_items`) VALUES ('category', 'category', '1', '0', 'Bunkhouses', '0')

I’ve tried reinstalling JA K2 filter but I still have the problem. I can add the ‘labels’ field to the taxonomy table but will there be other related problems?

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#574588

Hi there
Please try to create label field into bunk_jak2filter_taxonomy

Thank you,
Viet Vu

[iafdesign Friend iafdesignJoin date: October 2013Posts: 9Downloads:0Uploads:0]

#574625

I’ve added the ‘labels’ column and I’ve now got an entry in the taxonomy table from a K2 item, but now when I update one of the extra fields I get the message

1062 Duplicate entry '3-0-xfield' for key 'asset_idx' SQL=INSERT INTO bunk_jak2filter_taxonomy (`type`,`title`,`asset_id`,`option_id`,`labels`,`num_items`) VALUES ('xfield', 'xfield', '3', '0', '123', '0')

The Joomla version is 3.4.1, PHP is 5.4.28 and the JA K2 Filter is 1.1.9

[Luna Garden Moderator Luna GardenJoin date: July 2011Posts: 2617Downloads:80Uploads:96 Thanks: 78 Thanked: 453 times in 425 posts]

#574701

Hi,

Please ignore the answer of VietVu.

Tried to Re-index in back-end >> component >> JA K2 Filter.

If problem still persist, PM me your site URL, admin account, and FTP account.

[Luna Garden Moderator Luna GardenJoin date: July 2011Posts: 2617Downloads:80Uploads:96 Thanks: 78 Thanked: 453 times in 425 posts]

#641045

Hi,

Please ignore the answer of VietVu.

Tried to Re-index in back-end >> component >> JA K2 Filter.

If problem still persist, PM me your site URL, admin account, and FTP account.

[Luna Garden Moderator Luna GardenJoin date: July 2011Posts: 2617Downloads:80Uploads:96 Thanks: 78 Thanked: 453 times in 425 posts]

#739709

Hi,

Please ignore the answer of VietVu.

Tried to Re-index in back-end >> component >> JA K2 Filter.

If problem still persist, PM me your site URL, admin account, and FTP account.

[iafdesign Friend iafdesignJoin date: October 2013Posts: 9Downloads:0Uploads:0]

#574799

By ignore the previous answer, do you mean I should now delete the column ‘labels’ that I’ve added to the taxonomy table?

[Luna Garden Moderator Luna GardenJoin date: July 2011Posts: 2617Downloads:80Uploads:96 Thanks: 78 Thanked: 453 times in 425 posts]

#574964

<em>@iafdesign 479124 wrote:</em><blockquote>By ignore the previous answer, do you mean I should now delete the column ‘labels’ that I’ve added to the taxonomy table?</blockquote>

Yes, it’s not a right way to fix this issue.

Did you try to re-index ? Could you tell me the result ?

[Luna Garden Moderator Luna GardenJoin date: July 2011Posts: 2617Downloads:80Uploads:96 Thanks: 78 Thanked: 453 times in 425 posts]

#641308

<em>@iafdesign 479124 wrote:</em><blockquote>By ignore the previous answer, do you mean I should now delete the column ‘labels’ that I’ve added to the taxonomy table?</blockquote>

Yes, it’s not a right way to fix this issue.

Did you try to re-index ? Could you tell me the result ?

[Luna Garden Moderator Luna GardenJoin date: July 2011Posts: 2617Downloads:80Uploads:96 Thanks: 78 Thanked: 453 times in 425 posts]

#739970

<em>@iafdesign 479124 wrote:</em><blockquote>By ignore the previous answer, do you mean I should now delete the column ‘labels’ that I’ve added to the taxonomy table?</blockquote>

Yes, it’s not a right way to fix this issue.

Did you try to re-index ? Could you tell me the result ?

[iafdesign Friend iafdesignJoin date: October 2013Posts: 9Downloads:0Uploads:0]

#575335

re-indexing did not make any difference, I still get the error message.
I am not confident about using JA K2 Filter with these basic problems, surely a column missing from a table is just a simple SQL installation script fault?

[iafdesign Friend iafdesignJoin date: October 2013Posts: 9Downloads:0Uploads:0]

#641665

re-indexing did not make any difference, I still get the error message.
I am not confident about using JA K2 Filter with these basic problems, surely a column missing from a table is just a simple SQL installation script fault?

[iafdesign Friend iafdesignJoin date: October 2013Posts: 9Downloads:0Uploads:0]

#740327

re-indexing did not make any difference, I still get the error message.
I am not confident about using JA K2 Filter with these basic problems, surely a column missing from a table is just a simple SQL installation script fault?

[Luna Garden Moderator Luna GardenJoin date: July 2011Posts: 2617Downloads:80Uploads:96 Thanks: 78 Thanked: 453 times in 425 posts]

#575458

I guess you get this error after upgrade JA K2 filter to latest version. Normally after upgrade, JA K2 filter still work fine, but we don’t understand why the SQL script doesn’t run on your site.
So the best thing is, try to uninstall JA K2 Filter on your site, remove JA K2 Filter table from database and reinstall then re-index.

If it doesn’t work PM me your site URL, admin account and FTP account.

[iafdesign Friend iafdesignJoin date: October 2013Posts: 9Downloads:0Uploads:0]

#575576

This is a NEW 3.4.1 Joomla site with K2 Filter 1.1.9, so there is now upgrade involved. There is hardly any data involved just a few test cases. I have removed and reinstalled but there is still the same problem with missing ‘labels’ column.

[Author]

Posts