MySQL Error after updating flexicontent

mcmurdok
Topic Author
Offline
Senior Member

3 years 10 months ago #82112 by mcmurdok

MySQL Error after updating flexicontent was created by mcmurdok

After updating flexicontent I get repeatly the following error at the task "# tables: 1 :flexicontent_reviews (7 indexes missing):"
"InnoDB presently supports one FULLTEXT index creation at a time" (look at the picture)
Is there fix?
Regards
Martin

J3.10.5 / FC4.0.2 / MySQL 5.7.36-log / PHP 7.4.28

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

MinneMicha
Offline
New Member

3 years 8 months ago #82440 by MinneMicha

Replied by MinneMicha on topic MySQL Error after updating flexicontent

Anyone else these problem?
We have the same problem on all Flexicontent 4.0.2 installations.

Press "update" fix it for one or two days, but is repeatly present.

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

micker
Offline
Administrator

3 years 8 months ago #82444 by micker

Replied by micker on topic MySQL Error after updating flexicontent

strange problem can change type of table va phpmyadmin ?

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

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

micker
Offline
Administrator

3 years 8 months ago #82445 by micker

Replied by micker on topic MySQL Error after updating flexicontent

and here you can update to 4.1.1
github.com/FLEXIcontent/flexicontent-cck/releases/tag/v4.1.1

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

MinneMicha
Offline
New Member

3 years 8 months ago - 3 years 8 months ago #82457 by MinneMicha

Replied by MinneMicha on topic MySQL Error after updating flexicontent

Yes we can update via PHPMyAdmin, but first i will try the update.
The next days i can give feedback.

edit: is this a stable version? You really changed the value-output of the image field from array to JSON?

Last edit: 3 years 8 months ago by MinneMicha.

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

micker
Offline
Administrator

3 years 8 months ago #82459 by micker

Replied by micker on topic MySQL Error after updating flexicontent

hello
you can update to 4.1.1
what do you mean about image field
you have 3 modes : db (share image for same user) folder (image is linked to item) and joomla field (linked to joomla native field)

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

MinneMicha
Offline
New Member

3 years 8 months ago - 3 years 8 months ago #82463 by MinneMicha

Replied by MinneMicha on topic MySQL Error after updating flexicontent

To value-topic: we use the value array of the field to build custom output.
With this update the value-content is in JSON-format instead of an array and must be unserialised before.

To the main-topic: the update doesn't solve the problem. Can you say what have to be done in the DB to solve the problem?

Last edit: 3 years 8 months ago by MinneMicha.

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

micker
Offline
Administrator

3 years 8 months ago #82468 by micker

Replied by micker on topic MySQL Error after updating flexicontent

about value in field its a basic behavior, as i know we didn't plan to change anything
about the problem of this topic need a review about ggppdk

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

mcmurdok
Topic Author
Offline
Senior Member

3 years 8 months ago #82477 by mcmurdok

Replied by mcmurdok on topic MySQL Error after updating flexicontent

It seems that flexicontent has a problem to update the indexes of the keys 'title' and 'text' to FULLTEXT in the table '#__flexicontent_reviews'.
Because our table '#__flexicontent_reviews' was empty, it worked to manually drop the table and manually reinstall it with the SQL - statement of the newer flexicontent version (/admin/installation/install.mysql.utf8.sql)

Code:

CREATE TABLE IF NOT EXISTS `#__flexicontent_reviews` (   `id` int(11) NOT NULL auto_increment,   `content_id` int(11) NOT NULL,   `type` varchar(255) NOT NULL DEFAULT 'item',   `average_rating` int NOT NULL,   `custom_ratings` text NULL,   `user_id` int(11) NOT NULL DEFAULT '0',   `email` varchar(255) NOT NULL DEFAULT '',   `title` varchar(255) NULL,   `title_old` varchar(255) NULL,   `text` mediumtext NULL,   `text_old` mediumtext NULL,   `state` tinyint(3) NOT NULL DEFAULT '0',   `approved` tinyint(3) NOT NULL DEFAULT '0',   `verified` tinyint(3) NOT NULL DEFAULT '0',   `useful_yes` int(11) NOT NULL DEFAULT '0',   `useful_no` int(11) NOT NULL DEFAULT '0',   `submit_date` datetime NOT NULL,   `update_date` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',   `checked_out` int(11) unsigned NOT NULL default '0',   `checked_out_time` datetime NOT NULL default '1000-01-01 00:00:00',   `attribs` mediumtext NULL,   PRIMARY KEY  (`id`),   KEY (`content_id`, `user_id`, `type`),   KEY (`content_id`, `type`),   KEY `user_id` (`user_id`),   FULLTEXT KEY `title` (`title`),   FULLTEXT KEY `text` (`text`),   KEY `state` (`state`),   KEY `approved` (`approved`),   KEY `verified` (`verified`),   KEY `useful_yes` (`useful_yes`),   KEY `useful_no` (`useful_no`) ) ENGINE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;

Regards

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