Forums on Postgresql

[cuoz]

Anybody having problems running the forums on Posgresql? I'm using a CVS snapshot from last night. When I try to post a topic or message, I get an SQL exception:

11:00:49,962 ERROR [TopicEJB] Could not create entity
java.sql.SQLException: ERROR: pg_atoi: error in "false": can't parse "false"

IIRC, Postgresql requires 'FALSE' (all uppercase) and does not recognize 'false'.

Anybody else see this? If it is in fact a bug, I can take a look and try to fix it.

gary.

[julien1]

I don't have postgres yet so I can't tell you, please look into the case as we are going to release nukes 1.0 + forums. I would like this to be fixed.

thanks

[sgwood]

There are some issues in the Postgres database definition. I'll post a fix for this in the next few hours.


Sherman

[cuoz]

I poked around a bit...

The problem is that the ddl for Postgres defines the phpbb_forums table with the following field:
prune_enable | smallint | not null default '0'

but nukes tries to use the field as boolean.

[cuoz]

the same problem exists in the phpbb_posts table with all the enable_* fields.

[sgwood]

I know, I know.....


Working on it now....



Sherman

[sgwood]

Checked in DDL and setup.xml changes.

Also fixed a problem in the BB module where an invalid JDBC query was being executed when there were tracked topics.


Sherman