SP Easy Image Gallery - SQL Error - Question | JoomShaper
SP Page Builder 6 is Here! Learn More →

SP Easy Image Gallery - SQL Error

SB

Stepan Bako

Extension 3 years ago

HI, i installed SP Easy Image Gallery, created album, uploaded images and added as an module to sp buider, but im getting this 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 ') ORDER BY id ASC' at line 3

My DB version: MariaDB 10

can you help me with that? thanks stepan

0
8 Answers
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 3 years ago #42602

Hi 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 Easy Image Gallery 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 Easy Image Gallery extension, then unpublish it and then 'Uninstall' from menu option.

Download a fresh copy / package of the SP Easy Image Gallery Extension from JoomShaper's Extensions Download page and reinstall, then recreate 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

Hope this helps!

Note: Please take a full site backup before trying anything!

Best Regards

0
SB
Stepan Bako
Accepted Answer
3 years ago #42612

HI, thank you for your advice, i did every step you proposed, but nothings changed :( any other idea? thank you stepan

0
SB
Stepan Bako
Accepted Answer
3 years ago #43167

HI, can you please help me with that? Your solution did not worked :( thank you

0
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 3 years ago #43191

Hi there!

Did you choose category there as well? If yes, then kindly give me your admin access to check.

However, would you please recheck the documentation to see you are not missing anything?

https://www.joomshaper.com/documentation/joomla-extensions/sp-easyimagegallery

Best Regards

0
SB
Stepan Bako
Accepted Answer
3 years ago #43196

Hi, i checked, everything seems to be by zhe documentation, the difference is, that in documentation is much more items in Options..

this is the page where i created modul with image gallery https://desop.cyberart.cz/index.php/component/sppagebuilder/?view=page&id=49

thanks

0
SB
Stepan Bako
Accepted Answer
3 years ago #43257

Hi, it seems i solved the problem

0
Rashida Rahman
Rashida Rahman
Accepted Answer
Support Agent 3 years ago #43561

Glad to know that:)

What was the issue?

Please remove your login credentials from your reply, as it is visible to all. So use the hidden content area to share sensitive information with us, then it will be visible to our support agents only.

Best Regards

0
SB
Stepan Bako
Accepted Answer
3 years ago #43582

HI, i really dont know what was the problem, i tried to install some SP Portfolio blocks and the suddenly SP Gallery started to work...

0