Help me to solve this PROBLEM

[saqr]

Hi ,

Please Tell me why when I try to see or the profile of the users I see this error message
Database error in vBulletin 2.2.5:
---------------------------------------------------------------------------------
Invalid SQL: SELECT user.avatarid,avatarpath,\ ISNULL(avatardata) AS hascustom,customavatar.dateline
FROM user
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
WHERE user.userid='5'
mysql error: You have an error in your SQL syntax near '\ ISNULL(avatardata) AS hascustom,customavatar.dateline
' at line 1

mysql error number: 1064

Date: Monday 20th of May 2002 02:49:39 AM
Script: http://www.alsaqr.com/vb/vb/member.php?action=getinfo&userid=5
Referer: http://www.alsaqr.com/vb/
-----------------------------------------------------------------------------------

PLEASE TELL ME WHAT IS THE PROBLEM AND HOW TO SOLVE IT


Thank you

[eva2000]

Please enter your vBulletin.com forum username on the form on this page to receive support for this issue: http://www.vbulletin.com/members/forums.php
- you will need your vB license customer number and password to access this form.

[saqr]

Thank you

[eva2000]

i see you vB forum is in another language

create a file named phpinfo.php and place this code in it and post the url/link to it from your web site

<?
phpinfo();
?>

i.e. yourdomain.com/phpinfo.php

[saqr]

Thanks eva2000


The file you suggest me to add it to my directory is already there .

and when I run this URL the page of PHP Version 4.0.6
and all the information of my PHP shown in this page .
but do you mean that when I create this file the problem will gone ? if NO what is the other solution I can do it to solve this problem ?

I already asked my host server (HOSTWAY) to change the configuration of there PHP as i saw in this forum but they said we can't give any support to other software or programs not taken from our company ..

Thanks again for you repply and I hope you can find solution for this problem.

[Steve Machol]

Originally posted by saqr

but do you mean that when I create this file the problem will gone ? if NO what is the other solution I can do it to solve this problem ?No, this file is needed to help investigate the problem which is why eva2000 asked you to create it and post the link to it here.

[saqr]

OK

this thwe like for Phpinfo you asked :

http://www.alsaqr.com/phpinfo.php

Hope you can know what is the problem


Thanks

[eva2000]

what mysql version are you using ?

do you have any hacks you installed ?

you may need to submit a support ticket at http://vbulletin.com/members/support.php will all the info you provided in this thread along with the answer to the above 2 questions.

[Steve Machol]

According to the phpinfo file, the MySQL version is 3.22.25. The minimum version needed for vB (as per the purchase page) is 3.23.

[saqr]

So nothing to do with this problem because when I asked my host server (HOSTWAY.COM) to update there server they said we can't give any support to other software or programs not taken from our company.
it means the problem will remain until they update the server .

anyway thanks for your help .

:( :confused: :(

[eva2000]

Originally posted by saqr
So nothing to do with this problem because when I asked my host server (HOSTWAY.COM) to update there server they said we can't give any support to other software or programs not taken from our company.
it means the problem will remain until they update the server .

anyway thanks for your help .

:( :confused: :( hmmm i'd find a new host if they refuse to update outdated software on their servers