CiviCRM Community Forums (archive)

After trying an upgrade to 3.3.2 I got a message that the database was already partially upgraded. Since it didn't work I restored the database and went back to version 3.2.5.  Unfortunately I also had to restore a directory so I think I might have lost some files.

However... some pages from civicrm now give the information message "could not retrieve file".

Quote from: andro01 on January 09, 2011, 11:54:32 am

Well if the files were removed, then that's why CiviCRM can not retrieve them. CiviCRM doesn't store files in the database--they sit on the server. You will need to either find a backup of those files or replace them manually by uploading again to each contact or event or whatever.

Does anybody know how this can be fixed? (a fix for the partial upgrade problem might also be nice :-))

Did the upgrade procedure run to completion with a success message? If not, then what happened when you upgraded?

Hmmm, this situation can be troublesome. Sometimes it happens when an upgrade creates a table which is needed for the new version but not the old, but then if you somehow stick with the old version, that table is incorrect. And depending on how you roll back your DB, the new table may not be removed.

My only advice here would be to consider hiring someone to examine your DB in detail and see if they can determine what the problem is.

The other approach is to export ALL your data and then import into a fresh 3.3.2 but that is fraught with other problems--like forgetting things.

The partial upgrade issue is purely a DB issue.

The file issue is almost certainly just a lack of files on the server.

The only other idea I can suggest (if you want) is to trace through the upgrade code yourself and try to see what generates the partial upgrade message, but you will need to understand a bit of PHP and MySQL for that.