News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

Database Crashed

Started by Jeet Chowdhury, May 17, 2011, 04:45:35 PM

Previous topic - Next topic

Jeet Chowdhury

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.... :(

Matthew K.

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 :)

Illori

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.

Jeet Chowdhury

no all the folder under default and other theme directory are missing.... i am reuploading see if working.... :(

Jeet Chowdhury

thanks page opening now.... :) thanks a lot.... :)

Jeet Chowdhury

can u guys tell me if any other file missing???

Illori

your copyright is missing, it must be restored.

Jeet Chowdhury

it due to the old modded file. Im adding them. Many features not working. How to do clean install by retaining db.

Illori

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.

Jeet Chowdhury

when i clicking edit theme stylesheet nothing happening ilori i pm ing u my admin username pass can u help me please?

Illori

no i dont have time to help you right now, and please do not pm anyone for support without asking first.

Jeet Chowdhury

ok im sorry. Im trying.

mashby

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.
Always be a little kinder than necessary.
- James M. Barrie

Jeet Chowdhury

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?

Jeet Chowdhury

please reply where i get rc4 upgrade file full?

CapadY

Please, don't PM me for support unless invited.
If you don't understand this, you will be blacklisted.

aishaweb

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.... :-\


Jeet Chowdhury

thank you i have upgraded rc5 but my theme not working and many mods.... :(

Jeet Chowdhury

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

Jeet Chowdhury

which tables are safe to delete if i want to retain vanilla forum?

CapadY

Normaly, after an upgrade, all mod's have to be reinstalled.

Try attached tool to make your database a vanilla one:
Please, don't PM me for support unless invited.
If you don't understand this, you will be blacklisted.

Jeet Chowdhury

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

:(

Jeet Chowdhury

i have runned cleanup but table not got deleted. try yourself:

http://muskilashan.com/db_cleanup.php

Jeet Chowdhury


Illori

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.

CapadY

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.
Please, don't PM me for support unless invited.
If you don't understand this, you will be blacklisted.

CapadY

Give it another try with the new attachement.

Please, don't PM me for support unless invited.
If you don't understand this, you will be blacklisted.

Jeet Chowdhury

thanks its worked... many option in admin panel still not working.... ;(


Aleksi "Lex" Kilpinen

Have you been able to fix this, or do you still need assistance? :)
Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

yakyakyak

Policy has now changed and SMF are offering support on WareZ themed sites?


Aleksi "Lex" Kilpinen

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.
Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

yakyakyak

Glad we are maintaining standards

<clap>

Jeet Chowdhury

#34
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? ??? :-/

Jeet Chowdhury


Illori

they are talking about the content of your forum not your theme

Jeet Chowdhury

what they mean by "WareZ themed sites"????


Advertisement: