[Adem GEN?]

Hello,


Deprecated: Assigning the return value of new by reference is deprecated in *********/forum/classifieds.php on line 486






Database error in vBulletin 4.1.5:

Invalid SQL:

SELECT AVG(microclassifieds_orders.sreviewrating) AS thisrating,
user.* AS thisprofile
FROM microclassifieds_orders
JOIN user
ON user.userid=microclassifieds_orders.sellerid
WHERE microclassifieds_orders.sreviewrating>0
GROUP BY microclassifieds_orders.sellerid
ORDER BY microclassifieds_orders.sreviewrating DESC
LIMIT 5;

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 'AS thisprofile
FROM microclassifieds_orders
' at line 2
Error Number : 1064
Request Date : Sunday, August 21st 2011 @ 04:37:59 AM
Error Date : Sunday, August 21st 2011 @ 04:38:00 AM
Script : http://forum/classifieds.php
Referrer : http://forum/
IP Address : ********
Username : Adem GEN?
Classname : vB_Database
MySQL Version : 5.5.15-log



I receive this error