This is a simple step-by-step guide for people who want to update their antclick 1.0 pre1 installation to a recent version.

1. Get a fresh version from antclick from CVS or from the download page.
2. Install the fresh antclick version side by side to your old installation (i.e. do not overwrite the old version) and make sure both are not running.
3. Copy the following directories from your old installation to the new one:
   1. db/antville/*
   2. data/*
Do not work on the original files, and make sure you have backup copies!
4. Next, you need to update your antclick data to a new database format. You do this by invoking the following command from command line in your new antclick installation:

   java -cp lib/ext/mckoidb.jar com.mckoi.tools.DataFileConvertTool -path data

   Note that you may have to include the full path to your java runtime such as C:\programme\j2sdk1.4.1\bin\java . You should get the following output:

   Version 1.1 found. Converting database to version 1.2 schema... Guessing administrator is: admin Setting grant options for administrator. Converting: APP.AV_ACCESSLOG Converting: APP.AV_CHOICE Converting: APP.AV_FILE Converting: APP.AV_IMAGE Converting: APP.AV_MEMBERSHIP Converting: APP.AV_POLL Converting: APP.AV_SKIN Converting: APP.AV_SYSLOG Converting: APP.AV_TEXT Converting: APP.AV_USER Converting: APP.AV_VOTE Converting: APP.AV_SITE -- Convert Successful --

5. Finally, you need to add some columns to the database tables which have been added to antville since antclick 1.0 pre1. To do this, we launch the Mckoi Query tool:

   java -cp lib/ext/mckoidb.jar com.mckoi.tools.JDBCQueryTool -url jdbc:mckoi:local://./db.conf -u admin -p entwil

   A window similar to this should pop up. Enter the following line and hit "Run Query".

   alter table AV_USER add column USER_EMAIL_ISPUBLIC tinyint(1) null

   If you don't get any error message and the result grid says "0", you should be fine.

6. Exit the Mckoi Query tool and start antclick via hop.sh or hop.bat, depending on whether you are on Linux/Unix/OS X or Windows. Your new antclick should be functional. However, if you customized some of the skins it is very likely that you have some additional work to do here. The new skin diff feature should help you catch up with the changes in the default skins.

While I have performed the steps in this guide several times myself, it is possible, even probable, that I missed something. If you meet any problems with your updated antclick, please let me know by adding a comment to right here.

cvs info found via helma.org search engine: helma.org