Database Error After Upgrade to v4.1

[theproit]

Hello

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

Error :

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.

[puertoblack2003]

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

[Our Sponsors]

[puertoblack2003]

never mined fix ity by adding the mnissing table somehow during the upgrade it didn't add it.so far so good

[theproit]

same here.

+ this one :

http://www.vbadvanced.com/forum/showthread.php?t=40500

[Our Sponsors]

[i.s.s.w]

test in sql

ALTER TABLE `adv_links` ADD `hasthumb` INT( 20 ) NOT NULL ;

[i.s.s.w]

sql

ALTER TABLE `adv_links` ADD `hasthumb` INT( 20 ) NOT NULL ;

[Volion]

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

Edit: worked great, thanks much.

[grahamsmythe]

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/links/browselinks.php?c=28
Referrer :
IP Address : 216.129.119.12
Username : Unregistered
Classname : vB_Database
MySQL Version :

[grahamsmythe]

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

[i.s.s.w]

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




MySQL

ALTER TABLE `adv_links` ADD `hasthumb` INT( 20 ) NOT NULL ;

[Brian]

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.

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)

[theproit]

Thanks Brian, Problem is solved.