The hard drive on my server crashed on Sunday.The files were moved to a new server.Now when I try to access the site. I just get Database Error
Please try again. If you come back to this error screen, report the error to an administrator. I can't log in. I am using version 1.1.19. How can I upgrade to 1.1.20 or to the newest version manually because I can't login to admin. My host says the scripts are outdated. Thank you.
The error you have has nothing to do with your outdated version. There's something wrong with the database.
Check the table smf_log_errors, check the latest records, maybe there are more details there.
Also, check with phpmyadmin if there are any crashed tables.
if your host moved your database to a different server, you my have to update the server info in Settings.php.
Thank you for responding. I inherited this board. What need to be changed in Settings.php? I am a complete newbie. This was the old address for the board http://wellington-wef.com/sm/index.php?board=3.0,it now returns an error Incorrect key file for table 'smf_boards'; try to repair it.
margarett is correct, your forum is connecting to the database (Settings.php is ok) but it's damaged. You need to find phpmyadmin in the MySQL database section of your host cpanel, you can repair tables from there.
Edit: Your website loads, but the forum is not connecting to the db. What have you changed?
I have not changed anything. This is the result of the host moving the files to another server.
Ok in reference to my last post. Is it possible to install new version and import the one that is corrupted.
No way can you import a v1.x database into a v2.x forum, I'm afraid.
Can you not repair the db in Cpanel>Databases? Or, phpmyadmin?
Seems to be more than one thing happening here. The original error was displayed by the forum, so it was connecting to the db. When I looked at the site Monday, forum was not connecting to the db. Just took another look, and forum is again loading with db error.
Do you or your host have a backup of the db prior to the move?
After trying to repair with PHPMyAdmin,I get these results.
←
phpMyAdmin
HomeQuery windowphpMyAdmin documentationDocumentationReload navigation panel
Expand/Collapse
Database operations
information_schema
Expand/Collapse
New
Expand/Collapse
wellingt
Expand/Collapse
Database operations
wellingt_businessdir
Expand/Collapse
Database operations
wellingt_classifiedsh
Expand/Collapse
Database operations
wellingt_directory
Expand/Collapse
Database operations
wellingt_forum
X
New
New
Expand/Collapse
Structure
smf_ads
Expand/Collapse
Structure
smf_ads_settings
Expand/Collapse
Structure
smf_attachments
Expand/Collapse
Structure
smf_ban_groups
Expand/Collapse
Structure
smf_ban_items
Expand/Collapse
Structure
smf_boards
Expand/Collapse
Structure
smf_board_permissions
Expand/Collapse
Structure
smf_calendar
Expand/Collapse
Structure
smf_calendar_holidays
Expand/Collapse
Structure
smf_categories
Expand/Collapse
Structure
smf_collapsed_categories
Expand/Collapse
Structure
smf_log_actions
Expand/Collapse
Structure
smf_log_activity
Expand/Collapse
Structure
smf_log_banned
Expand/Collapse
Structure
smf_log_boards
Expand/Collapse
Structure
smf_log_errors
Expand/Collapse
Structure
smf_log_floodcontrol
Expand/Collapse
Structure
smf_log_karma
Expand/Collapse
Structure
smf_log_mark_read
Expand/Collapse
Structure
smf_log_notify
Expand/Collapse
Structure
smf_log_online
Expand/Collapse
Structure
smf_log_polls
Expand/Collapse
Structure
smf_log_search_messages
Expand/Collapse
Structure
smf_log_search_results
Expand/Collapse
Structure
smf_log_search_subjects
Expand/Collapse
Structure
smf_log_search_topics
Expand/Collapse
Structure
smf_log_topics
Expand/Collapse
Structure
smf_membergroups
Expand/Collapse
Structure
smf_members
Expand/Collapse
Structure
smf_messages
Expand/Collapse
Structure
smf_message_icons
Expand/Collapse
Structure
smf_moderators
Expand/Collapse
Structure
smf_package_servers
Expand/Collapse
Structure
smf_permissions
Expand/Collapse
Structure
smf_personal_messages
Expand/Collapse
Structure
smf_pm_recipients
Expand/Collapse
Structure
smf_polls
Expand/Collapse
Structure
smf_poll_choices
Expand/Collapse
Structure
smf_sessions
Expand/Collapse
Structure
smf_settings
Expand/Collapse
Structure
smf_smileys
Expand/Collapse
Structure
smf_themes
Expand/Collapse
Structure
smf_topics
Expand/Collapse
Database operations
wellingt_freelinks
Expand/Collapse
Database operations
wellingt_realestateads
Server: localhost »Database: wellingt_forum
Structure Structure
SQL SQL
Search Search
Query Query
Export Export
Import Import
Operations Operations
Routines Routines
Events Events
Triggers Triggers
SQL result
Host: localhost
Database: wellingt_forum
Generation Time: Nov 05, 2014 at 02:50 PM
Generated by: phpMyAdmin 4.1.8 / MySQL 5.6.17
SQL query: REPAIR TABLE `smf_ads`, `smf_ads_settings`, `smf_attachments`, `smf_ban_groups`, `smf_ban_items`, `smf_boards`, `smf_board_permissions`, `smf_calendar`, `smf_calendar_holidays`, `smf_categories`, `smf_collapsed_categories`, `smf_log_actions`, `smf_log_activity`, `smf_log_banned`, `smf_log_boards`, `smf_log_errors`, `smf_log_floodcontrol`, `smf_log_karma`, `smf_log_mark_read`, `smf_log_notify`, `smf_log_online`, `smf_log_polls`, `smf_log_search_messages`, `smf_log_search_results`, `smf_log_search_subjects`, `smf_log_search_topics`, `smf_log_topics`, `smf_membergroups`, `smf_members`, `smf_messages`, `smf_message_icons`, `smf_moderators`, `smf_package_servers`, `smf_permissions`, `smf_personal_messages`, `smf_pm_recipients`, `smf_polls`, `smf_poll_choices`, `smf_sessions`, `smf_settings`, `smf_smileys`, `smf_themes`, `smf_topics`;
Rows: 46
Table Op Msg_type Msg_text
wellingt_forum.smf_ads repair status OK
wellingt_forum.smf_ads_settings repair status OK
wellingt_forum.smf_attachments repair status OK
wellingt_forum.smf_ban_groups repair status OK
wellingt_forum.smf_ban_items repair status OK
wellingt_forum.smf_boards repair Error Incorrect key file for table 'smf_boards'; try to ...
wellingt_forum.smf_boards repair error Corrupt
wellingt_forum.smf_board_permissions repair status OK
wellingt_forum.smf_calendar repair status OK
wellingt_forum.smf_calendar_holidays repair status OK
wellingt_forum.smf_categories repair status OK
wellingt_forum.smf_collapsed_categories repair status OK
wellingt_forum.smf_log_actions repair status OK
wellingt_forum.smf_log_activity repair status OK
wellingt_forum.smf_log_banned repair status OK
wellingt_forum.smf_log_boards repair status OK
wellingt_forum.smf_log_errors repair status OK
wellingt_forum.smf_log_floodcontrol repair status OK
wellingt_forum.smf_log_karma repair status OK
wellingt_forum.smf_log_mark_read repair status OK
wellingt_forum.smf_log_notify repair status OK
wellingt_forum.smf_log_online repair Error Incorrect file format 'smf_log_online'
wellingt_forum.smf_log_online repair error Corrupt
wellingt_forum.smf_log_polls repair status OK
wellingt_forum.smf_log_search_messages repair status OK
wellingt_forum.smf_log_search_results repair status OK
wellingt_forum.smf_log_search_subjects repair status OK
wellingt_forum.smf_log_search_topics repair status OK
wellingt_forum.smf_log_topics repair status OK
wellingt_forum.smf_membergroups repair status OK
wellingt_forum.smf_members repair Error Incorrect key file for table 'smf_members'; try to...
wellingt_forum.smf_members repair error Corrupt
wellingt_forum.smf_messages repair status OK
wellingt_forum.smf_message_icons repair status OK
wellingt_forum.smf_moderators repair status OK
wellingt_forum.smf_package_servers repair status OK
wellingt_forum.smf_permissions repair status OK
wellingt_forum.smf_personal_messages repair status OK
wellingt_forum.smf_pm_recipients repair status OK
wellingt_forum.smf_polls repair status OK
wellingt_forum.smf_poll_choices repair status OK
wellingt_forum.smf_sessions repair status OK
wellingt_forum.smf_settings repair status OK
wellingt_forum.smf_smileys repair status OK
wellingt_forum.smf_themes repair status OK
wellingt_forum.smf_topics repair status OK
Open new phpMyAdmin window
Also is there a way to upgrade this board to the newest version? Thank you for your help.
If you can fix the database in your current version, then you can upgrade to 2.0.9. You can't upgrade a trashed db. Looks like a couple of key tables (
smf_members and
smf_boards) are corrupt.
Quote from: Krash on November 05, 2014, 11:46:56 AM
Do you or your host have a backup of the db prior to the move?
Quote from: K@ on November 05, 2014, 10:11:14 AMCan you not repair the db in Cpanel>Databases? Or, phpmyadmin?
If not, give your host a nudge. If they're worth their salt, they should be able to help you out.
Hello everyone. Thank you all for trying to help. My host is not worth a crap (onlinemalls.com). Had no valid backups.Lost another database as well. I am installing an old backup from a few months ago.
My quest now is to upgrade to version 2.0. Does any body have a dummies version of how to do this? Can it be done from admin? This week is alot like a New Orleans funeral.
Thanks .Have a good weekend.
No, it can not be done from smf admin.
http://wiki.simplemachines.org/smf/Upgrading
Quote from: droidhorse on November 07, 2014, 06:43:55 PMdummies version
http://wiki.simplemachines.org/smf/A_friendly_guide_to_Upgrading
:)