TOPIC:

I am updating Xerte V2 to Xerte V3. I am following the upgrade instructions in the PDF in the downloaded zip file.

All went well until the http://xerte_hostname/upgrade.php script would not run. I had to update the Xerte MySQL database user (xerte) to add the CREATE privilege.

The script then ran through (in debug mode) until part 7 giving the error mesage,
"Updating to version 7 Error creating authentication_method field"
The authentication_method column has not been created in the sitedetails table. Other tables were created, i.e. config and configdetails.
We use LDAP authentication at our site.

I did not know if this was a show-stopper so I restarted Apache and tried to access the installation.
I get the error message,
"Fatal error: Class 'Xerte_Validate_FileMimeType' not found in /var/www/plugins/file_uploading-mimetype.php on line 48"

Any pointers on how to proceed please?

Assuming you've backed up first try restoring the 2.1 database, change the MySQL permissions and then re-run upgrade.php.

Also assuming you are upgrading to 3.1 use the new auth_config.php from v3.1 which will default to guest access then use the management page to switch back to ldap.

HTH
Ron

Thanks Ron, I'll try that.
Would you recommend giving the Xerte MySQL user all privs for the upgrade?
For the V3.1 patch, do I simply put the 3.1 files in place over the 3.0 versions?

Hi Greg
yes usually a unique user just for the Xerte db with all privileges.
The downloads here can be a bit confusing. Use the full 3.1 download not the 3.1 update e.g. the only time to use the update version is when that shows as newer than the same version so 3.1 update only updates an install that is already 3.1 not an install that is only v3.
I've updated lots of installs so following the upgrade instructions should work fine but yes we assume the db user as all privs. Alternatively temporarily change the user or permissions and then change back after upgrade.
HTH
Ron

Hi Ron,
I gave the Xerte MySQL user all privileges in the Xerte database.
I copied the new files over the old apart from error_logs, import, library, and USER-FILES. I also over-wrote my LDAP auth_config.php.
I successfully ran the upgrade.php script.
I had to rename the plugins/file_uploading-mimetype.php file to prevent an error message that stopped the Xerte page appearing in the browser.
I used Xerte as the guest user and created a very simple LO.
I then replaced the auth_config.php with my original LDAP version and was prompted for a login, which worked.
However I can only see the guest projects not the old projects I had in the V2 installation.
The whole installation is owned by the web server user, www-data:www-data, including the USER-FILES directory. The permissions within USER-FILES are 777.
Any ideas?

Hi Greg
yes that all makes sense except as I said: "Also assuming you are upgrading to 3.1 use the new auth_config.php from v3.1 which will default to guest access then use the management page to switch back to ldap."

We've changed how the authentication is configured to make future upgrades even easier rather than having to protect/replace auth_config.php the setting is now saved in the database. This means an extra step now e.g. from any previous version to 3.1 but in future means the code can be updated without reverting back to guest and authentication method can be changed without access to the server files.

In other words put the auth_config.php from 3.1 in place and then switch to ldap via management and you should be good to go!
HTH
Ron