[ �� ] �� - �� 27

benelmokadem · 03:07 PM

��:

��

��

�� 112 ��

��

�� max_connections
��

+212027603014

�� · 27-04-2008, 03:08 PM

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User almubark_vbbb already has more than 'max_user_connections' active connections**:\**\vhosts\halaq8.com\httpdocs\vb\includes\class_core.php on line 274

��
��

�� , ��
'max_user_connections'

��

benelmokadem · 27-04-2008, 03:10 PM

��

�� max_connections

�� · 27-04-2008, 03:11 PM

��

��
��

benelmokadem · 27-04-2008, 03:13 PM

��:

��

��

��
��

��

c5c6.com · 08-05-2008, 06:00 AM

��

Database error in vBulletin 3.7.0:
Invalid SQL:
SELECT pf.profilefieldcategoryid, pfc.location, pf.*
FROM profilefield AS pf
LEFT JOIN profilefieldcategory AS pfc ON(pfc.profilefieldcategoryid = pf.profilefieldcategoryid)
WHERE pf.form = 0
ORDER BY pfc.displayorder, pf.displayorder;
MySQL Error : Unknown column 'pfc.location' in 'field list'
Error Number : 1054

��

Sawah · 10-05-2008, 12:10 PM

��

��

��:

��� �� ����� ������ vBulletin 3.6.8:

Invalid SQL:
SELECT crown_type AS type, show_crowns, show_t_won FROM games_settings;

��� MySQL : MySQL server has gone away
��� ����� : 2006

��

��

��:

��� �� ����� ������ vBulletin 3.6.8:

Invalid SQL:

SELECT user.username, user.usergroupid, user.membergroupids,
session.userid, session.inthread, session.lastactivity,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid,
IF(user.options & 512, 1, 0) AS invisible
FROM session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > 1210406200
ORDER BY username ASC, lastactivity DESC;

��� MySQL : MySQL server has gone away
��� ����� : 2006

��:

��� �� ����� ������ vBulletin 3.6.8:

Invalid SQL:

SELECT thread.threadid, thread.forumid, thread.title, postusername, postuserid, thread.lastpost, thread.replycount, forum.title AS forumtitle
,post.pagetext AS preview


FROM thread AS thread
INNER JOIN forum AS forum ON (forum.forumid = thread.forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)


WHERE thread.threadid IN (35911, 41671, 42377, 48166, 46805) AND thread.visible = 1
AND forum.password = ''


ORDER BY lastpost DESC;

��� MySQL : MySQL server has gone away
��� ����� : 2006

��:

��� �� ����� ������ vBulletin 3.6.8:

Invalid SQL:

UPDATE session
SET lastactivity = 1210362821, location = '/vb/newreply.php?do=newreply&amp;p=1006657', incalendar = 0, badlocation = 0, useragent = 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506)'
WHERE sessionhash = 'f2dde8dc377c71f8bac6cc3170a5bd91';

��� MySQL : MySQL server has gone away
��� ����� : 2006

��

ahmed-samara · 10-05-2008, 12:24 PM

��:

�� c5c6.com

��

Database error in vBulletin 3.7.0:
Invalid SQL:
SELECT pf.profilefieldcategoryid, pfc.location, pf.*
FROM profilefield AS pf
LEFT JOIN profilefieldcategory AS pfc ON(pfc.profilefieldcategoryid = pf.profilefieldcategoryid)
WHERE pf.form = 0
ORDER BY pfc.displayorder, pf.displayorder;
MySQL Error : Unknown column 'pfc.location' in 'field list'
Error Number : 1054

��

�� c5c6.com

�� ...

�� PHP:

   define('DISABLE_HOOKS', 1);

��
�� ?>

�� Sawah
�� phpmyadmin
��

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;

��

Sawah · 10-05-2008, 01:23 PM

��

�� ahmed-samara ��

��

Sawah · 10-05-2008, 08:28 PM

��

�� session ��

��:

��� �� ����� ������ vBulletin 3.6.8:

Invalid SQL:

REPLACE INTO postindex
(wordid, postid, score, intitle)
VALUES
(5066411, 1007301, 1, 0), (5065736, 1007301, 3, 0), (5101043, 1007301, 1, 0), (5066413, 1007301, 1, 0), (5085277, 1007301, 1, 0), (5206161, 1007301, 1, 0), (5066789, 1007301, 1, 0), (5066664, 1007301, 1, 0), (5087368, 1007301, 1, 0), (5066477, 1007301, 1, 0), (5066944, 1007301, 1, 0), (5082711, 1007301, 1, 0), (5067237, 1007301, 1, 0);

��� MySQL : Table './ahmed166_9ada/postindex' is marked as crashed and last (automatic?) repair failed
��� ����� : 144

��:

��� �� ����� ������ vBulletin 3.6.8:

Invalid SQL:

SELECT thread.threadid, thread.forumid, thread.title, postusername, postuserid, thread.lastpost, thread.replycount, forum.title AS forumtitle
,post.pagetext AS preview


FROM thread AS thread
INNER JOIN forum AS forum ON (forum.forumid = thread.forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)


WHERE thread.threadid IN (46108, 38715, 42675, 30376, 46746) AND thread.visible = 1
AND forum.password = ''


ORDER BY lastpost DESC;

��� MySQL : MySQL server has gone away
��� ����� : 2006

��:

��� �� ����� ������ vBulletin 3.6.8:

Invalid SQL:

SELECT postid, wordid,
CASE intitle
WHEN 0 THEN score
WHEN 1 THEN score + 5
WHEN 2 THEN score + 5 + 5
ELSE score
END AS score
FROM postindex
WHERE wordid IN (0,5067279,5067505,5072692,5088592,5107135,5278881,5362097,5365485,5630472,5666132,5766363,5916760,5944981,6042004,6056120,5070422,5084715,5151317,5301489,5449847,5581394,5743133,5812235,5115431,5080224,5089557,5689707);

��� MySQL : Table './ahmed166_9ada/postindex' is marked as crashed and last (automatic?) repair failed
��� ����� : 144

benelmokadem · 01:19 PM

�� showthread ��

��

��

CREATE TABLE postindex (
wordid INT UNSIGNED NOT NULL DEFAULT '0',
postid INT UNSIGNED NOT NULL DEFAULT '0',
intitle SMALLINT UNSIGNED NOT NULL DEFAULT '0',
score SMALLINT UNSIGNED NOT NULL DEFAULT '0',
UNIQUE KEY wordid (wordid, postid)
)
��

Sawah · 14-05-2008, 01:09 PM

��

��

��

�� PHP:

  TRUNCATE `adminlog`;

TRUNCATE `cpsession`;

TRUNCATE `cronlog`;

TRUNCATE `postindex`;

TRUNCATE `session`;

TRUNCATE `word`;

��

�� session ��

��
�� vBulletin 3.6.8:

�� PHP:

  Invalid SQL:

SELECT crown_type AS type, show_crowns, show_t_won FROM games_settings;

 
��� MySQL : MySQL server has gone away

��� ����� : 2006

��

�� PHP:

  ��� �� ����� ������ vBulletin 3.6.8:

 
Invalid SQL:

 
SELECT thread.threadid, thread.forumid, thread.title, postusername, postuserid, thread.lastpost, thread.replycount, forum.title AS forumtitle

,post.pagetext AS preview

 
 
FROM thread AS thread

INNER JOIN forum AS forum ON (forum.forumid = thread.forumid)

LEFT JOIN post AS post ON (post.postid = thread.firstpostid)

 
 
WHERE thread.threadid IN (7761, 7764, 4525, 12039, 1046) AND thread.visible = 1

AND forum.password = ''

 
 
ORDER BY lastpost DESC;

 
��� MySQL : MySQL server has gone away

��� ����� : 2006

�� PHP:

  ��� �� ����� ������ vBulletin 3.6.8:

 
Invalid SQL:

 
INSERT IGNORE INTO session

(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate)

VALUES

('faf01b5d0464e68e326779ad719b374b', 0, '87.236.48.130', '85a1b60a9999db0e74217444894f7f94', 1210669047, '/vb/printthread.php?t=3576', 0, 0, 0, 43, 3576, 0, 0, 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648)', 0, 0);

 
��� MySQL : MySQL server has gone away

��� ����� : 2006

�� PHP:

  ��� �� ����� ������ vBulletin 3.6.8:

 
Invalid SQL:

 
SELECT user.username, user.usergroupid, user.membergroupids,

session.userid, session.inthread, session.lastactivity,

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

IF(user.options & 512, 1, 0) AS invisible

FROM session AS session

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

WHERE session.lastactivity > 1210690964

ORDER BY username ASC, lastactivity DESC;

 
��� MySQL : MySQL server has gone away

��� ����� : 2006

�� 忿�

benelmokadem · 14-05-2008, 02:25 PM

��

CREATE TABLE postindex (
wordid INT UNSIGNED NOT NULL DEFAULT '0',
postid INT UNSIGNED NOT NULL DEFAULT '0',
intitle SMALLINT UNSIGNED NOT NULL DEFAULT '0',
score SMALLINT UNSIGNED NOT NULL DEFAULT '0',
UNIQUE KEY wordid (wordid, postid)
)

Sawah · 14-05-2008, 08:31 PM

��

��

��:

���
�������-SQL: 

CREATE TABLE postindex(

wordid INT UNSIGNED NOT NULL DEFAULT '0',
postid INT UNSIGNED NOT NULL DEFAULT '0',
intitle SMALLINT UNSIGNED NOT NULL DEFAULT '0',
score SMALLINT UNSIGNED NOT NULL DEFAULT '0',
UNIQUE KEY wordid( wordid, postid ) 
) 

MySQL ���:  

#1050 - Table 'postindex' already exists

Domoo3 · �� , 01:23 AM

��:

�� bh 4

��

��
�� 2.6.8 �� 3.6.2
�� dj

�� PHP:

Fatal error: Maximum execution time of 30 seconds exceeded in /home/*******/public_html/vb/includes/functions.php(5166) : eval()'d code on line 65

�� 
�� 

��

��

��

Sawah · �� , 07:14 PM

��:

�� Domoo3

��

��

��

��

��
includes/class_bbcode.php

��