Serialize flaking out on OSX?

[Scott Auge]

When I load up a new wiki, I am getting this:

Loading up virgin wiki

_AuthInfo
Fatal Error:

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

* DB Error: unknown error
* (UPDATE page SET cached_html='x=K0D @KV
* ih-JRݱUxf''TK|!]oB6<`[/~ѕ&n1M^

Any ideas?

[Scott Auge]

OK, this is what I have found...

I needed to:

/* scottauge - OSX PostgreSQL freaks out on this
See set() in WikiDB.php

function set_cached_html($pagename, $data) {
    $dbh = &$this->_dbh;
    $page_tbl = $this->_table_names['page_tbl'];
    $sth = $dbh->query("UPDATE $page_tbl"
                       . " SET cached_html=?"
                       . " WHERE pagename=?",
                       array($data, $pagename));
}

*/

in /WikiDB/backend/PearDB.php

and I was able to get it working.

Apparently it doesn't digest well on PostgreSQL 8.0.3/PHP 4.3.11 on OS X