اقتباس: |
المشاركة الأصلية كتبت بواسطة jeddah
عند البحث عن المشاركات الجديدة تظهر هذا الخطا
ارجو المساعدة
Database error in vBulletin 3.6.4:
Invalid SQL:
SELECT searchid FROM search AS search WHERE userid = 1 AND searchhash = '5f88436d1d3039c7696f24d0e2b39513' AND orderedids = '246,22,224,226,212,204,225,130,138,203,206,119,234,21,117,237,118,102,121,240,120,261,176,192,257,2 29,190,218,164,202,186,187,260,194,182,245,207,259,255,133,30,209,242,248,134,231,227,135,104,253,25 2,25,48,239,254,10,149,47,79,247,249,131' AND announceids = '' AND completed = 1;
MySQL Error : Unknown column 'completed' in 'where clause'
Error Number : 1054
Date : Friday, February 9th 2007 @ 05:40:54 AM
Script : http://mjnon.com/search.php?do=getdaily
Referrer : http://mjnon.com/search.php?do=getnew
IP Address :
Username :
Classname : vb_database |
تفضل اتبع الخطواط
اول شئ طريقة زرع الأمر http://www.swalif.net/softs/showpost...52&postcount=2
ثم ثاني شئ
ازرع هذا الأمر : كود PHP: DROP TABLE IF EXISTS search;
CREATE TABLE `search` (
`searchid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`ipaddress` varchar(15) NOT NULL default '',
`personal` smallint(5) unsigned NOT NULL default '0',
`query` varchar(200) NOT NULL default '',
`searchuser` varchar(200) NOT NULL default '',
`forumchoice` mediumtext,
`sortby` varchar(200) NOT NULL default '',
`sortorder` varchar(4) NOT NULL default '',
`searchtime` float NOT NULL default '0',
`showposts` smallint(5) unsigned NOT NULL default '0',
`orderedids` mediumtext,
`announceids` mediumtext,
`dateline` int(10) unsigned NOT NULL default '0',
`searchterms` mediumtext,
`displayterms` mediumtext,
`searchhash` varchar(32) NOT NULL default '',
`titleonly` smallint(5) unsigned NOT NULL default '0',
`completed` smallint(5) unsigned NOT NULL default '1',
PRIMARY KEY (`searchid`),
UNIQUE KEY `searchunique` (`searchhash`,`sortby`,`sortorder`)
) TYPE=MyISAM ;
__________________
Swalif (for) ever |