Advertisement:

Author Topic: database error  (Read 7212 times)

Offline droidhorse

  • Semi-Newbie
  • *
  • Posts: 42
database error
« on: November 03, 2014, 07:19:26 PM »
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.


Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: database error
« Reply #1 on: November 03, 2014, 07:28:04 PM »
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.
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 9,394
Re: database error
« Reply #2 on: November 03, 2014, 09:13:39 PM »
if your host moved your database to a different server, you my have to update the server info in Settings.php.

Offline droidhorse

  • Semi-Newbie
  • *
  • Posts: 42
Re: database error
« Reply #3 on: November 03, 2014, 10:06:02 PM »
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.

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 9,394
Re: database error
« Reply #4 on: November 03, 2014, 11:27:51 PM »
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?

Offline droidhorse

  • Semi-Newbie
  • *
  • Posts: 42
Re: database error
« Reply #5 on: November 04, 2014, 03:23:03 PM »
I have not changed anything. This is the result of the host moving the files to another server.

Offline droidhorse

  • Semi-Newbie
  • *
  • Posts: 42
database error
« Reply #6 on: November 05, 2014, 09:44:20 AM »
Ok in reference to my last post. Is it possible to install new version and import the one that is corrupted.

kat

  • Guest
Re: database error
« Reply #7 on: November 05, 2014, 10:11:14 AM »
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?

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 9,394
Re: database error
« Reply #8 on: November 05, 2014, 11:46:56 AM »
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?

Offline droidhorse

  • Semi-Newbie
  • *
  • Posts: 42
Re: database error
« Reply #9 on: November 05, 2014, 03:52:00 PM »
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

Offline droidhorse

  • Semi-Newbie
  • *
  • Posts: 42
Re: database error
« Reply #10 on: November 05, 2014, 04:10:58 PM »
Also is there a way to upgrade this board to the newest version? Thank you for your help.

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 9,394
Re: database error
« Reply #11 on: November 05, 2014, 09:55:45 PM »
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

  • Guest
Re: database error
« Reply #12 on: November 06, 2014, 05:53:20 AM »
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.

Offline droidhorse

  • Semi-Newbie
  • *
  • Posts: 42
Re: database error
« Reply #13 on: November 07, 2014, 06:43:55 PM »
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.

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,583
  • Gender: Male
    • Kindred-999 on GitHub
Re: database error
« Reply #14 on: November 07, 2014, 07:23:58 PM »
No, it can not be done from smf admin.

http://wiki.simplemachines.org/smf/Upgrading
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.