My website is using Joomla 5x and sp page builder 3x. i decided to update SPPB 5 and installed the latest version. after install the SPPB v5.4.4. i got the following error in front end.
"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 BYlftASC' at line 3"
How to fix it?
Hi there!
Thank you for bringing this to our attention, and I sincerely apologize for the inconvenience caused.
To assist you more effectively, may I kindly request temporary administrative access to your site? This will allow me to thoroughly investigate and resolve the issue for you.
Before sharing the credentials, I strongly recommend taking a complete backup of your site to ensure all data remains secure.
Looking forward to your response.
Best regards
Hello,
As just agreed in the email to post in this existing ticket.
Can you please help me?
When i try to edit a text block in SP Page Builder Pro i get an empty screen.
You already have my login for the admin.
see hidden content
Please contact with your hosting provider and ask them to increase the Maximum upload size
Hi Atick,
I have changed it to 64 mb.
Hi Atick, did you see my last message about the maximum upload size?
Yes, I'm working on your issue. Regarding the text addon not working due to using of Joomla 5. You can check this in our documentation. As you are using Joomla 5, you have to use SP Page Builder 5.
Ok, thanks in advance, do you let me know when it's resolved?
I'm working on it, it will take some time
Could you provide me your server access?
yes, of course, do you mean the ftp?
this is my ftp account
Check the hidden content
can you see the ftp account in the hidden content?
Yes
Please check now. I have updated you site to the latest Joomla and SPPB version.
Hi Atick,
What is the admin password?
The password seems to be changed.. can you tell me what te new password is?
Sorry, i forget you can not see the hidden content as it is not your post. The password is : admindemo321. please change it as soon as you login, because now the password is visable to to all the user. Hope you understand
It seems all to work, thx!
I'am missing the slideshow, i have checked the settings but i can't find why it isn't showing!
Do you have any ideas?
Please clear your browser cache and check again.
Is the issue solved?
Hi Atick,
Yes, the issue is solved.
Thank you so much for your help, you're the best!
Best regards, Reinder
Hi Reinder,
Thank you for the update! I'm glad to hear the issue has been resolved. It was a pleasure assisting you. If you need any further help, feel free to reach out anytime.
Best regards
