Databases changes

Posted: Tue Jan 24, 2012 4:47 pm

I upgraded to 2.5 with source code only (after copying necessary information from old config to new config). The only database problem I encountered was missing the new 'theme' database file. However, I am wondering if there are data changes to any database files I need to address(i.e. ip country codes )

Have not encountered any of the other problems listed in this forum for 2.5.

registered · Posted: Tue Jan 24, 2012 5:00 pm

You should run the upgrade script. There are many database changes from 2.4.01 to 2.5.

registered · Posted: Wed Jan 25, 2012 6:55 am

Always, always, always follow the upgrade instructions... missing a piece in the process will only cause you more severe headaches down the road as each release builds upon the previous one.

Posted: Wed Jan 25, 2012 8:13 am

There is a directory named table_compare in the 2.5 distribution. It will compare your current database structure to the 2.5 one and give you a list of any differences. Documentation is right in the programs.

Posted: Wed Jan 25, 2012 4:26 pm

I did run a separate fresh install. After nuken said there were other database changes I ran my own compare program and did a drop/load of certain databases (i.e i2country) and entered any new fields or keys to others. I noticed that some were removed completely, which some may or may not have used in their websites.

Posted: Wed Jan 25, 2012 5:13 pm

May I ask why you did not just run the upgrade script?

Have you considered the data that was inserted not just the structural changes?

Posted: Wed Jan 25, 2012 5:20 pm

There is a significant amount of data that was inserted into new tables because of new modules etc. There was/is code to convert certain pieces of data to work properly with new code.

Posted: Wed Jan 25, 2012 6:16 pm

My comparison compared data and structure. It may have not been logical, but the conversion worked without encountering any of the errors reported by others. I have not changed the data from 'download' to 'dlmodule' only because I don't use the downloads on this site.

It is a tedious process and not as fast as running the conversion script, but it does make you look at each database and data for accuracy and how it affects your website.

This website (http://www.raintreevillagecondos.com) is for our condo association reporting all crimewatch alerts. I have others that are not critical and will use the scripts provided.