1054 Unknown column 'rel.itemid'

KingoftheRoad
Topic Author
Offline
Senior Member

9 years 9 months ago #52454 by KingoftheRoad

1054 Unknown column 'rel.itemid' was created by KingoftheRoad

Hello,

I got an sql error:

Code:

1054 Unknown column 'rel.itemid' in 'field list' SQL=SELECT rel.itemid FROM z1n8r_flexicontent_cats_item_relations AS rel LEFT JOIN z1n8r_content AS i ON i.id = rel.itemid WHERE i.id IS NULL LIMIT 1

Anyone knows how to fix that?

Many thanks.

Seth

Please Log in or Create an account to join the conversation.

KingoftheRoad
Topic Author
Offline
Senior Member

9 years 9 months ago #52455 by KingoftheRoad

Replied by KingoftheRoad on topic 1054 Unknown column 'rel.itemid'

Now, I cannot access to Flexicontent.

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

9 years 9 months ago #52456 by ggppdk

Replied by ggppdk on topic 1054 Unknown column 'rel.itemid'

Hello

check and repair database tables

if the above does not work, restore a backup

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

KingoftheRoad
Topic Author
Offline
Senior Member

9 years 9 months ago #52458 by KingoftheRoad

Replied by KingoftheRoad on topic 1054 Unknown column 'rel.itemid'

Repair does not work.

As it is a new site, I can uninstall the Flexicontent and then reinstall it. Of couse, the data of Flexicontent's fields are all lost.

Anyway, I can start it all over again.

May you tell me is it a well know bug? Can it be fixed in near future?

Many thanks.

Seth

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

9 years 9 months ago #52459 by ggppdk

Replied by ggppdk on topic 1054 Unknown column 'rel.itemid'

Hello

if you go to phpmyadmin

and click on:
z1n8r_flexicontent_cats_item_relations

there should be 3 (INT) columns:
catid, itemid, ordering

and 3 indexes:
PRIMARY: catid, itemid
catid: catid
itemid: itemid

Please Log in or Create an account to join the conversation.