[ �� ] ��

ahmed-samara · 29-11-2006, 02:41 AM

��

�� ,

��

��

��
��

��

��

ahmed-samara

ahmed-samara · 29-11-2006, 02:42 AM

��

��
��
http://www.******.com/cpanel
�**** ��
�� phpmyadmin ��

��

��

moon_shadow · 29-11-2006, 03:15 AM

��

ahmed-samara · 29-11-2006, 03:16 AM

��
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

��

1-

�� PHP:

  DELETE FROM session;

2-

�� PHP:

  CREATE TABLE `session` (

  `sessionhash` char(32) NOT NULL default '',

  `userid` int(10) unsigned NOT NULL default '0',

  `host` char(15) NOT NULL default '',

  `idhash` char(32) NOT NULL default '',

  `lastactivity` int(10) unsigned NOT NULL default '0',

  `location` char(255) NOT NULL default '',

  `useragent` char(100) NOT NULL default '',

  `styleid` smallint(5) unsigned NOT NULL default '0',

  `languageid` smallint(5) unsigned NOT NULL default '0',

  `loggedin` smallint(5) unsigned NOT NULL default '0',

  `inforum` smallint(5) unsigned NOT NULL default '0',

  `inthread` int(10) unsigned NOT NULL default '0',

  `incalendar` smallint(5) unsigned NOT NULL default '0',

  `badlocation` smallint(5) unsigned NOT NULL default '0',

  `bypass` tinyint(4) NOT NULL default '0',

  `profileupdate` smallint(5) unsigned NOT NULL default '0',

  PRIMARY KEY  (`sessionhash`)

) TYPE=HEAP;

��

��

Database error in vBulletin 3.6.4:

Invalid SQL:

UPDATE session
SET lastactivity = 1164695903, location = '/vb/admincp/email.php?do=dosendmail&do=dosendmail', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = 'bb54ff31f2d2aabe4c51f2a3338e09a6';

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Tuesday, November 28th 2006 @ 12:54:01 AM
Script : http://xxxx/vb/admincp/email.php?do=dosendmail
Referrer : http://xxxx/vb/admincp/email.php?do=start
IP Address : xxxxxxxxx
Username : xxxxxx
Classname : vb_database

��
MySQL Error : Lost connection to MySQL server during query

�� ...
�� ..

moon_shadow · 29-11-2006, 03:19 AM

��

ahmed-samara · 29-11-2006, 03:19 AM

��

Database error in vBulletin 3.6.3:

Invalid SQL:

SELECT
SUM(IF(readtime <> 0, 1, 0)) AS confirmed,
SUM(IF(readtime = 0, 1, 0)) AS unconfirmed
FROM pmreceipt
WHERE userid = 19472;

��

��

Database error in vBulletin 3.6.3:

Invalid SQL:

UPDATE pmreceipt SET
tousername = 'admin'
WHERE touserid = 1;

MySQL Error : Table 'w_vb.pmreceipt' doesn't exist
Error Number : 1146
Date : Monday, November 27th 2006 @ 03:20:36 AM
Script : http://www.00000.com/vb/admincp/misc...pdateusernames
Referrer : http://www.0000.com/vb/admincp/misc.php?do=chooser
IP Address :
Username : admin
Classname :

��

��

�� PHP:

  CREATE TABLE `pmreceipt` (

  `pmid` int(10) unsigned NOT NULL default '0',

  `userid` int(10) unsigned NOT NULL default '0',

  `touserid` int(10) unsigned NOT NULL default '0',

  `tousername` varchar(100) NOT NULL default '',

  `title` varchar(250) NOT NULL default '',

  `sendtime` int(10) unsigned NOT NULL default '0',

  `readtime` int(10) unsigned NOT NULL default '0',

  `denied` smallint(5) unsigned NOT NULL default '0',

  PRIMARY KEY  (`pmid`),

  KEY `userid` (`userid`),

  KEY `touserid` (`touserid`)

) TYPE=MyISAM;

ahmed-samara · 29-11-2006, 03:22 AM

��

��

MySQL Error : Table 'lolo4_lolo4.adminmessage' doesn't exist
Error Number : 1146
Date : Wednesday, August 23rd 2006 @ 08:48:06 PM
Script : http://www.xxxx.net/vbp/admincp/index.php?do=home
Referrer : http://www.xxxx.net/vbp/admincp/index.php?do=nav
IP Address : 62.135.25.36
Username : admin
Classname : vb_database</textarea></form>

��

MySQL Error : Unknown column 'warnings' in 'field list'
Error Number : 1054
Date : Wednesday, August 23rd 2006 @ 09:13:45 PM
Script : http://www.xxxxx.net/vbp/admincp/user.php?do=update
Referrer : http://www.xxxx.net/vbp/admincp/use...=edit&u=134
IP Address : 62.135.25.36
Username : admin
Classname : vb_database</textarea></form>

��

��
��

��:

DROP TABLE IF EXISTS adminmessage;
CREATE TABLE `adminmessage` (
  `adminmessageid` int(10) unsigned NOT NULL auto_increment,
  `varname` varchar(250) NOT NULL default '',
  `dismissable` smallint(5) unsigned NOT NULL default '0',
  `script` varchar(50) NOT NULL default '',
  `action` varchar(20) NOT NULL default '',
  `execurl` mediumtext NOT NULL,
  `method` enum('get','post') NOT NULL default 'post',
  `dateline` int(10) unsigned NOT NULL default '0',
  `status` enum('undone','done','dismissed') NOT NULL default 'undone',
  `statususerid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`adminmessageid`),
  KEY `script_action` (`script`,`action`),
  KEY `varname` (`varname`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

��

��:

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

Rewish-Maxer · 29-11-2006, 03:41 AM

��

��

�� PHP:

  Database error in vBulletin 3.6.0:

 
Invalid SQL:

 
SELECT

post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,

user.*, userfield.*, usertextfield.*,

icon.title as icontitle, icon.iconpath,

avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,

deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,

editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,

editlog.reason AS edit_reason,

postparsed.pagetext_html, postparsed.hasimages,

sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,

sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,

IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid

 
 
FROM post AS post

LEFT JOIN user AS user ON(user.userid = post.userid)

LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)

LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)

LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)

LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)

LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post')

LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)

LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 39 AND postparsed.languageid = 2)

LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 39 AND sigparsed.languageid = 2)

LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)

 
WHERE post.postid IN (0,20537,20538,20539,20560,20561,20566,20567,20570 ,20572,20573)

ORDER BY post.dateline;

 
MySQL Error : Unknown column 'customavatar.width' in 'field list'

Error Number : 1054

Date : Monday, October 16th 2006 @ 07:56:26 AM

****** : [url]http://www.xxxxx.com/vb/showthread.php?=&threadid=2637[/url]

Referrer : 

IP Address : 63.146.104.148

Username : xxxxx

Classname : vb_database

��

ahmed-samara · 29-11-2006, 03:43 AM

��:

�� Rewish-Maxer

��

��

�� PHP:

Database error in vBulletin 3.6.0: Invalid SQL: SELECT post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted, user.*, userfield.*, usertextfield.*, icon.title as icontitle, icon.iconpath, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason, editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline, editlog.reason AS edit_reason, postparsed.pagetext_html, postparsed.hasimages, sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages, sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid FROM post AS post LEFT JOIN user AS user ON(user.userid = post.userid) LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid) LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid) LEFT JOIN icon AS icon ON(icon.iconid = post.iconid) LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post') LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid) LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 39 AND postparsed.languageid = 2) LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 39 AND sigparsed.languageid = 2) LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid) WHERE post.postid IN (0,20537,20538,20539,20560,20561,20566,20567,20570 ,20572,20573) ORDER BY post.dateline; MySQL Error : Unknown column 'customavatar.width' in 'field list' Error Number : 1054 Date : Monday, October 16th 2006 @ 07:56:26 AM ****** : [url]http://www.xxxxx.com/vb/showthread.php?=&threadid=2637[/url] Referrer : IP Address : 63.146.104.148 Username : xxxxx Classname : vb_database

��

��

��:

ALTER TABLE `customavatar` ADD `width` smallint(5) unsigned NOT NULL default '0'; 
  ALTER TABLE `customavatar` ADD `height` smallint(5) unsigned NOT NULL default '0';

Rewish-Maxer · 29-11-2006, 03:45 AM

��

��

moon_shadow · 29-11-2006, 03:47 AM

�� 2 ��
�� mozilla �� Fire Fox �� internet Explorer �� phpmyadmin
��
www.mozilla.com

ahmed-samara · 29-11-2006, 03:51 AM

Rewish-Maxer

��

moon_shadow
��
��

ahmed-samara · 29-11-2006, 06:46 AM

�� 3.6.0

�� PHP:

  Database error in vBulletin 3.6.2: 

 
Invalid SQL: 

TRUNCATE TABLE post_parsed; 

 
MySQL Error : Table 'vbxxxvb.post_parsed' doesn't exist 

Error Number : 1146 

Date : Tuesday, October 31st 2006 @ 12:01:03 AM 

****** : http://mysite.net/montada/xxx/plugin.php?do=productkill 

Referrer : http://mysite.net/montada/xxx/plugin...ssy_tools& s= 

IP Address : 2121212121 

Username : username 

Classname : vb_database

��

post_parsed ��
��
�� post_parsed �� postparsed �� 3.6 �� 3.5.4 �� :

�� PHP:

  rename table postparsed to post_parsed ;

�� :

�� PHP:

  CREATE TABLE `post_parsed` (

  `postid` int(10) unsigned NOT NULL default '0',

  `dateline` int(10) unsigned NOT NULL default '0',

  `styleid_code` int(11) NOT NULL default '-1',

  `styleid_html` int(11) NOT NULL default '-1',

  `styleid_php` int(11) NOT NULL default '-1',

  `styleid_quote` int(11) NOT NULL default '-1',

  `hasimages` smallint(6) NOT NULL default '0',

  `pagetext_html` mediumtext,

  PRIMARY KEY  (`postid`,`styleid_code`,`styleid_html`,`styleid_php`,`styleid_quote`),

  KEY `dateline` (`dateline`)

) type=MyISAM ;

��

moon_shadow

��:

�� ahmed-samara

�� 3.6.0

�� PHP:

Database error in vBulletin 3.6.2: Invalid SQL: TRUNCATE TABLE post_parsed; MySQL Error : Table 'vbxxxvb.post_parsed' doesn't exist Error Number : 1146 Date : Tuesday, October 31st 2006 @ 12:01:03 AM ****** : http://mysite.net/montada/xxx/plugin.php?do=productkill Referrer : http://mysite.net/montada/xxx/plugin...ssy_tools& s= IP Address : 2121212121 Username : username Classname : vb_database

��

post_parsed ��
��
�� post_parsed �� postparsed �� 3.6 �� 3.5.4 �� :

�� PHP:

rename table postparsed to post_parsed ;

�� :

�� PHP:

CREATE TABLE `post_parsed` ( `postid` int(10) unsigned NOT NULL default '0', `dateline` int(10) unsigned NOT NULL default '0', `styleid_code` int(11) NOT NULL default '-1', `styleid_html` int(11) NOT NULL default '-1', `styleid_php` int(11) NOT NULL default '-1', `styleid_quote` int(11) NOT NULL default '-1', `hasimages` smallint(6) NOT NULL default '0', `pagetext_html` mediumtext, PRIMARY KEY (`postid`,`styleid_code`,`styleid_html`,`styleid_php`,`styleid_quote`), KEY `dateline` (`dateline`) ) type=MyISAM ;

��

�� postparsed �� :

��:

�� sami1706

�� 1 �� 2
�� 1 �� 3.5 �� 3.6 �� 3.5 �� 3.6 �� 3.6 ��
�� 2 �� post_parsed �� post_parsed �� 3.6 �� post_parsed � �� postparsed �� post_parsed �� :
Table '.post_parsed' doesn't exist
�� postparsed �� post_parsed �� :

�� PHP:

RENAME TABLE postparsed TO post_parsed ;

�� postparsed �� :

�� PHP:

RENAME TABLE post_parsed TO postparsed ;

��
��