MySQL Error

[xhells21]

Hello guys,

Since i moved my forum to a new VPS this is what i get 24/7:

Database error in vBulletin 4.2.3:

Invalid SQL:
SELECT parent.nodeid, parent.styleid, parent.layoutid from cms_node AS node	INNER JOIN cms_node AS parent ON (node.nodeleft >= parent.nodeleft AND node.nodeleft <= parent.noderight)
WHERE node.nodeid = 
ORDER BY parent.nodeleft DESC ;;

MySQL Error : 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 parent.nodeleft DESC' at line 3
Error Number : 1064
Request Date : Saturday, August 13th 2016 @ 07:20:47 AM
Error Date : Saturday, August 13th 2016 @ 07:20:47 AM
Script : http://forums.insanityflyff.com/list.php?author/10282-Eurydice
Referrer :

Did anyone else experience and fix this matter?

Thanks a lot for looking at my topic

[Lynne]

I would suggest doing a database backup of your site and then running admincp > vBulletin CMS > Verify and Repair Node Table

[xhells21]

Hello
I tried it and i get this :

No CMS View Permission

[Lynne]

You got that when you clicked on Verify and Repair Node Table ? Are you a Super Administrator on the site?

[xhells21]

Hello,

Yes my user is with rights on all the special administrator things, including query, undeletableusers and so on...

[Lynne]

Then you shouldn't be getting any error trying to view any page in the admincp. I would suggest asking your host if they have mod_security or suhosin enabled on your server.

[xhells21]

Originally Posted by Lynne

Then you shouldn't be getting any error trying to view any page in the admincp. I would suggest asking your host if they have mod_security or suhosin enabled on your server.

Hello
i did not find those on my server installed
http://prntscr.com/c6p8mj

[TheLastSuperman]

Originally Posted by xhells21

Hello
i did not find those on my server installed
http://prntscr.com/c6p8mj

Ask them regardless, there may be options you're not privy to see. Also the screenshot is very blurry, next time please do not "screenshot" via phone or camera, you can use the "Print Screen" button on your keyboard, open MS Paint or your image editor of choice then paste (or CTRL+V) then save as an image and upload OR alternatively you could have copied and pasted the entire list shown in the picture to this thread via mouse i.e. highlight text/copy/paste.

[Mattwhf]

Checking cms_node from your forum, i think the error came from there

what is cms_node on your forum?

[Paul M]

Its a problem with your cms data - basically you dont have a root node in your cms_node table.