Viewing 5 replies - 16 through 20 (of 20 total)
  • Jonathon N

    (@imagiscapeca)

    I would click Resolved, since the original questioners’ blog is now working, and so is mine, but I can’t click Resolved – only the original questioner (topic creator) can do that.

    askoracledba

    (@askoracledba)

    I also faced this issue today. I was able to repair the database. But I am still seeing below error when i check tables from phpadmin tool. How do i correct it

    Problems with indexes of table wp_comments
    More than one INDEX key was created for column comment_approved

    -Amit

    I also have the same issue in my database
    I get the same warning
    More than one INDEX key was created for column comment_approved

    I do have two ROWS in the same COLUMN that start out with comment_approved
    (see below)

    comment_approved

    and

    comment_approved_date_gmt

    I am going to do an experiment and remove the later and see if that works. Perhaps will loose date stamp with my comments, but I can live with that.

    I really hope this does not mess everything up!
    -Fred,

    Wow! WordPress is very amazing community!

    I have got the solution now, thanks to Whooami

    Below is the fix, just follow the instructions, very simple!

    When your website redirects to wp-admin/install.php [FIX] :

    1. Login to phpMyAdmin.
    2. Select the database and click on ‘Structure’ tab.
    3. Right under the list of table there is a “Check All” link. Click on it to select all tables.
    4. From a “With selected:” drop-down menu right next to it, choose “Check table”.

    To Repair:

    1. Login to phpMyAdmin
    2. Choose the affected database. If you only have one database, it should choose it by default so you don’t need to do anything.
    3. In the main panel, you should see a list of your database tables. Check the boxes by the tables that need repair.
    4. At the bottom of the window just below the list of tables, there is a drop down menu. Choose “Repair Table”

    regarding: To Repair:

    what should that do? didn’t change a thing for me…

    is it maybe a false warning by phpmyadmin? according to the wordpress DB schemata this is the way it should be: https://codex.www.ads-software.com/Database_Description#Table:_wp_comments

Viewing 5 replies - 16 through 20 (of 20 total)
  • The topic ‘Already Installed for months, WP keeps forwarding me to Install page’ is closed to new replies.