Error in your SQL syntax; MySQL server version for the right syntax to use near ') ORDER BY `lft` ASC' - Forum | JoomShaper
Awaiting an answer SP Page Builder

Error in your SQL syntax; MySQL server version for the right syntax to use near ') ORDER BY `lft` ASC'

Asked by Matthias Schulz 4 years ago Last activity 4 years ago

Hi,

after updating from SP PB 3.8.8 to 4.0.4 I get the following error:

1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY `lft` ASC' at line 3

Any idea how to solve it?

7 replies

Matthias Schulz Asked this

Hi Ariba,

unfortunatly this doesn't help. I don't use any manual SQL scripting. Just straight forward standard extensions (only very few) und a template from ltheme.com. As I don't have any issues with 3.8.8 I gues it relatse to changes in 4.0.x.. If I try to get any SP PB created page directly I get an error 500.

Any other ideas? Thanks.

Ariba Staff

Have you tried the following?

  • Disable rocket_loader if you use cloudflare.
  • Disable mod_security from hosting provider.
Matthias Schulz Asked this

Hi Ariba,

I don't use rocket_loader and disabled mod_security although I think, it's not a good idea to switch off security functionalities. However, no change. still have the same issues.

Thanks

Ariba Staff

Please share your admin access. Use the hidden mode to share the log in credentials.

Matthias Schulz Asked this

Hi Ariba,

please find details below

Ariba Staff

Hello Matthias

My apologies for the unwanted delay. Could you please check your url and give access of it to Bangladesh? I cannot open it from my end.

1-location-access-denied.JPG

Log in to reply.