Re: [Phpwiki-talk] 1.3.12_rc2 and postgresql

[Reini U. <ru...@x-...>]

Alfredo Amontagna schrieb:
> Hi all,
> I have some problem with phpwiki 1.3.12_rc2
> 
> The first one is probably caused by a little bug in the backend code for
> postgresql.
> 
> Trying to "sign in" I receive the following fatal error:
> 
> |/usr/local/share/phpwiki-1.3.12_rc2/lib/WikiDB/backend/PearDB.php:1024:
> |	Error: wikidb_backend_peardb_pgsql: fatal database error
> |
> |   * DB Error: no such table
> |   * (SELECT prefs FROM pref WHERE userid='AlfredoAmontagna' [nativecode=ERROR: relation "pref" does not exist])
> |   *
> |
> |Notice: Undefined property: _user in /usr/local/share/phpwiki-1.3.12_rc2/lib/main.php on line 734
> 
> I think that in the code is missed the prefix defined in the config
> file:
> define('DATABASE_PREFIX', 'italt_');
> 
> Infact after creating the table "pref" (without prefix) the problem
> seems solved.

good point. thanks.
The correct way is to fix the config.ini DBAUTH SQL statements (the pref
tablename) for your prefix.

We want to be independent and allow external prefs and auth (external
databases and hosts), but for prefs it would be the best that we add the
table prefix for the default setup.

 > |CREATE TABLE pref (
> |        userid  CHAR(48) PRIMARY KEY,
> |        prefs   TEXT NULL DEFAULT '',
> |        passwd  CHAR(48) DEFAULT '',
> |        groupname CHAR(48) DEFAULT 'users'
> |);
> |GRANT SELECT,INSERT,UPDATE,DELETE ON pref TO "www-data";
> 
> I'm sorry, but I'm not a coder and I'm not able to check.
> 
> The second problem is very strange for me, and I cannot reproduce it :-(
> Sometime trying to modify a page, after giving "?action=edit" the
> browser receive a blank (empty) page.
> 
> This strange problem happens also with other backend type.
> 
> Can someone point me to some setting or to something to check to give
> more information?

Yes, this was a known problem some years ago.
Play with the redirect settings: DISABLE_HTTP_REDIRECT = true

Or try to mess with the redirect template as posted some weeks ago here
on this list.
This is server specific.
-- 
Reini Urban
http://phpwiki.org/
http://helsinki.at/  http://spacemovie.mur.at/