Quote:
Originally Posted by Cyricx
You'll have to repeat your problem.
The biggest problem people have had is not redoing the file edits after they upgrade vbulletin *sigh*
|
The problem is where we left it in private messaging. I have reinstalled and followed the upgrade instructions. No matter what I get this error. Can you help me resolve it? A lot of my traffic was based on the email intergration mod and my revenue, etc... is way down now. I'm using php5 and MYSQL 5. The user for SQL has complete access to the database on a dedicated server.
It worked before I attempted this upgrade. Not since tho...
Code:
Database error in vBulletin 3.8.1:
Invalid SQL:
UPDATE vb_forum SET
title_clean = 'Modeling & Acting Auditions (Metro Miami/Ft. Lauderdale & Florida!)',
title = 'Modeling & Acting Auditions (Metro Miami/Ft. Lauderdale & Florida!)',
description_clean = 'Castings in Metro Miami , Orlando, Tampa, and the rest of Florida.',
description = 'Castings in Metro Miami , Orlando, Tampa, and the rest of Florida.',
link = '',
displayorder = 60,
parentid = 3,
daysprune = -1,
defaultsortfield = 'lastpost',
defaultsortorder = 'desc',
showprivate = 0,
newpostemail = '',
newthreademail = '',
### Bitfield: vb_forum.options ###
options = IF(options & 8, options - 8, options),
options = IF(options & 16, options - 16, options),
options = IF(options & 32, options - 32, options),
options = IF(options & 32768, options - 32768, options),
options = IF(options & 8192, options - 8192, options),
options = IF(options & 4, options, options + 4),
options = IF(options & 1, options, options + 1),
options = IF(options & 2, options, options + 2),
options = IF(options & 16384, options, options + 16384),
options = IF(options & 256, options, options + 256),
options = IF(options & 64, options, options + 64),
options = IF(options & 128, options, options + 128),
options = IF(options & 512, options, options + 512),
options = IF(options & 1024, options, options + 1024),
options = IF(options & 2048, options, options + 2048),
options = IF(options & 4096, options, options + 4096),
options = IF(options & 65536, options, options + 65536),
options = IF(options & 131072, options - 131072, options),
styleid = 0,
imageprefix = '',
password = '',
vbseo_moderatepingbacks = 0,
vbseo_moderatetrackbacks = 0,
vbseo_moderaterefbacks = 0,
chiefpost = 1,
ei_replyaddress = 'atlanta@jobs.mymodeltalk.com',
ei_hostname = 'mail.mymodeltalk.com',
ei_username = 'atlanta@jobs.mymodeltalk.com',
ei_password = 'getmoney',
ei_folder = 'INBOX',
ei_connectiontype = '0',
ei_usergroups = '2',
ada_forum = 1,
ada_style = 3
WHERE forumid = 17;
MySQL Error : Unknown column 'ei_replyaddress' in 'field list'
Error Number : 1054
Request Date : Wednesday, May 27th 2009 @ 10:14:41 AM
Error Date : Wednesday, May 27th 2009 @ 10:14:41 AM
Script : http://www.mymodeltalk.com/jobs/admi....php?do=update
Referrer : http://www.mymodeltalk.com/jobs/admi...o=edit&f=17&s=
IP Address : 76.97.227.84
Username : mykkal
Classname : vB_Database
MySQL Version : 5.0.77-community
Code:
Database error in vBulletin 3.8.1
Invalid SQL:
SELECT ei_usergroups, title_clean, ei_active
FROM vb_forum
WHERE forumid = 57;
MySQL Error : Unknown column 'ei_usergroups' in 'field list'
Error Number : 1054
Request Date : Wednesday, May 27th 2009 @ 10:24:10 AM
Error Date : Wednesday, May 27th 2009 @ 10:24:11 AM
Script : http://www.mymodeltalk.com/jobs/admincp/usergroup.php?do=update
Referrer : http://www.mymodeltalk.com/jobs/admincp/usergroup.php?do=edit&usergroupid=2
IP Address : 76.97.227.84
Username : mykkal
Classname : vB_Database
MySQL Version : 5.0.77-community
|
More Information