Categories

Resolved Error: SQLSTATE[42000]: Syntax error or access violation

  1. New
  1. mmsarki
    mmsarki
  2. RO CSVI
  3. Wednesday, 14 January 2026
  4.  Subscribe via email
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
Attachments (1)
com_csvi.log.124.zip
0
Accepted Answer
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. 2 hours ago
  2. RO CSVI
  3. # Permalink
Sorry, the discussion is currently locked. You will not be able to post a reply or a comment at the moment.