I was having problems upgrading to vB3 (posted here: http://www.vbulletin.com/forum/showthread.php?t=89184) but found a way to install it by manually changing all the lines of code like this one (and other required files that had that same include type):
to the full file path
on the files: upgrade1.php and upgradecore.php
and it worked... the upgrade finished without errors... but as soon as I tried to login to the Admin CP I started getting errors, this also happened on the board. Eventually, I noticed I was getting errors on every thing I did that required a change something on the database... I will include in this post... all the errors I got, until I gave up. They are a lot of errors, I hope them can help to figure out my problem. I changed my actual site url from the errors to mydomain.com and also changed my IP on the error log I will copy here.
Here are all the errors I got:
Database error in vBulletin 3.0.0 Beta 3:
Invalid SQL:
INSERT INTO session
(sessionhash, userid, host, idhash, lastactivity, styleid, loggedin, bypass, useragent)
VALUES
('0df13dd38eb884d329ec11f87661e2bb', 20, '66.50.x.x', 'bd72f14651e34cf407817b196af5a90c', 1071304116, 0, 1, 0, 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6b) Gecko/20031206 Firebird/0.7+ (aebrahim)')
mysql error: Unknown column 'bypass' in 'field list'
mysql error number: 1054
Date: Saturday 13th of December 2003 04:28:36 AM
Script: http://www.mydomain.com/vB3/login.php
Referer: http://www.mydomain.com/vB3/login.php
Username: WebMaster
IP Address: 66.50.x.x
Database error in vBulletin 3.0.0 Beta 3:
Invalid SQL:
SELECT calendarcustomfieldid, title, options, allowentry, description
FROM calendarcustomfield AS calendarcustomfield
WHERE calendarid = 1
ORDER BY calendarcustomfieldid
mysql error: Unknown column 'description' in 'field list'
mysql error number: 1054
Date: Saturday 13th of December 2003 04:39:18 AM
Script: http://www.mydomain.com/vB3/calendar...nfo&e=2108&c=1
Referer: http://www.mydomain.com/vB3/
Username: WebMaster
IP Address: 66.50.x.x
Database error in vBulletin 3.0.0 Beta 3:
Invalid SQL:
SELECT calendarcustomfieldid, title, options, allowentry, description
FROM calendarcustomfield AS calendarcustomfield
WHERE calendarid = 1
ORDER BY calendarcustomfieldid
mysql error: Unknown column 'description' in 'field list'
mysql error number: 1054
Date: Saturday 13th of December 2003 04:39:35 AM
Script: http://www.mydomain.com/vB3/calendar...nfo&e=2108&c=1
Referer: http://www.mydomain.com/vB3/calendar...nfo&e=2108&c=1
Username: WebMaster
IP Address: 66.50.x.x
Database error in vBulletin 3.0.0 Beta 3:
Invalid SQL:
SELECT calendarcustomfieldid, title, options, allowentry, description
FROM calendarcustomfield AS calendarcustomfield
WHERE calendarid = 1
ORDER BY calendarcustomfieldid
mysql error: Unknown column 'description' in 'field list'
mysql error number: 1054
Date: Saturday 13th of December 2003 04:39:48 AM
Script: http://www.mydomain.com/vB3/calendar...=2003-12-7&c=1
Referer: http://www.mydomain.com/vB3/calendar.php?
Username: WebMaster
IP Address: 66.50.x.x
Database error in vBulletin 3.0.0 Beta 3:
Invalid SQL:
INSERT IGNORE INTO postindex
(wordid, postid, score, intitle)
SELECT DISTINCT wordid, 969052, CASE title WHEN 'Mensaje' THEN 2 WHEN 'prueba' THEN 2 WHEN 'Test' THEN 1 WHEN '123' THEN 1 ELSE 1 END, CASE title WHEN 'Mensaje' THEN 2 WHEN 'de' THEN 2 WHEN 'prueba' THEN 2 WHEN 'Test' THEN 0 WHEN '123' THEN 0 ELSE 0 END
FROM word
WHERE title IN ('Mensaje','prueba','Test','123')
mysql error: Table 'vB3.postindex' doesn't exist
mysql error number: 1146
Date: Saturday 13th of December 2003 04:45:04 AM
Script: http://www.mydomain.com/vB3/newthread.php
Referer: http://www.mydomain.com/vB3/newthrea...=newthread&f=2
Username: WebMaster
IP Address: 66.50.x.x
Database error in vBulletin 3.0.0 Beta 3:
Invalid SQL:
INSERT INTO user
(username, salt, password, passworddate, email, styleid, parentemail,
showvbcode, usertitle, joindate, daysprune, lastvisit, lastactivity, usergroupid, timezoneoffset,
options, maxposts, threadedmode, startofweek, ipaddress, pmpopup, referrerid,
reputationlevelid, reputation, autosubscribe, birthday)
VALUES
('vB3 Test',
'dl`',
'3b2a096f46291cb46a1dec47554ab71f',
NOW(),
'[email protected]',
1,
'',
2,
'Registered User',
1071305309,
-1,
1071305309,
1071305309,
3,
'-4',
3095,
-1,
0,
1,
'66.50.x.x',
0,
0,
5,
10,
-1,
''
)
mysql error: Unknown column 'autosubscribe' in 'field list'
mysql error number: 1054
Date: Saturday 13th of December 2003 04:48:29 AM
Script: http://www.mydomain.com/vB3/register.php
Referer: http://www.mydomain.com/vB3/register.php
Username: WebMaster
IP Address: 66.50.x.x
Database error in vBulletin 3.0.0 Beta 3:
Invalid SQL: UPDATE user SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
username = 'WebMaster',
email = '[email protected]',
languageid = '0',
usertitle = 'Administrator',
customtitle = '0',
homepage = 'http://www.mydomain.com/',
icq = '7107159',
aim = 'pulsorockcom@hotmail',
yahoo = '',
msn = '',
parentemail = '[email protected]',
posts = '3734',
ipaddress = '216.72.76.119',
usergroupid = '6',
reputation = '0',
pmpopup = '1',
autosubscribe = '0',
showvbcode = '1',
styleid = '0',
timezoneoffset = '-4',
daysprune = '-1',
displaygroupid = '6',
threadedmode = '0',
password = '66161c0cd1edd2e2cb24c455f08db366',
referrerid = '0',
joindate = '871315200',
lastvisit = '1071301440',
lastactivity = '1071305280',
lastpost = '1071278160',
birthday = '08-11-1977',
options = '8023',
reputationlevelid = '4',
membergroupids = ''
WHERE userid=20
mysql error: Unknown column 'autosubscribe' in 'field list'
mysql error number: 1054
Date: Saturday 13th of December 2003 04:50:47 AM
Script: http://www.mydomain.com/vB3/admincp/user.php
Referer: http://www.mydomain.com/vB3/admincp/user.php?do=edit&userid=20]
Username: WebMaster
IP Address: 66.50.x.x
Database error in vBulletin 3.0.0 Beta 3:
Invalid SQL:
INSERT INTO session
(sessionhash, userid, host, idhash, lastactivity, styleid, loggedin, bypass, useragent)
VALUES
('1f2fa30a7afb57ea9638234cb771441c', 5752, '66.50.x.x', 'a3df1c266c1a95f380d4e8563edc01d7', 1071305624, 0, 1, 0, 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Alexa Toolbar)')
mysql error: Unknown column 'bypass' in 'field list'
mysql error number: 1054
Date: Saturday 13th of December 2003 04:53:44 AM
Script: http://www.mydomain.com/vB3/login.php
Referer: http://www.mydomain.com/vB3/forumdisplay.php?f=2
Username: guillermo
IP Address: 66.50.x.x
Database error in vBulletin 3.0.0 Beta 3:
Invalid SQL:
UPDATE user SET
showvbcode = 2,
pmpopup = 1,
maxposts = -1,
daysprune = -1,
timezoneoffset = '-4',
startofweek = 1,
languageid = 0,
threadedmode = 0,
autosubscribe = -1,
options = 2390
WHERE userid = 5752
mysql error: Unknown column 'autosubscribe' in 'field list'
mysql error number: 1054
Date: Saturday 13th of December 2003 04:55:49 AM
Script: http://www.mydomain.com/vB3/profile.php
Referer: http://www.mydomain.com/vB3/profile.php?do=editoptions
Username: guillermo
IP Address: 66.50.x.x
Thanks for the help....
require_once('./includes/config.php');
require_once("/full/file/path/vB3/includes/config.php");
and it worked... the upgrade finished without errors... but as soon as I tried to login to the Admin CP I started getting errors, this also happened on the board. Eventually, I noticed I was getting errors on every thing I did that required a change something on the database... I will include in this post... all the errors I got, until I gave up. They are a lot of errors, I hope them can help to figure out my problem. I changed my actual site url from the errors to mydomain.com and also changed my IP on the error log I will copy here.
Here are all the errors I got:
Database error in vBulletin 3.0.0 Beta 3:
Invalid SQL:
INSERT INTO session
(sessionhash, userid, host, idhash, lastactivity, styleid, loggedin, bypass, useragent)
VALUES
('066197577c15a743b83fc21fe3fa06b9', 20, '66.50.x.x', 'bd72f14651e34cf407817b196af5a90c', 1071304074, 0, 1, 1, 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6b) Gecko/20031206 Firebird/0.7+ (aebrahim)')
mysql error: Unknown column 'bypass' in 'field list'
mysql error number: 1054
Date: Saturday 13th of December 2003 04:27:55 AM
Script: http://www.mydomain.com/vB3/login.php
Referer: http://www.mydomain.com/vB3/admincp/
Username: WebMaster
IP Address: 66.50.x.x
Invalid SQL:
INSERT INTO session
(sessionhash, userid, host, idhash, lastactivity, styleid, loggedin, bypass, useragent)
VALUES
('066197577c15a743b83fc21fe3fa06b9', 20, '66.50.x.x', 'bd72f14651e34cf407817b196af5a90c', 1071304074, 0, 1, 1, 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6b) Gecko/20031206 Firebird/0.7+ (aebrahim)')
mysql error: Unknown column 'bypass' in 'field list'
mysql error number: 1054
Date: Saturday 13th of December 2003 04:27:55 AM
Script: http://www.mydomain.com/vB3/login.php
Referer: http://www.mydomain.com/vB3/admincp/
Username: WebMaster
IP Address: 66.50.x.x
Database error in vBulletin 3.0.0 Beta 3:
Invalid SQL:
INSERT INTO session
(sessionhash, userid, host, idhash, lastactivity, styleid, loggedin, bypass, useragent)
VALUES
('0df13dd38eb884d329ec11f87661e2bb', 20, '66.50.x.x', 'bd72f14651e34cf407817b196af5a90c', 1071304116, 0, 1, 0, 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6b) Gecko/20031206 Firebird/0.7+ (aebrahim)')
mysql error: Unknown column 'bypass' in 'field list'
mysql error number: 1054
Date: Saturday 13th of December 2003 04:28:36 AM
Script: http://www.mydomain.com/vB3/login.php
Referer: http://www.mydomain.com/vB3/login.php
Username: WebMaster
IP Address: 66.50.x.x
Database error in vBulletin 3.0.0 Beta 3:
Invalid SQL:
SELECT calendarcustomfieldid, title, options, allowentry, description
FROM calendarcustomfield AS calendarcustomfield
WHERE calendarid = 1
ORDER BY calendarcustomfieldid
mysql error: Unknown column 'description' in 'field list'
mysql error number: 1054
Date: Saturday 13th of December 2003 04:39:18 AM
Script: http://www.mydomain.com/vB3/calendar...nfo&e=2108&c=1
Referer: http://www.mydomain.com/vB3/
Username: WebMaster
IP Address: 66.50.x.x
Database error in vBulletin 3.0.0 Beta 3:
Invalid SQL:
SELECT calendarcustomfieldid, title, options, allowentry, description
FROM calendarcustomfield AS calendarcustomfield
WHERE calendarid = 1
ORDER BY calendarcustomfieldid
mysql error: Unknown column 'description' in 'field list'
mysql error number: 1054
Date: Saturday 13th of December 2003 04:39:35 AM
Script: http://www.mydomain.com/vB3/calendar...nfo&e=2108&c=1
Referer: http://www.mydomain.com/vB3/calendar...nfo&e=2108&c=1
Username: WebMaster
IP Address: 66.50.x.x
Database error in vBulletin 3.0.0 Beta 3:
Invalid SQL:
SELECT calendarcustomfieldid, title, options, allowentry, description
FROM calendarcustomfield AS calendarcustomfield
WHERE calendarid = 1
ORDER BY calendarcustomfieldid
mysql error: Unknown column 'description' in 'field list'
mysql error number: 1054
Date: Saturday 13th of December 2003 04:39:48 AM
Script: http://www.mydomain.com/vB3/calendar...=2003-12-7&c=1
Referer: http://www.mydomain.com/vB3/calendar.php?
Username: WebMaster
IP Address: 66.50.x.x
Database error in vBulletin 3.0.0 Beta 3:
Invalid SQL:
INSERT IGNORE INTO postindex
(wordid, postid, score, intitle)
SELECT DISTINCT wordid, 969052, CASE title WHEN 'Mensaje' THEN 2 WHEN 'prueba' THEN 2 WHEN 'Test' THEN 1 WHEN '123' THEN 1 ELSE 1 END, CASE title WHEN 'Mensaje' THEN 2 WHEN 'de' THEN 2 WHEN 'prueba' THEN 2 WHEN 'Test' THEN 0 WHEN '123' THEN 0 ELSE 0 END
FROM word
WHERE title IN ('Mensaje','prueba','Test','123')
mysql error: Table 'vB3.postindex' doesn't exist
mysql error number: 1146
Date: Saturday 13th of December 2003 04:45:04 AM
Script: http://www.mydomain.com/vB3/newthread.php
Referer: http://www.mydomain.com/vB3/newthrea...=newthread&f=2
Username: WebMaster
IP Address: 66.50.x.x
Database error in vBulletin 3.0.0 Beta 3:
Invalid SQL:
INSERT INTO user
(username, salt, password, passworddate, email, styleid, parentemail,
showvbcode, usertitle, joindate, daysprune, lastvisit, lastactivity, usergroupid, timezoneoffset,
options, maxposts, threadedmode, startofweek, ipaddress, pmpopup, referrerid,
reputationlevelid, reputation, autosubscribe, birthday)
VALUES
('vB3 Test',
'dl`',
'3b2a096f46291cb46a1dec47554ab71f',
NOW(),
'[email protected]',
1,
'',
2,
'Registered User',
1071305309,
-1,
1071305309,
1071305309,
3,
'-4',
3095,
-1,
0,
1,
'66.50.x.x',
0,
0,
5,
10,
-1,
''
)
mysql error: Unknown column 'autosubscribe' in 'field list'
mysql error number: 1054
Date: Saturday 13th of December 2003 04:48:29 AM
Script: http://www.mydomain.com/vB3/register.php
Referer: http://www.mydomain.com/vB3/register.php
Username: WebMaster
IP Address: 66.50.x.x
Database error in vBulletin 3.0.0 Beta 3:
Invalid SQL: UPDATE user SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
username = 'WebMaster',
email = '[email protected]',
languageid = '0',
usertitle = 'Administrator',
customtitle = '0',
homepage = 'http://www.mydomain.com/',
icq = '7107159',
aim = 'pulsorockcom@hotmail',
yahoo = '',
msn = '',
parentemail = '[email protected]',
posts = '3734',
ipaddress = '216.72.76.119',
usergroupid = '6',
reputation = '0',
pmpopup = '1',
autosubscribe = '0',
showvbcode = '1',
styleid = '0',
timezoneoffset = '-4',
daysprune = '-1',
displaygroupid = '6',
threadedmode = '0',
password = '66161c0cd1edd2e2cb24c455f08db366',
referrerid = '0',
joindate = '871315200',
lastvisit = '1071301440',
lastactivity = '1071305280',
lastpost = '1071278160',
birthday = '08-11-1977',
options = '8023',
reputationlevelid = '4',
membergroupids = ''
WHERE userid=20
mysql error: Unknown column 'autosubscribe' in 'field list'
mysql error number: 1054
Date: Saturday 13th of December 2003 04:50:47 AM
Script: http://www.mydomain.com/vB3/admincp/user.php
Referer: http://www.mydomain.com/vB3/admincp/user.php?do=edit&userid=20]
Username: WebMaster
IP Address: 66.50.x.x
Database error in vBulletin 3.0.0 Beta 3:
Invalid SQL:
INSERT INTO session
(sessionhash, userid, host, idhash, lastactivity, styleid, loggedin, bypass, useragent)
VALUES
('1f2fa30a7afb57ea9638234cb771441c', 5752, '66.50.x.x', 'a3df1c266c1a95f380d4e8563edc01d7', 1071305624, 0, 1, 0, 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Alexa Toolbar)')
mysql error: Unknown column 'bypass' in 'field list'
mysql error number: 1054
Date: Saturday 13th of December 2003 04:53:44 AM
Script: http://www.mydomain.com/vB3/login.php
Referer: http://www.mydomain.com/vB3/forumdisplay.php?f=2
Username: guillermo
IP Address: 66.50.x.x
Database error in vBulletin 3.0.0 Beta 3:
Invalid SQL:
UPDATE user SET
showvbcode = 2,
pmpopup = 1,
maxposts = -1,
daysprune = -1,
timezoneoffset = '-4',
startofweek = 1,
languageid = 0,
threadedmode = 0,
autosubscribe = -1,
options = 2390
WHERE userid = 5752
mysql error: Unknown column 'autosubscribe' in 'field list'
mysql error number: 1054
Date: Saturday 13th of December 2003 04:55:49 AM
Script: http://www.mydomain.com/vB3/profile.php
Referer: http://www.mydomain.com/vB3/profile.php?do=editoptions
Username: guillermo
IP Address: 66.50.x.x
Comment