SQL Syntax Error When Deleting Items In Latest SP Page Builder Update
Marius
Dear SP Page Builder Support Team,
I recently updated to the latest version of SP Page Builder in Joomla, and I am encountering an issue when attempting to delete elements. The following error message appears:
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 'AS collection_item WHERE collection_item.id IN (4)' at line 2
This suggests a possible syntax issue in the SQL query. I am currently using:
Joomla version: Joomla! 5.2.3 Stabl] SP Page Builder version: 5.5.0 MariaDB version: 10.6.18-MariaDBa PHP version: 8.2.27 Could you please provide guidance on resolving this error?
Thank you for your assistance.
Best regards,
Asfakur Rahman Saikat
Accepted AnswerHi Marius,
Thank you for reaching out, and sorry for the inconvenience.
Could you please specify which element deletions caused this issue? It would also be helpful if you could provide a screenshot for reference.
Additionally, the username and password you provided are not working—perhaps they haven't been activated yet?
I look forward to your response.
Best regards
Marius
Accepted AnswerCould you please specify which element deletions caused this issue? It would also be helpful if you could provide a screenshot for reference.
Apologies, I wasn't clear enough. I am referring to the Dynamic Content elements. I created a collection, and within that collection, I added several items. When I try to delete these items completely, I receive the error shown in the screenshot.
Additionally, the username and password you provided are not working—perhaps they haven't been activated yet?
Apologies, the user was not activated. It should be working now.