• Resolved R. K. Bentley

    (@rkbentley)


    Hi guys,

    First time posting so bear with me.

    I installed WP 4.0 for a client about 3 weeks back and everything was smooth sailing until this morning when we starting getting 500/501/502/504 errors.

    MySQL was down for a time and then it came back up.

    I tried the website and it said there might be a database problem.

    Logged into MySQL and ran a repair and got this:

    [authors_wrdp2.wp_commentmeta] Error: Unknown storage engine ‘InnoDB’
    [authors_wrdp2.wp_commentmeta] error: Corrupt
    [authors_wrdp2.wp_comments] Error: Unknown storage engine ‘InnoDB’
    [authors_wrdp2.wp_comments] error: Corrupt
    [authors_wrdp2.wp_links] Error: Unknown storage engine ‘InnoDB’
    [authors_wrdp2.wp_links] error: Corrupt
    [authors_wrdp2.wp_options] Error: Unknown storage engine ‘InnoDB’
    [authors_wrdp2.wp_options] error: Corrupt
    [authors_wrdp2.wp_postmeta] Error: Unknown storage engine ‘InnoDB’
    [authors_wrdp2.wp_postmeta] error: Corrupt
    [authors_wrdp2.wp_posts] Error: Unknown storage engine ‘InnoDB’
    [authors_wrdp2.wp_posts] error: Corrupt
    [authors_wrdp2.wp_statpress] status: OK
    [authors_wrdp2.wp_term_relationships] Error: Unknown storage engine ‘InnoDB’
    [authors_wrdp2.wp_term_relationships] error: Corrupt
    [authors_wrdp2.wp_term_taxonomy] Error: Unknown storage engine ‘InnoDB’
    [authors_wrdp2.wp_term_taxonomy] error: Corrupt
    [authors_wrdp2.wp_terms] Error: Unknown storage engine ‘InnoDB’
    [authors_wrdp2.wp_terms] error: Corrupt
    [authors_wrdp2.wp_usermeta] Error: Unknown storage engine ‘InnoDB’
    [authors_wrdp2.wp_usermeta] error: Corrupt
    [authors_wrdp2.wp_users] Error: Unknown storage engine ‘InnoDB’
    [authors_wrdp2.wp_users] error: Corrupt

    I went to /wp-admin and it’s asking me to install WP again, went through the steps and gives me this long laundry list of error messages that begins like this:

    WordPress database error: [Unknown storage engine ‘InnoDB’]
    CREATE TABLE wp_users ( ID bigint(20) unsigned NOT NULL auto_increment, user_login varchar(60) NOT NULL default ”, user_pass varchar(64) NOT NULL default ”, user_nicename varchar(50) NOT NULL default ”, user_email varchar(100) NOT NULL default ”, user_url varchar(100) NOT NULL default ”, user_registered datetime NOT NULL default ‘0000-00-00 00:00:00’, user_activation_key varchar(60) NOT NULL default ”, user_status int(11) NOT NULL default ‘0’, display_name varchar(250) NOT NULL default ”, PRIMARY KEY (ID), KEY user_login_key (user_login), KEY user_nicename (user_nicename) ) DEFAULT CHARACTER SET utf8

    It gets to the end and says: here’s your username and click continue and it loops thru the install.

    You can see it over here

    Any way to save the database or am I starting from scratch?

    Thanks for the help!

Viewing 12 replies - 16 through 27 (of 27 total)
  • Im having the same issue across multiple websites and accounts on our reseller hosting account. Thanks for the update Russ. Will wait for an update.

    Thread Starter R. K. Bentley

    (@rkbentley)

    All fixed on my end, I had to default my permalinks and put them back to what they were but otherwise, all good!

    Yay!

    I’ll keep this thread unresolved until I hear from everyone who posted problems…

    Thanks for the tip, R.K.

    I had to manually go into phpMyAdmin and change all the “Type” from InnoDB to MYISAM but at least today it let me in! Yesterday it was telling me to contact my host because I did not have permission to edit phpMyAdmin.

    After I repaired the database, I was still getting errors on pages so I used R.K.’s tip and everything seems to be working fine. This is one of the few sites I have that is hosted on hostgator… and as soon as my client can find her domain name registrar info, I am moving it.

    I also had to default some permalinks. One of the sites crashed completely and the database became corrupt, but within a short period of time HostGator restored a backup. So all’s good on my end ??

    Our websites are back to normal. I didnt do anything, guess what ever the fix hostgator implemented seems to have fixed the databases. Only few servers are effected now and they are working to resolve according to the forum thread. https://forums.hostgator.com/oct-29-02-00-emergency-maintenance-t328219.html

    Hopefully everyone’s websites will be fixed soon. Good Luck guys.

    Thread Starter R. K. Bentley

    (@rkbentley)

    Okie dokie, since the problems seem to have been fixed, I’m going to switch this topic to resolved.

    My site disappeared today and only loads up with the install page! When I try to install I get this error….

    WordPress database error: [Unknown storage engine ‘InnoDB’]
    CREATE TABLE wp_users ( ID bigint(20) unsigned NOT NULL auto_increment, user_login varchar(60) NOT NULL default ”, user_pass varchar(64) NOT NULL default ”, user_nicename varchar(50) NOT NULL default ”, user_email varchar(100) NOT NULL default ”, user_url varchar(100) NOT NULL default ”, user_registered datetime NOT NULL default ‘0000-00-00 00:00:00’, user_activation_key varchar(60) NOT NULL default ”, user_status int(11) NOT NULL default ‘0’, display_name varchar(250) NOT NULL default ”, PRIMARY KEY (ID), KEY user_login_key (user_login), KEY user_nicename (user_nicename) ) DEFAULT CHARACTER SET utf8

    WordPress database error: [Unknown storage engine ‘InnoDB’]
    CREATE TABLE wp_usermeta ( umeta_id bigint(20) unsigned NOT NULL auto_increment, user_id bigint(20) unsigned NOT NULL default ‘0’, meta_key varchar(255) default NULL, meta_value longtext, PRIMARY KEY (umeta_id), KEY user_id (user_id), KEY meta_key (meta_key) ) DEFAULT CHARACTER SET utf8

    WordPress database error: [Unknown storage engine ‘InnoDB’]
    CREATE TABLE wp_terms ( term_id bigint(20) unsigned NOT NULL auto_increment, name varchar(200) NOT NULL default ”, slug varchar(200) NOT NULL default ”, term_group bigint(10) NOT NULL default 0, PRIMARY KEY (term_id), UNIQUE KEY slug (slug), KEY name (name) ) DEFAULT CHARACTER SET utf8

    etc…… it goes on and on!

    Can any one help??

    T0M-T0M,

    It sounds like the WordPress installation is trying to install a new database over the existing database, this may be the cause of database errors. I recommend exporting all tables and data from your existing WordPress database using PHPmyAdmin. From there I would delete the database and the database user and start a fresh install. After you’ve installed WordPress, you can import the tables and data from your previous database into your new database using PHPMyAdmin.

    If you need help, I may be able to assist you ??

    Also you may use an FTP client to backup your wp-contents folder as this contains your themes, plugins, uploads, etc.

    If you can access your homepage nomally, you should restart MySQL and everything will be ok!

    Hey guys, This issue is not with hosting server. I used to host my site on cloudfare and then on ovh server, but still facing the same issue with wordpress.

    This is an wordpress issue. and this problem may occur again.

    Hey guys,
    i’m running a e-commerce website..but unfortunately it is down and showing the wordpress database error..
    WordPress database error: [Unknown storage engine ‘InnoDB’]
    CREATE TABLE wp_users ( ID bigint(20) unsigned NOT NULL auto_increment, user_login varchar(60) NOT NULL default ”, user_pass varchar(64) NOT NULL default ”, user_nicename varchar(50) NOT NULL default ”, user_email varchar(100) NOT NULL default ”, user_url varchar(100) NOT NULL default ”, user_registered datetime NOT NULL default ‘0000-00-00 00:00:00’, user_activation_key varchar(60) NOT NULL default ”, user_status int(11) NOT NULL default ‘0’, display_name varchar(250) NOT NULL default ”, PRIMARY KEY (ID), KEY user_login_key (user_login), KEY user_nicename (user_nicename) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

    WordPress database error: [Unknown storage engine ‘InnoDB’]
    CREATE TABLE wp_usermeta ( umeta_id bigint(20) unsigned NOT NULL auto_increment, user_id bigint(20) unsigned NOT NULL default ‘0’, meta_key varchar(255) default NULL, meta_value longtext, PRIMARY KEY (umeta_id), KEY user_id (user_id), KEY meta_key (meta_key(191)) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

    WordPress database error: [Unknown storage engine ‘InnoDB’]
    CREATE TABLE wp_terms ( term_id bigint(20) unsigned NOT NULL auto_increment, name varchar(200) NOT NULL default ”, slug varchar(200) NOT NULL default ”, term_group bigint(10) NOT NULL default 0, PRIMARY KEY (term_id), KEY slug (slug(191)), KEY name (name(191)) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

    WordPress database error: [Unknown storage engine ‘InnoDB’]
    CREATE TABLE wp_term_taxonomy ( term_taxonomy_id bigint(20) unsigned NOT NULL auto_increment, term_id bigint(20) unsigned NOT NULL default 0, taxonomy varchar(32) NOT NULL default ”, description longtext NOT NULL, parent bigint(20) unsigned NOT NULL default 0, count bigint(20) NOT NULL default 0, PRIMARY KEY (term_taxonomy_id), UNIQUE KEY term_id_taxonomy (term_id,taxonomy), KEY taxonomy (taxonomy) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

    WordPress database error: [Unknown storage engine ‘InnoDB’]
    CREATE TABLE wp_term_relationships ( object_id bigint(20) unsigned NOT NULL default 0, term_taxonomy_id bigint(20) unsigned NOT NULL default 0, term_order int(11) NOT NULL default 0, PRIMARY KEY (object_id,term_taxonomy_id), KEY term_taxonomy_id (term_taxonomy_id) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

    How Can i resolve this problem..please help me iam a beginner..

    thanks..

Viewing 12 replies - 16 through 27 (of 27 total)
  • The topic ‘Unknown storage engine 'InnoDB'’ is closed to new replies.