Erreur Mysql bloquante après installation

micker
Offline
Administrator

9 years 11 months ago #51568 by micker

Replied by micker on topic Erreur Mysql bloquante après installation

en local sur un serveur wamp ?

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.

Arkteion
Topic Author
Offline
New Member

9 years 11 months ago #51635 by Arkteion

Replied by Arkteion on topic Erreur Mysql bloquante après installation

Hi ggppdk,

Can you tell me when you plan to modify the query.
I must know that to organize the planning of my new project.
Thank you for your answer

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

ggppdk
Offline
Administrator

9 years 11 months ago #51639 by ggppdk

Replied by ggppdk on topic Erreur Mysql bloquante après installation

Hello

this does not happen in later SQL versions, where behaviour can be controlled via SQL variable

ONLY_FULL_GROUP_BY

still the column causing this is not needed there

Test this change:
(i cannot test i don't have this MySQL version)

edit file:
component/com_flexicontent/models/items.php

find these 2 lines (about 420-430):

Code:

$query 	= 'SELECT '. ($count_only ? 'COUNT(*)' : 'c.id, c.title, c.introtext, c.`fulltext`, c.catid, c.created, c.created_by, c.modified, c.modified_by, c.version, c.state')
			. (FLEXI_J16GE ? ', c.language' : '')

replace with 1 line:

Code:

$query 	= 'SELECT '. ($count_only ? 'COUNT(*)' : 'c.id, c.title, c.introtext, c.`fulltext`, c.catid, c.created, c.created_by, c.modified, c.modified_by, c.version, c.state, c.language')

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