#1430 adodb databasse session w/postgres

v1.8.1
closed-out-of-date
5
2004-08-26
2004-04-14
Anonymous
No

encountered this error, after setting "store session in
database"

Session Replace: ERROR: column "sesskey" of relation
"sessions" does not exist

changed the database fieldnames to lowercase and things
were normal again.

it seems the postgres.sql database creation script
might need a slight change.

Discussion

  • Logged In: NO

    update:
    specifically, i guess i am proposing this diff:

    in file: tiki-1.8-pgsql.sql
    258,262c258,262
    < "SESSKEY" char(32) NOT NULL,
    < "EXPIRY" bigint NOT NULL,
    < "EXPIREREF" varchar(64),
    < "DATA" text NOT NULL,
    < PRIMARY KEY ("SESSKEY")
    ---
    > "sesskey" char(32) NOT NULL,
    > "expiry" bigint NOT NULL,
    > "expireref" varchar(64),
    > "data" text NOT NULL,
    > PRIMARY KEY ("sesskey")

    maybe i'm crazy, but its working well now for me.

     
    • assigned_to: nobody --> redflo
     
  • Logged In: YES
    user_id=738765

    I fixed the case in tiki.sql, commenting the change
    "Changed some rare uppercase column names to lowercase
    reported to be causing problem with pgsql on recommendation
    of 934745.Note that I assume/hope that this will ported to
    tiki-1.8-pgsql.sql "automatically" and I know about nothing
    about DBs."
    So I'll assign to redflo. We need a confirmation that the
    change will be ported to tiki-1.8-pgsql.sql, or then we need
    that it is ported manually.

     
  • Damian Parker
    Damian Parker
    2004-08-26

    • status: open --> closed-out-of-date