PacsOne Server

Hi All,
Thanks to Jonathan, I got PacsOne to connect to MySQL 4.1.
PacsOne service is running, but the log keeps filing up with the following error message:

2004 ERROR - RUNQUERY: SQL Bad Query: Table 'archive.dbjob' doesn't exist
2004 ERROR - Exeption encountered in Database Job Thread

Before installing PacsOne, I had created an 'archive' database as suggested in the PacsOne Install Manual:
mysql>create database DBNAME;
(where DBNAME is 'archive')

Any thoughts on that one?

It seems like your database tables were not setup properly during PacsOne installation. This could be the incompatiblity issues with MySQL 4.1 as there have been at least two users reported similar installation problems with MySQL 4.1, so now I've update the PacsOne download page asking users to download the latest MySQL 4.0.x release instead of 4.1.

To fix your tables, you can try the following:

1. Open a command shell and change directory to where PacsOne Server is installed.

2. Type the following MySQL command:

>mysql -vvf -u {USERNAME} -p {DBNAME} < upgrade_schema

where:

{DBNAME} is the database you created for PacsOne, i.e., 'archive'.
{USERNAME} is the MySQL username you created for PacsOne.

3. After the above command, you can login to MySQL and verify all the tables are created for your database 'archive':

mysql>show tables;

Hmm, I'm not having too much luck with the table fix thing, so I'll probably just uninstall MySQL 4.1 and get the 4.0 version...
I'll keep you posted.
Thanks.