Report an issue

Found a bug you'd like to tell us about?
 

 Here’s what to do…Login, Select an ‘Issue Category’ from below and click on the "New Issues” button.

 Please note that support questions will not be handled here. If you need hands on technical support please take out a subscription.

#16 – Critical error when logged in Front End

Posted in ‘ Ark Editor’
This is a public ticket. Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Sunday, 03 May 2015 14:19 BST
fungel

I'm getting issue:

"1271 - Illegal mix of collations for operation 'UNION' SQL=SELECT element AS name,params FROM joom_extensions WHERE folder = 'arkeditor' AND state = 1 UNION ( SELECT name,params FROM joom_ark_editor_plugins WHERE iscore = 1 AND published = 1)"

 

and the website is not operational if I'm logged in front end...

Custom Fields
Server type
Linux
Web server type
Apache
ARK product version
1.4RC2
Joomla! version
3.3.6
PHP Version
 
Web browser
Firefox
Errors log
 
Steps to replicate the issue
I logged in Front End. Then tried to go anywhere on the website and now i get the error message and NOTHING is possible to do on my site...
Sunday, 03 May 2015 14:38 BST
fungel

Even though the default editor was not set as Ark Editor the issue still remained.

I had to uninstall the ARK editor, media and manager extensions for my website to work again...

I'll reinstall if you need so you can identify the issue BUT we'll have to schedule it when I don't need to amend my site...

Thanks, Kyle.

Tuesday, 05 May 2015 09:01 BST
awills

This issue is arising because your database, server, collation is not the same as the table collation. Joomla explict sets the collation for tables to UTF8.  And beacause your database collation is not set to this it means when you do a UNION SQL statement from a Joomla table such as the extensions table and a non Joomla table you will get this issue.

you can run a query like this to see what your server, database collation is set to:

SHOW VARIABLES LIKE 'character_set%';
SHOW VARIABLES LIKE 'collation%';

This ticket is closed, therefore read-only. You can no longer reply to it. If you need to provide more information, please open a new ticket and mention this ticket's number.
WebxSolution Ltd is not affiliated with or endorsed by the Joomla! Project or Open Source Matters. The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.

Copyright © 2009 - 2016 WebxSolution Ltd
Powered by JoomlaWired