Erreur Mysql bloquante après installation

More
9 years 11 months ago #51554 by Arkteion
Bonjour,

Je viens d'installer la version 2.2.0 de flexicontent sur un Joomla 3.3.6
J'ai suivi la procédure post-installation.
Malheureusement maintenant, il m'est impossible d'accéder aux catégories et aux articles dans l'administration .
Le système me renvoit l'erreur suivante: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause SQL=SELECT COUNT(*), c.language FROM t09rn_content as c LEFT JOIN t09rn_categories as cat ON c.catid=cat.id WHERE 1 AND (cat.id IS NULL) LIMIT 0, 10000000
Côté client les quelques articles qui avaient été créés avant l'installation sont visibles.

Version de Mysql: 5.0.44
Version de PHP: 5.3.28

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

More
9 years 11 months ago #51555 by ggppdk
Hello

since this is a new installation of FLEXIcontent (is new right?)

you can safely uninstall FLEXIcontent, because you don't have any FLEXIcontent specific data



now about the error, i will test this query, and check if it will not run in some MySql versions ???


-- 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
9 years 11 months ago #51556 by Arkteion
Yes, it's a fresh installation.
I will uninstall it.
Hope you find the reason and post it. I am very interested to test your component!

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

More
9 years 11 months ago #51559 by micker
c'est vraiment bizarre jamais vu cette erreur
quel est ton serveur ?

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.

More
9 years 11 months ago #51560 by Arkteion
C'est un dédié OVH.
Version de Mysql: 5.0.44
Version de PHP: 5.3.28

Pour tester, je viens de faire une installation également sur un autre site en cours de construction.
L'erreur apparait lorsque l'on veut afficher la liste des articles, que ce soit par le natif "Contenu/Gestion des articles" ou par Flexicontent/Items
Je peux créer un item, mais lors de l'enregistrement, même erreur. Il semble que ce soit vraiment lié à l'appel de la liste des items.

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

More
9 years 11 months ago #51562 by ggppdk
Hello

will test this, and will examining changing the SQL query anyway for upcoming release

Regards


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