Black Friday 2026 50% off every plan Our biggest deal of the year on #1 Joomla products.
Ends in 12d 21h 16m 05s
Claim 50% off
Solved Templates

Sphere template does not work with SP Page Builder 5

Asked by Artur Bochenek 2 years ago Last activity 2 years ago

Hello

I have been using the Sphere template for a year.

  • Joomla 4.4.3
  • Database version: 10.6.17-MariaDB
  • PHP version: 8.1.27
  • SP Page Builder Pro: 3.8.10

It's time to update SP Page Builder to version 5.2.9 (in the future also to Joomla 5). Unfortunately, after installing a new version of SP Page Builder, the following error message appears:

1064
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 '2) ORDER BY LFT ASC' AT LINE 3

The Joomla backend works well.

I also use the Shaper Helix Ultimate 2.0.18 template on the same page. Subpages based on this template work properly. Only Sphere template pages display this error.

I had to revert to the old version of SP Page Builder.

Please give me tips on how to fix this.

In the hidden message I included information about the website and access to the Joomla backend.

Regards

Accepted answer

Marked as the solution
Toufiq Senior Staff

You should clean Joomla cache.

9 more replies

Toufiq Senior Staff

Hi there,

Thank you for reaching out, and I apologize for any inconvenience caused by this oversight. Where should i go to check this error?

1064 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 '2) ORDER BY LFT ASC' AT LINE 3

For database error, Please provide me phpmyadmin access & FTP access

I appreciate your cooperation and will ensure to get back to you as soon as possible.

Best regards,

Toufiqur Rahman (Team Lead, Support)

Artur Bochenek Asked this
2 years ago · edited

hidden message

Toufiq Senior Staff

Please check now and let me know. Thanks

Artur Bochenek Asked this

Installation of sppagebuilder_pro_v5.2.9 failed.

JInstaller::Instalacja: Error SQL Duplicate column name 'is_favorite'.

The website is not working.

0
FAILED OPENING REQUIRED '/HOME/FODACADEMY/PUBLIC_HTML/ADMINISTRATOR/COMPONENTS/COM_SPPAGEBUILDER/BUILDER/CLASSES/BASE.PHP' (INCLUDE_PATH='.:/OPT/CPANEL/EA-PHP81/ROOT/USR/SHARE/PEAR')

Toufiq Senior Staff

Please check now and let me know. Thanks

Artur Bochenek Asked this

I updated Joomla to version 5.0.3.

Everything works fine, but the Joomla TinyMCE editor does not work.

Toufiq Senior Staff

TinyMCE editor doesn't work means?

Artur Bochenek Asked this

In the Incognito browser, the editor works properly.
Thank you for your help.

Artur Bochenek Asked this
2 years ago · edited

After updating to sppagebuilder_pro_v5.3.0, the error appeared again:

1064
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 '2) ORDER BY LFT ASC' AT LINE 3

Please help

The issue only affects the Sphere template.
The Helixultimate template works well.

I sent access to the server in a hidden message.

Regards

Artur Bochenek Asked this

Please solve my problem. The website is not working.

Artur Bochenek Asked this

Once again, I am asking for help in solving my problem.

Toufiq Senior Staff

Please check now. Thanks

Artur Bochenek Asked this

It's ok. The website is working properly.

Please give me instructions on what was done. I will try to fix this error myself in the future.

Toufiq Senior Staff

The article addon category was selected All category and another category. If you select all category then no need to select another category. Thanks

Log in to reply.