Topic: database error

[droidhorse]

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.

[margarett]

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.

[Sir Osis of Liver]

if your host moved your database to a different server, you my have to update the server info in Settings.php.

[droidhorse]

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.

[Sir Osis of Liver]

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?

[droidhorse]

I have not changed anything. This is the result of the host moving the files to another server.

[droidhorse]

Ok in reference to my last post. Is it possible to install new version and import the one that is corrupted.

[kat]

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?

[Sir Osis of Liver]

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?

[droidhorse]

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

[droidhorse]

Also is there a way to upgrade this board to the newest version? Thank you for your help.

[Sir Osis of Liver]

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.

Do you or your host have a backup of the db prior to the move?

[kat]

Can 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.

[droidhorse]

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.

[Kindred]

No, it can not be done from smf admin.

http://wiki.simplemachines.org/smf/Upgrading

[kat]

dummies version

http://wiki.simplemachines.org/smf/A_friendly_guide_to_Upgrading