phpwiki-talk

[Phpwiki-talk] 1.3.12_rc2 and postgresql

[Alfredo A. <alf...@li...>]

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.

|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?

TIA
-- 
Bye,
Alfredo

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/

Re: [Phpwiki-talk] 1.3.12_rc2 and postgresql

[Alfredo A. <alf...@li...>]

On Thu, Mar 02, 2006 at 07:48:31AM +0000, Reini Urban wrote:
>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.

I will try your suggested solution later. Now I need to solve other
problems :-(

I have two PHP Warning but I don't know how to solve:

/usr/local/share/phpwiki-1.3.12_rc2/lib/CachedMarkup.php:56:
	Warning: gzuncompress(): data error

/usr/local/share/phpwiki-1.3.12_rc2/lib/CachedMarkup.php:57:
	Notice: unserialize(): Argument is not a string


>> 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.
>> 
>Yes, this was a known problem some years ago.
>Play with the redirect settings: DISABLE_HTTP_REDIRECT = true

this setting doesn't help me.

>Or try to mess with the redirect template as posted some weeks ago here
>on this list.
>This is server specific.

Sorry, but I haven't understood. Can you give me some keys to grep on my
archive?

Here some additional info.

I'm using the same settings of an old working wikifarm installation; for
instance http://www.linuxfan.it/icoli/

- A separate startup script with specific settings for each wiki; for
  example:
  /var/www/MyTest (you can play on http://orion.linuxfan.it/MyTest)
  containing:

define('DATABASE_PREFIX', 'italt_');
define('SCRIPT_NAME', '/MyTest');
define('VIRTUAL_PATH', '/MyTest');
include "phpwiki/index.php";
include "phpwiki/lib/main.php";

- A phpwiki installation on /usr/local/share/phpwiki-1.3.12_rc2
  with a symlink -> /var/www/phpwiki
- the following settings in config.ini
  DATA_PATH = /phpwiki
  PHPWIKI_DIR = /var/www/phpwiki
  USE_PATH_INFO = true

I can not understand what is wrong. I still have a blank page trying to
edit the wiki.




Now I have a problem also on the main server.
When I load a page from some host, I have the following fatal database
error:
/usr/local/share/phpwiki-20040514-italt/lib/WikiDB/backend/PearDB.php:778:
	Fatal[256]: wikidb_backend_pgsql: fatal database error

	*  DB Error: unknown error
	* (UPDATE session SET sess_data='', sess_date=1141679681, sess_ip='2001:1418:13:b::3' WHERE
	   sess_id='b821fd3e1832684425e923d2039c6ba5' [nativecode=ERROR: value too long for type character(15)])
	*

	Warning: Unknown(): A session is active. You cannot change the session module's ini
	settings at this time. in Unknown on line 0

Is it an IPv6 related error?
What can I do?


Thank you for the great work.

-- 
Bye,
Alfredo

Re: [Phpwiki-talk] 1.3.12_rc2 and postgresql

[Alfredo A. <alf...@li...>]

On Thu, Mar 02, 2006 at 07:48:31AM +0000, Reini Urban wrote:
>> 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
>https://lists.sourceforge.net/lists/listinfo/phpwiki-talk

for the record:

the problem is caused by a php memory limit.
we need to increase the "memory_limit" in the php.ini config file, or
disable the toolbar in the wiki editor (ENABLE_EDIT_TOOLBAR = false)

please consider to add a note in the config-dist.ini file.


-- 
Bye,
Alfredo

Re: [Phpwiki-talk] 1.3.12_rc2 and postgresql

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

Alfredo Amontagna schrieb:
> On Thu, Mar 02, 2006 at 07:48:31AM +0000, Reini Urban wrote:
>>> 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
>> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
> 
> for the record:
> 
> the problem is caused by a php memory limit.
> we need to increase the "memory_limit" in the php.ini config file, or
> disable the toolbar in the wiki editor (ENABLE_EDIT_TOOLBAR = false)
> 
> please consider to add a note in the config-dist.ini file.

Thanks.

Maybe it's just one of the TOOLBAR_*_PULLDOWN options?
These are known to need a lot of memory.
ENABLE_EDIT_TOOLBAR per se is no memory hog.

-- 
Reini Urban
http://phpwiki.org/
http://helsinki.at/  http://spacemovie.mur.at/

Re: [Phpwiki-talk] 1.3.12_rc2 and postgresql

[Alfredo A. <alf...@li...>]

On Tue, Mar 07, 2006 at 07:25:58AM +0000, Reini Urban wrote:
>> the problem is caused by a php memory limit.
>> we need to increase the "memory_limit" in the php.ini config file, or
>> disable the toolbar in the wiki editor (ENABLE_EDIT_TOOLBAR = false)
>> 
>> please consider to add a note in the config-dist.ini file.
>
>Maybe it's just one of the TOOLBAR_*_PULLDOWN options?

Are you speaking about AddCategory and AddPlugin buttons?
If you explain me how to disable them, I can make additional test.


>These are known to need a lot of memory.
>ENABLE_EDIT_TOOLBAR per se is no memory hog.

with the toolbar shown at http://orion.linuxfan.it/MyTest/HomePage?action=edit
I need to increase the memory limit at 12 M.

-- 
Bye,
Alfredo

Re: [Phpwiki-talk] 1.3.12_rc2 and postgresql

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

2006/3/7, Alfredo Amontagna <alf...@li...>:
> On Tue, Mar 07, 2006 at 07:25:58AM +0000, Reini Urban wrote:
> >> the problem is caused by a php memory limit.
> >> we need to increase the "memory_limit" in the php.ini config file, or
> >> disable the toolbar in the wiki editor (ENABLE_EDIT_TOOLBAR =3D false)
> >>
> >> please consider to add a note in the config-dist.ini file.
> >
> >Maybe it's just one of the TOOLBAR_*_PULLDOWN options?
>
> Are you speaking about AddCategory and AddPlugin buttons?
> If you explain me how to disable them, I can make additional test.

Disable those two options in config.ini:
TOOLBAR_PAGELINK_PULLDOWN
TOOLBAR_TEMPLATE_PULLDOWN

You may also want to disable the plugin button.
Comment out in lib/EditToolbar.php this line:
  //$sr_html =3D HTML($sr_html, $this->pluginPulldown());

Since these actions are cached they only require more memory the very
first time and
then once every 6 hours.

--
Reini Urban
http://phpwiki.org/
http://spacemovie.mur.at/   http://helsinki.at/