مشكلتي في المنتدى

[عاشق المنتديات]

السلام عليكم

من اعدل خيارات المنتدى

يعتفس

Invalid SQL:
SELECT usergroupid,avatarrevision,reputation,user.posts,u ser.usertitle,user.username,user.userid,COUNT(*) AS total FROM user AS user,post AS post WHERE usergroupid IN (Array) AND user.userid NOT IN (0) AND user.userid=post.userid AND post.dateline BETWEEN 1214924673 AND 1215011073 GROUP BY post.userid ORDER BY total DESC LIMIT 1;

MySQL Error : Unknown column 'Array' in 'where clause'
Error Number : 1054
Request Date : Wednesday, July 2nd 2008 @ 03:04:33 PM
Error Date : Wednesday, July 2nd 2008 @ 03:04:33 PM
Script : http://r7l3.net/vb/
Referrer :
MySQL Version : 5.0.51a-community

[i.s.s.w]

تاكد من الجداول كلها موجوده والترميز نفس الشي

usergroupid,avatarrevision,reputation,user.posts,u ser.usertitle,user.username,user.userid,

[serag777]

الحـــــــل:







ازرع الامر التالي
بالقاعدة


ALTER TABLE `user` ADD `showbirthday` INT(10) UNSIGNED DEFAULT '0' NOT NULL;