PDA

View Full Version : Got error after installing vb4 need help


nomoreturn
11-26-2009, 12:15 AM
Hello evry one i need help to fix database error i just install vb4 publish suit and got this error

Database error in vBulletin 4.0.0 Beta 4:

Invalid SQL:

SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline,
customavatar.width, customavatar.height, customavatar.width_thumb, customavatar.height_thumb
FROM vb_user AS user
LEFT JOIN vb_avatar AS avatar ON avatar.avatarid = user.avatarid
LEFT JOIN vb_customavatar AS customavatar ON customavatar.userid = user.userid
WHERE user.userid =;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 6
Error Number : 1064
Request Date : Wednesday, November 25th 2009 @ 09:10:12 PM
Error Date : Wednesday, November 25th 2009 @ 09:10:12 PM
Script : http://www.mastdunya.com/
Referrer :
IP Address : **.**2.**.**
Username : admin
Classname : vB_Database
MySQL Version : 5.0.81-community-log

HMBeaty
11-26-2009, 12:19 AM
Please see this thread:

Installation Issues / Questions or bug reports regarding default vBulletin 4.0 (https://vborg.vbsupport.ru/showthread.php?t=228035)

nomoreturn
11-26-2009, 12:27 AM
yeha i read that too my question is that before installation i have only forum upgraded vb4 forum and today i upgrade to vb4 publish suit so my question is i have to install blog and cms on some other directory or just simple upgrade it i think i just simple upgrade to vb4 publish so may be thats why i got this just want to make sure
blog link working
forum link working
whats new link working
only got this error when i clik on home link

Problem in CMS

Lynne
11-26-2009, 04:23 AM
The questions you are wondering about are all questions about the default vbulletin software and should be asked over on vb.com