PDA

View Full Version : Help! Database error when I try and access user.php in the admin cp...

Chris M
05-25-2002, 09:26 AM
I keep getting this error :

Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: SELECT *,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,FROM_UNIXTIME(awaydate) AS awaydateastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,
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=31
mysql error: You have an error in your SQL syntax near ') AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,
' at line 1

mysql error number: 1064

Do you know what can be done to correct it?

Satan
Chris M
05-25-2002, 09:34 AM
I think I have solved it...

May not have tho...

Satan
Chris M
05-25-2002, 09:36 AM
Damn it...

Now Ive got This error :

Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: SELECT *,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,FROM_UNIXTIME(awaydate) AS awaydateastactivity AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,
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=31
mysql error: You have an error in your SQL syntax near 'AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,
' at line 1

mysql error number: 1064

Satan
Chris M
05-25-2002, 09:39 AM
Ok...No problem now...

I sorted both errors!

Can a Mod close or delete this topic now...Thanks...

Satan
Foxtroter
06-22-2002, 11:45 PM
well could u at least tell me whatcha did im having same prob
Steve Machol
06-22-2002, 11:47 PM
The best way to fix this is to upgrade to 2.2.6.
Foxtroter
06-23-2002, 01:59 AM
thanks i got it
Chris M
06-24-2002, 10:26 AM
Sorry Foxtroter...

I posted this on the 25th of May, almost a Month ago, so I didnt need it again...

Satan