Error message items_versions

Rooney
Topic Author
Offline
Moderator

11 years 11 months ago #25569 by Rooney

Error message items_versions was created by Rooney

Hi,

after the last update I am getting the following error in the backend from time to time:

Code:

Table 'xxx_flexicontent_items_versions' doesn't exist SQL=SELECT c.id,c.version,iv.version as iversion FROM xxx_content as c LEFT JOIN xxx_flexicontent_items_versions as iv ON c.id=iv.item_id AND c.version=iv.version JOIN xxx_categories as cat ON c.catid=cat.id WHERE c.version > '1' AND iv.version IS NULL AND cat.extension='com_content' LIMIT 0,1

I have to repair permissions then and refresh. Joomla 2.5, latest FC build.

Anyone else having this issue? Everything else works fine.

Rooney

Joomla! 3.9.24 and FC 3.3.9

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

ggppdk
Offline
Administrator

11 years 11 months ago #25582 by ggppdk

Replied by ggppdk on topic Error message items_versions

Someone or something deleted this table, or it is corrupted, check with phpmyadmin,

for now, try to recreate it in phpmyadmin:
(NOTE replace jjj with your db prefix)

CREATE TABLE IF NOT EXISTS `jjj_flexicontent_items_versions` (
`version` int(11) NOT NULL default '0',
`field_id` int(11) NOT NULL default '0',
`item_id` int(11) NOT NULL default '0',
`valueorder` int(11) NOT NULL default '1',
`value` mediumtext NOT NULL,
PRIMARY KEY (`version`,`field_id`,`item_id`,`valueorder`),
KEY `version` (`version`),
KEY `field_id` (`field_id`),
KEY `item_id` (`item_id`),
FULLTEXT KEY `value` (`value`),
KEY `valueorder` (`valueorder`)
) ENGINE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;

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