MySQL version and configuration

[Rene]

Hi There,

I'm trying to set-up tonguetied with mySQL but I get some warnings
during tonguetied server startup.
What I did:
- I set up a MySQL 4.1 server on a machine in my local network.
- I created a scheme called "tonguetied" and assigned all provileges
to the root user.
- I started tonguetied with the default installation (HSQL) and
everything seems to run fine.
- I shutdown the tonguetied server and changed the jdbc.properties
file for the MySQL configuration.
- I restarted tonguetied and I see in the log that it connects with
the MySQL server
1. Tonguetied creates the required tables without warnings, so
privileges seem to be ok.
2. When tonguetied tries to add rows to the tables it seems to go
wrong and I get several warnings like:

WARN [main] (SchemaDaoImpl.java:54) - The following statement failed
to execute: INSERT INTO LANGUAGE(code, name) VALUES ('DEFAULT',
'Default(English)')

Is there something wrong with the MySQL configuration/version or can
it be a problem in tonguetied?

Rene

[Ben Sion]

Hi Rene,

Unfortunately I have only tested TongueTied with MySQL 5.1 very bad of me. Is there any chance of you running with MySQL 5.1?

If not, can you run the script initial-data.sql directly against your DB and see if the script works, or if it reveals any further explanation as to why that script fails?

I will set up a version of MySQL 4.1 and test against that, but I will not get a chance to do it until this Friday (my day job and life tend to get in the way of my coding activites :)). My sincere apologies for the problems you are facing and any delay that it will take me to get a resolution.

Cheers,
Ben

[Rene]

Ok, it working now.

The problem is just the "initial-data.sql" file. The tables specified
in the SQL statements are written in CAPITALS but in the MySQL
database the table names just start with a capital.
"INSERT INTO LANGUAGE ......" changed into "INSERT INTO Language ...."

I updated the MySQL server to 5.0 but I don't think it was necessary.

Thanks!

Rene

> > Rene- Tekst uit oorspronkelijk bericht niet weergeven -
>
> - Tekst uit oorspronkelijk bericht weergeven -

[Ben Sion]

Ok cool. Glad to hear you got it working. Sorry about that. This has been fixed for version 1.1.0 which I am planning to release this long weekend. But please note, that the there is a significant schema change in this release. It is a one off though, and I will write a script to migrate the old schema's.

Also if you have the time, I would like to know your thoughts on the application.

thanks,
Ben