I have an old site in Drupal 4.6.3 that is no longer being changed but should be kept published as an archive about past events. I need to move it to a new hosting service that no longer supports PHP4.x. Under PHP5.x, I get many error messages, most (maybe all) of which complain about "Unknown column 'n.nid' in 'on clause'" and/or "Column 'nid' in from clause is ambiguous".
I know that for security reasons I absolutely must upgrade this site, from 4.6.3 to the last version 4.x.x, from that to the last version 5.x.x, from that to the last version 6.x.x., and finally from that to the last version 7.x.x. There are enough add-on modules (those in the old CivicSpace plus a handful of others) involved that this would be an incredible nightmare.
Leaving security aside, would it be less work to try to fix 4.6.3 to function with PHP5.x? I do know some PHP and some SQL, but not a lot.
This site has been reliable, and never been hacked, even though Drupal has not been upgraded since September, 2005.
Read »








