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_userONa1agl_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
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
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.
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
Log in to reply to this topic.