#1284 install.sql breaks in PostgreSQL 7.3
Php Version: 4.3.3
Web Server: Apache 1.3.26
Operating System: Linux 2.4.20-20.7
SQL Server: PostGreSQL 7.3
Browser: Firefox-0.8
PhpWebSite Version: 0.9.3.3
All the table creation stuff is broken. Even copy paste
the SQL statement to the psql console results in error,
so the SQL statement is not compatible with postgresql.
The SQL file that used for creating the database:
setup/install.sql does not work in postgresql-7.3. I
fix that in my copy, but then, it breaks again in
:
DB Error: syntax error
CREATE TABLE mod_lang_EN ( phrase_id int unsigned NOT
NULL, module varchar(30) NOT NULL default '', phrase
text NOT NULL, translation text NOT NULL, PRIMARY KEY
(phrase_id), KEY module (module) ); [nativecode=ERROR:
parser: parse error at or near "unsigned"]
Logged In: YES
user_id=722742
phpWebSite prior to v1.0 does not support Postgres or indeed any other database than
MySQL. We hope to fully support Postgres in v1.0. Until that time we are postponing
any bug, RFE or patch. We do not intend to add Postgres support into v0.10.x
Please revisit your issue in v1.0 and if the problem still exists then please add to this
report.