Hi all I am using VB 2.3.3 and currently trying to move server, we have exported the sql database and imported it back into the new server, everything appears fine until trying to view a profile, or reply to a post, or pm. Can post new threads however.
The error messages are
What we have noticed is that their seems to be an extra /forums directory appeared in the Script link, why would this happen as it should just be co.uk/forums.
Any help is greatly appreciated.
The error messages are
Database error in vBulletin 2.3.3:
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='17683'
AND subscribethread.userid=user.userid
AND usergroup.usergroupid=user.usergroupid
AND user.userid<>'2'
AND user.usergroupid<>'3'
AND usergroup.canview = 1
AND user.lastactivity>'1168823778'
mysql error: Unknown column 'user.styleid' in 'on clause'
mysql error number: 1054
Date: Wednesday 31st of January 2007 02:24:54 PM
Script: http://www.thescuderia.co.uk/forums/forums/newreply.php
Referer: http://www.thescuderia.co.uk/forums...&threadid=17683
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='17683'
AND subscribethread.userid=user.userid
AND usergroup.usergroupid=user.usergroupid
AND user.userid<>'2'
AND user.usergroupid<>'3'
AND usergroup.canview = 1
AND user.lastactivity>'1168823778'
mysql error: Unknown column 'user.styleid' in 'on clause'
mysql error number: 1054
Date: Wednesday 31st of January 2007 02:24:54 PM
Script: http://www.thescuderia.co.uk/forums/forums/newreply.php
Referer: http://www.thescuderia.co.uk/forums...&threadid=17683
Database error in vBulletin 2.3.3:
Invalid SQL: SELECT
user.*,userfield.*,avatar.avatarpath,customavatar.dateline AS avatardateline,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
FROM user,userfield
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
WHERE userfield.userid=user.userid AND user.userid=343
mysql error: Unknown column 'user.avatarid' in 'on clause'
mysql error number: 1054
Date: Wednesday 31st of January 2007 02:26:19 PM
Script: http://www.thescuderia.co.uk/forums...messageid=36902
Referer: http://www.thescuderia.co.uk/forums/private.php?s=
Invalid SQL: SELECT
user.*,userfield.*,avatar.avatarpath,customavatar.dateline AS avatardateline,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
FROM user,userfield
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
WHERE userfield.userid=user.userid AND user.userid=343
mysql error: Unknown column 'user.avatarid' in 'on clause'
mysql error number: 1054
Date: Wednesday 31st of January 2007 02:26:19 PM
Script: http://www.thescuderia.co.uk/forums...messageid=36902
Referer: http://www.thescuderia.co.uk/forums/private.php?s=
Database error in vBulletin 2.3.3:
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='2' AND folderid=0 AND touser.userid=privatemessage.touserid AND fromuser.userid=privatemessage.fromuserid AND messageread=0 AND privatemessage.fromuserid<>298 ORDER BY dateline DESC
mysql error: Unknown column 'privatemessage.iconid' in 'on clause'
mysql error number: 1054
Date: Wednesday 31st of January 2007 03:00:43 PM
Script: http://www.thescuderia.co.uk/forums...s/usercp.php?s=
Referer: http://www.thescuderia.co.uk/forums/
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='2' AND folderid=0 AND touser.userid=privatemessage.touserid AND fromuser.userid=privatemessage.fromuserid AND messageread=0 AND privatemessage.fromuserid<>298 ORDER BY dateline DESC
mysql error: Unknown column 'privatemessage.iconid' in 'on clause'
mysql error number: 1054
Date: Wednesday 31st of January 2007 03:00:43 PM
Script: http://www.thescuderia.co.uk/forums...s/usercp.php?s=
Referer: http://www.thescuderia.co.uk/forums/
Any help is greatly appreciated.
Comment