Support is offline. We are back Monday 23 November, 09:00.

Error: SQLSTATE[42000]: Syntax error or access violation #85406

Resolved Locked mmsarki opened this topic Wednesday, 14 January 2026 · 3 replies
Author

Hello,
I have a template for exporting Hikashop orders linked to Joomla users that used to work with the MySQL database, but since the database was migrated to MariaDB, I get the following error when exporting:

Error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(LEFT) JOIN a1agl_hikashop_user ON a1agl_hikashop_user.user_id = `a1a...' at line 8

I am not an expert in database queries. Can you give me some guidance on how to resolve this issue?
I am attaching the log file and the template XML file.
Thank's

Support

Hi,

I see you wrote your custom SQL query and we are no database experts either :D

My guess is that you need to remove the word (GAUCHE) from the query as that is something I have never seen before. Your GROUP BY and ORDER BY is also missing a table name. This most likely will work but might be something you want to check as well.

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

Thank you, indeed there were COM_CSVI_JOIN_TYPE_... strings in the translation file that should not have been translated.
I saw in another post that you were going to do an update tomorrow, so I'm attaching this file that I just corrected.

Support

Hi,

Thank you for the updated file. I will include this in the release tomorrow.

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

This topic is locked. New replies are not possible.

Log in to reply to this topic.