السلام عليكم
لدي قاعدة بيانات منتدى أصدار 3.8.4 حجم قاعدة البيانات 78ميجابايت
حاولت بعدة طرق لإستعادة القادعدة دون فائدة
الطرق التي أتبعتها
بعد إيقاف الهاكات من الكونفيج
1- تقسيم قاعدة البيانات ببرنامج SQLDumpSplitter ورفعها عن طريق phpmyadmin
ولكن تظهر بعض الاجزاء أخطاء مثل
2- رفعت قاعدة البيانات على السيرفر وأستخدمت سكربت bigdump بإصداريةخطأ
إستعلام-SQL:
INSERT INTO `access` VALUES (118,2,0),(118,1,0),(118,36,0),(118,37,0),(118,38,0),(118,39,0),(118,3,0),(118,4,0),(118,6,0),(118,4 1,0),(118,47,0),(118,43,0),(118,49,0),(118,5,0),(118,7,0),(118,18,0),(118,50,0),(118,40,0),(118,34,0 ),(118,32,0),(118,13,0),(118,14,0),(118,15,0),(118,16,0),(118,31,0),(118,51,0),(118,33,0),(118,42,0) ,(118,35,0),(118,23,0),(118,22,0),(118,9,0),(118,10,0),(118,11,0),(118,12,0),(118,24,0),(118,25,0),( 118,26,0),(118,53,0),(118,55,0),(118,54,0),(118,27,0),(118,52,0),(118,28,0),(118,29,0),(118,57,0),(1 18,30,0),(118,44,0),(220,2,0),(220,1,0),(220,36,0),(220,37,0),(220,38,0),(220,39,0),(220,68,0),(220, 69,0),(220,70,0),(220,72,0),(220,3,0),(220,4,0),(220,6,0),(220,41,0),(220,7,0),(220,43,0),(220,47,0) ,(220,66,0),(220,65,0),(220,67,0),(220,5,0),(220,49,0),(220,50,0),(220,40,0),(220,73,1),(220,74,0),( 220,34,0),(220,32,0),(220,75,0),(220,13,0),(220,14,0),(220,15,0),(220,60,0),(220,61,0),(220,62,0),(2 20,16,0),(220,18,0),(220,31,0),(220,51,0),(220,64,0),(220,33,0),(220,42,[...]
MySQL قال:
#1062 - Duplicate entry '118-2' for key 1
bigdump ver. 0.21b
ظهر الخطأ التالي
bigdump v0.32bError at the line 3012: /*!40101 SET character_set_client = @saved_cs_client */;
Query: /*!40101 SET character_set_client = @saved_cs_client */;
MySQL: Variable 'character_set_client' can't be set to the value of 'NULL'
تظهر النتيجة نجاح
Congratulations: End of file reached, assuming OK
ولكن عند التوجة للمنتدى يظهر التالي
vBulletin datastore error caused by one or more of the following:
Fatal error: vBulletin datastore cache incomplete or corrupt in [path]/includes/init.php on line 224
- You may have uploaded vBulletin 3.6 files without also running the vBulletin upgrade script. If you have not run the upgrade script, do so now.
- The datastore cache may have been corrupted. Run Rebuild Bitfields from tools.php, which you can upload from the do_not_upload folder of the vBulletin package.
وبعد مرور مدة من الوقت فتح المنتدى ولكن برموز غريبة والخطأ التالي في أعلى الهيدر:
Warning: array_keys() [function.array-keys]: The first argument should be an array in [path]/includes/functions.php on line 4243
Warning: Invalid argument supplied for foreach() in [path]/includes/functions.php on line 4243
/*** vBulletin 3.8.4 CSS* Style: 'Default Style'; Style ID: 1*/body{ background: url(/vb/bg1.gif); color: #000000; font: 11px tahoma; margin: 0px 0px 0px 0px; padding: 0px; background-image: url(/vb/bg1.gif); background-repeat: no-repeat; background-attachment: fixed; }a:link, body_alink{ color: #000000;}a:visited, body_avisited{ color: #000000;}a:hover, a:active, body_ahover{ color: #FF4400;}.page{ color: #000000; font-family: tahoma;}td, th, p, li{ font: 11px tahoma;}.tborder{ background: #999999; font-family: tahoma; font-family: tahoma; border: 1px solid #0B198C; }.tcat{ background: #484f52; color: #FFFFFF; font: bold 11px tahoma;}.tcat a:link, .tcat_alink{ color: #FFFFFF; text-decoration: none;}.tcat a:visited, .tcat_avisited{ color: #FFFFFF; text-decoration: none;}.tcat a:hover, .tcat a:active, .tcat_ahover{ text-decoration: none;}.thead{ background: #ffc060; color: #333333; font: bold 11px tahoma;}.tfoot{ background: #484f52; color: #ffc060; font: 11px tahoma;}.tfoot a:link, .tfoot_alink{ color: #ffc060; text-decoration: none;}.tfoot a:visited, .tfoot_avisited{ color: #ffc060; text-decoration: none;}.tfoot a:hover, .tfoot a:active, .tfoot_ahover{ color: #ffc060; text-decoration: none;}.alt1, .alt1Active{ background: #FFFFFF; color: #000000; font: bold 10pt tahoma;}.alt1 a:link, .alt1_alink, .alt1Active a:link, .alt1Active_alink{ text-decoration: none;}.alt1 a:visited, .alt1_avisited, .alt1Active a:visited, .alt1Active_avisited{ text-decoration: none;}.alt1 a:hover, .alt1 a:active, .alt1_ahover, .alt1Active a:hover, .alt1Active a:active, .alt1Active_ahover{ text-decoration: none;}.alt2, .alt2Active{ background: #e8eeef; color: #000033; font: bold 10pt tahoma;}.alt2 a:link, .alt2_alink, .alt2Active a:link, .alt2Active_alink{ text-decoration: none;}.alt2 a:visited, .alt2_avisited, .alt2Active a:visited, .alt2Active_avisited{ text-decoration: none;}.alt2 a:hover, .alt2 a:active, .alt2_ahover, .alt2Active a:hover, .alt2Active a:active, .alt2Active_ahover{ text-decoration: none;}.inlinemod{ background: #316AC5; color: #CCCCCC; font-family: tahoma;}.wysiwyg{ background: #FFFFFF; color: #000000; font: 11pt tahoma; margin: 5px 10px 10px 10px; padding: 0px;}.wysiwyg a:hover, .wysiwyg a:active, .wysiwyg_ahover{ color: #FF4400;}textarea, .bginput{ background: #FFFFFF; color: #000000; font: 10pt tahoma , verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;}.bginput option, .bginput optgroup{ font-size: 10pt; font-family: tahoma , verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif;}.button{ font: 11px tahoma;}select{ background: #FFFFFF; color: #316AC5; font: 11px tahoma;}option, optgroup{ font-size: 11px; font-family: tahoma;}.smallfont{ font: 11px tahoma;}.time{ color: #000000; font-family: tahoma;}.navbar{ background: #FFFFFF; color: #316AC5; font: 11px tahoma;}.highlight{ color: #FF0000; font: bold 11px tahoma;}.fjsel{ background: #FFFFFF; color: #CC6600;}.fjdpth0{ background: #F7F7F7; color: #660000;}.panel{ background: transparent; color: #316AC5; font-family: tahoma; padding: 10px; border: 2px outset;}.panelsurround{ background: #e8eeef; color: #333333; font-family: tahoma;}legend{ color: #000000; font: 11px tahoma;}.vbmenu_control{ background: #484f52; color: #FFFFFF; font: bold 11px tahoma; padding: 3px 6px 3px 6px; white-space: nowrap;}.vbmenu_control a:link, .vbmenu_control_alink{ color: #FFFFFF; text-decoration: none;}.vbmenu_control a:visited, .vbmenu_control_avisited{ color: #FFFFFF; text-decoration: none;}.vbmenu_control a:hover, .vbmenu_control a:active, .vbmenu_control_ahover{ color: #FFFFFF; text-decoration: none;}.vbmenu_popup{ background: #316AC5; color: #999999; font-family: tahoma; border: 1px solid #0B198C;}.vbmenu_option{ background: #333333; color: #FFFFFF; font: 11px tahoma; white-space: nowrap; cursor: pointer;}.vbmenu_option a:link, .vbmenu_option_alink{ color: #FFFFFF; text-decoration: none;}.vbmenu_option a:visited, .vbmenu_option_avisited{ color: #FFFFFF; text-decoration: none;}.vbmenu_option a:hover, .vbmenu_option a:active, .vbmenu_option_ahover{ color: #FFFFFF; text-decoration: none;}.vbmenu_hilite{ background: #333333; color: #FFFFFF; font: 11px tahoma , verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif; white-space: nowrap; cursor: pointer;}.vbmenu_hilite a:link, .vbmenu_hilite_alink{ color: #FFFFFF; text-decoration: none;}.vbmenu_hilite a:visited, .vbmenu_hilite_avisited{ color: #FFFFFF; text-decoration: none;}.vbmenu_hilite a:hover, .vbmenu_hilite a:active, .vbmenu_hilite_ahover{ color: #FFFFFF; text-decoration: none;}/* ***** styling for 'big' usernames on postbit etc. ***** */.bigusername { font-size: 14pt; }/* ***** small padding on 'thead' elements ***** */td.thead, th.thead, div.thead { padding: 4px; }/* ***** basic styles for multi-page nav elements */.pagenav a { text-decoration: none; }.pagenav td { padding: 2px 4px 2px 4px; }/* ***** de-emphasized text */.shade, a.shade:link, a.shade:visited { color: #777777; text-decoration: none; }a.shade:active, a.shade:hover { color: #FF4400; text-decoration: underline; }.tcat .shade, .thead .shade, .tfoot .shade { color: #DDDDDD; }/* ***** define margin and font-size for elements inside panels ***** */.fieldset { margin-bottom: 6px; }.fieldset, .fieldset td, .fieldset p, .fieldset li { font-size: 11px; }html scrollbar-base-color: #A15D12; scrollbar-arrow-color: #F4E9B3; scrollbar-track-color: #F4E9B3; .quotes_header_r {background-image: url('images/quotes/quotes_06.png');background-repeat: no-repeat;background-position: center center;width: 24px;height: 38px;float: right;} .quotes_header_l {background-image: url('images/quotes/quotes_03.png');background-position: center center;background-repeat: no-repeat;width: 74px;height: 38px;float: left;} .quotes_header_c {background-image: url('images/quotes/quotes_05.png');background-repeat: repeat-x;background-position: center center;height: 38px;margin: 0 24px 0 74px;} .quotes_content_r {background-image: url('images/quotes/quotes_10.png');background-position: right center;background-repeat: repeat-y;padding-right: 15px;} .quotes_content_l {background-image: url('images/quotes/quotes_12.png');background-position: left center;background-repeat: repeat-y;padding-left: 15px;} .quotes_footer_r {background-image: url('images/quotes/quotes_16.png');background-position: center bottom;background-repeat: no-repeat;width: 24px;height: 23px;float: right;} .quotes_footer_l {background-image: url('images/quotes/quotes_13.png');background-position: center center;background-repeat: no-repeat;width: 24px;height: 23px;float: left;} .quotes_footer_c {background-image: url('images/quotes/quotes_15.png');background-position: center center;background-repeat: repeat-x;height: 24px;margin:0 24px 0 24px;} .quotes_content_line {background:white url('images/quotes/quotes_09.png') right center no-repeat;} .quotes_content_co{background:white;} .quotes_header_cont {padding-top: 18px;}
طبعاً بعد ما عملت بحث في سوالف وغيرها لم أجد أي جواب نهائياً
علماً أن لدي لوحة تحكم whm إذا ممكن أستفيد منها في حل المشكلة
شكراً