When adding a page I get a DB error

[tscargo]

Database error in vBulletin 4.0.3:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO adv_pages
(`title`, `name`, `displayorder`, `meta`, `parentid`, `navpos`, `navchildren`, `styleid`, `active`, `customize`, `type`, `advanced`, `useshell`, `modules`, `custom_title`, `colspan`, `formcode`, `userperms`, `dateline`)
VALUES
('test', 'test', '1', 'a:2:{s:8:\"keywords\";s:4:\"test\";s:11:\"description\";s:5:\"tesst\";}', '0', '', '0', '0', '1', '0', 'module', 'N;', '0', 'a:1:{i:2;a:2:{i:6;i:10;i:12;i:20;}}', '', '0', '', '4,6,8,14,13,12,9,7,2,5,1,3', '1271859545');

MySQL Error : Unknown column 'navpos' in 'field list'
Error Number : 1054
Request Date : Wednesday, April 21st 2010 @ 04:19:05 PM
Error Date : Wednesday, April 21st 2010 @ 04:19:05 PM
Script : http://xxx/admincp/vba_cmps_admin.php
Referrer : http://xxx/admincp/vba_cmps_admin.php?do=addpage&type=module
IP Address : 1.2.3.4
Username : Taco
Classname : vB_Database_MySQLi
MySQL Version : 5.0.77

Running vB 4.0.3 and VBA 4.0.0 RC1

[Brian]

Did you run the Upgrade option from the admincp/vbacmps_install.php file?

[Our Sponsors]

[tscargo]

Yes I did....

[tscargo]

But when I did that it indicated "You are already running the current version of vBadvanced CMPS!"

[Our Sponsors]

[Brian]

Can you run this query via phpMyAdmin or your Admin CP and post the results here?
SELECT * FROM adv_setting WHERE varname = 'portal_version';

[tscargo]

varname grouptitle value defaultvalue optioncode displayorder serialize
portal_version adv_portal_main 4.0.0 RC1 4.0.0 RC1 hidden 0 0

[tscargo]

I tried upgrading to 4.0.0 but got database errors again about missing navpos.

[Brian]

Ahh, I think I see the issue. I'm guessing you were upgrading from v3.2.2? If so, it looks like there was a small bug that would have prevented the install file from adding those columns to your 'adv_pages' table during the upgrade. You should be able to correct the problem by running the following query:
UPDATE adv_setting SET value = '3.2.1' WHERE varname = 'portal_version';

After running that query, run the Upgrade option again from the admincp/vbacmps_install.php file and it should take care of the issue.

[tscargo]

That must have been the reason, all works fine now. Thank you very much.
As I am now doing a test-migration, do you advise me to run this query on the vB3 installation before the upgrade of vB and vbSEO ?

Thanks,

Taco

[Brian]

It wouldn't hurt to run that on your live site.