Invalid SQL: SELECT whoviewed FROM thread WHERE threadid = 5879
mysql error: Unknown column 'whoviewed' in 'field list'
mysql error number: 1054
Date: Tuesday 31st of May 2005 02:02:03 PM
ÇáÍá
ÇÚãá ÇÕáÇÍ ááÌÏÇæá æÞÇÚÏÉ ÇáÈíÇäÇÊ
=================================================
ÇáãÔßáå
Invalid SQL: SELECT u.userid, u.username FROM user u WHERE u.downloads LIKE "32%" OR u.downloads LIKE "%32%" OR u.downloads LIKE "%32" ORDER BY u.username ASC
mysql error: Unknown column 'u.downloads' in 'where clause'
mysql error number: 1054
ÇáÍá
ÇÒÑÚ ÇáÇãÑ ÇáÊÇáí
ßæÏ PHP:
[color="Green"]ALTER TABLE `user` ADD `downloads` **** NOT NULL;[/color]
Invalid SQL:
UPDATE poll
SET votes = '1|||0|||0|||0',
voters = voters + 1,
lastvote = 1118582446
WHERE pollid = 2
mysql error: Unknown column 'lastvote' in 'field list'
mysql error number: 1054
Date: Sunday 12th of June 2005 10:20:46 AM
ÇáÍá
ÇÒÑÚ ÇáÇãÑ ÇáÊÇáí
ALTER TABLE `poll` ADD `lastvote` INT(15) DEFAULT '0' NOT NULL;
========================================
ÇáãÔßáÉ
<!--
Data**** error in vBulletin :
Link-ID == false, connect failed
mysql error:
mysql error number: 0
Date: Monday 13th of March 2006 03:16:31 AM
ÇáÍá
ÞÇÚÏÉ ÇáÈíÇäÇÊ ÝÕáå ãä ÇáÓíÑÝÑ
=========================================
ÇáãÔßáå
Data**** error in vBulletin 3.5.3:
Invalid SQL:
SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.page**** AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open,
replycount, postusername, postuserid, thread.iconid AS threadiconid,
thread.lastpost, lastposter, thread.dateline, IF(views<=replycount,
replycount+1, views) AS views, notes, thread.visible, sticky, votetotal,
thread.attach,
hiddencount
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username,
deletionlog.reason AS del_reason
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid =
deletionlog.primaryid AND type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid =
thread.threadid AND subscribethread.userid = 1)
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
WHERE thread.threadid IN
(0,1478,1394,1447,1489,1487,1485,1481,1370,1476,13 59,1421,1424,1269,1387,1231,1348,1239,1437,1417,14 48,91,460,420,507,1395)
ORDER BY sticky DESC, thread.lastpost DESC;
MySQL Error : Can't open file: 'post.MYI'. (errno: 144)
Error Number : 1016
Date : Sunday, March 5th 2006 @ 09:16:17 AM
ÇáÍá
ÇÕáÇÍ ÞæÇÚÏ ÇáÈíÇäÇÊ æÇáÌÏÇæá
æÞÇáÈ ãÇ íÌíß åÐÇ ÇáÎØÇÁ
Can't open file:xxxMYI
================================================
ÇáãÔßáÉ
Invalid SQL:
SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid,
session.userid, session.inforum, session.lastactivity,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > 1141921235
ORDER BY username ASC;
MySQL Error : Can't open file: 'session.MYI' (errno: 145)
Error Number : 1016
Date : Thursday, March 9th 2006 @ 08:35:36 AM
ÇáÍá
ÇÒÑÚ ÇáÇãÑíä
ßæÏ PHP:
DELETE FROM session;
ßæÏ PHP:
CREATE TABLE session (
ßæÏ PHP:
[left]sessionhash varchar(32) NOT NULL default '', userid int(10) unsigned NOT NULL default '0', host varchar(15) NOT NULL default '', lastactivity int(10) unsigned NOT NULL default '0', styleid smallint(5) unsigned NOT NULL default '0', location varchar(255) NOT NULL default '', althash varchar(32) NOT NULL default '', badlocation tinyint(3) unsigned NOT NULL default '0', inforum smallint(5) unsigned NOT NULL default '0', inthread int(10) unsigned NOT NULL default '0', incalendar int(10) unsigned NOT NULL default '0', loggedin smallint(5) unsigned NOT NULL default '0', idhash varchar(32) NOT NULL default '', useragent varchar(100) NOT NULL default '', bypass smallint(6) NOT NULL default '0', PRIMARY KEY (sessionhash) ) TYPE=HEAP; [/left]
============================
ÇáãÔßáÉ
========
<!--
Data**** error in vBulletin 3.5.4:
Invalid SQL:
SELECT
userfield.*, user****field.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_holiday AS phrasegroup_holiday,
language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN user****field AS user****field ON (user****field.userid = user.userid) INNER JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 5, user.languageid))
SELECT imagecategorypermission.imagecategoryid, usergroupid
FROM imagecategorypermission AS imagecategorypermission, imagecategory AS imagecategory
WHERE imagetype = 2
AND imagecategorypermission.imagecategoryid = imagecategory.imagecategoryid
ORDER BY imagecategory.displayorder;
Invalid SQL:
SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline
FROM user AS user
LEFT JOIN avatar AS avatar ON avatar.avatarid = user.avatarid
LEFT JOIN customavatar AS customavatar ON customavatar.userid = user.userid
WHERE user.userid = 76
mysql error: Unknown column 'avatardata' in 'field list'
Invalid SQL:
SELECT wordid, title FROM word WHERE title IN ('','ãÔÇÑßÉ','ÞáÞ¡','ÈßÇÁ','¡','äÑÝÒÉ','¡','ÃÚÑÇÖ' ,'ãÊáÇÒãÉ','ãÇ','ÞÈá','ÇáÏæÑå','ÇáÔåÑíøå','ÝãÇ','å æ','åÐÇ','ÇáãÑÖ¿','ÔßÑÇ','íÇ','Ãã','ÇáØíÈ','Úáì',' åÐÇ','ÇáãæÖæÚ');
MySQL Error : Table 'at3ad_vb.word' doesn't exist
Error Number : 1146
Data**** error in vBulletin 3.5.0 Release Candidate 3
ÇáãÔßáÉ
Data**** error in vBulletin 3.5.0 Release Candidate 3:
Invalid SQL:
SELECT username, userid, birthday
FROM user
WHERE (birthday LIKE '03-29-%' OR birthday LIKE '03-30-%')
AND usergroupid IN (0, 6, 7, 2, 5)
AND showbirthday = 2
AND lastactivity >= 1141125827;
MySQL Error : Unknown column 'showbirthday' in 'where clause'
Error Number : 1054
Date : Thursday, March 30th 2006 @ 01:23:47 PM
****** : http://www.b7st.com/vbno/
Referrer :
IP Address : 212.138.47.17
Username : admin
Classname : vb_data****
ÇáÍá
ÇÒÑÚ åÇ ÇáÇãÑ
ßæÏ PHP:
ALTER TABLE `user` ADD `showbirthday` MEDIUMBLOB NOT NULL;
Çæ åÐ
ßæÏ PHP:
ALTER TABLE `user` ADD `showbirthday` INT(10) UNSIGNED DEFAULT '0' NOT NULL;
ÇáãÝÖáÇÊ