Results 1 to 5 of 5

Thread: Unknown column 'dateline' in 'field list' error

  1. #1

    Question Unknown column 'dateline' in 'field list' error

    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`)
    ('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 :
    Referrer :
    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.

  2. #2
    Join Date
    Jan 2004
    Georgia, USA


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

  3. #3


    Thank you Brian, all set.

  4. #4
    Join Date
    Jul 2009


    had the same problem and the fix worked great, thank you!!

  5. #5


    thanks i had the same issue solved now....

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. MySQL Error: Unknown column 'phrasegroup_local_links' in 'field list'
    By natas in forum Troubleshooting & Problems
    Replies: 2
    Last Post: 09-24-2008, 04:38 PM
  2. MySQL Error: Unknown column 'dodeleted'
    By natas in forum Bugs From 3.0.0
    Replies: 3
    Last Post: 09-12-2008, 11:36 AM
  3. Unknown column error
    By Pingu in forum Troubleshooting & Problems
    Replies: 1
    Last Post: 09-29-2007, 07:34 AM
  4. DB Error: Unknown column 'phrasegroup_adv_links'
    By Freesteyelz in forum Troubleshooting & Problems
    Replies: 5
    Last Post: 09-09-2006, 08:18 AM
  5. MySQL Error: 1052 : Column 'dateline' in order clause is ambiguous
    By Bailx in forum Troubleshooting & Problems
    Replies: 8
    Last Post: 08-23-2006, 04:55 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