Results 1 to 4 of 4

Thread: MySQL Error: Unknown column 'dodeleted'

  1. #1
    Join Date
    Aug 2004
    Posts
    25

    Default MySQL Error: Unknown column 'dodeleted'

    First, I noticed that the image for progress was broken on my site. When I right-clicked it and viewed the image source I get this:
    http://www.vbadvanced.com/forum/imag...c/progress.gif

    When I try to generate a new report I get this error:
    Code:
    Database error in vBulletin 3.7.3:
    
    Invalid SQL:
    
    			INSERT INTO adv_links_reports
    				(userid, data, dateline, endtime, checkagain, type, dodeleted)
    			VALUES (
    				1,
    				'',
    				1221152237,
    				1221152237,
    				1,
    				1,
    				0
    		);
    
    MySQL Error   : Unknown column 'dodeleted' in 'field list'
    Error Number  : 1054
    Request Date  : Thursday, September 11th 2008 @ 04:57:17 PM
    Error Date    : Thursday, September 11th 2008 @ 04:57:17 PM
    Script        : http://domain.com/links/moderate.php
    Referrer      : http://domain.com/links/moderate.php?do=statusreports
    IP Address    : 71.154.18.246
    Username      : sjordan
    Classname     : vB_Database
    MySQL Version : 5.0.58

  2. #2
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default

    Quote Originally Posted by natas View Post
    First, I noticed that the image for progress was broken on my site. When I right-clicked it and viewed the image source I get this:
    http://www.vbadvanced.com/forum/imag...c/progress.gif
    Where at exactly?

    When I try to generate a new report I get this error:
    Thank you for pointing this out. The 'dodeleted' field is new in 3.0.0, but looks like it wasn't added to the query when doing a new install (which has been corrected in the install file now). For anyone who has already done a fresh install of v3.0.0, you can correct that by running the following query via your Admin CP or phpMyAdmin: If you use table prefixes, be sure to add your table prefix before 'adv_links_reports' on the first line.
    Code:
    ALTER TABLE adv_links_reports
    CHANGE `type` `type` SMALLINT(3) UNSIGNED NOT NULL DEFAULT '0',
    ADD dodeleted SMALLINT(3) UNSIGNED NOT NULL DEFAULT '0'

  3. #3
    Join Date
    Aug 2004
    Posts
    25

    Default

    [QUOTE=Brian;154806]Where at exactly?

    When you click on "Continue" on adding a link. I did a search for the image in my templates and the direct link to vbadvanced.com was there:

    ADV_LINKS_ADD_START

    Code:
    setTimeout('document.images["wait_img"].src = "http://www.vbadvanced.com/forum/images/misc/progress.gif"', 200);

  4. #4
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default

    Huh... Not sure how that got in there. I've went ahead and applied the fix to the files in the download package here though, so you can correct one of two ways.

    1). Download the files from here agian, upload the forum/admincp/vbalinks_install.php file, go to it in your browser, and select the option to re-install the templates (this will add the fix and prevent you from having a customized template).

    2). Edit your 'ADV_LINKS_ADD_START' template through your Style Manager and replace 'http://www.vbadvanced.com/forum/images/misc' with '$stylevar[imgdir_misc]'.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Unknown column error
    By Pingu in forum Troubleshooting & Problems
    Replies: 1
    Last Post: 09-29-2007, 08:34 AM
  2. DB Error: Unknown column 'phrasegroup_adv_links'
    By Freesteyelz in forum Troubleshooting & Problems
    Replies: 5
    Last Post: 09-09-2006, 09:18 AM
  3. MySQL Error: 1052 : Column 'dateline' in order clause is ambiguous
    By Bailx in forum Troubleshooting & Problems
    Replies: 8
    Last Post: 08-23-2006, 05:55 PM
  4. Upgrade to 3.5 error. MySQL duplicate column name
    By DougM in forum Troubleshooting & Problems
    Replies: 1
    Last Post: 10-08-2005, 07:30 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
  •