1054 Unknown column 'rel.itemid'

ggppdk
Offline
Administrator

10 years 11 months ago #52478 by ggppdk

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

Hello

someone or something has overwritten the table

the table is overwritten with non-FLEXIcontent data,

the DB SCHEMA of the table is that of Joomla smart search "terms" table

these columns do not exist anywhere inside FLEXIcontent code

all table data are gone !

did you or anyone else made any updates recently via phpmyadmin, etc ?

did you update Joomla recently ?
other software ?

did you run any backup / restore software or made other work on th DB?

-- 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 review. Thanks!

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

KingoftheRoad
Topic Author
Offline
Senior Member

10 years 11 months ago #52491 by KingoftheRoad

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

I did not and don't have any cue.

Thanks so much.

Seth

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

ggppdk
Offline
Administrator

10 years 11 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

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