Tweet
Going from one headache to another........
after switching to a new hosting company (because my old hosting company kept having mySQL issues), I went with a new hosting company that uses mySQL 5.0.18. Ever since I got all the files transfere and database uploaded, I'm getting errors like this:
This has basically rendered my forums useless.
Now, I've done enough research to pretty much find out that its a problem with mySQL 5 and how vB 2.3.0 is coded.
Has anyone figured out what changes need to be made so that this will work? ('downgrading' to mySQL 4 is not an option and I like the somplicity of v2.3.0, so I would rather not upgrade to v3.X)
after switching to a new hosting company (because my old hosting company kept having mySQL issues), I went with a new hosting company that uses mySQL 5.0.18. Ever since I got all the files transfere and database uploaded, I'm getting errors like this:
Database error in vBulletin 2.3.0:
Invalid SQL: SELECT privatemessage.*,touser.username AS tousername,fromuser.username AS fromusername,icon.title AS icontitle,icon.iconpath FROM privatemessage,user AS touser,user AS fromuser LEFT JOIN icon ON icon.iconid=privatemessage.iconid WHERE privatemessage.userid='1' AND folderid=0 AND touser.userid=privatemessage.touserid AND fromuser.userid=privatemessage.fromuserid AND messageread=0 ORDER BY dateline DESC
mysql error: Unknown column 'privatemessage.iconid' in 'on clause'
mysql error number: 1054
Date: Thursday 30th of March 2006 10:59:43 PM
Script: http://www.wcfords.com/ubb/ubb/usercp.php?
Referer: http://westcoastmustangs.com/ubb/for...php?forumid=41
Invalid SQL: SELECT privatemessage.*,touser.username AS tousername,fromuser.username AS fromusername,icon.title AS icontitle,icon.iconpath FROM privatemessage,user AS touser,user AS fromuser LEFT JOIN icon ON icon.iconid=privatemessage.iconid WHERE privatemessage.userid='1' AND folderid=0 AND touser.userid=privatemessage.touserid AND fromuser.userid=privatemessage.fromuserid AND messageread=0 ORDER BY dateline DESC
mysql error: Unknown column 'privatemessage.iconid' in 'on clause'
mysql error number: 1054
Date: Thursday 30th of March 2006 10:59:43 PM
Script: http://www.wcfords.com/ubb/ubb/usercp.php?
Referer: http://westcoastmustangs.com/ubb/for...php?forumid=41
Database error in vBulletin 2.3.0:
Invalid SQL: SELECT user.*, style.templatesetid
FROM subscribethread,user,usergroup
LEFT JOIN style ON (IF(user.styleid=0, 1, user.styleid)=style.styleid)
WHERE subscribethread.threadid='24488'
AND subscribethread.userid=user.userid
AND usergroup.usergroupid=user.usergroupid
AND user.userid<>'1'
AND user.usergroupid<>'3'
AND usergroup.canview = 1
AND user.lastactivity>'1143782548'
mysql error: Unknown column 'user.styleid' in 'on clause'
mysql error number: 1054
Date: Thursday 30th of March 2006 11:00:05 PM
Script: http://www.wcfords.com/ubb/ubb/newreply.php
Referer: http://westcoastmustangs.com/ubb/sho...threadid=24488
Invalid SQL: SELECT user.*, style.templatesetid
FROM subscribethread,user,usergroup
LEFT JOIN style ON (IF(user.styleid=0, 1, user.styleid)=style.styleid)
WHERE subscribethread.threadid='24488'
AND subscribethread.userid=user.userid
AND usergroup.usergroupid=user.usergroupid
AND user.userid<>'1'
AND user.usergroupid<>'3'
AND usergroup.canview = 1
AND user.lastactivity>'1143782548'
mysql error: Unknown column 'user.styleid' in 'on clause'
mysql error number: 1054
Date: Thursday 30th of March 2006 11:00:05 PM
Script: http://www.wcfords.com/ubb/ubb/newreply.php
Referer: http://westcoastmustangs.com/ubb/sho...threadid=24488
Database error in vBulletin 2.3.0:
Invalid SQL:
SELECT DISTINCT post.userid,
thread.threadid,thread.threadid AS postid,thread.title AS threadtitle,thread.iconid AS threadiconid,thread.replycount,
thread.views,thread.pollid,thread.open,thread.lastpost AS postdateline,thread.lastpost,thread.lastposter,
forum.forumid,forum.title AS forumtitle,forum.allowicons,attach,
thread.postusername AS usrname,
user.userid AS postuserid,
threadicon.iconpath AS threadiconpath,threadicon.title AS threadicontitle
FROM
thread,forum
LEFT JOIN icon AS threadicon ON thread.iconid=threadicon.iconid
LEFT JOIN post ON (thread.threadid = post.threadid AND post.userid = '1' AND post.visible = 1)
WHERE
thread.forumid=forum.forumid AND thread.threadid IN (0,24488,24487,24486,24485)
ORDER BY
thread.lastpost DESC,thread.lastpost DESC
mysql error: Unknown column 'user.userid' in 'field list'
mysql error number: 1054
Date: Thursday 30th of March 2006 11:02:52 PM
Script: http://www.wcfords.com/ubb/ubb/searc...earchid=183663
Referer:
Invalid SQL:
SELECT DISTINCT post.userid,
thread.threadid,thread.threadid AS postid,thread.title AS threadtitle,thread.iconid AS threadiconid,thread.replycount,
thread.views,thread.pollid,thread.open,thread.lastpost AS postdateline,thread.lastpost,thread.lastposter,
forum.forumid,forum.title AS forumtitle,forum.allowicons,attach,
thread.postusername AS usrname,
user.userid AS postuserid,
threadicon.iconpath AS threadiconpath,threadicon.title AS threadicontitle
FROM
thread,forum
LEFT JOIN icon AS threadicon ON thread.iconid=threadicon.iconid
LEFT JOIN post ON (thread.threadid = post.threadid AND post.userid = '1' AND post.visible = 1)
WHERE
thread.forumid=forum.forumid AND thread.threadid IN (0,24488,24487,24486,24485)
ORDER BY
thread.lastpost DESC,thread.lastpost DESC
mysql error: Unknown column 'user.userid' in 'field list'
mysql error number: 1054
Date: Thursday 30th of March 2006 11:02:52 PM
Script: http://www.wcfords.com/ubb/ubb/searc...earchid=183663
Referer:
This has basically rendered my forums useless.
Now, I've done enough research to pretty much find out that its a problem with mySQL 5 and how vB 2.3.0 is coded.
Has anyone figured out what changes need to be made so that this will work? ('downgrading' to mySQL 4 is not an option and I like the somplicity of v2.3.0, so I would rather not upgrade to v3.X)
And I thought you guys were better than that.
Comment