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' CREATE TABLE psql:SQL/postgres.initial.sql:55: ERROR: parser: parse error at or near "WITH" at character 40 psql:SQL/postgres.initial.sql:73: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'identities_pkey' for table 'identities' psql:SQL/postgres.initial.sql:73: NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) CREATE TABLE psql:SQL/postgres.initial.sql:87: ERROR: parser: parse error at or near "WITH" at character 39 psql:SQL/postgres.initial.sql:104: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'contacts_pkey' for table 'contacts' psql:SQL/postgres.initial.sql:104: NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) CREATE TABLE psql:SQL/postgres.initial.sql:117: ERROR: parser: parse error at or near "BY" at character 41 psql:SQL/postgres.initial.sql:131: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'cache_pkey' for table 'cache' psql:SQL/postgres.initial.sql:131: NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) CREATE TABLE psql:SQL/postgres.initial.sql:144: ERROR: parser: parse error at or near "BY" at character 43 psql:SQL/postgres.initial.sql:167: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'messages_pkey' for table 'messages' psql:SQL/postgres.initial.sql:167: NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) CREATE TABLE
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,
--
.''. -- 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
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
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