Table 'cepneu.j25_flexicontent_advsearch_index' doesn't exis

gcprnet
Topic Author
Offline
Elite Member

11 years 5 months ago #36868 by gcprnet

Table 'cepneu.j25_flexicontent_advsearch_index' doesn't exis was created by gcprnet

I'm testing an upgrade of my site from J 1.5 to J 2.5 using jupgrade.
After upgrading to J 2.5 I had to reinstall Flexicontent, which I did without any errors.
But now, when I open an article and try to save it, it says:

Code:

Table 'cepneu.j25_flexicontent_advsearch_index' doesn't exist SQL=INSERT INTO j25_flexicontent_advsearch_index (field_id,item_id,extraid,search_index,value_id) VALUES ( 2,5612,0,'2013-04','2013-04'),( 3,5612,0,'test user','150'),( 13,5612,0,'Erneuerbare Energien','299'),( 13,5612,1,'Nachhaltigkeit und Klima','301'),( 13,5612,2,'Wirtschaft und Unternehmen','303'),( 13,5612,3,'Politik','304'),( 13,5612,4,'Cleantech','307'),( 13,5612,5,'Energieeffizienz','341'),( 14,5612,0,'CO2','4'),( 14,5612,1,'Energieeffizienz','64'),( 14,5612,2,'Nachhaltigkeit','74'),( 14,5612,3,'Energie','123'),( 14,5612,4,'Niederlande','656'),( 14,5612,5,'Gebäudesanierung','685'),( 14,5612,6,'Heizung','1009'),( 14,5612,7,'grünes Bauen','1591'),( 14,5612,8,'Erneuerbar','3554')

Any clue, why I'm getting this message? (I know, it's because the table cepneu.j25_flexicontent_advsearch_index is missing (which is indeed the case) but why is it missing?)
Or to put it even another way: Is there any recommended procedure to upgrade from J 1.5 to J 2.5 with sites that have more than 2000 articles?

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

ggppdk
Offline
Administrator

11 years 5 months ago #36884 by ggppdk

Replied by ggppdk on topic Table 'cepneu.j25_flexicontent_advsearch_index' doesn't exis

Try executing this in phpmyadmin (replace #__ with your prefix e.g. jos_)

CREATE TABLE IF NOT EXISTS `#__flexicontent_advsearch_index` (
`sid` int(11) NOT NULL auto_increment,
`field_id` int(11) NOT NULL,
`item_id` int(11) NOT NULL,
`extraid` int(11) NOT NULL,
`search_index` longtext NOT NULL,
`value_id` varchar(255) NULL,
PRIMARY KEY (`field_id`,`item_id`,`extraid`),
KEY `sid` (`sid`),
KEY `field_id` (`field_id`),
KEY `item_id` (`item_id`),
FULLTEXT `search_index` (`search_index`),
KEY `value_id` (`value_id`)
) 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.

Pitou
Offline
Premium Member

11 years 4 months ago #37471 by Pitou

Replied by Pitou on topic Table 'cepneu.j25_flexicontent_advsearch_index' doesn't exis

Hello

I also had the same error after upgrading to 2.0.2 r1680.
Thanks for the code.

++

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

ggppdk
Offline
Administrator

11 years 4 months ago #37535 by ggppdk

Replied by ggppdk on topic Table 'cepneu.j25_flexicontent_advsearch_index' doesn't exis

Hello,

i rechecked this, indeed the installation script does not create the table when upgrading from an old installation that did not have this table

i have made a fix for v2.0.3

regards

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