Title: b2 Upgrade error Last modified: August 18, 2016 --- # b2 Upgrade error * [doron](https://wordpress.org/support/users/doron/) * (@doron) * [22 years, 7 months ago](https://wordpress.org/support/topic/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) * Moderator [Matt Mullenweg](https://wordpress.org/support/users/matt/) * (@matt) * [22 years, 7 months ago](https://wordpress.org/support/topic/b2-upgrade-error/#post-24735) * 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](https://wordpress.org/support/users/doron/) * (@doron) * [22 years, 7 months ago](https://wordpress.org/support/topic/b2-upgrade-error/#post-24737) * yup Done works great 10x 🙂 * [gfmorris](https://wordpress.org/support/users/gfmorris/) * (@gfmorris) * [22 years, 7 months ago](https://wordpress.org/support/topic/b2-upgrade-error/#post-24826) * 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. * [gfmorris](https://wordpress.org/support/users/gfmorris/) * (@gfmorris) * [22 years, 7 months ago](https://wordpress.org/support/topic/b2-upgrade-error/#post-24827) * 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. 🙂 * [ludvig87](https://wordpress.org/support/users/ludvig87/) * (@ludvig87) * [22 years, 7 months ago](https://wordpress.org/support/topic/b2-upgrade-error/#post-24836) * In what file should I make those changes because I have those faults as well 🙁 * Moderator [Matt Mullenweg](https://wordpress.org/support/users/matt/) * (@matt) * [22 years, 7 months ago](https://wordpress.org/support/topic/b2-upgrade-error/#post-24837) * `wp-config.php` * [gfmorris](https://wordpress.org/support/users/gfmorris/) * (@gfmorris) * [22 years, 7 months ago](https://wordpress.org/support/topic/b2-upgrade-error/#post-24838) * 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. * [rantor](https://wordpress.org/support/users/rantor/) * (@rantor) * [22 years, 7 months ago](https://wordpress.org/support/topic/b2-upgrade-error/#post-24866) * 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? * [rantor](https://wordpress.org/support/users/rantor/) * (@rantor) * [22 years, 7 months ago](https://wordpress.org/support/topic/b2-upgrade-error/#post-24867) * Oh, nevermind! (note to self: RTFM!) * [otaku42](https://wordpress.org/support/users/otaku42/) * (@otaku42) * [22 years, 7 months ago](https://wordpress.org/support/topic/b2-upgrade-error/#post-24874) * 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. * In: [Installing WordPress](https://wordpress.org/support/forum/installation/) * 10 replies * 6 participants * Last reply from: [otaku42](https://wordpress.org/support/users/otaku42/) * Last activity: [22 years, 7 months ago](https://wordpress.org/support/topic/b2-upgrade-error/#post-24874) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics