مشكله اثناء استرجاع قاعدة بيانات المنتدى

stargate

عضو جديد
9 أبريل 2009
85
0
0
مشكله اثناء استرجاع القاعدة عن طريق php admin
:busted_red:​

كود:
[B]خطأ[/B]

[B]إستعلام-SQL:[/B] 
-- -- إرجاع أو إستيراد بيانات الجدول `attachment` -- INSERT INTO `attachment` (`attachmentid`, `userid`, `dateline`, `thumbnail_dateline`, `filename`, `filedata`, `visible`, `counter`, `filesize`, `postid`, `filehash`, `posthash`, `thumbnail`, `thumbnail_filesize`, `extension`) VALUES (1, 1, 1249526022, 1249526022, 'flash memory toolkit.zip', 0x504b03040a0000000000a72be83600000000000000000000000015000000666c617368206d656d6f727920746f6f6c6b69742f504b03040a000000000058bd553648a1b95550000000500000001e000000666c617368206d656d6f727920746f6f6c6b69742f437261636b2e72656752454745444954340d0a5b484b45595f4c4f43414c5f4d414348494e455c534f4654574152455c466c617368204d656d6f727920546f6f6c6b69745d0d0a2273223d64776f72643a3132616535623631504b030414000000080005a77b36af9d8374ab990b007ff40b001e000000666c617368206d656d6f727920746f6f6c6b69742f53657475702e657865ecfd075c134df0380e5f488000a1a8d85151b1208a20764411080282468a2856a40848131241a504234a3851ec62efbd60476c4028a2a8d8512cd80f83[...] 
[B]MySQL قال: [/B][URL="http://dev.mysql.com/doc/refman/5.0/en/error-messages-server.html"][IMG]http://www.php-myadmin.com/themes/original/img/b_help.png[/IMG][/URL] 
[CENTER][FONT=Simplified Arabic Fixed]#2006 - MySQL server has gone away[/FONT][/CENTER]





وقمت بتجربه اسكربت بيج دامب وقام باستراع القاعدة لكن المنتى لم يفتح

وتاتى هذه الرساله الى الايميل

كود:
[CENTER]Database error in vBulletin 3.8.3:[/CENTER]
 
[CENTER]Invalid SQL:[/CENTER]
 
[CENTER]               SELECT *
               FROM session
               WHERE sessionhash = '04d0b47719e52b95e8aaec2de8706a2d'
                   AND lastactivity > 1250008833
                   AND idhash = '48643ed24294d2f5b38a88fbeb071fe2';[/CENTER]
 
[CENTER]MySQL Error   : Table 'moha_vb.session' doesn't exist
Error Number  : 1146
Request Date  : Tuesday, August 11th 2009 @ 12:55:33 PM
Error Date    : Tuesday, August 11th 2009 @ 12:55:33 PM
Script        : [URL="http://www.xxxxx.com/vb/"][COLOR=#800080]http://www.xxxxx.com/vb/[/COLOR][/URL]
Referrer      : 
IP Address    : 41.232.51.33
Username      : 
Classname     : vB_Database
MySQL Version :[/CENTER]

ما الحل​
 

2odaay.com

عضو جديد
22 يوليو 2009
46
0
0
آم الدنيا
www.2odaay.com
ادخل على الاف تي بي واعمل ايقاف للهاكات و ان شاء الله هيشتغل معاك


نفتح برنامج الاف تي بي ( او من خلال السي بنل )
ونذهب الى ملف الكونفج config ( على هذا المسار vb\includes\config )

ونضيف هذا الكود في اي مكان بملف الكونفج config


كود PHP:
define('DISABLE_HOOKS', true);

وهذه صورة للكود في ملف الكونفج

6rb44-29a9ed9de6.jpg



و ان شاء الله هيشتغل

 

stargate

عضو جديد
9 أبريل 2009
85
0
0
لقد قمت بعمل ذلك وم ينجح وجاء خطاء جديد

كود:
Database error in vBulletin 3.8.3:

Invalid SQL:

        SELECT 
            userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
            IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
            language.phrasegroup_global AS phrasegroup_global,
            language.phrasegroup_holiday AS phrasegroup_holiday,
            language.options AS lang_options,
            language.languagecode AS lang_code,
            language.charset AS lang_charset,
            language.locale AS lang_locale,
            language.imagesoverride AS lang_imagesoverride,
            language.dateoverride AS lang_dateoverride,
            language.timeoverride AS lang_timeoverride,
            language.registereddateoverride AS lang_registereddateoverride,
            language.calformat1override AS lang_calformat1override,
            language.calformat2override AS lang_calformat2override,
            language.logdateoverride AS lang_logdateoverride,
            language.decimalsep AS lang_decimalsep,
            language.thousandsep AS lang_thousandsep
            
        FROM user AS user
        LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
        LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid)) 
        
        WHERE user.userid = 1;

MySQL Error   : Table 'moha_vb.user' doesn't exist
Error Number  : 1146
Request Date  : Tuesday, August 11th 2009 @ 01:52:07 PM
Error Date    : Tuesday, August 11th 2009 @ 01:52:08 PM
Script        : [URL="http://www.xxxxx.com/vb/"][COLOR=#800080]http://www.xxxxx.com/vb/[/COLOR][/URL]
Referrer      : 
IP Address    : 41.232.51.33
Username      : 
Classname     : vB_Database
MySQL Version :
 

m@m

عضو جديد
27 يونيو 2009
987
14
0
support-ar.com
sharingman.net
جرب اخوى الاول ارجع كافه الجداول

ثانيا

ازرع هذا الجدول

كود:
[COLOR=#000000][COLOR=#0000BB]CREATE TABLE [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#0000BB]session[/COLOR][COLOR=#007700]` ( 
  `[/COLOR][COLOR=#0000BB]sessionhash[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]char[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]32[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#DD0000]''[/COLOR][COLOR=#007700], 
  `[/COLOR][COLOR=#0000BB]userid[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]int[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]10[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]unsigned NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#DD0000]'0'[/COLOR][COLOR=#007700], 
  `[/COLOR][COLOR=#0000BB]host[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]char[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]15[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#DD0000]''[/COLOR][COLOR=#007700], 
  `[/COLOR][COLOR=#0000BB]idhash[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]char[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]32[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#DD0000]''[/COLOR][COLOR=#007700], 
  `[/COLOR][COLOR=#0000BB]lastactivity[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]int[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]10[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]unsigned NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#DD0000]'0'[/COLOR][COLOR=#007700], 
  `[/COLOR][COLOR=#0000BB]location[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]char[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]255[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#DD0000]''[/COLOR][COLOR=#007700], 
  `[/COLOR][COLOR=#0000BB]useragent[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]char[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]100[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#DD0000]''[/COLOR][COLOR=#007700], 
  `[/COLOR][COLOR=#0000BB]styleid[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]smallint[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]5[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]unsigned NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#DD0000]'0'[/COLOR][COLOR=#007700], 
  `[/COLOR][COLOR=#0000BB]languageid[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]smallint[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]5[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]unsigned NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#DD0000]'0'[/COLOR][COLOR=#007700], 
  `[/COLOR][COLOR=#0000BB]loggedin[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]smallint[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]5[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]unsigned NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#DD0000]'0'[/COLOR][COLOR=#007700], 
  `[/COLOR][COLOR=#0000BB]inforum[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]smallint[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]5[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]unsigned NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#DD0000]'0'[/COLOR][COLOR=#007700], 
  `[/COLOR][COLOR=#0000BB]inthread[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]int[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]10[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]unsigned NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#DD0000]'0'[/COLOR][COLOR=#007700], 
  `[/COLOR][COLOR=#0000BB]incalendar[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]smallint[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]5[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]unsigned NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#DD0000]'0'[/COLOR][COLOR=#007700], 
  `[/COLOR][COLOR=#0000BB]badlocation[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]smallint[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]5[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]unsigned NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#DD0000]'0'[/COLOR][COLOR=#007700], 
  `[/COLOR][COLOR=#0000BB]bypass[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]tinyint[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]4[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#DD0000]'0'[/COLOR][COLOR=#007700], 
  `[/COLOR][COLOR=#0000BB]profileupdate[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000BB]smallint[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]5[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000BB]unsigned NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#DD0000]'0'[/COLOR][COLOR=#007700], 
  [/COLOR][COLOR=#0000BB]PRIMARY KEY  [/COLOR][COLOR=#007700](`[/COLOR][COLOR=#0000BB]sessionhash[/COLOR][COLOR=#007700]`) 
) [/COLOR][COLOR=#0000BB]ENGINE[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#0000BB]MEMORY [/COLOR][COLOR=#007700]DEFAULT [/COLOR][COLOR=#0000BB]CHARSET[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#0000BB]utf8[/COLOR][COLOR=#007700];  [/COLOR][/COLOR]
 

stargate

عضو جديد
9 أبريل 2009
85
0
0
جرب اخوى الاول ارجع كافه الجداول

ثانيا

ازرع هذا الجدول

كود:
[COLOR=#000000][COLOR=#0000bb]CREATE TABLE [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#0000bb]session[/COLOR][COLOR=#007700]` ( [/COLOR]
[COLOR=#007700] `[/COLOR][COLOR=#0000bb]sessionhash[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000bb]char[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]32[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000bb]NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#dd0000]''[/COLOR][COLOR=#007700], [/COLOR]
[COLOR=#007700] `[/COLOR][COLOR=#0000bb]userid[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000bb]int[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]10[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000bb]unsigned NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#dd0000]'0'[/COLOR][COLOR=#007700], [/COLOR]
[COLOR=#007700] `[/COLOR][COLOR=#0000bb]host[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000bb]char[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]15[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000bb]NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#dd0000]''[/COLOR][COLOR=#007700], [/COLOR]
[COLOR=#007700] `[/COLOR][COLOR=#0000bb]idhash[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000bb]char[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]32[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000bb]NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#dd0000]''[/COLOR][COLOR=#007700], [/COLOR]
[COLOR=#007700] `[/COLOR][COLOR=#0000bb]lastactivity[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000bb]int[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]10[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000bb]unsigned NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#dd0000]'0'[/COLOR][COLOR=#007700], [/COLOR]
[COLOR=#007700] `[/COLOR][COLOR=#0000bb]location[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000bb]char[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]255[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000bb]NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#dd0000]''[/COLOR][COLOR=#007700], [/COLOR]
[COLOR=#007700] `[/COLOR][COLOR=#0000bb]useragent[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000bb]char[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]100[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000bb]NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#dd0000]''[/COLOR][COLOR=#007700], [/COLOR]
[COLOR=#007700] `[/COLOR][COLOR=#0000bb]styleid[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000bb]smallint[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]5[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000bb]unsigned NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#dd0000]'0'[/COLOR][COLOR=#007700], [/COLOR]
[COLOR=#007700] `[/COLOR][COLOR=#0000bb]languageid[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000bb]smallint[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]5[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000bb]unsigned NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#dd0000]'0'[/COLOR][COLOR=#007700], [/COLOR]
[COLOR=#007700] `[/COLOR][COLOR=#0000bb]loggedin[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000bb]smallint[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]5[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000bb]unsigned NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#dd0000]'0'[/COLOR][COLOR=#007700], [/COLOR]
[COLOR=#007700] `[/COLOR][COLOR=#0000bb]inforum[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000bb]smallint[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]5[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000bb]unsigned NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#dd0000]'0'[/COLOR][COLOR=#007700], [/COLOR]
[COLOR=#007700] `[/COLOR][COLOR=#0000bb]inthread[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000bb]int[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]10[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000bb]unsigned NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#dd0000]'0'[/COLOR][COLOR=#007700], [/COLOR]
[COLOR=#007700] `[/COLOR][COLOR=#0000bb]incalendar[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000bb]smallint[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]5[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000bb]unsigned NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#dd0000]'0'[/COLOR][COLOR=#007700], [/COLOR]
[COLOR=#007700] `[/COLOR][COLOR=#0000bb]badlocation[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000bb]smallint[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]5[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000bb]unsigned NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#dd0000]'0'[/COLOR][COLOR=#007700], [/COLOR]
[COLOR=#007700] `[/COLOR][COLOR=#0000bb]bypass[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000bb]tinyint[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]4[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000bb]NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#dd0000]'0'[/COLOR][COLOR=#007700], [/COLOR]
[COLOR=#007700] `[/COLOR][COLOR=#0000bb]profileupdate[/COLOR][COLOR=#007700]` [/COLOR][COLOR=#0000bb]smallint[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000bb]5[/COLOR][COLOR=#007700]) [/COLOR][COLOR=#0000bb]unsigned NOT NULL [/COLOR][COLOR=#007700]default [/COLOR][COLOR=#dd0000]'0'[/COLOR][COLOR=#007700], [/COLOR]
[COLOR=#0000bb]PRIMARY KEY  [/COLOR][COLOR=#007700](`[/COLOR][COLOR=#0000bb]sessionhash[/COLOR][COLOR=#007700]`) [/COLOR]
[COLOR=#007700]) [/COLOR][COLOR=#0000bb]ENGINE[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#0000bb]MEMORY [/COLOR][COLOR=#007700]DEFAULT [/COLOR][COLOR=#0000bb]CHARSET[/COLOR][COLOR=#007700]=[/COLOR][COLOR=#0000bb]utf8[/COLOR][COLOR=#007700];  [/COLOR][/COLOR]


شكرا لك اخى الحبيب تم اصلاح المشكله👏

لكن بعد حذف الجدول نفسه 🍭