أخطاء وحلول قواعد البيانات من نسخة 3.7.0 الي الاصدار الجديد 4.0.0

[سهيل كنزي]

أخطاء وحلول قواعد البيانات للنسخ الجديدة


أخطاء وحلول قواعد البيانات من نسخة 3.7.0 الي الاصدار الجديد 4.0.0


الخطأ

Database error in vBulletin 3.8.4:  

Invalid SQL:  

        SELECT rankid, ranklevel, minposts, rankimg, ranks. usergroupid,title, type, display, stack  
        FROM ranks AS ranks  
        LEFT JOIN usergroup AS usergroup USING(usergroupid)  
        ORDER BY ranks.usergroupid, minposts;  

MySQL Error   : Unknown column 'rankid' in 'field list'

الحل

ALTER TABLE ranks ADD rankid SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT

 

[سهيل كنزي]

الخطأ

 			 MySQL Error   : Unknown column 'stack' in 'field list'

الحل

 			 ALTER TABLE ranks ADD stack SMALLINT UNSIGNED NOT NULL DEFAULT '0'

 

[سهيل كنزي]

الخطأ

 			 MySQL Error   : Unknown column 'rankid' in 'field list'

الحل

 			 ALTER TABLE ranks ADD rankid SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,

 

[سهيل كنزي]

الخطأ

 			 MySQL Error   : Unknown column 'display' in 'field list'

الحل

  		 			 ALTER TABLE `ranks` ADD `display` SMALLINT UNSIGNED NOT NULL DEFAULT '0'

 

[سهيل كنزي]

الخطأ

 			 MySQL Error   : Unknown column 'albumpicmaxsize' in 'field list'

الحل

  		 			 ALTER TABLE `usergroup` ADD `albumpicmaxsize` INT UNSIGNED NOT NULL DEFAULT '0'

 

[سهيل كنزي]

الخطأ النسخ 4

Database error in vBulletin 4.0.0 Beta 4:

Invalid SQL:
ALTER TABLE searchcore_text MODIFY title VARCHAR(254) NOT NULL DEFAULT '';

MySQL Error : Table '*******_*****.searchcore_text' doesn't exist

الحل

CREATE TABLE `searchgroup_text` ( 
  `searchgroupid` int(10) unsigned NOT NULL, 
  `title` varchar(254) NOT NULL, 
  PRIMARY KEY  (`searchgroupid`), 
  FULLTEXT KEY `grouptitle` (`title`) 
)

 

[سهيل كنزي]

الخطأ

Database error in vBulletin 3.8.4:

Invalid SQL:

UPDATE session
SET lastactivity = 1268337923, inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = 'd2ad7cc799aa2b1f9d3d12a5107baac9';

MySQL Error : MySQL server has gone away

الحل

 TRUNCATE `session`

 

[سهيل كنزي]

الخطأ

 MySQL Error   : Unknown column 'options' in 'where clause'

الحل

 ALTER TABLE prefix ADD options INT UNSIGNED NOT NULL DEFAULT '0'

 

[سهيل كنزي]

الخطأ

Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT COUNT(threadid) AS total FROM thread WHERE postuserid=;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

الحل

الحل
لوحة التحكم
التحكم بالاضافات البرمجيه Plugin

عداد المواضيع والردود والزيارات والمرفقات
تعديل :

استبدل محتواه بـ :

//arabdeaf.net###  
global $db;  
$this_hack_userid = $this->post[userid];  
if($post[userid] !=0){   
$user_theard_query = $db->query_read("SELECT COUNT(threadid) AS total FROM " . TABLE_PREFIX . "thread WHERE postuserid=$this_hack_userid");  
$personal1=$db->query_first("SELECT SUM(views) AS personalviews FROM thread WHERE postuserid=$post[userid] AND open!='10'");  
$personal= 2*$post[posts]+$personal1[personalviews];  
if ($personal1 == ""):  
$personal1 = "0";endif;  
global $db;$personal1=$db->query_first("SELECT SUM(views) AS personalviews FROM thread WHERE postuserid=$post[userid] AND open!='10'");  
$personal= 2*$post[posts]+$personal1[personalviews];  
if ($personal1 == ""):  
$personal1 = "0";endif;  
$attachment = $db->query_first("SELECT COUNT(attachmentid) AS total FROM attachment WHERE userid=$post[userid] ");  
$attachcoun = $attachment[total];  
$usertherd_pro_fetch = $db->fetch_array($user_theard_query);  
$usertherdcoun = $usertherd_pro_fetch[total];  
$userpostdcoun = $post[posts] - $usertherdcoun ;}     
//arabdeaf.net###

اذا لم تنفع الطريقة

عدد المواضيع والردود لكل عضو من Milad

استبدل محتواه بـ :

global $db; 

$this_hack_userid = $this->post[userid]; 

if ($this_hack_userid != '') 
{ 

$user_theard_query = $db->query_read("SELECT COUNT(threadid) AS total FROM " . TABLE_PREFIX . "thread WHERE postuserid=$this_hack_userid"); 
$usertherd_pro_fetch = $db->fetch_array($user_theard_query); 

$usertherdcoun = $usertherd_pro_fetch[total]; 

$userpostdcoun = $post[posts] - $usertherdcoun ; 

}

​

 

[سهيل كنزي]

الخطأ

Database error in vBulletin 4.0.2:

Invalid SQL:
UPDATE language SET title = title, phrasegroup_vbsettings =  languageid = 1;

MySQL Error   : Unknown column 'phrasegroup_emailbody' in 'field list'
Error Number  : 1054

الحل

 ALTER TABLE `language` ADD `phrasegroup_emailbody` mediumtext

 

[سهيل كنزي]

الخطأ

Database error in vBulletin 3.8.2:

Invalid SQL:
SELECT MAX(dateline) AS dateline FROM post WHERE userid = 2;

MySQL Error   : Table 'post' is marked as crashed and should be repaired
Error Number  : 1194

الحل

 repair table post;

 

[سهيل كنزي]

الخطأ

Database error in vBulletin 3.8.4:

Invalid SQL:

                SELECT user.username, user.usergroupid,  user.membergroupids,
                        session.userid, session.inthread,  session.lastactivity, session.badlocation,
                        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 > 1267299386
                ORDER BY  username ASC, lastactivity DESC;

MySQL Error   : MySQL server has gone away
Error Number  : 2006

المشكل من بعض الهاكات ترسل استعلامات
الحل
طبق الامر

 TRUNCATE `session`

 

[سهيل كنزي]

الخطأ

 MySQL Error : Unknown column 'gxcss_color' in 'field list'

الحل

 ALTER TABLE user ADD gxcss_font mediumtext NOT NULL DEFAULT ''

 

[سهيل كنزي]

الخطأ

MySQL Error   : Unknown column 'picturecomment.pictureid' in 'where clause'
Error Number  : 1054

الحل

 ِALTER TABLE picturecomment ADD pictureid INT UNSIGNED NOT NULL DEFAULT '0';

 

[سهيل كنزي]

الخطأ

MySQL Error   : Unknown column 'enabled' in 'field list'
Error Number  : 1054

الحل

 ALTER TABLE `attachmenttype` ADD `enabled` smallint(5) unsigned NOT NULL default '1'

 

[سهيل كنزي]

الخطأ

MySQL Error   : Unknown column 'filehash' in 'field list'
Error Number  : 1054

الحل

 ALTER TABLE `attachment` ADD  `filehash` varchar(32) NOT NULL default ''

 

[سهيل كنزي]

الخطأ

Database error in vBulletin 4.0.2: 

Invalid SQL: 

    SELECT COUNT(*) AS count 
    FROM attachment AS attachment 
    INNER JOIN post AS post USING (postid) 
    WHERE attachment.visible = 0; 

MySQL Error   : Unknown column 'postid' in 'from clause'

الحل

 ALTER TABLE postedithistory ADD `postid` int( 10 ) unsigned NOT NULL AUTO_INCREMENT

 ALTER TABLE `postparsed` ADD `postid` INT( 10 ) NOT NULL ;

 ALTER TABLE `postlog` ADD `postid` INT( 10 ) NOT NULL ;

 ALTER TABLE `postindex` ADD `postid` INT( 10 ) NOT NULL ;

 ALTER TABLE `posthash` ADD `postid` INT( 10 ) NOT NULL ;

 

[سهيل كنزي]

الخطأ

 MySQL Error : Unknown column 'phrasegroup_award' in 'field list'

الحل

 ALTER TABLE `language` ADD `phrasegroup_award` mediumtext

​

 

[سهيل كنزي]

الخطأ

Database error in vBulletin 3.8.4:

Invalid SQL:

                INSERT IGNORE INTO session
                    (sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate)
                VALUES
                    ('333d7130be722860efa1a4774a6b5098', 1, '109.83.182.250', '480a59b31ab71ae2646d35572eafafdf', 1270758915, '/vb/admincp/index.php?do=head', 106, 0, 1, 0, 0, 0, 0, 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0)', 0, 0);

MySQL Error   : The table 'session' is full
Error Number  : 1114

الحل

 TRUNCATE `session`

​

 

[سهيل كنزي]

الخطأ

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)
/home/alfora/public_html/vb/includes/class_core.php on line 311

MySQL Error : 
Error Number :

الحل

راسل مستظيفك واطلب منه عمل ريستارت ل my sql


​