Migration/Upgrade Tips

[huggie]

Good afternoon, my predecessor has left me in a tough position and I wonder if you could give me a few pointers. I need to migrate PMF from a machine running PHP 5.2 to a new machine running the latest versions of PHP and Apache. I've hit a few stumbling blocks and wonder if you have any advice. Here is a brief history of what I've tried.

The original installation of PMF was Version 2.0.0 and I was left with the SQL export (taken from the backup screen in PMF) to work with. So I installed PMF 2.6.15 only to find out that I can't import it as it's from 2.0

OK, that's not a problem, I'll just give them the old version, so I download and attempt to install version 2.0.0 but get an error about "redeclaring a reference", something which I've found out is related to PHP 5.3 (which I'm running on the new machine) and is fixed in 2.0.13

OK, let's try the latest branch of the 2.0 stream, so I install 2.0.17, perfect, no issues at all installing, but when I attempt the SQL import I get a message saying "Unknown column 'rights' in 'field list'" when trying to insert into the faquser table. OK, so I check the sql create statements for all of the versions I've downloaded, and none of them contain a 'rights' column in the faquser table. Where did this column come from? Are they using an even older version that's been upgraded to 2.0.0?

What is the best way for me to get from a (possibly upgraded from an earlier version) install of 2.0.0 to the most recent 2.6.15 maintaining all the users and data?

Kind regards and sorry it's long.
Rich

P.S. I'm comfortable with PHP if any code needs editing to get this to work.

[Thorsten]

Hi,

the rights column could be from an old 1.x installation. You can delete this column and it should work like you tried, an update from 2.0.17 to the latest 2.6 release works very smooth.

bye
Thorsten