1054 Unknown column 'rel.itemid'

ggppdk
Offline
Administrator

9 years 2 months ago #52495 by ggppdk

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

Hello

you said it is a new web-site maybe you tested some software in it ?

since you have no backup, do this:

1. rename table in phpmyadmin to 'wroong_table1' (just in case it is needed)

2. execute in phpmyadmin:

Code:

CREATE TABLE IF NOT EXISTS `#__flexicontent_cats_item_relations` (
  `catid` int(11) NOT NULL default '0',
  `itemid` int(11) NOT NULL default '0',
  `ordering` int(11) NOT NULL default '0',
  PRIMARY KEY  (`catid`,`itemid`),
  KEY `catid` (`catid`),
  KEY `itemid` (`itemid`)
) ENGINE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;

3. logout-relogin in backend and visit FLEXIcontent dashboard

only secondary category assignments were lost, the main category of items should be ok

-- 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.