PDA

View Full Version : Unknown column 'dateline' in 'field list' error



Infopro
07-17-2009, 10:55 AM
From announcement:


As a result of the above feature, when editing a vBa CMPS page through the Admin CP, you will now see the date/time the page was last modified in the top-right corner.

This is a fresh install forum and vbadvanced downloaded both last night. Saving a page or editing a page results in this error:





Database error in vBulletin 3.8.3:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO som_adv_pages
(`title`, `name`, `displayorder`, `meta`, `parentid`, `styleid`, `active`, `customize`, `template`, `useshell`, `custom_title`, `colspan`, `formcode`, `type`, `advanced`, `modules`, `userperms`, `dateline`)
VALUES
('Testingthis', 'testme', '3', 'a:2:{s:8:\"keywords\";s:0:\"\";s:11:\"description\";s:0:\"\";}', '0', '0', '1', '0', 'adv_portal_testme', '1', '', '', '', 'template', 'N;', 'a:1:{i:2;a:1:{i:12;i:10;}}', '4,6,8,7,2,5,1,3', '1247841664');

MySQL Error : Unknown column 'dateline' in 'field list'
Error Number : 1054
Request Date : Friday, July 17th 2009 @ 07:41:04 AM
Error Date : Friday, July 17th 2009 @ 07:41:04 AM
Script : http://domain.com/admincp/vba_cmps_admin.php
Referrer : http://domain.com/admincp/vba_cmps_admin.php?do=addpage&type=template
IP Address : My.IP.GOES.HERE
Username : Infopro
Classname : vB_Database
MySQL Version : 5.0.81-community

Do you think this is related to the new feature for timestamp?

There are no mods or customizations to this forum at all. Base setup. Found this adding the first new page.

Thanks in advance.

Brian
07-17-2009, 11:36 AM
Thank you for pointing this out. I'm not sure how I managed to do it, but somehow those fields got removed from the install file for new installs. I've updated the admincp/vbacmps_install.php file here to include the fix so that shouldn't be an issue for others. If you're already installed then you can correct the issue by running the following two queries via phpMyAdmin or your vB Admin CP.

ALTER TABLE adv_pages ADD dateline INT(10) UNSIGNED NOT NULL DEFAULT '0';

ALTER TABLE adv_pages_user ADD dateline INT(10) UNSIGNED NOT NULL DEFAULT '0';

Our Sponsors
 

Infopro
07-17-2009, 12:13 PM
Thank you Brian, all set.

pmex
07-18-2009, 10:24 AM
had the same problem and the fix worked great, thank you!!

Our Sponsors
 

gayandilanga
04-30-2010, 08:04 PM
thanks i had the same issue solved now....