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

الإهداءات
  • باسم إبراهيمي باسم إبراهيمي:
    لا تخبرهم بما أنت قادر على فعله ,إجعلهم يعيشون المفاجأة
  • ن ناس أدرار:
    واصرف عنا خبث البشر، و سواد القلوب يااا الله 🤍 🤲

سهيل كنزي

عضو نشيط جدا
المشاركات
105
مستوى التفاعل
3
النقاط
0


الخطأ

كود:
MySQL Error   : Unknown column 'newstylevars' in 'field list'
Error Number  : 1054

الحل

كود:
 ALTER TABLE `style` ADD `newstylevars` MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL


 

سهيل كنزي

عضو نشيط جدا
المشاركات
105
مستوى التفاعل
3
النقاط
0


الخطأ

كود:
Database error in vBulletin 4.0.3:
Invalid SQL:
 SELECT adminmessage.adminmessageid
 FROM adminmessage AS adminmessage
 INNER JOIN adminlog AS adminlog ON (adminlog.script = adminmessage.script AND adminlog.action = adminmessage.action)
 WHERE adminmessage.status = 'undone'
  AND adminmessage.script <> ''
  AND adminlog.dateline > adminmessage.dateline
 GROUP BY adminmessage.adminmessageid;
MySQL Error   : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_cs,IMPLICIT) for operation '='
Error Number  : 1267

الحل

كود:
ALTER TABLE `adminmessage` CHANGE `varname` `varname` VARCHAR( 250 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
CHANGE `script` `script` VARCHAR( 50 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
CHANGE `action` `action` VARCHAR( 20 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
CHANGE `execurl` `execurl` MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,
CHANGE `method` `method` ENUM( 'get', 'post' ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'post',
CHANGE `status` `status` ENUM( 'undone', 'done', 'dismissed' ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'undone'


 

سهيل كنزي

عضو نشيط جدا
المشاركات
105
مستوى التفاعل
3
النقاط
0


الخطأ

كود:
Database error in vBulletin 3.8.5:
Invalid SQL:
   SELECT searchid, search.userid, query, searchuser, user.userid AS targetuserid
   FROM search AS search
   LEFT JOIN user AS user ON (user.username = search.searchuser)
   WHERE searchid IN (0,9797);
MySQL Error   : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number  : 1267

الحل

كود:
ALTER TABLE `search` CHANGE `ipaddress` `ipaddress` VARCHAR(15) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
CHANGE `query` `query` VARCHAR(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
CHANGE `searchuser` `searchuser` VARCHAR(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
CHANGE `forumchoice` `forumchoice` MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
CHANGE `prefixchoice` `prefixchoice` MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
CHANGE `sortby` `sortby` VARCHAR(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
CHANGE `sortorder` `sortorder` VARCHAR(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
CHANGE `orderedids` `orderedids` MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
CHANGE `announceids` `announceids` MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
CHANGE `searchterms` `searchterms` MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
CHANGE `displayterms` `displayterms` MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
CHANGE `searchhash` `searchhash` VARCHAR( 32 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL


 

سهيل كنزي

عضو نشيط جدا
المشاركات
105
مستوى التفاعل
3
النقاط
0


الخطأ

كود:
Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT prefix.*, prefixpermission.usergroupid AS restriction
FROM forumprefixset AS forumprefixset
INNER JOIN prefixset AS prefixset ON (prefixset.prefixsetid = forumprefixset.prefixsetid)
INNER JOIN prefix AS prefix ON (prefix.prefixsetid = prefixset.prefixsetid)
LEFT JOIN prefixpermission AS prefixpermission ON (prefix.prefixid = prefixpermission.prefixid)
WHERE forumprefixset.forumid = 15
ORDER BY prefixset.displayorder, prefix.displayorder;
MySQL Error : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267

الحل

كود:
ALTER TABLE `prefix` CHANGE `prefixid` `prefixid` VARCHAR( 25 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
CHANGE `prefixsetid` `prefixsetid` VARCHAR( 25 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL

اذا لم ينفع ...التالي
كود:
 ALTER TABLE `prefixpermission` CHANGE `prefixid` `prefixid` VARCHAR( 25 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL

اذا لم ينفع التالي
كود:
 ALTER TABLE `prefixset` CHANGE `prefixsetid` `prefixsetid` VARCHAR( 25 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
 

سهيل كنزي

عضو نشيط جدا
المشاركات
105
مستوى التفاعل
3
النقاط
0


الخطأ

كود:
Database error in vBulletin 4.0.2:
Invalid SQL:
   SELECT plugin.*,
    IF(product.productid IS NULL, 0, 1) AS foundproduct,
    IF(plugin.product = 'vbulletin', 1, product.active) AS productactive
   FROM plugin AS plugin
   LEFT JOIN product AS product ON(product.productid = plugin.product)
   WHERE plugin.active = 1
    AND plugin.phpcode <> ''
   ORDER BY plugin.executionorder ASC;
MySQL Error   : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number  : 1267

الحل

كود:
ALTER TABLE `plugin` CHANGE `title` `title` VARCHAR( 250 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
CHANGE `hookname` `hookname` VARCHAR( 250 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
CHANGE `phpcode` `phpcode` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL ,
CHANGE `product` `product` VARCHAR( 25 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
CHANGE `devkey` `devkey` VARCHAR( 25 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL


 

سهيل كنزي

عضو نشيط جدا
المشاركات
105
مستوى التفاعل
3
النقاط
0


الخطأ

كود:
MySQL Error : Unknown column 'language.phrasegroup_cppermission' in 'field list'
Error Number : 1054

الحل

كود:
 ALTER TABLE `language` ADD `phrasegroup_cppermission` mediumtext;


 
أعلى