Latest post by Lefteris Kavadas on Tuesday, 07 October 2025 14:36 EEST
Hi,
It looks like there’s a small syntax issue in your SQL query — a missing parenthesis before the last ADD KEY.
Please try running the export/import again — sometimes this error occurs due to how the SQL dump is generated.
Also, could you please let me know which tool you’re using to perform the database import/export (e.g. phpMyAdmin, Adminer, or another tool)?
Regards,
Lefteris
Thanks for the clarification!
It seems the error occurred while phpMyAdmin was trying to automatically generate SQL during the “Copy database” operation. Sometimes this happens if phpMyAdmin encounters a table definition it can’t parse correctly.
Please try the copy process again — it might have been a temporary glitch.
Also, could you please confirm which version of phpMyAdmin and MySQL or MariaDB you’re using? This will help me understand why phpMyAdmin generated that incorrect query.
Regards,
Lefteris
Thanks for the details!
Everything looks up to date — you’re using phpMyAdmin 5.2.2 with MariaDB 11.4, so this seems to be a phpMyAdmin quirk rather than a version issue. Occasionally, phpMyAdmin’s “Copy database” feature generates slightly incorrect SQL when a table includes multiple key definitions (like in the CommentBox table).
Please try running the copy again — sometimes it works on a second attempt.
If the same error appears again, I can guide you through an alternative way to copy the database using Export → Import in phpMyAdmin, which avoids this issue completely. Would you like me to send you the exact steps?
Best Regards,
Lefteris
Note: An active subscription is required in order to get support for our paid extensions. For our free extensions, if you don't have an account, register and then submit your support request. In case you just want to ask a question, you can also use the contact form .