PDA

View Full Version : Help:How can I fix this error?


Peace
07-13-2002, 11:58 AM
I'm getting this error when I try to post a message. The following message appearing at the top of the page. The databse error, in quote, that I got from my Admin email account is below.

Parse error: parse error, unexpected '}', expecting ']' in /home/www/theonlinelounge/forums/admin/functions.php(432) : eval()'d code on line 28




Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: SELECT user.*,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,FROM_UNIXTIME(awaydate) AS awaydate
avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
FROM user
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
WHERE user.userid=7
mysql error: You have an error in your SQL syntax near 'avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
' at line 2

mysql error number: 1064

Date: Friday 12th of July 2002 08:09:54 PM
Script: http://www.theonline.com/forums/forums/admin/user.php?action=edit&userid=7
Referer: http://theonline.com/forums/admin/?

Peace
07-13-2002, 03:12 PM
Can someone help me, please?

Here's my function file in the attachment. Can someone take a look at it and see what is missing or what's causing the problem.

Admin
07-13-2002, 03:58 PM
Please don't post full files from vBulletin. Also don't bump your post every few hours.