Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: Jeet Chowdhury on May 17, 2011, 04:45:35 PM

Title: Database Crashed
Post by: Jeet Chowdhury on May 17, 2011, 04:45:35 PM
my host crashed for some reason now my site http://muskilashan.com not displaying properlly... i checked the files but i think the problem is with its database. i'm uploading its database can anyone fix it for me please.... :(
Title: Re: Database Crashed
Post by: Matthew K. on May 17, 2011, 04:54:07 PM
I went ahead and removed your attached database, as it's really not the safest thing to attach. Illori should be posting soon to help you out :)
Title: Re: Database Crashed
Post by: Illori on May 17, 2011, 04:54:33 PM
the issue at hand here does not seem to be a problem with your database it is a problem with a missing file

http://muskilashan.com/Themes/default/css/index.css?rc3
Not Found

The requested URL /Themes/default/css/index.css was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.


please verify that all your files in place on your server.
Title: Re: Database Crashed
Post by: Jeet Chowdhury on May 17, 2011, 05:16:16 PM
no all the folder under default and other theme directory are missing.... i am reuploading see if working.... :(
Title: Re: Database Crashed
Post by: Jeet Chowdhury on May 17, 2011, 05:26:44 PM
thanks page opening now.... :) thanks a lot.... :)
Title: Re: Database Crashed
Post by: Jeet Chowdhury on May 17, 2011, 05:30:01 PM
can u guys tell me if any other file missing???
Title: Re: Database Crashed
Post by: Illori on May 17, 2011, 05:45:22 PM
your copyright is missing, it must be restored.
Title: Re: Database Crashed
Post by: Jeet Chowdhury on May 17, 2011, 05:55:20 PM
it due to the old modded file. Im adding them. Many features not working. How to do clean install by retaining db.
Title: Re: Database Crashed
Post by: Illori on May 17, 2011, 06:00:58 PM
upload a clean set of files to your server overriding your existing files. you would need to use the files in the large upgrade package.
Title: Re: Database Crashed
Post by: Jeet Chowdhury on May 17, 2011, 06:01:47 PM
when i clicking edit theme stylesheet nothing happening ilori i pm ing u my admin username pass can u help me please?
Title: Re: Database Crashed
Post by: Illori on May 17, 2011, 06:02:47 PM
no i dont have time to help you right now, and please do not pm anyone for support without asking first.
Title: Re: Database Crashed
Post by: Jeet Chowdhury on May 17, 2011, 06:06:45 PM
ok im sorry. Im trying.
Title: Re: Database Crashed
Post by: mashby on May 17, 2011, 07:30:11 PM
display:none is surely not the result of a mod, but likely the result of editing index.template.php, eh?
<div id="footerarea">
<span style="display:none" class="smalltext">
<span style="display: inline; visibility: visible; font-family: Verdana, Arial, sans-serif;" class="smalltext"><a class="new_win" target="_blank" title="Simple Machines Forum" href="http://www.simplemachines.org/">Powered by SMF 2.0 RC4</a> |
<a class="new_win" target="_blank" title="Free Forum Software" href="http://www.simplemachines.org/about/copyright.php">SMF &copy; 2006&ndash;2011, Simple Machines LLC</a><br><a class="new_win" target="_blank" href="http://www.simpleportal.net/">SimplePortal 2.3.3 &copy; 2008-2010, SimplePortal</a>
</span>
<br>Theme by <a target="_blank" href="http://www.dzinerstudio.com"><b>DzinerStudio</b></a></span><br><span class="smalltext">Page created in 0.223 seconds with 10 queries.</span>
</div>
I doubt you'll get much further support without at least removing that display:none dealio.
Title: Re: Database Crashed
Post by: Jeet Chowdhury on May 18, 2011, 12:48:57 AM
Quote from: mashby on May 17, 2011, 07:30:11 PM
display:none is surely not the result of a mod, but likely the result of editing index.template.php, eh?
<div id="footerarea">
<span style="display:none" class="smalltext">
<span style="display: inline; visibility: visible; font-family: Verdana, Arial, sans-serif;" class="smalltext"><a class="new_win" target="_blank" title="Simple Machines Forum" href="http://www.simplemachines.org/">Powered by SMF 2.0 RC4</a> |
<a class="new_win" target="_blank" title="Free Forum Software" href="http://www.simplemachines.org/about/copyright.php">SMF &copy; 2006&ndash;2011, Simple Machines LLC</a><br><a class="new_win" target="_blank" href="http://www.simpleportal.net/">SimplePortal 2.3.3 &copy; 2008-2010, SimplePortal</a>
</span>
<br>Theme by <a target="_blank" href="http://www.dzinerstudio.com"><b>DzinerStudio</b></a></span><br><span class="smalltext">Page created in 0.223 seconds with 10 queries.</span>
</div>
I doubt you'll get much further support without at least removing that display:none dealio.

i said modded backup... means i uploaded my home apache test file to check... working or not... this issue happen 1 month before... this is that time backup file....

and when i try to click edit theme style****** black page come....

http://muskilashan.com/index.php?action=admin;area=theme;th=6;fe5bed774fa=3ba6ec5efae2456f16ddd8267f314f18;sa=edit;directory=css

and also i cant backup database blank page come... where i get rc4 full upgrade files?
Title: Re: Database Crashed
Post by: Jeet Chowdhury on May 18, 2011, 04:23:45 AM
please reply where i get rc4 upgrade file full?
Title: Re: Database Crashed
Post by: CapadY on May 18, 2011, 04:31:31 AM
http://download.simplemachines.org/index.php?thanks;filename=smf_2-0-rc4_upgrade.zip
Title: Re: Database Crashed
Post by: aishaweb on May 18, 2011, 04:54:59 AM
http://download.simplemachines.org/

You could upgrade to SMF 2.0 RC5


Dont you just hate it when "display:none" just randomly and completely by accident inserts itself in the copyright code.... :-\
Title: Re: Database Crashed
Post by: Jeet Chowdhury on May 18, 2011, 11:05:48 AM
Quote from: CapadY on May 18, 2011, 04:31:31 AM
http://download.simplemachines.org/index.php?thanks;filename=smf_2-0-rc4_upgrade.zip

thanks doing that now :)
Title: Re: Database Crashed
Post by: Jeet Chowdhury on May 18, 2011, 11:27:45 AM
thank you i have upgraded rc5 but my theme not working and many mods.... :(
Title: Re: Database Crashed
Post by: Jeet Chowdhury on May 18, 2011, 11:33:16 AM
and many features still not working here is repair log of database:

Quote
muskilas_forum.smf_2sichatrepairstatusOK
muskilas_forum.smf_2sichat_gadgetsrepairstatusOK
muskilas_forum.smf_admin_info_filesrepairstatusOK
muskilas_forum.smf_adsrepairErrorIncorrect information in file: './muskilas_forum/s...
muskilas_forum.smf_adsrepairerrorCorrupt
muskilas_forum.smf_ads_settingsrepairErrorIncorrect information in file: './muskilas_forum/s...
muskilas_forum.smf_ads_settingsrepairerrorCorrupt
muskilas_forum.smf_ajaxchat_bansrepairstatusOK
muskilas_forum.smf_ajaxchat_invitationsrepairstatusOK
muskilas_forum.smf_ajaxchat_messagesrepairstatusOK
muskilas_forum.smf_ajaxchat_onlinerepairstatusOK
muskilas_forum.smf_ajaxshout_bansrepairstatusOK
muskilas_forum.smf_ajaxshout_invitationsrepairstatusOK
muskilas_forum.smf_ajaxshout_messagesrepairstatusOK
muskilas_forum.smf_ajaxshout_onlinerepairstatusOK
muskilas_forum.smf_approval_queuerepairstatusOK
muskilas_forum.smf_arcade_categoriesrepairstatusOK
muskilas_forum.smf_arcade_favoriterepairstatusOK
muskilas_forum.smf_arcade_filesrepairstatusOK
muskilas_forum.smf_arcade_gamesrepairstatusOK
muskilas_forum.smf_arcade_game_inforepairstatusOK
muskilas_forum.smf_arcade_matchesrepairstatusOK
muskilas_forum.smf_arcade_matches_playersrepairstatusOK
muskilas_forum.smf_arcade_matches_resultsrepairstatusOK
muskilas_forum.smf_arcade_matches_roundsrepairstatusOK
muskilas_forum.smf_arcade_ratesrepairstatusOK
muskilas_forum.smf_arcade_scoresrepairstatusOK
muskilas_forum.smf_arcade_settingsrepairstatusOK
muskilas_forum.smf_attachmentsrepairstatusOK
muskilas_forum.smf_ban_groupsrepairstatusOK
muskilas_forum.smf_ban_itemsrepairstatusOK
muskilas_forum.smf_boardsrepairstatusOK
muskilas_forum.smf_board_permissionsrepairstatusOK
muskilas_forum.smf_buddiesrepairstatusOK
muskilas_forum.smf_calendarrepairstatusOK
muskilas_forum.smf_calendar_holidaysrepairstatusOK
muskilas_forum.smf_categoriesrepairstatusOK
muskilas_forum.smf_collapsed_categoriesrepairstatusOK
muskilas_forum.smf_custom_fieldsrepairstatusOK
muskilas_forum.smf_gallery_catrepairErrorIncorrect information in file: './muskilas_forum/s...
muskilas_forum.smf_gallery_catrepairerrorCorrupt
muskilas_forum.smf_gallery_commentrepairErrorIncorrect information in file: './muskilas_forum/s...
muskilas_forum.smf_gallery_commentrepairerrorCorrupt
muskilas_forum.smf_gallery_picrepairErrorIncorrect information in file: './muskilas_forum/s...
muskilas_forum.smf_gallery_picrepairerrorCorrupt
muskilas_forum.smf_gallery_reportrepairErrorIncorrect information in file: './muskilas_forum/s...
muskilas_forum.smf_gallery_reportrepairerrorCorrupt
muskilas_forum.smf_group_moderatorsrepairstatusOK
muskilas_forum.smf_log_actionsrepairstatusOK
muskilas_forum.smf_log_activityrepairstatusOK
muskilas_forum.smf_log_bannedrepairstatusOK
muskilas_forum.smf_log_boardsrepairstatusOK
muskilas_forum.smf_log_commentsrepairstatusOK
muskilas_forum.smf_log_digestrepairstatusOK
muskilas_forum.smf_log_enotify_pmsrepairErrorIncorrect information in file: './muskilas_forum/s...
muskilas_forum.smf_log_enotify_pmsrepairerrorCorrupt
muskilas_forum.smf_log_enotify_repliesrepairErrorIncorrect information in file: './muskilas_forum/s...
muskilas_forum.smf_log_enotify_repliesrepairerrorCorrupt
muskilas_forum.smf_log_errorsrepairstatusOK
muskilas_forum.smf_log_floodcontrolrepairstatusOK
muskilas_forum.smf_log_group_requestsrepairstatusOK
muskilas_forum.smf_log_karmarepairstatusOK
muskilas_forum.smf_log_mark_readrepairstatusOK
muskilas_forum.smf_log_member_noticesrepairstatusOK
muskilas_forum.smf_log_notifyrepairstatusOK
muskilas_forum.smf_log_onlinerepairstatusOK
muskilas_forum.smf_log_packagesrepairstatusOK
muskilas_forum.smf_log_pollsrepairstatusOK
muskilas_forum.smf_log_reportedrepairstatusOK
muskilas_forum.smf_log_reported_commentsrepairstatusOK
muskilas_forum.smf_log_scheduled_tasksrepairstatusOK
muskilas_forum.smf_log_search_messagesrepairstatusOK
muskilas_forum.smf_log_search_resultsrepairstatusOK
muskilas_forum.smf_log_search_subjectsrepairstatusOK
muskilas_forum.smf_log_search_topicsrepairstatusOK
muskilas_forum.smf_log_spider_hitsrepairstatusOK
muskilas_forum.smf_log_spider_statsrepairstatusOK
muskilas_forum.smf_log_subscribedrepairstatusOK
muskilas_forum.smf_log_topicsrepairstatusOK
muskilas_forum.smf_mail_queuerepairstatusOK
muskilas_forum.smf_membergroupsrepairstatusOK
muskilas_forum.smf_membersrepairstatusOK
muskilas_forum.smf_messagesrepairstatusOK
muskilas_forum.smf_message_iconsrepairstatusOK
muskilas_forum.smf_moderatorsrepairstatusOK
muskilas_forum.smf_openid_assocrepairstatusOK
muskilas_forum.smf_package_serversrepairstatusOK
muskilas_forum.smf_permissionsrepairstatusOK
muskilas_forum.smf_permission_profilesrepairstatusOK
muskilas_forum.smf_personal_messagesrepairstatusOK
muskilas_forum.smf_picture_commentsrepairstatusOK
muskilas_forum.smf_pm_recipientsrepairstatusOK
muskilas_forum.smf_pm_rulesrepairstatusOK
muskilas_forum.smf_pollsrepairstatusOK
muskilas_forum.smf_poll_choicesrepairstatusOK
muskilas_forum.smf_post_draftsrepairstatusOK
muskilas_forum.smf_premiumbeat_mp3srepairstatusOK
muskilas_forum.smf_premiumbeat_settingsrepairstatusOK
muskilas_forum.smf_pretty_topic_urlsrepairstatusOK
muskilas_forum.smf_pretty_urls_cacherepairstatusOK
Table Op Msg_type Msg_text
muskilas_forum.smf_profile_albumsrepairstatusOK
muskilas_forum.smf_profile_commentsrepairstatusOK
muskilas_forum.smf_profile_picturesrepairstatusOK
muskilas_forum.smf_sa_adsrepairstatusOK
muskilas_forum.smf_sa_positionsrepairstatusOK
muskilas_forum.smf_scheduled_tasksrepairstatusOK
muskilas_forum.smf_sessionsrepairstatusOK
muskilas_forum.smf_settingsrepairstatusOK
muskilas_forum.smf_smileysrepairstatusOK
muskilas_forum.smf_spidersrepairstatusOK
muskilas_forum.smf_sp_articlesrepairstatusOK
muskilas_forum.smf_sp_blocksrepairstatusOK
muskilas_forum.smf_sp_categoriesrepairstatusOK
muskilas_forum.smf_sp_functionsrepairstatusOK
muskilas_forum.smf_sp_pagesrepairstatusOK
muskilas_forum.smf_sp_parametersrepairstatusOK
muskilas_forum.smf_sp_shoutboxesrepairstatusOK
muskilas_forum.smf_sp_shoutsrepairstatusOK
muskilas_forum.smf_staffrepairstatusOK
muskilas_forum.smf_subscriptionsrepairstatusOK
muskilas_forum.smf_themesrepairstatusOK
muskilas_forum.smf_topicsrepairstatusOK
muskilas_forum.smf_tracker_categoryrepairstatusOK
muskilas_forum.smf_tracker_downloadersrepairstatusOK
muskilas_forum.smf_tracker_peersrepairstatusOK
muskilas_forum.smf_tracker_torrentsrepairstatusOK
Title: Re: Database Crashed
Post by: Jeet Chowdhury on May 18, 2011, 11:34:09 AM
which tables are safe to delete if i want to retain vanilla forum?
Title: Re: Database Crashed
Post by: CapadY on May 18, 2011, 01:28:40 PM
Normaly, after an upgrade, all mod's have to be reinstalled.

Try attached tool to make your database a vanilla one:
Title: Re: Database Crashed
Post by: Jeet Chowdhury on May 19, 2011, 02:10:44 AM
when i try to backup database still getting this error,

Incorrect information in file: './muskilas_forum/smf_ads.frm'
File: /home/muskilas/public_html/Sources/DumpDatabase.php
Line: 162

:(
Title: Re: Database Crashed
Post by: Jeet Chowdhury on May 19, 2011, 02:15:58 AM
i have runned cleanup but table not got deleted. try yourself:

http://muskilashan.com/db_cleanup.php
Title: Re: Database Crashed
Post by: Jeet Chowdhury on May 19, 2011, 10:23:27 AM
please help me.... ;(
Title: Re: Database Crashed
Post by: Illori on May 19, 2011, 10:25:23 AM
please do not bump within 24 hours we are all volunteers and will reply if and when we know the answer. especially when you are waiting for a reply from one person bumping will not help.
Title: Re: Database Crashed
Post by: CapadY on May 19, 2011, 11:53:04 AM
And that special person is unable to solve this kind of things while he is working :)

I've found the problem. I will try if I have some time to test it tonight and repost it.
Title: Re: Database Crashed
Post by: CapadY on May 19, 2011, 02:09:27 PM
Give it another try with the new attachement.

Title: Re: Database Crashed
Post by: Jeet Chowdhury on May 20, 2011, 05:06:13 AM
thanks its worked... many option in admin panel still not working.... ;(
Title: Re: Database Crashed
Post by: Jeet Chowdhury on May 20, 2011, 05:07:03 AM
such as edittting style sheet showing blank page....

http://muskilashan.com/index.php?action=admin;area=theme;th=6;b796d6b90=bc1b6e8f7edfadfe9b09418db5349831;sa=edit;directory=css
Title: Re: Database Crashed
Post by: Aleksi "Lex" Kilpinen on June 13, 2011, 08:15:19 AM
Have you been able to fix this, or do you still need assistance? :)
Title: Re: Database Crashed
Post by: yakyakyak on June 13, 2011, 08:19:59 AM
Policy has now changed and SMF are offering support on WareZ themed sites?

Title: Re: Database Crashed
Post by: Aleksi "Lex" Kilpinen on June 13, 2011, 08:25:30 AM
Quote from: yakyakyak on June 13, 2011, 08:19:59 AM
Policy has now changed and SMF are offering support on WareZ themed sites?
Actually no - Thanks for pointing that out. I had not checked the site in question, and it seems you are right in calling it WareZ themed.

As is, I'm fairly confident most of the team will not offer further support on this.
Title: Re: Database Crashed
Post by: yakyakyak on June 13, 2011, 08:26:19 AM
Glad we are maintaining standards

<clap>
Title: Re: Database Crashed
Post by: Jeet Chowdhury on June 13, 2011, 10:27:50 AM
QuotePolicy has now changed and SMF are offering support on WareZ themed sites?

what the hell you mean by that? ??? DO YOU ACTUALLY KNOW THERE ARE MANY THEMES ARE FREE TO DOWNLOAD FROM DZSTUDIO... or just like to pass a comment? ??? :-/
Title: Re: Database Crashed
Post by: Jeet Chowdhury on June 13, 2011, 10:39:32 AM
LIST OF FREE THEMES BY DZSTUDIO:

http://www.dzinerstudio.com/index.php?PHPSESSID=1de912e5f389fe11ba0f9be706eb5125&action=downloads;cat=1

TAKE A LOOK.... THEN PASS STUPID REPLYS..... :|
Title: Re: Database Crashed
Post by: Illori on June 13, 2011, 10:40:41 AM
they are talking about the content of your forum not your theme
Title: Re: Database Crashed
Post by: Jeet Chowdhury on June 13, 2011, 10:43:02 AM
what they mean by "WareZ themed sites"????
Title: Re: Database Crashed
Post by: Illori on June 13, 2011, 10:44:35 AM
http://en.wikipedia.org/wiki/Warez