Results 1 to 7 of 7

Thread: Database Error While Installing

  1. #1
    Join Date
    Aug 2009
    Posts
    2

    Default Database Error While Installing

    I got the following error when installing the latest vbAdvanced

    Code:
    Database error in vBulletin 4.0.2:
    
    Invalid SQL:
    UPDATE adv_pages SET
    
    ### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    	`title` = 'Homepage',
    	`displayorder` = '0',
    	`meta` = 'a:2:{s:8:\"keywords\";s:0:\"\";s:11:\"description\";s:0:\"\";}',
    	`parentid` = '0',
    	`navpos` = '',
    	`navchildren` = '0',
    	`styleid` = '0',
    	`active` = '1',
    	`customize` = '0',
    	`type` = 'module',
    	`name` = 'home',
    	`advanced` = 'N;',
    	`useshell` = '0',
    	`modules` = 'a:3:{i:1;a:6:{i:14;i:10;i:1;i:20;i:2;i:30;i:8;i:40;i:10;i:50;i:7;i:60;}i:2;a:3:{i:9;i:10;i:4;i:20;i:5;i:30;}i:3;a:4:{i:3;i:10;i:6;i:20;i:11;i:30;i:13;i:40;}}',
    	`custom_title` = '',
    	`colspan` = '0',
    	`formcode` = '',
    	`userperms` = '6,8,7,2,5,1,3,4',
    	`dateline` = '1268270618'
    WHERE pageid = 1;
    
    MySQL Error   : Unknown column 'navpos' in 'field list'
    Error Number  : 1054
    Request Date  : Thursday, March 11th 2010 @ 12:23:38 PM
    Error Date    : Thursday, March 11th 2010 @ 12:23:38 PM
    Script        : http://thraxmedia.com/forum/admincp/vba_cmps_admin.php
    Referrer      : http://thraxmedia.com/forum/admincp/vba_cmps_admin.php?do=editpage&pageid=1
    IP Address    : 115.69.5.203
    Username      : thrax
    Classname     : vB_Database_MySQLi
    MySQL Version : 5.1.37-1ubuntu5.1
    If I re-run all parts of the install, they complete without failure, and in my AdminCP I can see/change all CPMS options - however trying to load the main page I get this error.

    Code:
    Warning: require_once(./includes/vba_cmps_include_template.php) [function.require-once]: failed to open stream: No such file or directory in /var/www/index.php on line 43
    
    Fatal error: require_once() [function.require]: Failed opening required './includes/vba_cmps_include_template.php' (include_path='.:/usr/share/php:/usr/share/pear') in /var/www/index.php on line 43
    Please help

  2. #2
    Join Date
    Aug 2009
    Posts
    2

    Default

    By the way, this is a fresh/empty install of vBulletin as well - there's nothing to screw up.

  3. #3
    Join Date
    Dec 2009
    Posts
    3

    Default

    did you edit your index.php file to point to the correct forum path?

    // ============================================
    // Enter the full path to your forum here
    // Example: /home/vbadvanced/public_html/forum
    // ============================================

    $forumpath = '';

  4. #4
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default

    Thank you for pointing this out. It looks like the new table columns were not added during a new install and that's what's causing the database error. I've just updated the admincp/vbacmps_install.php file in the download package here, so if you will download the files again and update that one on your server, you should be able to complete the installation. Note that you may need to run the Uninstall option from the install file to remove the tables that were added before reinstalling.
    Frequently Asked Questions
    CMPS Users Manual

    For vBadvanced software assistance, please use the support forums.
    Unsolicted PMs, IMs, and email will not be responded to.
    If you have a non-software related question or problem with your account, please submit a support ticket.

  5. #5
    Join Date
    Apr 2009
    Posts
    2

    Default

    I've downloaded the files about an hour ago and I have done the unistall/ reinstall process several times but I'm still getting the error.

    Code:
    Warning: require_once(./includes/vba_cmps_include_template.php) [function.require-once]: failed to open stream: No such file or directory in /home/panth8/public_html/test_home/index.php on line 43
    
    Fatal error: require_once() [function.require]: Failed opening required './includes/vba_cmps_include_template.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/panth8/public_html/test_home/index.php on line 43
    Any suggestions?

  6. #6
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default

    Have you tried the suggestions from our FAQ?
    http://www.vbadvanced.com/forum/faq....ble_inctmpfile
    Frequently Asked Questions
    CMPS Users Manual

    For vBadvanced software assistance, please use the support forums.
    Unsolicted PMs, IMs, and email will not be responded to.
    If you have a non-software related question or problem with your account, please submit a support ticket.

  7. #7
    Join Date
    Apr 2009
    Posts
    2

    Default

    At first I thought, yes I followed all instructions something else must be wrong. But I went back in and looked at the index file, sure enough I left off a critical piece. Since I upload to test section first I forgot the /home. Thank you for your help and sorry to bother with such a minor problem. The update is working great on my test and live forums.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Database error after installing backup.
    By Dutch_Boy in forum Troubleshooting & Problems
    Replies: 2
    Last Post: 08-19-2009, 04:22 PM
  2. DATABASE error after installing VBADVANCED
    By snivvle in forum Troubleshooting & Problems
    Replies: 2
    Last Post: 07-19-2007, 03:06 PM
  3. Error when installing:
    By IrishTechTalk in forum Troubleshooting & Problems
    Replies: 2
    Last Post: 09-18-2006, 12:22 PM
  4. SQL Error after installing
    By kyle in forum Troubleshooting / "How do I..." Questions
    Replies: 1
    Last Post: 12-18-2004, 11:54 AM
  5. Database Error installing script
    By GIO in forum Troubleshooting / "How do I..." Questions
    Replies: 4
    Last Post: 11-06-2004, 03:58 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •