Database Error While Installing

[thraxlol]

I got the following error when installing the latest vbAdvanced

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.

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 :)

[thraxlol]

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

[Our Sponsors]

[grabalane]

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 = '';

[Brian]

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.

[Our Sponsors]

[tankkiller]

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.

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?

[Brian]

Have you tried the suggestions from our FAQ?
http://www.vbadvanced.com/forum/faq.php?faq=vba_trouble#faq_vba_trouble_inctmpfile

[tankkiller]

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.