تبلیغات در اینترنت

تبلیغات در اینترنتگیفت کارت گوگل پلی
نمایش نتایج: از 1 به 4 از 4

موضوع: ارور دیتابیس بعد از انتقال سرور

  1. Top | #1
    کاربر سایت

    تاریخ عضویت
    Mar 2011
    ورژن ویبولتین
    4.1.3
    نوشته ها
    474
    مورد پسند
    135 بار
    نوشته های وبلاگ
    1
    اطلاعات
    Windows XP Firefox 17.0
    میزان امتیاز
    55

    پیش فرض ارور دیتابیس بعد از انتقال سرور

    سلام
    من بعد انتقال انجمنم با ارور دیتابیس روبرو شدم
    کد PHP:
    Database error       The Ø¨Ø§Ø´Ú¯Ø§Ù‡ Ø¢Ù¾ÙØ§Ø¯Ø§Ù†Ø§ database has encountered a problem
    back up که از دیتابیس داشتم رو نمیشد از هاست ریستور کرد برای همین پشتیبانی از روت اصلی ریستور کردند
    اما الان با ارور دیتابیس بالا روبرو می شم
    تنها صفحه ای که می تونم مشاهده کنم صفحه ورود به بخش مدیریت سایت است یعنی admincp
    لازم به ذکر هست که من اطلاعات کانفیگ ر و ست کردم
    از دوستان کسی هست من رو راهنمایی کنه که مشکلم رو حل کنم ؟
    عشق یعنی تنهایی




  2. گیفت کارت آیتونز

  3. Top | #2
    کاربر سایت

    تاریخ عضویت
    May 2011
    ورژن ویبولتین
    4
    نوشته ها
    361
    مورد پسند
    216 بار
    اطلاعات
    Windows 7/Server 2008 R2 Opera 11.50
    میزان امتیاز
    46

    پیش فرض

    اگر دایرکت ادمین هستید از mysql managment دیتابیس رو repair کنید تا درست بشه
    اگر سی پنل هستید از phpmyadmin هم میتونید repair کنید
    اگر کانفیگ رو درست ست کرده باشید احتمال زیاد با ریپیر درست میشه

  4. Top | #3
    کاربر سایت

    تاریخ عضویت
    Mar 2011
    ورژن ویبولتین
    4.1.3
    نوشته ها
    474
    مورد پسند
    135 بار
    نوشته های وبلاگ
    1
    اطلاعات
    Windows XP Firefox 17.0
    میزان امتیاز
    55

    پیش فرض

    سلام
    نه مشکل حل نشد
    این گزارش ریپیر هست
    SQL result

    Host: localhost
    Database: engineer_forums
    Generation Time: Dec 31, 2012 at 12:10 PM
    Generated by: phpMyAdmin 3.5.3 / MySQL 5.1.66-cll
    SQL query: REPAIR TABLE `aaggregate_temp_1342107600`, `aaggregate_temp_1342251600`, `access`, `action`, `ad`, `adcriteria`, `adminhelp`, `administrator`, `adminlog`, `adminmessage`, `adminutil`, `album`, `albumupdate`, `announcement`, `announcementread`, `apiclient`, `apilog`, `apipost`, `attachment`, `attachmentcategory`, `attachmentcategoryuser`, `attachmentpermission`, `attachmenttype`, `attachmentviews`, `autosave`, `avatar`, `badwords`, `bbcode`, `bbcode_video`, `block`, `blockconfig`, `blocktype`, `blog`, `blog_attachmentlegacy`, `blog_category`, `blog_categorypermission`, `blog_categoryuser`, `blog_custom_block`, `blog_custom_block_parsed`, `blog_deletionlog`, `blog_editlog`, `blog_featured`, `blog_groupmembership`, `blog_grouppermission`, `blog_hash`, `blog_moderation`, `blog_moderator`, `blog_pinghistory`, `blog_rate`, `blog_read`, `blog_relationship`, `blog_search`, `blog_searchresult`, `blog_sitemapconf`, `blog_subscribeentry`, `blog_subscribeuser`, `blog_summarystats`, `blog_tachyentry`, `blog_text`, `blog_textparsed`, `blog_trackback`, `blog_trackbacklog`, `blog_user`, `blog_usercss`, `blog_usercsscache`, `blog_userread`, `blog_userstats`, `blog_views`, `blog_visitor`, `bookmarksite`, `cache`, `cacheevent`, `calendar`, `calendarcustomfield`, `calendarmoderator`, `calendarpermission`, `cms_article`, `cms_category`, `cms_grid`, `cms_layout`, `cms_layoutwidget`, `cms_navigation`, `cms_node`, `cms_nodecategory`, `cms_nodeconfig`, `cms_nodeinfo`, `cms_permissions`, `cms_rate`, `cms_sectionorder`, `cms_widget`, `cms_widgetconfig`, `cms_widgettype`, `contentpriority`, `contenttype`, `cpsession`, `cron`, `cronlog`, `customavatar`, `customprofile`, `customprofilepic`, `datastore`, `dbquery`, `deletionlog`, `discussion`, `discussionread`, `editlog`, `event`, `externalcache`, `faq`, `filedata`, `forum`, `forumpermission`, `forumprefixset`, `forumread`, `forumrunner_push_data`, `forumrunner_push_users`, `games_cats`, `games_champs`, `games_league`, `games_list`, `games_savedGames`, `games_scores`, `games_session`, `games_settings`, `groupmessage`, `groupmessage_hash`, `groupread`, `holiday`, `humanverify`, `hvanswer`, `hvquestion`, `icon`, `imagecategory`, `imagecategorypermission`, `indexqueue`, `infraction`, `infractionban`, `infractiongroup`, `infractionlevel`, `language`, `macro`, `mailqueue`, `moderation`, `moderator`, `moderatorlog`, `notice`, `noticecriteria`, `noticedismissed`, `package`, `passwordhistory`, `paymentapi`, `paymentinfo`, `paymenttransaction`, `phrase`, `phrasetype`, `picturecomment`, `picturecomment_hash`, `picturelegacy`, `plugin`, `pm`, `pmreceipt`, `pmtext`, `pmthrottle`, `podcast`, `podcastitem`, `poll`, `pollvote`, `post`, `postedithistory`, `posthash`, `postlog`, `postparsed`, `post_thanks`, `prefix`, `prefixpermission`, `prefixset`, `product`, `productcode`, `productdependency`, `profileblockprivacy`, `profilefield`, `profilefieldcategory`, `profilevisitor`, `ranks`, `reminder`, `reputation`, `reputationlevel`, `route`, `rssfeed`, `rsslog`, `searchcore`, `searchcore_text`, `searchgroup`, `searchgroup_text`, `searchlog`, `session`, `setting`, `settinggroup`, `sigparsed`, `sigpic`, `sitelink`, `skimlinks`, `smilie`, `socialgroup`, `socialgroupcategory`, `socialgroupicon`, `socialgroupmember`, `spamlog`, `stats`, `strikes`, `style`, `stylevar`, `stylevardfn`, `subscribediscussion`, `subscribeevent`, `subscribeforum`, `subscribegroup`, `subscribethread`, `subscription`, `subscriptionlog`, `subscriptionpermission`, `tachyforumcounter`, `tachyforumpost`, `tachythreadcounter`, `tachythreadpost`, `tag`, `tagcontent`, `taggregate_temp_1319779560`, `taggregate_temp_1320668760`, `taggregate_temp_1342189560`, `taggregate_temp_1344291960`, `taggregate_temp_1344320760`, `taggregate_temp_1344324360`, `taggregate_temp_1344327960`, `taggregate_temp_1344331560`, `taggregate_temp_1344335160`, `taggregate_temp_1344338760`, `taggregate_temp_1344342360`, `taggregate_temp_1344345960`, `taggregate_temp_1344349560`, `taggregate_temp_1344353160`, `taggregate_temp_1344356760`, `taggregate_temp_1344360360`, `taggregate_temp_1344367560`, `taggregate_temp_1344371160`, `taggregate_temp_1344374760`, `taggregate_temp_1344378360`, `taggregate_temp_1344399960`, `taggregate_temp_1344410760`, `taggregate_temp_1344414360`;
    Rows: 250
    Table Op Msg_type Msg_text
    engineer_forums.aaggregate_temp_1342107600 repair note The storage engine for the table doesn't support repair
    engineer_forums.aaggregate_temp_1342251600 repair note The storage engine for the table doesn't support repair
    engineer_forums.access repair status OK
    engineer_forums.action repair status OK
    engineer_forums.ad repair status OK
    engineer_forums.adcriteria repair status OK
    engineer_forums.adminhelp repair status OK
    engineer_forums.administrator repair status OK
    engineer_forums.adminlog repair status OK
    engineer_forums.adminmessage repair status OK
    engineer_forums.adminutil repair status OK
    engineer_forums.album repair status OK
    engineer_forums.albumupdate repair status OK
    engineer_forums.announcement repair status OK
    engineer_forums.announcementread repair status OK
    engineer_forums.apiclient repair status OK
    engineer_forums.apilog repair status OK
    engineer_forums.apipost repair status OK
    engineer_forums.attachment repair status OK
    engineer_forums.attachmentcategory repair status OK
    engineer_forums.attachmentcategoryuser repair status OK
    engineer_forums.attachmentpermission repair status OK
    engineer_forums.attachmenttype repair status OK
    engineer_forums.attachmentviews repair status OK
    engineer_forums.autosave repair status OK
    engineer_forums.avatar repair status OK
    engineer_forums.badwords repair status OK
    engineer_forums.bbcode repair status OK
    engineer_forums.bbcode_video repair status OK
    engineer_forums.block repair status OK
    engineer_forums.blockconfig repair status OK
    engineer_forums.blocktype repair status OK
    engineer_forums.blog repair status OK
    engineer_forums.blog_attachmentlegacy repair status OK
    engineer_forums.blog_category repair status OK
    engineer_forums.blog_categorypermission repair status OK
    engineer_forums.blog_categoryuser repair status OK
    engineer_forums.blog_custom_block repair status OK
    engineer_forums.blog_custom_block_parsed repair status OK
    engineer_forums.blog_deletionlog repair status OK
    engineer_forums.blog_editlog repair status OK
    engineer_forums.blog_featured repair status OK
    engineer_forums.blog_groupmembership repair status OK
    engineer_forums.blog_grouppermission repair status OK
    engineer_forums.blog_hash repair status OK
    engineer_forums.blog_moderation repair status OK
    engineer_forums.blog_moderator repair status OK
    engineer_forums.blog_pinghistory repair status OK
    engineer_forums.blog_rate repair status OK
    engineer_forums.blog_read repair status OK
    engineer_forums.blog_relationship repair status OK
    engineer_forums.blog_search repair status OK
    engineer_forums.blog_searchresult repair status OK
    engineer_forums.blog_sitemapconf repair status OK
    engineer_forums.blog_subscribeentry repair status OK
    engineer_forums.blog_subscribeuser repair status OK
    engineer_forums.blog_summarystats repair status OK
    engineer_forums.blog_tachyentry repair status OK
    engineer_forums.blog_text repair status OK
    engineer_forums.blog_textparsed repair status OK
    engineer_forums.blog_trackback repair status OK
    engineer_forums.blog_trackbacklog repair status OK
    engineer_forums.blog_user repair status OK
    engineer_forums.blog_usercss repair status OK
    engineer_forums.blog_usercsscache repair status OK
    engineer_forums.blog_userread repair status OK
    engineer_forums.blog_userstats repair status OK
    engineer_forums.blog_views repair status OK
    engineer_forums.blog_visitor repair status OK
    engineer_forums.bookmarksite repair status OK
    engineer_forums.cache repair status OK
    engineer_forums.cacheevent repair status OK
    engineer_forums.calendar repair status OK
    engineer_forums.calendarcustomfield repair status OK
    engineer_forums.calendarmoderator repair status OK
    engineer_forums.calendarpermission repair status OK
    engineer_forums.cms_article repair status OK
    engineer_forums.cms_category repair status OK
    engineer_forums.cms_grid repair status OK
    engineer_forums.cms_layout repair status OK
    engineer_forums.cms_layoutwidget repair status OK
    engineer_forums.cms_navigation repair status OK
    engineer_forums.cms_node repair status OK
    engineer_forums.cms_nodecategory repair status OK
    engineer_forums.cms_nodeconfig repair status OK
    engineer_forums.cms_nodeinfo repair status OK
    engineer_forums.cms_permissions repair status OK
    engineer_forums.cms_rate repair status OK
    engineer_forums.cms_sectionorder repair status OK
    engineer_forums.cms_widget repair status OK
    engineer_forums.cms_widgetconfig repair status OK
    engineer_forums.cms_widgettype repair status OK
    engineer_forums.contentpriority repair status OK
    engineer_forums.contenttype repair status OK
    engineer_forums.cpsession repair note The storage engine for the table doesn't support repair
    engineer_forums.cron repair status OK
    engineer_forums.cronlog repair status OK
    engineer_forums.customavatar repair status OK
    engineer_forums.customprofile repair status OK
    engineer_forums.customprofilepic repair status OK
    Table Op Msg_type Msg_text
    engineer_forums.datastore repair status OK
    engineer_forums.dbquery repair status OK
    engineer_forums.deletionlog repair status OK
    engineer_forums.discussion repair status OK
    engineer_forums.discussionread repair status OK
    engineer_forums.editlog repair status OK
    engineer_forums.event repair status OK
    engineer_forums.externalcache repair status OK
    engineer_forums.faq repair status OK
    engineer_forums.filedata repair status OK
    engineer_forums.forum repair status OK
    engineer_forums.forumpermission repair status OK
    engineer_forums.forumprefixset repair status OK
    engineer_forums.forumread repair status OK
    engineer_forums.forumrunner_push_data repair status OK
    engineer_forums.forumrunner_push_users repair status OK
    engineer_forums.games_cats repair status OK
    engineer_forums.games_champs repair status OK
    engineer_forums.games_league repair status OK
    engineer_forums.games_list repair status OK
    engineer_forums.games_savedGames repair status OK
    engineer_forums.games_scores repair status OK
    engineer_forums.games_session repair status OK
    engineer_forums.games_settings repair status OK
    engineer_forums.groupmessage repair status OK
    engineer_forums.groupmessage_hash repair status OK
    engineer_forums.groupread repair status OK
    engineer_forums.holiday repair status OK
    engineer_forums.humanverify repair status OK
    engineer_forums.hvanswer repair status OK
    engineer_forums.hvquestion repair status OK
    engineer_forums.icon repair status OK
    engineer_forums.imagecategory repair status OK
    engineer_forums.imagecategorypermission repair status OK
    engineer_forums.indexqueue repair status OK
    engineer_forums.infraction repair status OK
    engineer_forums.infractionban repair status OK
    engineer_forums.infractiongroup repair status OK
    engineer_forums.infractionlevel repair status OK
    engineer_forums.language repair status OK
    engineer_forums.macro repair status OK
    engineer_forums.mailqueue repair status OK
    engineer_forums.moderation repair status OK
    engineer_forums.moderator repair status OK
    engineer_forums.moderatorlog repair status OK
    engineer_forums.notice repair status OK
    engineer_forums.noticecriteria repair status OK
    engineer_forums.noticedismissed repair status OK
    engineer_forums.package repair status OK
    engineer_forums.passwordhistory repair status OK
    engineer_forums.paymentapi repair status OK
    engineer_forums.paymentinfo repair status OK
    engineer_forums.paymenttransaction repair status OK
    engineer_forums.phrase repair status OK
    engineer_forums.phrasetype repair status OK
    engineer_forums.picturecomment repair status OK
    engineer_forums.picturecomment_hash repair status OK
    engineer_forums.picturelegacy repair status OK
    engineer_forums.plugin repair status OK
    engineer_forums.pm repair status OK
    engineer_forums.pmreceipt repair status OK
    engineer_forums.pmtext repair status OK
    engineer_forums.pmthrottle repair status OK
    engineer_forums.podcast repair status OK
    engineer_forums.podcastitem repair status OK
    engineer_forums.poll repair status OK
    engineer_forums.pollvote repair status OK
    engineer_forums.post repair status OK
    engineer_forums.postedithistory repair status OK
    engineer_forums.posthash repair status OK
    engineer_forums.postlog repair status OK
    engineer_forums.postparsed repair status OK
    engineer_forums.post_thanks repair status OK
    engineer_forums.prefix repair status OK
    engineer_forums.prefixpermission repair status OK
    engineer_forums.prefixset repair status OK
    engineer_forums.product repair status OK
    engineer_forums.productcode repair status OK
    engineer_forums.productdependency repair status OK
    engineer_forums.profileblockprivacy repair status OK
    engineer_forums.profilefield repair status OK
    engineer_forums.profilefieldcategory repair status OK
    engineer_forums.profilevisitor repair status OK
    engineer_forums.ranks repair status OK
    engineer_forums.reminder repair status OK
    engineer_forums.reputation repair status OK
    engineer_forums.reputationlevel repair status OK
    engineer_forums.route repair status OK
    engineer_forums.rssfeed repair status OK
    engineer_forums.rsslog repair status OK
    engineer_forums.searchcore repair status OK
    engineer_forums.searchcore_text repair status OK
    engineer_forums.searchgroup repair status OK
    engineer_forums.searchgroup_text repair status OK
    engineer_forums.searchlog repair status OK
    engineer_forums.session repair note The storage engine for the table doesn't support repair
    engineer_forums.setting repair status OK
    engineer_forums.settinggroup repair status OK
    engineer_forums.sigparsed repair status OK
    engineer_forums.sigpic repair status OK
    Table Op Msg_type Msg_text
    engineer_forums.sitelink repair status OK
    engineer_forums.skimlinks repair status OK
    engineer_forums.smilie repair status OK
    engineer_forums.socialgroup repair status OK
    engineer_forums.socialgroupcategory repair status OK
    engineer_forums.socialgroupicon repair status OK
    engineer_forums.socialgroupmember repair status OK
    engineer_forums.spamlog repair status OK
    engineer_forums.stats repair status OK
    engineer_forums.strikes repair status OK
    engineer_forums.style repair status OK
    engineer_forums.stylevar repair status OK
    engineer_forums.stylevardfn repair status OK
    engineer_forums.subscribediscussion repair status OK
    engineer_forums.subscribeevent repair status OK
    engineer_forums.subscribeforum repair status OK
    engineer_forums.subscribegroup repair status OK
    engineer_forums.subscribethread repair status OK
    engineer_forums.subscription repair status OK
    engineer_forums.subscriptionlog repair status OK
    engineer_forums.subscriptionpermission repair status OK
    engineer_forums.tachyforumcounter repair status OK
    engineer_forums.tachyforumpost repair status OK
    engineer_forums.tachythreadcounter repair status OK
    engineer_forums.tachythreadpost repair status OK
    engineer_forums.tag repair status OK
    engineer_forums.tagcontent repair status OK
    engineer_forums.taggregate_temp_1319779560 repair note The storage engine for the table doesn't support repair
    engineer_forums.taggregate_temp_1320668760 repair note The storage engine for the table doesn't support repair
    engineer_forums.taggregate_temp_1342189560 repair note The storage engine for the table doesn't support repair
    engineer_forums.taggregate_temp_1344291960 repair note The storage engine for the table doesn't support repair
    engineer_forums.taggregate_temp_1344320760 repair note The storage engine for the table doesn't support repair
    engineer_forums.taggregate_temp_1344324360 repair note The storage engine for the table doesn't support repair
    engineer_forums.taggregate_temp_1344327960 repair note The storage engine for the table doesn't support repair
    engineer_forums.taggregate_temp_1344331560 repair note The storage engine for the table doesn't support repair
    engineer_forums.taggregate_temp_1344335160 repair note The storage engine for the table doesn't support repair
    engineer_forums.taggregate_temp_1344338760 repair note The storage engine for the table doesn't support repair
    engineer_forums.taggregate_temp_1344342360 repair note The storage engine for the table doesn't support repair
    engineer_forums.taggregate_temp_1344345960 repair note The storage engine for the table doesn't support repair
    engineer_forums.taggregate_temp_1344349560 repair note The storage engine for the table doesn't support repair
    engineer_forums.taggregate_temp_1344353160 repair note The storage engine for the table doesn't support repair
    engineer_forums.taggregate_temp_1344356760 repair note The storage engine for the table doesn't support repair
    engineer_forums.taggregate_temp_1344360360 repair note The storage engine for the table doesn't support repair
    engineer_forums.taggregate_temp_1344367560 repair note The storage engine for the table doesn't support repair
    engineer_forums.taggregate_temp_1344371160 repair note The storage engine for the table doesn't support repair
    engineer_forums.taggregate_temp_1344374760 repair note The storage engine for the table doesn't support repair
    engineer_forums.taggregate_temp_1344378360 repair note The storage engine for the table doesn't support repair
    engineer_forums.taggregate_temp_1344399960 repair note The storage engine for the table doesn't support repair
    engineer_forums.taggregate_temp_1344410760 repair note The storage engine for the table doesn't support repair
    engineer_forums.taggregate_temp_1344414360 repair note The storage engine for the table doesn't support repair

    بچه ها کسی هست اینجا برای رفع این مشکل بتونه من رو راهنمایی کنه ؟
    ویرایش توسط tsonade : 2012/12/31 در ساعت 12:20 PM دلیل: ادغام دو پست
    عشق یعنی تنهایی

  5. Top | #4
    کاربر سایت

    تاریخ عضویت
    Mar 2011
    ورژن ویبولتین
    4.1.3
    نوشته ها
    474
    مورد پسند
    135 بار
    نوشته های وبلاگ
    1
    اطلاعات
    Windows XP Firefox 17.0
    میزان امتیاز
    55

    پیش فرض

    دوستان اگه اطلاعاتی دارید ممنون میشم در اختیار من قرار بدید
    بنده یک فایل htaccess ایجادم کرده بودم
    شاید
    مدودیت در سرور باعث این مشکل میشه
    البته این کد رو حذف کردم
    کد به شرح زیر می باشد
    کد PHP:
     RewriteEngine on  

    RewriteCond 
    %{THE_REQUEST} ^[A-Z]{3,9} /index.php HTTP/
    RewriteRule ^index.phphttp://www.engineer-forum.com/ [R=301,L]  


    RewriteCond %{HTTP_HOST} ^engineer-forum.com$
    RewriteRule (.*) http://www.engineer-forum.com/$1 [R=301,L] 
    تمام هک ها هم از فایل Config غیر فعال کردم

    این دیتابیس رو از قسمت PHPmyadmin ایپوردت کردیم
    چون ریستور نمی شد
    کسی نیست راهنمایی کنه ؟
    ویرایش توسط tsonade : 2012/12/31 در ساعت 07:17 PM دلیل: ادغام دو پست
    عشق یعنی تنهایی

اطلاعات موضوع

کاربرانی که در حال مشاهده این موضوع هستند

در حال حاضر 1 کاربر در حال مشاهده این موضوع است. (0 کاربران و 1 مهمان ها)

موضوعات مشابه

  1. پاسخ: 33
    آخرين نوشته: 2014/01/15, 11:39 AM
  2. مشکل دیتا بیس ارور پس از تغییر collition در دیتابیس
    توسط ortegoli2010 در انجمن پرسش و پاسخ
    پاسخ: 8
    آخرين نوشته: 2013/10/30, 10:14 PM
  3. مشکل دیتا بیس ارور پس از تغییر collition در دیتابیس
    توسط ortegoli2010 در انجمن پرسش و پاسخ
    پاسخ: 0
    آخرين نوشته: 2012/11/04, 11:32 PM
  4. پاسخ: 1
    آخرين نوشته: 2012/08/21, 08:15 AM
  5. انتقال یک انجمن از طریق دیتابیس به دیتابیسی دیگر
    توسط ReZaPishgam در انجمن پرسش و پاسخ
    پاسخ: 1
    آخرين نوشته: 2012/05/09, 10:32 PM

کلمات کلیدی این موضوع

علاقه مندی ها (Bookmarks)

علاقه مندی ها (Bookmarks)

مجوز های ارسال و ویرایش

  • شما نمیتوانید موضوع جدیدی ارسال کنید
  • شما امکان ارسال پاسخ را ندارید
  • شما نمیتوانید فایل پیوست کنید.
  • شما نمیتوانید پست های خود را ویرایش کنید
  •