Wednesday, December 20, 2006

Upgrading forum with phpBB2 and restoring from database backup

Well I had to do some phpBB (phpBB2) issues for a client who runs hispanito.com. He had a forum which ran on probably phpBB2 version 2.0.7 and with MySQL 4.x. Now I had to bring those data to a different server with MySQL 5.x I tried a fresh install with latest phpBB2 version 2.0.21, but it failed as soon as I tried to bring in the old data. I tried an Upgrade too, but that failed too. Then I tried many other ways, none of which worked so at last I simply understood that table structures must have changed other than an very visible change in the number of tables ("session_keys" was a new table). Now I had to edit the tables that had changed almost by hand, so if you must have to do the same here are the tables which I changed: "users": two columns added: "user_login_tries" and "user_last_login_try" "sessions": one column added: "session_admin" "search_results": one column added: "search_time" You have to do the above changes after you make a normal install of new phpBB2 and then restore old database backup, which will change the table structures. Hope that helps.