Build Updates - Proper way to perform

[trevius]

You just need to use the new Binaries from the build download and then make sure to source in any SQL update from the /utils/sql/svn/ folder in the source code that were added between your last revision and the new revision you are changing to.

So, if you are running Rev1052 and wanting to upgrade to Rev1143, you would check the SQL file list here:

http://code.google.com/p/projecteqem.../utils/sql/svn

Then, look at the numbers at the beginning of the file names there. Those numbers are the revision that SQL was added for. So, you are looking for any between 1052 and 1143. They are kinda hard to look for all of them, due to how it is sorted there, but just look it over really well to make sure you get them all. I checked quickly and see that you would need the following:

1057_titles.sql
1077_botgroups.sql
1136_spell_globals.sql
1144_optional_rule_return_nodrop.sql

You can then just click on each of those files to see the SQL in them. Then just copy and paste that SQL at your mysql prompt and you are done.

Also, it is a good idea to always backup your database before making ANY changes like that.

[Rykeau]

Thank you for the assistance - I'll do my best not to blow up too much

[harddisk]

Hi,

Was looking to update my database from 1052 - 1143 too.

I have read and apply what you explain in this post and unfortunately now I have an error message box " missing perl510.dll " when launching the "start.bat"

Anyone have successfully updated to 1143 DB ?

Thanks

[Derision]

Originally Posted by harddisk

I have read and apply what you explain in this post and unfortunately now I have an error message box " missing perl510.dll " when launching the "start.bat"

The 1143 and 1180 executables I uploaded to the SVN were compiled on a system with Perl5.10 installed, so you will need to uninstall Perl 5.8 and install 5.10 for them to work.