[1320Nation]

I have had issues with getting this mod to work on my domain. My webtech fixed it but, said to pass this info along to the developer.

Tell the developer to edit \microclassifieds\includes\functions.php

And change:
".TABLE_PREFIX."user.* AS thisprofile
to:
".TABLE_PREFIX."user.*

in every place he's done that.
Otherwise it'll never work right.

Btw, before fixing the issue this is the error I was getting.

Database error in vBulletin 4.1.5:

Invalid SQL:

SELECT AVG(board_microclassifieds_orders.sreviewrating) AS thisrating,
board_microclassifieds_profiles.* AS thisprofile
FROM board_microclassifieds_orders
JOIN board_microclassifieds_profiles
ON board_microclassifieds_profiles.userid=board_micro classifieds_orders.sellerid
WHERE board_microclassifieds_orders.sreviewrating>0
GROUP BY board_microclassifieds_orders.sellerid
ORDER BY board_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 board_microclassifieds_orders
' at line 2
Error Number : 1064