Problem after installation of v3.2.0-dev-build2

More
8 years 9 months ago - 8 years 8 months ago #67608 by BusinessCorsair
Hello. I have a problem after installation flexicontent latest version or Flexicontent dev.

If I install latest version I have a problem when click to Components - Flexicontent - there is message The page isn't working HTTP Error 500.

If I install flexicontent master (dev) I don't have problem "cant display this page" but when I open Flexicontent Dashboard first time, I need to "update" and when I try to update Creat DB Indexies I have error and see message
Code:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IGNORE TABLE `#__flexicontent_favourites` ADD UNIQUE `unique_rec`(`itemid`, `' at line 1

PHP 7, Mysql 5.7.18 Joomla 3.7.2

There are no problems if I am using CGI but I want to use Apache.
Last edit: 8 years 8 months ago by ggppdk.

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

More
8 years 9 months ago - 8 years 8 months ago #67671 by ggppdk
Hello

For testing v3.2.0-dev

please use the new BETA2 or later that we have at github:
github.com/FLEXIcontent/flexicontent-cck/releases


-- 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 review. Thanks!
Last edit: 8 years 8 months ago by ggppdk.

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

More
8 years 8 months ago - 8 years 8 months ago #67920 by charlynancy
Hi,
i confirm the same issue on j3.7.2- new install :

when I try to update Creat DB Indexies I have error and see message
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IGNORE TABLE `#__flexicontent_favourites` ADD UNIQUE `unique_rec`(`itemid`, `' at line 1

with FLEXIcontent v3.2.0-dev-build2 21-Jun-2017
Not with : v3.2.0-dev-build1
Last edit: 8 years 8 months ago by ggppdk.

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

More
8 years 8 months ago - 8 years 8 months ago #67921 by charlynancy
I believe that something happens with commits between 7 jun and 11 jun.
Perhaps : Some fixes / cleanups related to the new common base model
I hope this could help you Georgios
Last edit: 8 years 8 months ago by ggppdk.

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

More
8 years 8 months ago - 8 years 8 months ago #67922 by ggppdk
Hello

the ALTER IGNORE TABLE is not supported by newer mysql versions

but i have made a fix on 19 of July and that is it that is included in
FLEXIcontent v3.2.0-dev-build2 21-Jun-2017

Can you redownload it ? and retry ?


-- 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 review. Thanks!
Last edit: 8 years 8 months ago by ggppdk.

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

More
8 years 8 months ago - 8 years 8 months ago #67924 by charlynancy
i redownload it and retry... and now all is all right :)
My mysql version is : Ver 14.14 Distrib 5.7.18, for Linux (x86_64)
Last edit: 8 years 8 months ago by ggppdk.

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

More
8 years 8 months ago - 8 years 8 months ago #67925 by ggppdk
Hello

the "build2" get also a date part

so you have :
FLEXIcontent v3.2.0-dev-build2 11-Jun-2017
FLEXIcontent v3.2.0-dev-build2 15-Jun-2017
FLEXIcontent v3.2.0-dev-build2 21-Jun-2017

but with the same tag:
v3.2.0-dev-build2

- doing the above to avoid having too many PRE-releases being inside github releases list (creating multiple TAGs, and deleting them later is not convenient, because old tags can be recommited by people with "write" privelege in github repository)


-- 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 review. Thanks!
Last edit: 8 years 8 months ago by ggppdk.

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

More
8 years 8 months ago #67933 by charlynancy
Ok, i understand finally my mistakes on Git :
When you arrive on the flexi page on git : github.com/FLEXIcontent/flexicontent-cck
Default branch is master
Instead of the master branch, i should select the Active branches "3.2.x-stable"

That seems to be evident but i am afraid that other users make the same mistake

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

More
8 years 8 months ago #67934 by ggppdk
Hello

they are currently the same except for some new features
(should be unless we miss some commit)

differences are APPs import / export and reviews
(and reviews has been moved to be included in v3.2.x too)


-- 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 review. Thanks!

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

More
8 years 8 months ago - 8 years 8 months ago #67954 by charlynancy
Hi Georgios,
Last time i was not enough precis and i did not see something about this matter.

1°) with MySQL 5.5.55 no problem / with MySQL 5.7.18 the problem happens

2°) with MySQL 5.7.18 when the problem happens :

a) in POST INSTALLATION message :"Create DB indexes (this may take a long time on big web-sites,...)
# tables: 1 :
flexicontent_favourites (1 indexes missing)

b) when you click on update , this warning appear : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IGNORE TABLE `#__flexicontent_favourites` ADD UNIQUE `unique_rec`(`itemid`, `' at line 1

c) If you click on refresh , you don't have more warning message

So the problem is perhaps solved, i don't know
If i reinstall i have again the points a) b) and c) above

I searched about your fix of the 19 jun , i think it's this fix :
Started work for integrated FLEXIcontent fields into Joomla article form
and this part :
Code:
+ // Allow dropping of duplicate rows using ALTER IGNORE TABLE + $query = "SET session old_alter_table=1"; + $db->setQuery($query); + $db->execute(); + foreach($index_cmds as $index_type => $index_clause) { $query = "ALTER IGNORE TABLE `#__".$tblname."` ";
But i see always the "ignore" command
Last edit: 8 years 8 months ago by charlynancy.

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

Moderators: vistamediajoomlacornerggppdk
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
Save