Date index for Jun 2002

Hello Herman,

Reintke, Herman wrote:

> 1/ I used the achievo_0_9 scripts to create the database because there were
> no achievo _0_8 sql files

That's right. PostgreSQL support has not received sufficient testing to 
be in a stable release.

Therefor I appreciate your patches a lot! If you find more problems, 
please let me know.

> Do you know where the select is generated and what to change to make it work
> ?

This select is in class.hours.inc, in the function weekComplete, around 
line 400. I don't know enough postgreSQL to immediately see what could 
be the problem, but I can help you with a simple workaround. This 
function checks if a user has registered enough time to be able to lock 
the week. If you modify the function so it skips the query and always 
returns true, you won't get the error. Drawback: Users can always lock 
the week.

> Are there any other known issues using PostgeSQL and Achievo_0_8 ?

There might be, as I've said above, it's not been tested much on 
postgresql (at least by us). The recommended database for Achievo is 
currently MySQL.

Greetings,
Ivo