Table 'cepneu.j25_flexicontent_advsearch_index' doesn't exis

More
11 years 6 months ago #36868 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.

More
11 years 6 months ago #36884 by ggppdk
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.

More
11 years 5 months ago #37471 by Pitou
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.

More
11 years 5 months ago #37535 by ggppdk
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


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

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.403 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline