I am laboriously working to upgrade a IP board with near 200 users and several thousand posts, from: IP Version 18.104.22.168 and phpbb2 version 2.0.22 to: IP 22.214.171.124 RC2. As to the new phpbb version that the current IP is running on, I've no idea as it is not displayed anywhere that I can see.
Regardless, I am seeing many schema differences in the database. I have been able to successfully import the ip_users, and ip_categories tables, and recreated the ip_forums table through the CMS webapp; however, in order to import the ip_posts I am going to have to reconcile many differences in the table and an unknown number of dependencies in other tables.
Is there any any guidance on performing this upgrade? Or, conversely, is there a chain of schema upgrades that I can run through to incrementally upgrade the database through several stages and arrive at the current version of IP?
This upgrade is precipitated by the need to move this site from a shared hosting environment to a dedicated server that I have provisioned. I never was given root access, or any shell access for that matter, to the original server. I had only ftp access and phpmyadmin access. I was able to get the sysadmins for the box to create a tar.bz2 file of the DocumentRoot, as well as to dump the mysql db manualy, as I was not able to either transfer the content via ftp properly, nor get an error free download of the database as I experienced query timeouts through phpmyadmin. Due to this inability to direclty access the original server, I have been hampered in trouble shooting why I have been unable to simply move the site, in its exiting version, its current server to this new one. The errors with the original server's code and schema, on my new server, are all related to the variable $phpbb_root_path being null on a myriad include and include_once calls as per: h**p://***.ethericwarriors.org/ip (if you could check this out please). I read the PHPBB module developers guide, where one is instructed to define this variable on all user accessible files however, I find it missing in many, many, files on this old version. How it runs correctly, at the original site (which is still up) at h**p://***.ethericwarriors.com/ip is a mystery to me.
One point, the new server is running on OpenBSD 4.5 and the Apache 1.3 is chrooted so as to protect the server in the event of a compromise; however, I don't believe this is any issue as the new version of IP runs fine at: h**p://dev.ethericwarriors.org/ip
What I need to do is either to immediately move forward to transfering the data from the original site and move dev.ethericwarriors.org to production or, conversely, to succeed in bringing up the old code, on the new server, without errors and then, over time, port over to the new code.
Any help in this matter would be greatly appreciated
Thanks in advance.