Loading...
 
Architecture / Installation

Architecture / Installation


Tiki with PostgreSQL

posts: 4 Ukraine

I try to install Wiki with PostgerSQL
Tiki 1.9RC2, Apache/1.3.29, php 4.3.7, FreeBSD 5.1, PostgreSQL 7.4.2

There are many errors when I try create database from tiki-1.9-pgsql.sql script.

I see many errors in SQL script used for DB creating (in file tiki-1.9-mysql.sql):

---------------
PRIMARY KEY ("quizId"," nVersion")
superfluous space in " nVersion".
---------------

CREATE TABLE `tiki_download` ( <---- syntax error. wrong quotation marks
....
PRIMARY KEY ("`id`")
KEY `object` (`object`,`userId`,`type`), <---- syntax error
KEY `userId` (`userId`),
KEY `type` (`type`),

KEY `date` (`date`)
) "AUTO_INCREMENT"=32;

-------------
Where can I get correct script for postgreSQL, please?

Thank's

posts: 4 Ukraine

I did it!


cvs -d:pserver:anonymous@cvs.sourceforge.net:/cvsroot/tikiwiki co -d tiki19_psql tikiwiki

Same errors

It works fine with mySql, but does not with PostgreSQL.
It looks like this .sql script tiki-1.10-pgsql.sql was not tested with PostgreSQL

Any ideas?


posts: 4 Ukraine

I did it!

  1. cvs -d:pserver:anonymous@cvs.sourceforge.net:/cvsroot/tikiwiki co -d tiki19_psql tikiwiki


Same errors

It works fine with mySql, but does not with PostgreSQL.
It looks like this .sql script tiki-1.10-pgsql.sql was not tested with PostgreSQL

Any ideas?


posts: 2881 United Kingdom

If you want Tiki and Postgres, Checkout the fork called TikiPro at www.tikipro.org they are much more postgres than TikiWiki

Damian


Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting