Hello,
During the installation or update of SP Page Builder Pro v5.6.1, I encountered the following error:
500 SQL syntax error near ',9,10,11,12,13,14) ORDER BY lft ASC' at line 3" is not valid header value
It appears that a dynamically generated SQL query contains an invalid leading comma before the IN (...) clause, which causes a MySQL 1064 syntax error. This SQL error is then improperly injected into the HTTP headers, triggering a 500 Internal Server Error.
Hi,
Apologies for the inconvenience you're experiencing. The issue you're facing may be related to a mismatch in the database structure prnt.sc/9rGOlWL6KQKK.
To resolve this, please follow these steps:
Update the database structure by navigating to System > Maintenance > Database in your Joomla backend and clicking the “Update Structure” button if prompted prnt.sc/wbEs3rtFFiFa.
Reinstall the latest version of SP Page Builder Pro by downloading it from the following link: SP Page Builder Pro - Latest Version
This should resolve the issue.
And also please check your PHP version. Try PHP 8.2 or 8.3
If the problem persists after following these steps, please let me know. I’ll be happy to investigate further. Thank you for your patience and understanding.
Best regards
Hello,
I have followed all your recommended steps:
The Joomla database structure is fully up to date.
I reinstalled the latest version of SP Page Builder Pro (v5.6.1 – 29 May 2025) from your official website.
My PHP version is 8.2.28 running on Apache/2.4.54 (Win64) with mod_fcgid.
However, the issue still persists. I continue to receive the following error:
500 SQL syntax error near ',9,10,11,12,13,14) ORDER BY lft ASC' at line 3
It looks like a malformed SQL query is being generated with a leading comma in the IN (...) clause, which causes a MySQL 1064 error and then a 500 response due to an invalid HTTP header.
Hi
Could you please keep a full site backup and give me your super admin access?
Hi,
My website is installed locally because it is not yet hoste.
Hi,
As requested, I’ve created a temporary Super Admin account so that you can log in and investigate the issue I’m facing with the installation of SP Page Builder Pro v5.6.1.
You can access the Joomla administrator panel using the following link:
🔗 https://miseajour.oecdjibouti.com/administrator/
Login credentials:
Username: support-joomshaper
Password: Joomshaper@2025Help
Please let me know once your investigation is complete so I can remove this temporary account for security purposes.
Just for your reference, the site is hosted on a subdomain of my main domain (miseajour.oecdjibouti.com) and the server is running PHP version 8.2.28.
It was problem with SPPB 5.6.0 update on PHP 8.1 and below. But it was fixed in SPPB 5.6.1. But if you have PHP 8.4 in theory should be OK. Just remember to clear cache Joomla & Browser. And please share your credentials in the hidden content, not in public area. Please remove it from the public area portion and put it in the hidden content.
Hi,
I’m switching to PHP version 8.4, and some error messages are appearing in the administration interface :
Deprecated: Joomla\CMS\Application\AdministratorApplication::__construct(): Implicitly marking parameter $input as nullable is deprecated, the explicit nullable type must be used instead in /home/c1569237c/public_html/miseajour/libraries/src/Application/AdministratorApplication.php on line 71
Deprecated: Joomla\CMS\Application\AdministratorApplication::__construct(): Implicitly marking parameter $config as nullable is deprecated, the explicit nullable type must be used instead in /home/c1569237c/public_html/miseajour/libraries/src/Application/AdministratorApplication.php on line 71
Deprecated: Joomla\CMS\Application\AdministratorApplication::__construct(): Implicitly marking parameter $client as nullable is deprecated, the explicit nullable type must be used instead in /home/c1569237c/public_html/miseajour/libraries/src/Application/AdministratorApplication.php on line 71
Deprecated: Joomla\CMS\Application\AdministratorApplication::__construct(): Implicitly marking parameter $container as nullable is deprecated, the explicit nullable type must be used instead in /home/c1569237c/public_html/miseajour/libraries/src/Application/AdministratorApplication.php on line 71
Deprecated: Joomla\CMS\Application\CMSApplication::__construct(): Implicitly marking parameter $input as nullable is deprecated, the explicit nullable type must be used instead in /home/c1569237c/public_html/miseajour/libraries/src/Application/CMSApplication.php on line 170
Deprecated: Joomla\CMS\Application\CMSApplication::__construct(): Implicitly marking parameter $config as nullable is deprecated, the explicit nullable type must be used instead in /home/c1569237c/public_html/miseajour/libraries/src/Application/CMSApplication.php on line 170
Deprecated: Joomla\CMS\Application\CMSApplication::__construct(): Implicitly marking parameter $client as nullable is deprecated, the explicit nullable type must be used instead in /home/c1569237c/public_html/miseajour/libraries/src/Application/CMSApplication.php on line 170
Deprecated: Joomla\CMS\Application\CMSApplication::__construct(): Implicitly marking parameter $container as nullable is deprecated, the explicit nullable type must be used instead in /home/c1569237c/public_html/miseajour/libraries/src/Application/CMSApplication.php on line 170
Hi
Did you try PHP 8.3?
Yes, we didn't test our extension on PHP 8.4, so using PHP 8.3 is safer option.
And please remove login details from post, and copy them to "Hidden Content" area (!)
Hi,
I have switched back to PHP 8.3 as recommended, but I’m still encountering the following SQL error:
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 '9,10,11,12,13,14) ORDER BY lft ASC' at line 3.
It seems there might be an issue with the IN clause syntax. Could you please advise if there is an update or fix available for this, or if any specific configuration is required?
Apologies for the inconvenience caused.
I’ve resolved the issue you reported. The problem was related to the configuration of the Articles addon—specifically, both "All Categories" and additional individual categories were selected at the same time, which caused a conflict https://prnt.sc/nI7X0JA8g_1X.
To fix this, I removed the "All Categories" option, as it should not be selected alongside individual categories. The addon is now working as expected.
Please check on your end and let me know if everything looks good.
Best regards
Bonjour,
My website is working properly now, and thank you for your kind support.
You're most welcome! I'm glad to hear your website is working properly now.
If you need any further assistance or have questions in the future, feel free to reach out at any time.
Have a great day!
Please marked the issue as solved.
Best regards
Good evening Atick,
I have just migrated my website from Joomla 4 to Joomla 5 locally, and the entire administration interface is working correctly. However, I’m encountering the same issue that you had previously resolved.
Error message displayed:
"500 Syntax error near ',9,10,11,12,13,14) ORDER BY lft ASC' at line 3"
Could you please guide me once again on how to fix this error?
The problem was related to the configuration of the Articles addon—specifically, both "All Categories" and additional individual categories were selected at the same time, which caused a conflict prnt.sc/nI7X0JA8g_1X.
Hi
Is this resolved now? If yes, you can then close this post by accepting the answer.
Hi,
Thank you, the problem is solved.
Glad to know that. You can now close this post by accepting the answer.
