Error In Your SQL Syntax; MySQL Server Version For The Right Syntax To Use Near ') ORDER BY `lft` ASC' - Question | JoomShaper
Black Friday sale is live with flat 50% OFF. Sale ends soon! Grab your deal now!

Error In Your SQL Syntax; MySQL Server Version For The Right Syntax To Use Near ') ORDER BY `lft` ASC'

MS

Matthias Schulz

SP Page Builder 3 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?

0
7 Answers
Ariba
Ariba
Accepted Answer
Support Agent 3 years ago #83776

Hello

Apologies for the inconvenience. The 1064 error can have multiple causes, however there are some common reasons that can result in this error. Could you please try the solutions mentioned in the link below and check if it helps you?

https://www.inmotionhosting.com/support/server/databases/error-1064/

0
MS
Matthias Schulz
Accepted Answer
3 years ago #83777

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.

0
Ariba
Ariba
Accepted Answer
Support Agent 3 years ago #83778

Have you tried the following?

  • Disable rocket_loader if you use cloudflare.
  • Disable mod_security from hosting provider.
0
MS
Matthias Schulz
Accepted Answer
3 years ago #83889

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

0
Ariba
Ariba
Accepted Answer
Support Agent 3 years ago #84001

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

0
MS
Matthias Schulz
Accepted Answer
3 years ago #84011

Hi Ariba,

please find details below

0
Ariba
Ariba
Accepted Answer
Support Agent 3 years ago #85594

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

0