vb.org Archive - MySQL Error

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)

- - MySQL Error (https://vborg.vbsupport.ru/showthread.php?t=323236)

xhells21

08-13-2016 05:28 AM

MySQL Error

Hello guys,

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

Code:

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

08-13-2016 03:34 PM

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

xhells21

08-13-2016 04:14 PM

Hello
I tried it and i get this :

No CMS View Permission

Lynne

08-13-2016 10:28 PM

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

xhells21

08-14-2016 06:44 AM

Hello,

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

Lynne

08-14-2016 08:19 PM

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

08-17-2016 02:11 AM

Quote:

Originally Posted by Lynne (Post 2574734)

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

08-28-2016 12:21 AM

Quote:

Originally Posted by xhells21 (Post 2574843)

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

09-04-2016 07:26 PM

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

what is cms_node on your forum?

Paul M

09-04-2016 09:57 PM

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

All times are GMT. The time now is 05:05 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01028 seconds Memory Usage 1,727KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: