Helix 3 And SP Image Gallery Error
Jim Simms
Helix 3 Joomla 3.10.6 SP Page Builder Pro 3.8.0 PHP 8.0
I am getting the following error and don't know how to proceeed
"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 ') ORDER BY id ASC' at line 3"
website url: https://madeintheusamichigan.com/index.php/in-store-items
I have already reached out to the hosting company, they recommened to reach out to component provider.
Rashida Rahman
Accepted AnswerHi there!
Sorry for the inconvenience!
You can try the following:
-
Please take a full site backup first in order to prevent any data loss.
-
Please uninstall your SP Simple Portfolio component by 1st unpublishing your module/extension (from the Extensions\Modules tab) and trashing it.
-
Then go to Extensions tab again and navigate to "Manage" and find your SP Simple Portfolio extension, then unpublish it and then 'Uninstall' from menu option.
-
Download a fresh copy / package of the SP Simple Portfolio Extension from JoomShaper's Extensions Download page and reinstall, then recreate a module, and its content.
PS: you are basically then disassociating the original database associated with the template and allowing the Extension upon new installation to recreate a new / blank database that will work with current version of template.
If the error persists, please go to this location: templates\Your_Template\html and rename mod_spsimpleportfolio folder if there any. Then check your issue.
Hope this helps!
Note: Please take a full site backup before trying anything! Your SP Simple Portfolio modules can be lost, so you need to recreate the modules later, but items will remain safe!
Moreover, PHP 8 is not compatible with Helix3 yet, please downgrade your PHP version to 7.3/7.4.
Best Regards