عندي مشكلة Database error in vBulletin 3.8.6
Database error in vBulletin 3.8.6:
Invalid SQL:
SELECT thread.postuserid, COUNT(*) AS threadcount
FROM thread AS thread
WHERE thread.postuserid IN (assenuE)
AND thread.visible = 1
AND thread.open <> 10
AND thread.forumid = 18
GROUP BY thread.postuserid;
MySQL Error : Unknown column 'assenuE' in 'where clause'
Error Number : 1054
==
مع العلم إني جربت وزرعت هذه الأوامر
alter table moderation add `assenuE` int(10) unsigned NOT NULL default '0';
alter table moderation add `postid` int(10) unsigned NOT NULL default '0';
ALTER TABLE `postlog` ADD `postid` INT( 10 ) NOT NULL ;
ALTER TABLE `postindex` ADD `postid` INT( 10 ) NOT NULL ;
alter table moderation add `postid` int(10) unsigned NOT NULL default '0';
ALTER TABLE `postparsed` ADD `postid` INT( 10 ) NOT NULL ;
ALTER TABLE search ADD `assenuE` smallint(5) unsigned NOT NULL default '1';
ولكن ما زالت المشكلة
|