Installation on PostgreSQL: syntax error creating 'tiki_categorized_objects'
- Status
- Closed
- Subject
- Installation on PostgreSQL: syntax error creating 'tiki_categorized_objects'
- Version
- 1.9.x
- Category
- Error
- Feature
- Installer (profiles, upgrades and server-related issues)
Database independence (Non-Mysql, ADOdb Postgres, Oracle, etc) - Resolution status
- Out of Date
- Submitted by
- agnewtj
- Lastmod by
- Kissaki
- Rating
- Description
Installation error during table creates:
Command: CREATE TABLE "tiki_categorized_objects" (
"catObjectId" bigserial,
"type" varchar(50) default NULL,
"objId" varchar(255) default NULL,
"description" text,
"created" bigint default NULL,
"name" varchar(200) default NULL,
"href" varchar(200) default NULL,
"hits" integer default NULL,
PRIMARY KEY ("catObjectId"),
KEY(type, objId)
)
Message: ERROR: syntax error at or near "("
LINE 11: KEY(type, objId)- Solution
Please upgrade to a more recent version of tiki.
For recent/next version: Fix on the way.
Please see tracker item
http://dev.tikiwiki.org/tiki-view_tracker_item.php?trackerId=5&itemId=2514
- Importance
- 6
- Priority
- 30
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 1355
- Created
- Wednesday 19 September, 2007 22:06:44 UTC
by Unknown - LastModif
- Saturday 08 August, 2009 19:34:31 UTC