it has problems when trying creating the tables (e.g. papers) in the database.
It is because postgresql (>=7.4.x?) does not know the date type DATETIME.
[It seems that postgresql (>=7.3) does not support type DATETIME and recommends TIMESTAMP instead -- http://postgresql.org/, Google, etc.]
Is there a patch for it?
[Here it is
-- see at the bottom. At least it gets through the install. That's all for now.]
Zs
# Patch of install.php in ocs-1.1.5. Not fully tested, use at your own risk!
- Code: Select all
--- install.php.orig 2004-01-11 03:40:17.000000000 +0100
+++ install.php 2006-01-18 14:33:52.000000000 +0100
@@ -420,7 +420,7 @@
view_reviews VARCHAR(5) NOT NULL DEFAULT '',
primary_track_id INT NOT NULL DEFAULT 0,
secondary_track_id INT NOT NULL DEFAULT 0,
- created DATETIME,
+ created TIMESTAMP,
timestamp TIMESTAMP NOT NULL DEFAULT NOW()
)") or $error = "createtables";
}
@@ -599,8 +599,8 @@
has_paid VARCHAR(5) NOT NULL DEFAULT '',
reg_email VARCHAR(5) NOT NULL DEFAULT '',
special_requests TEXT NOT NULL DEFAULT '',
- date_registered DATETIME,
- date_paid DATETIME
+ date_registered TIMESTAMP,
+ date_paid TIMESTAMP
)") or $error = "createtables";
}
else {