Once im able to finish him i will post here...indeed, i will stop hmail and make a full backup including sql dump then i will rollback and if anything goes wrong at least im able to get 5.4 ready to rock again...Bill48105 wrote:Hmm so yours is likely newer. Either microsoft broke something in newer version or that is not it.FiShBuRn wrote:The version of my file is 5.0.2195.7280
Btw my rough method of rebuilding file paths was:
Need to grab messageacccountid from hm_messages & lookup their account & domain from hm_accounts using that then update messagefilename in hm_messages to prepend DatafolderPath\theirdomain\theiraccount\originalfilename.eml & repeat for every message in hm_messages likely only doing ones that have messagetype = 2 which means delivered
In either case I'd have backups of your database & realize it is very risky.. I'd certainly test on a test server 1st. once paths are fixed (view some ot make sure they look right) then the other changes between 5.3.x & 5.4 shouldn't matter or are less critical. I thought I posted them up but you can view the upgrade SQL file in the DBScripts folder inside the hmail folder. You definitely need to manually change the db version value though. Then you should be able to install 5.3.4 over 5.4, select your existing database & cross your fingers. (Again I'd do trial runs on test server, even if using backups from your real server..)
When u say "manually change db version" is to 5320 value right?