PDA

View Full Version : Error when trying to save in admin


dreck
05-27-2009, 08:55 PM
I was making some changes to my site today. Then all of a sudden the cmps page quit working. I waited 30 minutes or so thinking it was just a glitch. Nope! So i decided to upgrade to the new version.

Now i cant edit my home page in the admin section:

Database error in vBulletin 3.8.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',
`styleid` = '0',
`active` = '1',
`customize` = '0',
`type` = 'module',
`name` = 'home',
`advanced` = 'a:1:{s:15:\"adv_portal_poll\";a:1:{s:19:\"portal_poll_forumid\";a:0:{}}}',
`modules` = 'a:3:{i:1;a:5:{i:1;i:10;i:2;i:20;i:8;i:30;i:10;i:40;i:7;i:50;}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;}}',
`useshell` = '0',
`custom_title` = '',
`colspan` = '0',
`formcode` = '',
`userperms` = '4,6,8,7,2,5,1,3'
WHERE pageid = 1;

MySQL Error : Unknown column 'customize' in 'field list'
Error Number : 1054
Request Date : Wednesday, May 27th 2009 @ 06:51:39 PM
Error Date : Wednesday, May 27th 2009 @ 06:51:40 PM
Script : http://www.thisdarncar.com/vb/admincp/vba_cmps_admin.php
Referrer : http://www.thisdarncar.com/vb/admincp/vba_cmps_admin.php?do=editpage&pageid=1
IP Address : 65.12.100.218
Username : dreck
Classname : vb_database
MySQL Version : 5.0.75-community-log

Any ideas?

Thanks, dreck

Brian
05-28-2009, 11:31 AM
Looks like you did not run the Upgrade option from the admincp/vbacmps_install.php file.

Our Sponsors
 

dreck
05-28-2009, 01:09 PM
Thanks!

Daryl
07-17-2009, 08:18 AM
I'm also getting this error.

But do I have to upgrade since this was a fresh install..

The website is working perfectly fine however whenever I try to save a page it shows that.

Our Sponsors
 

Brian
07-17-2009, 11:45 AM
Are you sure it wasn't this (http://www.vbadvanced.com/forum/showthread.php?t=36106) error instead?

Daryl
07-17-2009, 12:47 PM
Yes, my bad.

Worked, thanks for the help.