Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
FAQ Community Calendar Today's Posts Search

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-12-2014, 04:57 PM
tpearl5's Avatar
tpearl5 tpearl5 is offline
 
Join Date: Nov 2001
Location: PA
Posts: 1,014
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Errors with CMS

I'm stumped with this one and it's driving me nuts...

I had been noticing some weird behavior in my CMS lately, so I ran 'Verify and Repair Node Table'. It said something was fixed then that the node table was repaired. Originally when clicking on Content, Section, and Category manager nothing was shown. There was an option for "Lost and Found', but nothing was in it. When clicking on permissions I get this error:

Quote:
Cannot proceed as no CMS root node could be found.

This is a fatal error that should never occur unless your node table is broken or corrupted. You may need to reinstall the CMS.

So I did the following in this order...
  1. Reinstalled the CMS - didn't work, same errors
  2. clicked Verify and Repair Node Table again - it completed by had no effect
  3. Disabled hooks, and ran repair again - didn't make a difference
  4. Reuploaded all files and ran the update for 4.2.2 pl1 - didn't make a difference, however now I'm able to see options when clicking on 'Change Section' in Content and Section managers, otherwise nothing is displayed.
  5. Now this error appears when clicking Verify and Repair Node Table:
    Quote:
    No required itemid specified when instantiating Model object 'vBCms_Item_Content' on line 207 in /home/site/public_html/vb/model.php
    #0 /home/site/public_html/vb/item/content.php(108): vB_Model->__construct(0, false)
    #1 /home/site/public_html/packages/vbcms/item/content.php(576): vB_Item_Content->__construct(0, false)
    #2 /home/site/public_html/packages/vbcms/dm/node.php(614): vBCms_Item_Content->__construct(0)
    #3 [internal function]: vBCms_DM_Node->validateParent(0, false)
    #4 /home/site/public_html/vb/dm.php(621): call_user_func_array(Array, Array)
    #5 /home/site/public_html/vb/dm.php(488): vB_DM->validate('parentnode', NULL, false)
    #6 /home/site/public_html/packages/vbcms/dm/node.php(763): vB_DM->set('parentnode', NULL)
    #7 /home/site/public_html/packages/vbcms/contentmanager.php(3681): vBCms_DM_Node->set('parentnode', NULL)
    #8 /home/site/public_html/admincp/cms_content_admin.php(450): vBCms_ContentManager::fixNodeLR()
    #9 {main}


    Fatal error: No required itemid specified when instantiating Model object 'vBCms_Item_Content' on line 207 in /home/site/public_html/vb/model.php in /home/site/public_html/vb/vb.php on line 286
  6. Removed any erroneous files from past installs, verifying all files again - didn't make a difference
  7. Checked database and ran repairs on cms tables - didn't make a difference

I'm also now getting this database error consistently:

Quote:
valid SQL:
SELECT parent.nodeid, parent.styleid, parent.layoutid from n_cms_node AS node INNER JOIN n_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
It looks like it's triggering when a user's article post page is accessed. (even though none of the users have any articles, which is silly that the page even exists at all..)

What am I missing here? What is needed in the database that is not there?
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 06:43 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.03609 seconds
  • Memory Usage 2,366KB
  • Queries Executed 12 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (1)post_thanks_box_bit
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)postbit_wrapper
  • (1)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_threadedmode.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete