Breno Jacinto Duarte da Costa wrote:
Hello,
I'm trying to install Roundcube for testing here at the company
I'm working for, but the system is old - Conectiva Linux 9. Since it's
under production, and I'm not willing to change many things by now,
here'`s what I've got:
- Postgresql 7.3.2
- PHP 4.3.1
While trying to create the database on Postgres, I got some errors:
psql:SQL/postgres.initial.sql:10: ERROR: parser: parse error at or
near "BY" at character 40
psql:SQL/postgres.initial.sql:26: NOTICE: CREATE TABLE / PRIMARY KEY
will create implicit index 'users_pkey' for table 'users'
CREATE TABLE
psql:SQL/postgres.initial.sql:41: NOTICE: CREATE TABLE / PRIMARY KEY
will create implicit index 'session_pkey' for table 'session'
Although the tables were created. But when I try to access the
system (index.php), nothing returns, not even a debugging message.
In the docs it's not explicit it requires a greater version of
Postgres (although it was not tested)... but I suppose this is the
problem?
Thanks,
I don't know what the sql file has in it. See if this helps.
Remove the table names from postgres.initial.sql, like the example below:
-------------------
query=# UPDATE uuser SET uuser.id='6',uuser.login='NEW',uuser.name='Mr.
foo' WHERE id='6';
ERROR: parser: parse error at or near "." at character 23
remove uuser.,
query=# UPDATE uuser SET id='6',login='NEW',name='Mr. foo' WHERE
id='6';
UPDATE 0
-------------
-Nitin