#476 "fatal database error" (setting cached html)

Database
closed
Reini Urban
Postgresql (18)
5
2012-10-11
2005-05-21
Thomas Leonard
No

Doing a fresh install of phpwiki-1.3.11-rc3 with a
clean postgres database, I get:

Loading up virgin wiki
...
Fatal Error:

lib/WikiDB/backend/PearDB.php:1014: Error:
wikidb_backend_peardb_pgsql: fatal database error

* DB Error: unknown error
* (UPDATE phpwikipage SET cached_html='xڭTM<random

nonsense>

Looking in /var/log/postgresql/postgres.log, I see:

ERROR: unterminated quoted string at or near "'...

Setting WIKIDB_NOCACHE_MARKUP = true makes the errors
go away.

$ dpkg --status postgresql
Version: 7.4.7-5

Discussion

  • Yhom
    Yhom
    2005-06-24

    Logged In: YES
    user_id=1178938

    It seems exactly like the closed bug #1175761 (which i
    experienced also) related to cache management.

     
  • Reini Urban
    Reini Urban
    2005-08-06

    Logged In: YES
    user_id=13755

    fixed with #1175761 at 2005-04-06 07:50

    for now we serialize postgresql blob's until proper
    postgresql quoting is ensured upstream.