• Resolved creativecomponent

    (@creativecomponent)


    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: https://codex.www.ads-software.com/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.

Viewing 6 replies - 1 through 6 (of 6 total)
  • 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?

    Thread Starter creativecomponent

    (@creativecomponent)

    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 ''

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

    Thread Starter creativecomponent

    (@creativecomponent)

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

    Thread Starter creativecomponent

    (@creativecomponent)

    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.

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

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘After 2.7 update my site is borked.’ is closed to new replies.