Collation error on custom Ajax file field downloads

  • Posts: 74
  • Thank you received: 6
  • Hikamarket Frontedition Hikashop Business
2 weeks 5 days 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: 84102
  • Thank you received: 13637
  • MODERATOR
2 weeks 5 days 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.

  • Posts: 74
  • Thank you received: 6
  • Hikamarket Frontedition Hikashop Business
1 week 6 days ago #367754

Thanks Nicoloas.

For the record it was.... hikashop_field.field_namekey


: D

The following user(s) said Thank You: nicolas

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

  • Posts: 84102
  • Thank you received: 13637
  • MODERATOR
1 week 6 days ago #367755

Thanks.

What was the other column of which table it was trying to JOIN together with that column ?
Or, would you happen to have the MySQL query creating the issue ?
It might help someone else find this thread and solve the problem on his end down the line.

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

  • Posts: 74
  • Thank you received: 6
  • Hikamarket Frontedition Hikashop Business
1 week 5 days ago #367763

Didn’t save it but it was a 4seo table so we matched their collation, utf8mb4_unicode.

The following user(s) said Thank You: nicolas

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

Time to create page: 0.060 seconds
Powered by Kunena Forum