help please. sql error
 

Invalid SQL:

SELECT user.*, (user.options & 512) AS invisible , avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, customavatar.filedata_thumb, customavatar.height AS avheight, customavatar.width AS avwidth, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb
FROM userlist AS userlist
INNER JOIN user AS user ON (user.userid = userlist.relationid)
LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)

WHERE userlist.userid = 17
AND userlist.type = 'buddy'
AND userlist.friend = 'yes'
LIMIT 0,;

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 10
Error Number : 1064
Request Date : Sunday, February 15th 2009 @ 08:40:43 AM
Error Date : Sunday, February 15th 2009 @ 08:40:43 AM
Script : http://mysite.co.il/friends.php?u=17
Referrer : http://mysite.co.il/showthread.php?t=660
IP Address : XX.XXX.X.XXX
Username : Splinter
Classname : vB_Database
MySQL Version :

Try disabling your plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

i only got it 1 time to my mail.. website is running..

Database error in vBulletin 3.7.0:

Invalid SQL:

SELECT user.*, (user.options & 512) AS invisible , avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, customavatar.filedata_thumb, customavatar.height AS avheight, customavatar.width AS avwidth, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb
FROM userlist AS userlist
INNER JOIN user AS user ON (user.userid = userlist.relationid)
LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)

WHERE userlist.userid = 17
AND userlist.type = 'buddy'
AND userlist.friend = 'yes'
LIMIT 0,;

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 10
Error Number : 1064
Request Date : Wednesday, February 18th 2009 @ 07:18:07 PM
Error Date : Wednesday, February 18th 2009 @ 07:18:07 PM
Script : http://site.co.il/friends.php?u=17
Referrer : http://site.co.il/index.php
IP Address : XX.XXX.195.76
Username : Splinter
Classname : vB_Database

well.. again.. x2 times to my email
disabling the plugins will make my mods not to work ??

It is a problem with your modification. You should post in the modification thread for help with the error or read the thread and see if it's already been addressed.

but to what modification its belong to ?

Script : http://site.co.il/friends.php?u=17

friends.php is not a default vBulletin file.

ok, problem solved thanks.