b2 Upgrade error

  • Gotr the following error on step 2 (?) any clues ?
    thanks
    There are some changes we need to make to the post table, we’ll do those next.
    SQL/DB Error —
    [Table ‘pechambers.wp_posts’ doesn’t exist]
    Warning: Invalid argument supplied for foreach() in /home/u3/pechambers/journal/html/wp-admin/wp-install-helper.php on line 37
    SQL/DB Error —
    [Table ‘pechambers.wp_posts’ doesn’t exist]
    SQL/DB Error —
    [Table ‘pechambers.wp_posts’ doesn’t exist]
    Warning: Invalid argument supplied for foreach() in /home/u3/pechambers/journal/html/wp-admin/wp-install-helper.php on line 46
    SQL/DB Error —
    [Table ‘pechambers.wp_posts’ doesn’t exist]
    Warning: Invalid argument supplied for foreach() in /home/u3/pechambers/journal/html/wp-admin/wp-install-helper.php on line 99
    SQL/DB Error —
    [Table ‘pechambers.wp_posts’ doesn’t exist]
    Warning: Invalid argument supplied for foreach() in /home/u3/pechambers/journal/html/wp-admin/wp-install-helper.php on line 37
    SQL/DB Error —
    [Table ‘pechambers.wp_posts’ doesn’t exist]
    SQL/DB Error —
    [Table ‘pechambers.wp_posts’ doesn’t exist]
    Warning: Invalid argument supplied for foreach() in /home/u3/pechambers/journal/html/wp-admin/wp-install-helper.php on line 46
    SQL/DB Error —
    [Table ‘pechambers.wp_posts’ doesn’t exist]
    Warning: Invalid argument supplied for foreach() in /home/u3/pechambers/journal/html/wp-admin/wp-install-helper.php on line 99
    There was a problem with wp_posts
    There was a problem with wp_posts

Viewing 10 replies - 1 through 10 (of 10 total)

  • Yes, unless you renamed your tables, you probably have a table called b2posts instead of wp_posts. You should modify your wp-config.php accordingly.

    Thread Starter doron

    (@doron)

    yup
    Done
    works
    great
    10x
    ??

    You can also run the following:
    ALTER TABLE b2categories RENAME wp_categories;
    ALTER TABLE b2comments RENAME wp_comments;
    ALTER TABLE b2posts RENAME wp_posts;
    ALTER TABLE b2settings RENAME wp_settings;
    ALTER TABLE b2users RENAME wp_users;
    I ran it in phpMyAdmin, and it worked like a champ.

    Of course, if that doesn’t work for you, you need to make sure what your tables are named in the first place. What you change is after the ALTER TABLE statement; clearly, the latter is what WP expects. ??

    In what file should I make those changes because I have those faults as well ??

    wp-config.php

    Yeah, if you’re going to edit the config, you do what Matt said.
    If you’re going to fix the tables, you go into phpMyAdmin or run it via command line.

    I’ve got a wierd and similar error. I ran b2-2-wp.php and got [table b2.options does not exist]. I did create and edit a wp-config.php, and I left my table_prefix blank. If I put ‘b2’ in there, I see [table b2.b2options does not exist]. I’ve grepped from hell to breakfast and can’t find where that ‘b2.’ is getting prepended. WordPress-072-gold. Ideas? Please?

    Oh, nevermind! (note to self: RTFM!)

    For the others that may have the same problem like Rantor: most times errors related to not being able to access a table are reported in the form “blabla database.table“. Obviously in the above description by Rantor the b2 in question was the name of his database, and options (with blank $table_prefix) and b2options (with $tableprefix=”b2″) was the name of the table that couldn’t be accessed.
    Bye, Mike

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘b2 Upgrade error’ is closed to new replies.