[Ur] urblog

[Manu]

gdp3 at cs.waikato.ac.nz wrote:
>> manu at chleb:~/Code/Ur/urblog$ ./urblog.exe
>> Fatal initialization error: Unable to create prepared statement:
>> SELECT User.uw_DisplayName, User.uw_Id, User.uw_Password,
>> User.uw_Username FROM uw_Urblog_user AS User WHERE ((User.uw_id =
>> $1::int8) AND (User.uw_password = $2::text))
>> ERROR:  syntax error at or near "."
>> LINE 1: SELECT User.uw_DisplayName, User.uw_Id, User.uw_Password, Us...
>>                    ^
>>
>>
>> Has this to do with the special version of the compiler Gian's been using
>> ?
>>     
>
> Unlikely.  I compiled Urblog with the last two public releases of the
> compiler with no trouble.  The special versions of the compiler were just
> versions with bug fixes that have since been applied in the most recent
> releases.  I suspect that more information about the specific
> platform/database environment might be helpful to diagnosing this.
>
> Gian
>   



Hi Gian

I am using Postgresql 8.3 on Ubuntu 9.04
I can import the SQL file into the database without problem, but I get 
the previous error when I run urblog.exe

It is a database problem as the following query causes the same error:

SELECT User.uw_displayName, User.uw_Id, User.uw_Password, 
User.uw_Username FROM uw_Urblog_user AS User

ERROR:  syntax error at or near "."
LINE 1: SELECT User.uw_displayName, User.uw_Id, User.uw_Password, Us...

whereas this query works fine:

SELECT uw_displayName, uw_Id, uw_Password, uw_Username FROM uw_Urblog_user

hum...

Manu