Loading...
 
Skip to main content

Architecture / Installation

Forum List Topic List

 
Thread actions
Print this page
  • Print all pages

    • TikiWiki and Postgres tables

    Posted by tasmaniac

    Hi List,

    With tikiwiki-1.9.11 the tiki_categorized_objects table doesnt get created in postgres8.3 due to a syntax error.
    The culprit is KEY(type,objld). Can anyone tell me what this should actually be? (should it be an index or foreign key or .... )
    I'm working me way thru the sql to check if there are other tables not created.

    Also if anyone is using workflow and postgre see my problem on the other forum

    Tasmaniac

    Some further notes to this:

    The only 'bad' table I found was the above one which wasnt bad considering the size of the file

    For some reason using postgres database the search function doesnt work on anything but the wiki part.
    Error returned is Operator does not exist character varying = integer (or bigint). Which from my basic understanding means that the query is trying to compare two different field types. (which on further investigation is the case. eg for articles it trys to compare tiki_searchindex.page (charvar) to tiki_articles.articleId (integer).

    Is this a problem in postgres or is it a bug in 1.9.11?

    System is Debian R4 V3, Apache2.2.3, PHP5.2.0-8, Postgres 8.3.1, tikiwiki 1.9.11

    Reads: 742