Results 1 to 12 of 12

Thread: Database Error After Upgrade to v4.1

  1. #1

    Lightbulb Database Error After Upgrade to v4.1

    Hello

    I will get the DB error by adding a link after upgrading to 4.1.0

    Error :

    Code:
    Database error in vBulletin 4.0.3:
    
    Invalid SQL:
    
    				INSERT INTO adv_links
    					(catid, name, linkurl, description, keywords, linkrecipurl, valid, open, hasthumb, username, userid, dateline, lastupdated, ipaddress)
    				VALUES (
    					45,
    					'website title',
    					'http://XXXXXX.com/',
    					'Gerash internet forum',
    					'',
    					'',
    					1,
    					1,
    					'',
    					'config',
    					11,
    					1274908294,
    					1274908294,
    					'########'
    			);
    
    MySQL Error   : Unknown column 'hasthumb' in 'field list'
    Error Number  : 1054
    Request Date  : Wednesday, May 26th 2010 @ 04:11:34 PM
    Error Date    : Wednesday, May 26th 2010 @ 04:11:37 PM
    Script        : http://www.domain.com/links/addlink.php
    Referrer      : http://www.domain.com/links/addlink.php
    IP Address    : ########
    Username      : username
    Classname     : vB_Database
    MySQL Version : 5.1.30

    Thanks.

  2. #2
    Join Date
    May 2005
    Location
    PhillyaDelphia
    Posts
    41

    Default Database erro in 4.1v

    i click on "my stuff" and go this db error

    Database error in vBulletin 4.0.3:

    Invalid SQL:

    SELECT links.linkid, name, links.description, linkurl, links.catid, views, links.valid, links.hasthumb, links.username, links.userid, links.dateline, lastupdated, sticky, open, votenum, votetotal, customfields.* , NOT ISNULL(subscribelink.linkid) AS issubscribed, links.posts, links.lastpostdateline, links.lastpostuserid, links.lastpostusername, links.lastpostid, NOT ISNULL(favorites.linkid) AS isfavorite
    FROM adv_links AS links
    LEFT JOIN adv_links_cfields_entries AS customfields ON (links.linkid = customfields.lid)
    LEFT JOIN adv_links_subscribelink AS subscribelink ON (links.linkid = subscribelink.linkid AND 1 = subscribelink.userid) LEFT JOIN adv_links_favorites AS favorites ON (favorites.linkid = links.linkid AND favorites.userid = 1)
    WHERE links.linkid IN(21,1,15,19,14,23,12,17,18,26,27,6,10,28,25,4,5,8,11,29,2,13,16,9,7)
    ORDER BY links.name ASC, links.linkid;

    MySQL Error : Unknown column 'links.hasthumb' in 'field list'
    Error Number : 1054
    Request Date : Wednesday, May 26th 2010 @ 05:34:12 PM
    Error Date : Wednesday, May 26th 2010 @ 05:34:13 PM
    Script : http://bla/links/members/puertoblack2003-1/
    Referrer : http://bla/links/browselinks.php
    IP Address : bla
    Username :bla
    Classname : vB_Database
    MySQL Version : 5.1.46-community-log
    Nextel phone modding and other software programs at your service visit at: Puerto Technology Central



  3. #3
    Join Date
    May 2005
    Location
    PhillyaDelphia
    Posts
    41

    Default

    never mined fix ity by adding the mnissing table somehow during the upgrade it didn't add it.so far so good
    Nextel phone modding and other software programs at your service visit at: Puerto Technology Central



  4. #4

  5. #5
    Join Date
    May 2007
    Location
    KUWAIT
    Posts
    58

    Default

    test in sql

    PHP Code:
          ALTER TABLE `adv_linksADD `hasthumbINT20 NOT NULL 

    i.s.s.w

  6. #6
    Join Date
    May 2007
    Location
    KUWAIT
    Posts
    58

    Default sql

    sql

    PHP Code:
           ALTER TABLE `adv_linksADD `hasthumbINT20 NOT NULL 

    i.s.s.w

  7. #7

    Default

    Yeah I have the same error, will try the alter table fix..

    Edit: worked great, thanks much.
    Last edited by Volion; 05-26-2010 at 11:33 PM.

  8. #8
    Join Date
    Apr 2007
    Posts
    160

    Default

    I have the same thing...

    Database error in vBulletin 4.0.3:

    Invalid SQL:

    SELECT links.linkid, name, links.description, linkurl, links.catid, views, links.valid, links.hasthumb, links.username, links.userid, links.dateline, lastupdated, sticky, open, votenum, votetotal, customfields.* , links.posts, links.lastpostdateline, links.lastpostuserid, links.lastpostusername, links.lastpostid
    FROM adv_links AS links
    LEFT JOIN adv_links_cfields_entries AS customfields ON (links.linkid = customfields.lid)

    WHERE links.linkid IN(71,73,54,50,47,45,68)
    ORDER BY sticky DESC, links.name ASC, links.linkid;

    MySQL Error : Unknown column 'links.hasthumb' in 'field list'
    Error Number : 1054
    Request Date : Thursday, May 27th 2010 @ 12:59:03 AM
    Error Date : Thursday, May 27th 2010 @ 12:59:03 AM
    Script : http://www.vincentownersclub.co.uk/l...links.php?c=28
    Referrer :
    IP Address : 216.129.119.12
    Username : Unregistered
    Classname : vB_Database
    MySQL Version :

  9. #9
    Join Date
    Apr 2007
    Posts
    160

    Default

    Anyone worked out a fix for this yet, as I'm getting a ton on database errors

  10. #10
    Join Date
    May 2007
    Location
    KUWAIT
    Posts
    58

    Default

    Quote Originally Posted by grahamsmythe View Post
    Anyone worked out a fix for this yet, as I'm getting a ton on database errors



    MySQL

    PHP Code:
           ALTER TABLE `adv_linksADD `hasthumbINT20 NOT NULL 

    i.s.s.w

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

    Default

    Sorry for the issue guys. It looks like there was a small bug in the 4.1.0 install file that could prevent that query from being run. I've updated that file in the donwload package here so that shouldn't be an issue for any new downloads. For anyone who has already upgraded and is receiving the database error above, just run this query via phpMyAdmin or your Admin CP and it should take care of the issue.

    Code:
    ALTER TABLE adv_links ADD hasthumb VARCHAR(10) NOT NULL AFTER sticky;
    (note that if you use table prefixes, you will need to add your table prefix in front of "adv_links" before running the query)
    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.

  12. #12

    Default

    Thanks Brian, Problem is solved.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Database Error, SQL Error and i cant Upgrade
    By ikorolis in forum Troubleshooting & Problems
    Replies: 2
    Last Post: 05-29-2015, 04:26 PM
  2. Database error after upgrade
    By dxflw in forum Troubleshooting & Problems
    Replies: 1
    Last Post: 02-25-2009, 12:28 PM
  3. Error during upgrade, now can't complete upgrade
    By kirkus-tat in forum Troubleshooting & Problems
    Replies: 31
    Last Post: 02-22-2009, 02:06 AM
  4. Database error after upgrade to 3.0
    By goyocafe in forum Troubleshooting & Problems
    Replies: 4
    Last Post: 07-04-2007, 10:54 AM
  5. Problem with Database after upgrade
    By vitoreis in forum Troubleshooting & Problems
    Replies: 2
    Last Post: 05-28-2007, 07:56 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
  •