My SQL error

Permalink
Hi guys,

Hope you can help.

I recently moved server and am getting the following MySql error when I try and add a new page or product.

mysql 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 'LIMIT 1' at line 1] in EXECUTE("select max(cDisplayOrder) from Pages where cParentID = LIMIT 1")

I've asked my server team and they have responded in the following manner

"The syntax error in the EXECUTE("select max(cDisplayOrder) from Pages where cParentID = LIMIT 1") statement indicates that the cParentID is not being selected / added to the SQL query properly (since the cParentID value in the above statement is empty).

As such I would suggest contacting either a developer or concrete5 regarding this issue. If you have any questions or concerns, feel free to let me know."

They have suggested I ask Concrete5 so here I am?

Anyone have any ideas on how to fix this?

Thanks

DeFrae1

 
hutman replied on at Permalink Reply
hutman
Can you tell if this is happening within a block or in some custom code?

The server company is right, the cParentID isn't being passed in to wherever it's supposed to be, but it's impossible to say where this is happening without more information.