mysql version

[iain.d...@gsk.com]

Could you tell me what version of mysql you used for cPath please?

I am using the 4.0.x version on my linux and windows boxes.  While installing cPath for a colleague, I used mysql 4.1.x, and it had a problem with the cpath.sql file.  I am trying to narrow down whether the mysql install was incorrect (as it was a little problematic) or whether the cPath.sql file needs a tweak.

This issue was with the definition of the primary key in the creation of the import table, it was referred to twice:
        PRIMARY KEY  (`IMPORT_ID`,`IMPORT_ID`)

I have removed the second reference to the IMPORT_ID column ie:
        PRIMARY KEY  (`IMPORT_ID`)"
and the table creation proceeded correctly.

Unfortunately due to further problems, I finally reverted back to mysql version 4.0.x. Which worked.

I thought you may be interested.

Regards

Iain K

[Gary Bader]

Hi Iain,
We're using the 4.0 series here. We have not tested using 4.1. We
should make this explicit in our admin guide, now that MySQL 4.1 is the
recommended download from mysql.com. The cpath.sql file was from an
automatic phpMySQL dump from a MySQL 4.0, which looks like it might be a
little buggy. If you develop a cpath.sql file that works for 4.0 and
4.1, please let us know.

Thanks,
Gary