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