Re: Installing RoundCube

Hey,

Thanks for the reply. Actually the error is in this part of the SQL file:

CREATE SEQUENCE user_ids INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1;

psql:postgres.initial.sql:10: ERROR: parser: parse error at or near "BY" at character 40

 Which is weird. All other parts of the file that have a BY clause

will get the same error.

 I haven't tested this script with a newer version o Postgres -

maybe thats the issue?

 If anybody else can confirm this, it'd be appreciated.

cheers,

-- Breno

On 4/7/06, N P List nplist@xnet.com wrote:

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

-- .''. -- Breno Jacinto : :´ : -- breno /at/ freeunix dot com dot br : ' ' : -- 88AE 3F43 7110 57F6 A206 .'-- D116 02CA 02F4 803D 4294-- -- Debian GNU/Linux - The Universal OS