Collation error on custom Ajax file field downloads

  • Posts: 72
  • Thank you received: 4
  • Hikamarket Frontedition Hikashop Business
1 day 16 hours ago #367701

-- HikaShop version -- : 6.0.0
-- Joomla version -- : 4.4.13
-- PHP version -- : 8.2.28
-- Browser(s) name and version -- : Firefox 139.0.4
-- Error-message(debug-mod must be tuned on) -- : Illegal mix of collations

Hey Nicholas,

We've been using the Ajax File custom field on our Product pages to allow downloads of specs and brochures in pdf or jpg formats.

Recently these downloads broke due to header problems introduced in a custom tax plugin we added. We think we've got the header problems fixed. which fixed the downloads....sort of.

We've got an interaction problem with the 4SEO component. When it's turned on instead of the file downloading properly, we get an error page. If we shut 4SEO off the files download properly.

I'd like to keep using 4SEO and get the downloads working. (I've got a ticket into 4SEO as well).

Investigating the 4SEO/download problem we're getting a 1267 collation error...see attached screenshot.

I searched this forum and found a related problem not to long ago... www.hikashop.com/forum/install-update/908982-update-error.html

I checked phpadmin and in our case.... our hikashop tables are a mix of utf8_general_ci and utf8_unicode_ci. our joomla tables are utf8mb4_unicode_ci.

i've run a

hikashop check database and admin tools "repair and optimize tables". The joomla database maintenance tool reports "all structures are up to date".

what are your thoughts and recommendations ?

Thanks,

Dave

Attachments:

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

  • Posts: 84024
  • Thank you received: 13613
  • MODERATOR
1 day 14 hours ago #367702

Hi,

The error you point at in the other thread is similar, but it's not the same. That other thread specifically mentions that the problem happens during the install / update of HikaShop. And I know for a fact that there is only one MySQL query which does a JOIN with potentially a mismatch of collation during that process.
So I could easily point to the tables / columns so that the user could fix them, without even getting the full error message.

However, here, the problem is not during the install /update. While I know you need to fix the collation between two columns of two tables, I don't know which ones. So, the first thing is to activate the debug setting of the Joomla configuration in order to get the full error message of that error on the page with the error.
That way, you'll be able to know which column of which table needs to have the same collation as which column of which table. Then, you can just go in your PHPMyAdmin and fix that.

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

Time to create page: 0.082 seconds
Powered by Kunena Forum