Problem after installation of v3.2.0-dev-build2

More
7 years 5 months ago - 7 years 5 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...
Last edit: 7 years 5 months ago by ggppdk.

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

More
7 years 5 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
7 years 5 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...

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

More
7 years 5 months ago - 7 years 5 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: 7 years 5 months ago by charlynancy.

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

More
7 years 5 months ago #67955 by charlynancy
i tried the changement code below :
Code:
//jca $query = "ALTER IGNORE TABLE `#__".$tblname."` "; $query = "ALTER TABLE `#__".$tblname."` ";

The warning disappear (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)

But i am really not sure that this solution is good :(

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

More
7 years 5 months ago #67956 by ggppdk
Hello

if it runs without IGNORE then Database
did not have duplicates rows, so you did not need it in the first place

the question is if you get error message with Newer builds:
FLEXIcontent v3.2.0-dev-build2 24-Jun-2017

please notice the date above 24-Jun-2017
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...

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

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.907 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