WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] After 2.7 update my site is borked. (7 posts)

  1. creativecomponent
    Member
    Posted 5 years ago #

    Ugh. I've been working for a few weeks on a local install of WordPress 2.6.5.

    Nearly finished with the client site, I thought I should upgrade to 2.7 in-case there were any issues with plugins, etc. So I did this last PM. I didn't notice any issues then.

    Tonight, I noticed that my jQuery animations were not working. I thought it might be the Lightbox plugin conflicting, so I went to disable Lightbox, and errors started cropping-up. Before I knew it, every page on the site directed me to INSTALL WORDPRESS.

    My database is still intact, so I backed it up for safe keeping. Now, I'm trying to figure-out how to install WP from an existing database, and I'm not having much luck.

    I tried clearing-out all of the files, except for the ones mentioned here: http://codex.wordpress.org/Upgrading_WordPress_Extended -- replacing the old files with new ones, but I still get the same result: I'm directed to 'Install WordPress' at install.php.

    Is there a way to clean-install WP the 'right way' and import my exported '.sql' file?

    Any help would be appreciated.

  2. docalex
    Member
    Posted 5 years ago #

    I'm probably misunderstanding you, but after you uploaded the new 2.7 files, did you load wp-admin.php into a browser and run it?

  3. creativecomponent
    Member
    Posted 5 years ago #

    To confirm, I just tried everything all over again. Yes -- I ran wp-admin/upgrade.php.

    I received the "no update needed" page, but the same problem persists -- I'm taken back to install.php. I just tried to enter the "new site information": Blog Title & admin email. On step 2, I get a page with a million errors. Looks like WP is trying to populate the database and it's crashing.

    A few:

    WordPress database error: [Table '.\wordpress\wp_options' is marked as crashed and should be repaired]
    DESCRIBE wp_options;
    
    WordPress database error: [Table '.\wordpress\wp_options' is marked as crashed and should be repaired]
    SHOW INDEX FROM wp_options;
    
    WordPress database error: [Table '.\wordpress\wp_options' is marked as crashed and should be repaired]
    ALTER TABLE wp_options ADD COLUMN option_id bigint(20) NOT NULL auto_increment
    
    WordPress database error: [Table '.\wordpress\wp_options' is marked as crashed and should be repaired]
    ALTER TABLE wp_options ADD COLUMN blog_id int(11) NOT NULL default '0'
    
    WordPress database error: [Table '.\wordpress\wp_options' is marked as crashed and should be repaired]
    ALTER TABLE wp_options ADD COLUMN option_name varchar(64) NOT NULL default ''
  4. JackSim
    Member
    Posted 5 years ago #

    You must repair your MySQL tables. Log on your SQL server with PHPMyAdmin and repair all tables. That should do it.

  5. creativecomponent
    Member
    Posted 5 years ago #

    @JackSim Ah. Let me try this tonight. Thanks much!

  6. creativecomponent
    Member
    Posted 5 years ago #

    THAT WAS IT! Thanks so much for your help.
    I was really close to copying html out of the database. 8-|

    WordPress rocks again, and I do love the 2.7.

  7. boglioh
    Member
    Posted 4 years ago #

    I just encountered the same thing, and the posted solution worked a treat. This forum just covered itself in glory!

Topic Closed

This topic has been closed to new replies.

About this Topic