update Flexocontent With content

More
7 years 1 month ago #66097 by phdh
I updated my website to Joomla 3.6.5 and it seems that all is OK in front.
Bet I can't any more access to the admin of FlexiContent.

I got this error

1267 - Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT COUNT(*)...

It seems also that is a well known error,
And i understood that I must update fleicontennt too.

But I would not lost my content witch is important.

How Can I do that.
If I install directly flexiContent as a new component, will I lost my content or not ?


Thank you for your answer
this problem seems known but I found really the answer

Pierre

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

More
7 years 1 month ago - 7 years 1 month ago #66103 by ggppdk
Hello

you need FLEXIcontent v3.1.1 (or later) with Joomla 3.6.5

Do you have FLEXIcontent v3.1.1 ?

Note to upgrade an existing site that already has FLEXIcontent,
you only need to upload new FLEXIcontent package via Joomla installer


-- 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...
Last edit: 7 years 1 month ago by ggppdk.

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

More
7 years 1 month ago #66130 by phdh
Thank you for your answer.

I do'nt know the version of my FLEXIcontent, because I have no access to it.
But that I understand is that I have no risk to lose my content.

Pi

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

More
7 years 2 weeks ago #66577 by phdh
So I continue to try update my site.
I updated Flexicontent with this release : "flexicontent-cck-3.1.1" (Joomla 3.6.5)

And when I finished installation, I got a new error :
Code:
Créer les indexs de DB (in french) Create DB index ?

Code:
Multiple primary key defined SQL=ALTER TABLE `#__flexicontent_fields_item_relations` ADD INDEX value_integer(`value_integer`), ADD INDEX value_decimal(`value_decimal`), ADD INDEX value_datetime(`value_datetime`), ADD PRIMARY KEY(`field_id`, `item_id`, `valueorder`, `suborder`)

So I tried directly with PHP MyAdmin
Code:
ALTER TABLE `jnea_flexicontent_fields_item_relations` ADD INDEX value_integer(`value_integer`), ADD INDEX value_decimal(`value_decimal`), ADD INDEX value_datetime(`value_datetime`), ADD PRIMARY KEY(`field_id`, `item_id`, `valueorder`, `suborder`) MySQL answer Documentation #1072 - Key column 'value_integer' doesn't exist in table

Should I create column in this Table before ?

It works soon better .

Thank you for your answer
Pi.

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

More
7 years 2 weeks ago #66608 by pierreHaut
So I tried to do SQL Request with phpMyAdmin
I added the Columns value_integer On jnea_flexicontent_files



ALTER TABLE `jnea_flexicontent_fields_item_relations` ADD INDEX value_integer(`value_integer`), ADD INDEX value_decimal(`value_decimal`), ADD INDEX value_datetime(`value_datetime`), ADD PRIMARY KEY(`field_id`, `item_id`, `valueorder`, `suborder`)

So now,I have this Error :
Multiple primary key defined SQL=ALTER TABLE `#__flexicontent_fields_item_relations` ADD INDEX value_integer(`value_integer`), ADD INDEX value_decimal(`value_decimal`), ADD INDEX value_datetime(`value_datetime`), ADD PRIMARY KEY(`field_id`, `item_id`, `valueorder`, `suborder`)

I tried to Re-install FlexiContent But ther is nothing different !

Please What should I do....

Pi

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

More
7 years 2 weeks ago #66618 by ggppdk
Hello

you do not need backend access to FLEXIcontent to upgrade FLEXIcontent to v3.1.1

Just download FLEXIcontent v3.1.1 from here:
www.flexicontent.org/downloads/latest-version.html

Then go to Joomla extension manager and upload it
(NOTE: your maximum file upload should be at least 8 MBytes)


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