I installed it and anything seems to work fine but now i recognised a problem!

After a users returndate he is still away!
No changes..

Hmm any suggestions would be nice :D

Greetings

StarBuG

But....

Admin CP editing a user gets this message

Database error in vBulletin Control Panel 2.2.1:

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 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=1
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: Tuesday 22nd of January 2002 06:43:14 PM
Script: http://buffy.phpwebhosting.com/forum...=edit&userid=1
Referer: http://buffy.phpwebhosting.com/forums/admin/?


Could you tell me what I need to edit.. i tried the suggest you have earlier on page 5 of this thread, but it didn't seem to make a difference.

Cheers.

[QUOTE]Originally posted by Russ
But....

Admin CP editing a user gets this message

Database error in vBulletin Control Panel 2.2.1:

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 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=1
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: Tuesday 22nd of January 2002 06:43:14 PM
Script: http://buffy.phpwebhosting.com/forum...=edit&userid=1
Referer: http://buffy.phpwebhosting.com/forums/admin/?


Could you tell me what I need to edit.. i tried the suggest you have earlier on page 5 of this thread, but it didn't seem to make a difference.

Cheers.

I know this is a long thread, but can someone answer my question?

I am having the same problem as a few others with the away icon not showing in post. Online status is on and everything else seems to be ok.. Ijust dont see the icon.. Great hack though.:)

My mistake on the last error but now I'm getting this error when I go to user options at the bottom of members profile..

Database error in vBulletin Control Panel 2.2.1:

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 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=27
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: Tuesday 29th of January 2002 08:40:47 AM
Script: http://www.a2zautoforums.com/admin/u...edit&userid=27
Referer: http://www.a2zautoforums.com/admin/i...%26userid%3D27

I noticed a couple of other post with the same problem. Has anyone created a fix yet or figured out how to fix this?

Thanks:)

Please disregard this post the problem was the coma after:

FROM_UNIXTIME(awaydate) AS awaydate

was missing. Hasn't been updated in the install script.

I upgraded to 2.2.2 and tried twice install this hack twice. I backed up my php files before i started installing the hack so I had fresh files each time. I couldn't get anything to show at all anywhere. I know I'm seeing 2.2.2 at the beginning of this post, lol.. I managed to get it installed on 2.2.1 and it worked perfectly.. Its a real nice addition. Just not for me right now.:(

[QUOTE]Originally posted by PhotoGenie
My mistake on the last error but now I'm getting this error when I go to user options at the bottom of members profile..

Database error in vBulletin Control Panel 2.2.1:

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 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=27
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: Tuesday 29th of January 2002 08:40:47 AM
Script: http://www.a2zautoforums.com/admin/u...edit&userid=27
Referer: http://www.a2zautoforums.com/admin/i...%26userid%3D27

I noticed a couple of other post with the same problem. Has anyone created a fix yet or figured out how to fix this?

Thanks:)

Please disregard this post the problem was the coma after:

FROM_UNIXTIME(awaydate) AS awaydate

was missing. Hasn't been updated in the install script.

[QUOTE]Originally posted by bira
sorry, try adding a coma , after "FROM_UNIXTIME(awaydate) AS awaydate"

Yep Linus.. My problem too.. I corrected it the first time I installed it but the second time I had forgotten it... Seems thats really the only problem in the installer.. Mine is working now though :) .. I really like this hack.