vb.org Archive

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 02:13 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01032 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