Auto-upgrade doesn't fully upgrade database. (and breaks deployment)

[Nhorning]

When I auto upgraded my deployment (nepalmonitor.org) all the messages said that the upgrade had taken place successfully, but when I refreshed the site I was met with a database error.

I tried the relevant scripts from the SQL directory manually in cpanel sql admin, and encountered errors when running "upgrade91-92"

Investigation showed the problem was missing " ` " around all instances of the word "settings."

For instance:

SELECT 'site_name' AS key, site_name AS value FROM settings WHERE id = 1

should read

SELECT 'site_name' AS key, site_name AS value FROM settings WHERE id = 1

This issue is already fixed in github files: https://github.com/ushahidi/Ushahidi_Web/blob/develop/sql/upgrade91-92.sql

However, it's NOT fixed in the live auto-upgrade as of 20th August. This will cause everyone using the auto-upgrade to break their deployment and fish around in SQL like I did unless the change is reflected in the live version.

[rjmackay]

This should be fixed now - however we should possibly reroll the relevant upgrade scripts
anything to 2.4 or 2.4.1

[rjmackay]

Got this wrong - its the upgrade to 2.5 that needed a fix. I've updated the downloads here https://wiki.ushahidi.com/display/WIKI/Ushahidi+Platform+Downloads
but need to change the auto upgrader links

[rjmackay]

@eyedol can you update the auto upgrade to use the new rackspace cloud files URLs

[eyedol]

Fixed!