phpwiki-talk

Re: [Phpwiki-talk] Removed pages are not really deleted

[Stefan <son...@ba...>]

I've tried it with  _usecache = false and it works as it should.

The solution could be to purge the cache before reading a deleted page.
or to disable the cache for the moment a deleted page should be read.

To reset the cache on page deletion is not enough i think.
A page can be deleted with button "remove page" or removing the content 
from the page.
Both have to reset the cache. But the second is first a normal edit 
function.

Maybe it's easier to do it while reading a deleted page.
Stefan
_
Manuel Vacelet schrieb:
> 2007/1/26, Manuel Vacelet <man...@gm...>:
>   
>> 2007/1/26, Stefan <son...@ba...>:
>>     
>>> Hello Manuel,
>>>
>>> i have inserted the patch here but the result for me is the same as
>>> before (1.3.13 RC2)
>>> Entering a delteted page with the deleted page link in "recend changes"
>>> there is a message to create the page. open the page with the full
>>> linkname in browser url field (widthout action=create) the page is shown
>>> as before i deleted it. i will make the code tests to see when it stops.
>>>       
>> Hello Stephan,
>>
>> I made the patch on a customized version of phpwiki 1.3.12p3 (on this
>> part, our customization shouldn't impact much).
>>
>> I remember I had to switch off HTML cache (USECACHE = false) during my
>> test but I can't figure if I re-enabled it after.
>>     
>
> I didn't have time to test with the latest RC but I confirm I had to
> switch cache off and it didn't work with cache enabled.
>
> I think the good option it to reset html cache on page deletion.
>
> What do you think ?
>
> BTW, can you make the test with USECACHE = false ?
>
> -- Manuel
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>
>
>   

Re: [Phpwiki-talk] Removed pages are not really deleted

[Manuel V. <man...@gm...>]

2007/1/26, Manuel Vacelet <man...@gm...>:
> 2007/1/26, Stefan <son...@ba...>:
> > Hello Manuel,
> >
> > i have inserted the patch here but the result for me is the same as
> > before (1.3.13 RC2)
> > Entering a delteted page with the deleted page link in "recend changes"
> > there is a message to create the page. open the page with the full
> > linkname in browser url field (widthout action=create) the page is shown
> > as before i deleted it. i will make the code tests to see when it stops.
>
> Hello Stephan,
>
> I made the patch on a customized version of phpwiki 1.3.12p3 (on this
> part, our customization shouldn't impact much).
>
> I remember I had to switch off HTML cache (USECACHE = false) during my
> test but I can't figure if I re-enabled it after.

I didn't have time to test with the latest RC but I confirm I had to
switch cache off and it didn't work with cache enabled.

I think the good option it to reset html cache on page deletion.

What do you think ?

BTW, can you make the test with USECACHE = false ?

-- Manuel

Re: [Phpwiki-talk] issues with latest cvs version loading virgin wiki on postgres 8. 1

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

John Cole schrieb:
> Reini,
>   Just updated my test server :-)  I want to upgrade to postgres, so I've
> created the database and the wikiuser user and have the database loaded
> (though, I'm using the postgres account to connect).
> 
>   Here are some issues:
> 
>   1)  when creating the database, don't create it using UTF8, lots of pages
> in pgsrc throw an error when it's UTF8, this should be noted somewhere.

Should be fixed in 1.3.13rc1

> ----------------------------------------------------------------------
> 
>   2)  running the schema scripts throws several errors...  Here are my
> results for 8.1 on windows.
> 
> F:\inetpub\wwwroot\phpwiki_cvs\schemas>"c:\Program
> Files\PostgreSQL\8.1\bin"\psq
> l -U postgres wiki < psql-1_3_12.sql

wrong schema. use psql-initialize.sql

> schema enhancements
> ERROR:  type "serial" does not exist
> ERROR:  cannot alter type of a column used by a view or rule
> DETAIL:  rule _RETURN on view curr_page depends on column "id"
> ERROR:  cannot alter type of a column used by a view or rule
> DETAIL:  rule _RETURN on view existing_page depends on column "id"
> Creating experimental page views (not yet used)
> ERROR:  relation "existing_page" already exists
> ERROR:  relation "curr_page" already exists
> ERROR:  column "relation" of relation "link" already exists
> ERROR:  relation "relation_idx" already exists
> add tsearch2 fulltextsearch extension
> ERROR:  relation "pg_ts_dict" does not exist
> ERROR:  type "tsvector" does not exist
> ERROR:  function to_tsvector("unknown", text) does not exist
> HINT:  No function matches the given name and argument types. You may need
> to ad
> d explicit type casts.
> ERROR:  column "idxfti" does not exist
> ERROR:  function tsearch2() does not exist
> Initializing stored procedures
> ERROR:  cannot change return type of existing function
> HINT:  Use DROP FUNCTION first.

The tsearch2.dll couldn't be found. I only tried the cygwin version, 
which I maintain. You should complain upstream.

> F:\inetpub\wwwroot\phpwiki_cvs\schemas>"c:\Program
> Files\PostgreSQL\8.1\bin"\psq
> l -U postgres wiki < psql-tsearch2.sql
>        prefix =  ''
>    httpd_user =  'phpwiki'
> ERROR:  relation "pg_ts_dict" does not exist
> ERROR:  type "tsvector" does not exist
> ERROR:  function to_tsvector("unknown", text) does not exist
> HINT:  No function matches the given name and argument types. You may need
> to ad
> d explicit type casts.
> ERROR:  column "idxfti" does not exist
> ERROR:  function tsearch2() does not exist
> 
> F:\inetpub\wwwroot\phpwiki_cvs\schemas>
> 
> ----------------------------------------------------------------------
> 
>   3)  Loading the virgin wiki throws the following errors:
> 
> f:\inetpub\wwwroot\phpwiki_cvs\lib\plugin\Template.php:89 Notice[8]:
> Undefined index: page
> 
> f:\inetpub\wwwroot\phpwiki_cvs\lib\BlockParser.php:561 Notice[1024]:
> Internal Error: no block advance
> 
> f:\inetpub\wwwroot\phpwiki_cvs\lib\BlockParser.php:664 Warning[512]: no
> lastTR: <tr class="tightenable bottom top">
> 
>     * <th rowspan="2">_</th>
>     * <th rowspan="2">S'inscrire</th>
>     * <th rowspan="2">_</th>
>     * <td colspan="2"><p class="tightenable top bottom">¥µ¥¤¥??</p>
>     * </td>
>     * </tr>
>     * <tr class="tightenable top bottom">
>     * <th>_</th>
>     * <td>_</td>
>     * </tr>
> 
> f:\inetpub\wwwroot\phpwiki_cvs\lib\BlockParser.php:664 Warning[512]: no
> lastTR: <tr class="tightenable bottom top">
> 
>     * <th rowspan="2">Sign In</th>
>     * <th rowspan="2">Anmelden</th>
>     * <th rowspan="2">_</th>
>     * <th rowspan="2">S'inscrire</th>
>     * <th rowspan="2">_</th>
>     * <td colspan="2"><p class="tightenable top bottom">¥µ¥¤¥??</p>
>     * </td>
>     * </tr>
>     * <tr class="tightenable top bottom">
>     * <th>_</th>
>     * <td>_</td>
>     * </tr>
> 
> Fatal Error:
> f:\inetpub\wwwroot\phpwiki_cvs\lib\WikiDB\adodb\adodb-errorhandler.inc.php:7
> 6 Error[256]: postgres7 error: [ERROR: invalid input syntax for integer:
> "25-Jan-2007 08:23:49": ERROR: invalid input syntax for integer:
> "25-Jan-2007 08:23:49"] in EXECUTE("INSERT INTO accesslog
> (time_stamp,remote_host,remote_user,request_method,request_line,request_uri,
> request_args,request_time,status,bytes_sent,referer,agent,request_duration)
> VALUES('25-Jan-2007 08:23:49','192.168.243.84','-','GET','GET
> /phpwiki_cvs/index.php/HomePage
> HTTP/1.1','/phpwiki_cvs/index.php/HomePage','','25/Jan/2007:08:23:49
> -0600',200,0,'http://cvs.uai.com/phpwiki_cvs/index.php/HomePage','Mozilla/5.
> 0 (Windows; U; Windows NT 6.0; en-US; rv:1.8.1.1) Gecko/20061204
> Firefox/2.0.0.1','12.478621')")

I improved accesslog handling to be backend specific.
Only oracle uses a data datatype now. All other a simple int.

> f:\inetpub\wwwroot\phpwiki_cvs\lib\BlockParser.php:664 Warning[512]: no
> lastTR: <tr class="tightenable bottom">
> 
>     * <th rowspan="7"><em>Automatically generated pages</em></th>
>     * <th>English (en)</th>
>     * <th>Deutsch (de)</th>
>     * <th>Espa?(es)</th>
>     * <th>Fran?s (fr)</th>
>     * <th>Italiano (it)</th>
>     * <th>Japanese (ja)</th>
>     * <th>Nederlands (nl)</th>
>     * <td>Svenska (sv)</td>
>     * </tr>
> 
> f:\inetpub\wwwroot\phpwiki_cvs\lib\WikiPlugin.php:524 Warning[2]:
> getplugin(lib/plugin/New.php): failed to open stream: No such file or
> directory
> 
> ----------------------------------------------------------------------
> 
>   4) the 'time_stamp' column on the accesslog table is set to an int type,
> which is wrong.  Changing it to a timestamp type fixed the fatal error in 3)
> which was happening on every page.

int is the new way to go.
I changed the logger function.

> ----------------------------------------------------------------------
> 
> 5) trying to edit the sandbox page returns the following error when you hit
> save, and the save fails:
> 
> f:\inetpub\wwwroot\phpwiki_cvs\lib\WikiDB\adodb\adodb-errorhandler.inc.php:7
> 6 Error[256]: postgres7 error: [ERROR: update or delete on "version"
> violates foreign key constraint "recent_id_fkey1" on "recent"
> 
>     * DETAIL: Key (id,version)=(144,1) is still referenced from table
> "recent".: ERROR: update or delete on "version" violates foreign key
> constraint "recent_id_fkey1" on "recent"
>     * DETAIL: Key (id,version)=(144,1) is still referenced from table
> "recent".] in ADODB_Error_Handler(DELETE FROM version WHERE id=144 AND
> version=1, )
>     *

Looks like you are using an old postgresql schema.

> ----------------------------------------------------------------------
> 
> 6) trying to upload a zipdump (made with the same version of phpwiki)
> results in the following error:
> 
> f:\inetpub\wwwroot\phpwiki_cvs\lib\ziplib.php:197 Error[256]: CRC32
> mismatch: calculated=3448885092, expected=-846082204

yep, that's not fixed yet.

> Stopping there :-)
> 
> Thanks,
> 
> John
> 


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

Re: [Phpwiki-talk] Removed pages are not really deleted

[Manuel V. <man...@gm...>]

2007/1/26, Stefan <son...@ba...>:
> Hello Manuel,
>
> i have inserted the patch here but the result for me is the same as
> before (1.3.13 RC2)
> Entering a delteted page with the deleted page link in "recend changes"
> there is a message to create the page. open the page with the full
> linkname in browser url field (widthout action=create) the page is shown
> as before i deleted it. i will make the code tests to see when it stops.

Hello Stephan,

I made the patch on a customized version of phpwiki 1.3.12p3 (on this
part, our customization shouldn't impact much).

I remember I had to switch off HTML cache (USECACHE = false) during my
test but I can't figure if I re-enabled it after.

I will try to apply the patch on the latest RC this week-end.

-- Manuel

Re: [Phpwiki-talk] Removed pages are not really deleted

[Stefan <son...@ba...>]

Hello Manuel,

i have inserted the patch here but the result for me is the same as 
before (1.3.13 RC2)
Entering a delteted page with the deleted page link in "recend changes" 
there is a message to create the page. open the page with the full 
linkname in browser url field (widthout action=create) the page is shown 
as before i deleted it. i will make the code tests to see when it stops.

Stefan

Manuel Vacelet wrote:
> 2007/1/23, Reini Urban <ru...@x-...>:
>   
>> Manuel Vacelet schrieb:
>>     
>>> 2007/1/20, Stefan <son...@ba...>:
>>>       
>>>> Hello Manuel,
>>>>
>>>> how do you access the page? If you access it with the link in recent
>>>> changes (?) you are right.
>>>> If you access the page with the url of the deleted page put it direct in
>>>> the browser url field you will see the deleted page again.
>>>>         
>>> Unfortunatly I think it's not a cache issue (at least neither proxy
>>> nor browser cache) because I tried to load page2 from a different
>>> browser on a different machine.
>>>
>>> Moreover, I already set cache settings to NO_CACHE :/
>>>       
>> No, I meant our internal pagedb ache, not the browsers cache.
>>     
>
> I found a solution.
>
> In getPackedContent method, I added a test to verify if the requested
> page is not deleted:
> ----------------------->8-----------------------
> if (empty($data['%content'])
>             || (!$this->_wikidb->isWikiPage($this->_pagename)
>                 && $this->isCurrent())) {
> ----------------------->8-----------------------
>
> The remove a page will lead to following use case.
> On page deletion:
> - Page history add a mark about deletion.
> - Links in other pages show the page as not existing.
> - Direct access to the page give the same behaviour (Describe %s here).
> - Page history show the previous states of the page.
> - Access to an old revision of the page output the content of this old version.
>
> Is my fix right ?
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>
>
>   

Re: [Phpwiki-talk] Removed pages are not really deleted

[Manuel V. <man...@gm...>]

2007/1/23, Reini Urban <ru...@x-...>:
> Manuel Vacelet schrieb:
> > 2007/1/20, Stefan <son...@ba...>:
> >> Hello Manuel,
> >>
> >> how do you access the page? If you access it with the link in recent
> >> changes (?) you are right.
> >> If you access the page with the url of the deleted page put it direct in
> >> the browser url field you will see the deleted page again.
> >
> > Unfortunatly I think it's not a cache issue (at least neither proxy
> > nor browser cache) because I tried to load page2 from a different
> > browser on a different machine.
> >
> > Moreover, I already set cache settings to NO_CACHE :/
>
> No, I meant our internal pagedb ache, not the browsers cache.

I found a solution.

In getPackedContent method, I added a test to verify if the requested
page is not deleted:
----------------------->8-----------------------
if (empty($data['%content'])
            || (!$this->_wikidb->isWikiPage($this->_pagename)
                && $this->isCurrent())) {
----------------------->8-----------------------

The remove a page will lead to following use case.
On page deletion:
- Page history add a mark about deletion.
- Links in other pages show the page as not existing.
- Direct access to the page give the same behaviour (Describe %s here).
- Page history show the previous states of the page.
- Access to an old revision of the page output the content of this old version.

Is my fix right ?

[Phpwiki-talk] issues with latest cvs version on mysql...

[John C. <joh...@ua...>]

Reini,
  Switching back to mysql, here are the errors I'm seeing:

1) running action=upgrade has the following errors:

f:\inetpub\wwwroot\phpwiki_cvs\lib\upgrade.php:442 Notice[8]: Undefined
variable: DBParams

f:\inetpub\wwwroot\phpwiki_cvs\lib\WikiDB\adodb\adodb-errorhandler.inc.php:7
6 Warning[512]: mysql error: [1064: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the right
syntax to use near '' at line 1] in EXECUTE("SHOW COLUMNS FROM ")

f:\inetpub\wwwroot\phpwiki_cvs\lib\WikiDB\adodb\drivers\adodb-mysql.inc.php:
365 Notice[8]: Only variable references should be returned by reference

f:\inetpub\wwwroot\phpwiki_cvs\lib\WikiDB\backend\ADODB.php:1277 Warning[2]:
Invalid argument supplied for foreach()

f:\inetpub\wwwroot\phpwiki_cvs\lib\WikiDB\adodb\adodb.inc.php:858 Notice[8]:
Only variable references should be returned by reference

---------------------------------------------------------------------------

2) every page has the following fatal error:

f:\inetpub\wwwroot\phpwiki_cvs\lib\WikiDB\adodb\adodb-errorhandler.inc.php:7
6 Error[256]: mysql error: [1062: Duplicate entry
'27c8da7526cb38447e1a388e1a49b7a4' for key 1] in EXECUTE("INSERT INTO
session (sess_id, sess_data, sess_date, sess_ip) VALUES
('27c8da7526cb38447e1a388e1a49b7a4',
'wiki_user|O:10:\"_adminuser\":11:{s:7:\"_userid\";s:5:\"admin\";s:6:\"_leve
l\";i:10;s:6:\"_prefs\";O:15:\"userpreferences\":4:{s:6:\"_prefs\";a:14:{s:6
:\"userid\";O:15:\"_userpreference\":2:{s:13:\"default_value\";s:0:\"\";

---------------------------------------------------------------------------

3) on the admin page, trying to select a page called 'test' does not work.

---------------------------------------------------------------------------

4) using the /rename page and selecting the 'test' page from the list of all
pages, and attempting to rename 'test' to 'testrename' fails:

    * Couldn't rename page 'test' to 'testrename'.

No pages renamed.

And has the fatal error:

:\inetpub\wwwroot\phpwiki_cvs\lib\WikiDB\adodb\adodb-errorhandler.inc.php:76
Error[256]: mysql error: [1062: Duplicate entry
'27c8da7526cb38447e1a388e1a49b7a4' for key 1] in EXECUTE("INSERT INTO
session (sess_id, sess_data, sess_date, sess_ip) VALUES
('27c8da7526cb38447e1a388e1a49b7a4',
'wiki_user|O:10:\"_adminuser\":11:{s:7:\"_userid\";s:5:\"admin\";s:6:\"_leve
l\";i:10;s:6:\"_prefs\";O:15:\"userpreferences\":4:{s:6:\"_prefs\";a:14:{s:6
:\"userid\";O:15:\"_userpreference\":2:{s:13:\"default_value\";s:0:\"\";s:6


I'll do more testing when I can get past these probs.

Thanks,

John


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.17.10/651 - Release Date: 1/24/2007
6:48 PM
 
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.

[Phpwiki-talk] issues with latest cvs version loading virgin wiki on postgres 8. 1

[John C. <joh...@ua...>]

Reini,
  Just updated my test server :-)  I want to upgrade to postgres, so I've=

created the database and the wikiuser user and have the database loaded
(though, I'm using the postgres account to connect).

  Here are some issues:

  1)  when creating the database, don't create it using UTF8, lots of pag=
es
in pgsrc throw an error when it's UTF8, this should be noted somewhere.

----------------------------------------------------------------------

  2)  running the schema scripts throws several errors...  Here are my
results for 8.1 on windows.

F:\inetpub\wwwroot\phpwiki_cvs\schemas>"c:\Program
Files\PostgreSQL\8.1\bin"\psq
l -U postgres wiki < psql-1_3_12.sql
schema enhancements
ERROR:  type "serial" does not exist
ERROR:  cannot alter type of a column used by a view or rule
DETAIL:  rule _RETURN on view curr_page depends on column "id"
ERROR:  cannot alter type of a column used by a view or rule
DETAIL:  rule _RETURN on view existing_page depends on column "id"
Creating experimental page views (not yet used)
ERROR:  relation "existing_page" already exists
ERROR:  relation "curr_page" already exists
ERROR:  column "relation" of relation "link" already exists
ERROR:  relation "relation_idx" already exists
add tsearch2 fulltextsearch extension
ERROR:  relation "pg_ts_dict" does not exist
ERROR:  type "tsvector" does not exist
ERROR:  function to_tsvector("unknown", text) does not exist
HINT:  No function matches the given name and argument types. You may nee=
d
to ad
d explicit type casts.
ERROR:  column "idxfti" does not exist
ERROR:  function tsearch2() does not exist
Initializing stored procedures
ERROR:  cannot change return type of existing function
HINT:  Use DROP FUNCTION first.

F:\inetpub\wwwroot\phpwiki_cvs\schemas>"c:\Program
Files\PostgreSQL\8.1\bin"\psq
l -U postgres wiki < psql-tsearch2.sql
       prefix =3D  ''
   httpd_user =3D  'phpwiki'
ERROR:  relation "pg_ts_dict" does not exist
ERROR:  type "tsvector" does not exist
ERROR:  function to_tsvector("unknown", text) does not exist
HINT:  No function matches the given name and argument types. You may nee=
d
to ad
d explicit type casts.
ERROR:  column "idxfti" does not exist
ERROR:  function tsearch2() does not exist

F:\inetpub\wwwroot\phpwiki_cvs\schemas>

----------------------------------------------------------------------

  3)  Loading the virgin wiki throws the following errors:

f:\inetpub\wwwroot\phpwiki_cvs\lib\plugin\Template.php:89 Notice[8]:
Undefined index: page

f:\inetpub\wwwroot\phpwiki_cvs\lib\BlockParser.php:561 Notice[1024]:
Internal Error: no block advance

f:\inetpub\wwwroot\phpwiki_cvs\lib\BlockParser.php:664 Warning[512]: no
lastTR: <tr class=3D"tightenable bottom top">

    * <th rowspan=3D"2">_</th>
    * <th rowspan=3D"2">S'inscrire</th>
    * <th rowspan=3D"2">_</th>
    * <td colspan=3D"2"><p class=3D"tightenable top bottom">=A5=B5=A5=A4=A5=
??</p>
    * </td>
    * </tr>
    * <tr class=3D"tightenable top bottom">
    * <th>_</th>
    * <td>_</td>
    * </tr>

f:\inetpub\wwwroot\phpwiki_cvs\lib\BlockParser.php:664 Warning[512]: no
lastTR: <tr class=3D"tightenable bottom top">

    * <th rowspan=3D"2">Sign In</th>
    * <th rowspan=3D"2">Anmelden</th>
    * <th rowspan=3D"2">_</th>
    * <th rowspan=3D"2">S'inscrire</th>
    * <th rowspan=3D"2">_</th>
    * <td colspan=3D"2"><p class=3D"tightenable top bottom">=A5=B5=A5=A4=A5=
??</p>
    * </td>
    * </tr>
    * <tr class=3D"tightenable top bottom">
    * <th>_</th>
    * <td>_</td>
    * </tr>

Fatal Error:
f:\inetpub\wwwroot\phpwiki_cvs\lib\WikiDB\adodb\adodb-errorhandler.inc.ph=
p:7
6 Error[256]: postgres7 error: [ERROR: invalid input syntax for integer:
"25-Jan-2007 08:23:49": ERROR: invalid input syntax for integer:
"25-Jan-2007 08:23:49"] in EXECUTE("INSERT INTO accesslog
(time_stamp,remote_host,remote_user,request_method,request_line,request_u=
ri,
request_args,request_time,status,bytes_sent,referer,agent,request_duratio=
n)
VALUES('25-Jan-2007 08:23:49','192.168.243.84','-','GET','GET
/phpwiki_cvs/index.php/HomePage
HTTP/1.1','/phpwiki_cvs/index.php/HomePage','','25/Jan/2007:08:23:49
-0600',200,0,'http://cvs.uai.com/phpwiki_cvs/index.php/HomePage','Mozilla=
/5.
0 (Windows; U; Windows NT 6.0; en-US; rv:1.8.1.1) Gecko/20061204
Firefox/2.0.0.1','12.478621')")

f:\inetpub\wwwroot\phpwiki_cvs\lib\BlockParser.php:664 Warning[512]: no
lastTR: <tr class=3D"tightenable bottom">

    * <th rowspan=3D"7"><em>Automatically generated pages</em></th>
    * <th>English (en)</th>
    * <th>Deutsch (de)</th>
    * <th>Espa?(es)</th>
    * <th>Fran?s (fr)</th>
    * <th>Italiano (it)</th>
    * <th>Japanese (ja)</th>
    * <th>Nederlands (nl)</th>
    * <td>Svenska (sv)</td>
    * </tr>

f:\inetpub\wwwroot\phpwiki_cvs\lib\WikiPlugin.php:524 Warning[2]:
getplugin(lib/plugin/New.php): failed to open stream: No such file or
directory

----------------------------------------------------------------------

  4) the 'time_stamp' column on the accesslog table is set to an int type=
,
which is wrong.  Changing it to a timestamp type fixed the fatal error in=
 3)
which was happening on every page.

----------------------------------------------------------------------

5) trying to edit the sandbox page returns the following error when you h=
it
save, and the save fails:

f:\inetpub\wwwroot\phpwiki_cvs\lib\WikiDB\adodb\adodb-errorhandler.inc.ph=
p:7
6 Error[256]: postgres7 error: [ERROR: update or delete on "version"
violates foreign key constraint "recent_id_fkey1" on "recent"

    * DETAIL: Key (id,version)=3D(144,1) is still referenced from table
"recent".: ERROR: update or delete on "version" violates foreign key
constraint "recent_id_fkey1" on "recent"
    * DETAIL: Key (id,version)=3D(144,1) is still referenced from table
"recent".] in ADODB_Error_Handler(DELETE FROM version WHERE id=3D144 AND
version=3D1, )
    *

----------------------------------------------------------------------

6) trying to upload a zipdump (made with the same version of phpwiki)
results in the following error:

f:\inetpub\wwwroot\phpwiki_cvs\lib\ziplib.php:197 Error[256]: CRC32
mismatch: calculated=3D3448885092, expected=3D-846082204

Stopping there :-)

Thanks,

John

--=20
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.17.10/651 - Release Date: 1/24/200=
7
6:48 PM
=20
This email and any files transmitted with it are confidential and intende=
d solely for the use of the individual or entity to whom they are address=
ed. If you have received this email in error please notify the sender. Th=
is message contains confidential information and is intended only for the=
 individual named. If you are not the named addressee you should not diss=
eminate, distribute or copy this e-mail.

[Phpwiki-talk] How to change the title of a page?

[umfan866 <mh...@so...>]

Hi, is there a way to take an existing page, and change its title? What I've
done so
far is to create the new page with a different title, and manually transfer
all of the 
old content, and then trry to delete the old page. If there is a better
method,
please let me know. Thanks, Marvin. phpwiki v 1.3.12p3
-- 
View this message in context: http://www.nabble.com/How-to-change-the-title-of-a-page--tf3066214.html#a8528382
Sent from the phpwiki-talk mailing list archive at Nabble.com.

[Phpwiki-talk] How to change the current owner of a page?

[umfan866 <mh...@so...>]

Hi can anyone tell me, or point me to documentation on how to change the
owner of a page?
Basically I created a page, but want to assign a new owner so that he/she
can control the
content and lock it down.  phpwiki version 1.3.12p.3. Thanks, Marvin. 
-- 
View this message in context: http://www.nabble.com/How-to-change-the-current-owner-of-a-page--tf3066208.html#a8528351
Sent from the phpwiki-talk mailing list archive at Nabble.com.

Re: [Phpwiki-talk] Removed pages are not really deleted

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

Manuel Vacelet schrieb:
> 2007/1/20, Stefan <son...@ba...>:
>> Hello Manuel,
>>
>> how do you access the page? If you access it with the link in recent
>> changes (?) you are right.
>> If you access the page with the url of the deleted page put it direct in
>> the browser url field you will see the deleted page again.
> 
> Unfortunatly I think it's not a cache issue (at least neither proxy
> nor browser cache) because I tried to load page2 from a different
> browser on a different machine.
> 
> Moreover, I already set cache settings to NO_CACHE :/

No, I meant our internal pagedb ache, not the browsers cache.
I will check it today.
-- 
Reini Urban
http://phpwiki.org/  http://murbreak.at/
http://helsinki.at/  http://spacemovie.mur.at/

Re: [Phpwiki-talk] Error in WikiLens theme

[Peter C. <pe...@pe...>]

On Sunday 21 January 2007 18:32, Reini Urban wrote:
> Peter Chant schrieb:
> > I've selected the wikilens theme and get the following error:
> >
> > Fatal Error:
> >
> > lib/WikiDB/adodb/adodb-errorhandler.inc.php (In template 'navbar' < 'top'
> > < 'body' < 'html'):76: Error: mysql error: [1146: Table 'test.page'
> > doesn't exist] in EXECUTE("SELECT latestversion FROM page, recent WHERE
> > page.id=recent.id AND pagename='UserPreferences'")
> >
> >     *
> >
> > Unfortuately this corrupts the preferences screen.  Any ideas how to
> > change the theme to another one?
>
> Themes are selected in config.ini
>
> The problem I got with adodb and certain cfg can be fixed with:
>
> lib/WikiDB/backend/ADODB.php:296
>              if (0 and $dbh->hasGenID) {
>

Hmm, I've must have different version of that file, using 1.3.12p3.  You 
modification '0 and' ? did not appear to fit in with the code on that line! 


>
> This will not create a temp. sequence table. E.g. if the db user does
> not have the proper permissions.

Hmm, I note the code was a mysql error, but I am not using mysql!

Pete

Re: [Phpwiki-talk] Removed pages are not really deleted

[Manuel V. <man...@gm...>]

2007/1/20, Stefan <son...@ba...>:
> Hello Manuel,
>
> how do you access the page? If you access it with the link in recent
> changes (?) you are right.
> If you access the page with the url of the deleted page put it direct in
> the browser url field you will see the deleted page again.

Unfortunatly I think it's not a cache issue (at least neither proxy
nor browser cache) because I tried to load page2 from a different
browser on a different machine.

Moreover, I already set cache settings to NO_CACHE :/

-- Manuel

Re: [Phpwiki-talk] Error in WikiLens theme

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

Peter Chant schrieb:
> I've selected the wikilens theme and get the following error:
> 
> Fatal Error:
> 
> lib/WikiDB/adodb/adodb-errorhandler.inc.php (In template 'navbar' < 'top' 
> < 'body' < 'html'):76: Error: mysql error: [1146: Table 'test.page' doesn't 
> exist] in EXECUTE("SELECT latestversion FROM page, recent WHERE 
> page.id=recent.id AND pagename='UserPreferences'")
> 
>     *
> 
> Unfortuately this corrupts the preferences screen.  Any ideas how to change 
> the theme to another one?

Themes are selected in config.ini

The problem I got with adodb and certain cfg can be fixed with:

lib/WikiDB/backend/ADODB.php:296
             if (0 and $dbh->hasGenID) {


This will not create a temp. sequence table. E.g. if the db user does 
not have the proper permissions.

Re: [Phpwiki-talk] Problem setting up phpwiki-1.3.13

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

Jeff Bowes schrieb:
> I fixed the loading virgin wiki problem, but can't seem to keep it from
> prompting for login everytime you go to a different page.
> 
> I have USER_AUTH_ORDER set to "LDAP : Session" and USER_AUTH_POLICY set
> to stacked.  I've also tried sett ORDER to Session : LDAP but then the
> LDAP authentication fails.
> 
> Also ALLOW_ANON_USER, ALLOW_ANON_EDIT, and ALLOW_BOGO_LOGIN = false and
> ALLOW_USER_PASSWORDS = true
> 
> AUTH_SESS_USER = "user[username]", I've also tried it as userid.
> 
> AUTH_SESS_LEVEL = 2
> 
> Anyone have any ideas?

Yes, stacked auth is currently broken for the second auth method on. 
Only the first works. I'm working on it.

> On Fri, 2007-01-19 at 14:40 -0600, Jeff Bowes wrote:
>> I've installed phpwiki 1.3.13rc1 using mysql for page store and LDAP for
>> authentication.  I followed the db setup and modified the config.ini as
>> required for mysql config and LDAP auth.  But when I go to the wiki and
>> login it loads the virgin wiki as it should initially.  But now
>> everytime i always get prompted to sign in and when going to the
>> HomePage it says its loading the virgin wiki.
>>
>>
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share your
>> opinions on IT & business topics through brief surveys - and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> Phpwiki-talk mailing list
>> Php...@li...
>> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>>
> 
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
> 


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

[Phpwiki-talk] Error in WikiLens theme

[Peter C. <pe...@pe...>]

I've selected the wikilens theme and get the following error:

Fatal Error:

lib/WikiDB/adodb/adodb-errorhandler.inc.php (In template 'navbar' < 'top' 
< 'body' < 'html'):76: Error: mysql error: [1146: Table 'test.page' doesn't 
exist] in EXECUTE("SELECT latestversion FROM page, recent WHERE 
page.id=recent.id AND pagename='UserPreferences'")

    *

Unfortuately this corrupts the preferences screen.  Any ideas how to change 
the theme to another one?

Pete

Re: [Phpwiki-talk] Problem setting up phpwiki-1.3.13

[Jeff B. <jef...@ic...>]

I fixed the loading virgin wiki problem, but can't seem to keep it from
prompting for login everytime you go to a different page.

I have USER_AUTH_ORDER set to "LDAP : Session" and USER_AUTH_POLICY set
to stacked.  I've also tried sett ORDER to Session : LDAP but then the
LDAP authentication fails.

Also ALLOW_ANON_USER, ALLOW_ANON_EDIT, and ALLOW_BOGO_LOGIN = false and
ALLOW_USER_PASSWORDS = true

AUTH_SESS_USER = "user[username]", I've also tried it as userid.

AUTH_SESS_LEVEL = 2

Anyone have any ideas?

On Fri, 2007-01-19 at 14:40 -0600, Jeff Bowes wrote:
> I've installed phpwiki 1.3.13rc1 using mysql for page store and LDAP for
> authentication.  I followed the db setup and modified the config.ini as
> required for mysql config and LDAP auth.  But when I go to the wiki and
> login it loads the virgin wiki as it should initially.  But now
> everytime i always get prompted to sign in and when going to the
> HomePage it says its loading the virgin wiki.
> 
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
> 

Re: [Phpwiki-talk] Removed pages are not really deleted

[Stefan <son...@ba...>]

Hello Manuel,

how do you access the page? If you access it with the link in recent 
changes (?) you are right.
If you access the page with the url of the deleted page put it direct in 
the browser url field you will see the deleted page again.
The Problem is that google etc. will send you users to the deleted page 
and they think it is the real one.

-- Stefan

Manuel Vacelet wrote:
> 2007/1/19, Stefan <son...@ba...>:
>   
>> hello sabri,
>>
>> it works as designed. thats no bug but it's useless i think. the pages
>> are only marked as deleted but shown as i think from the cached version
>> table. when you edit a deleted page it is empty. i agree with you that
>> deleted pages should'nt be shown anymore.
>>     
>
> Hell Stefan,
>
> With phpwiki 1.3.10 I don't see this problem:
>
> After page2 deletion, when I access directly page2, I have the empty
> page with 'Describe page2 here'.
>
> Here we still access to page2 with full history and so on.
>
> -- Manuel
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>
>
>   

[Phpwiki-talk] Problem setting up phpwiki-1.3.13

[Jeff B. <jef...@ic...>]

I've installed phpwiki 1.3.13rc1 using mysql for page store and LDAP for
authentication.  I followed the db setup and modified the config.ini as
required for mysql config and LDAP auth.  But when I go to the wiki and
login it loads the virgin wiki as it should initially.  But now
everytime i always get prompted to sign in and when going to the
HomePage it says its loading the virgin wiki.

Re: [Phpwiki-talk] Removed pages are not really deleted

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

2007/1/19, Manuel Vacelet <man...@gm...>:
> 2007/1/19, Stefan <son...@ba...>:
> > hello sabri,
> >
> > it works as designed. thats no bug but it's useless i think. the pages
> > are only marked as deleted but shown as i think from the cached version
> > table. when you edit a deleted page it is empty. i agree with you that
> > deleted pages should'nt be shown anymore.
>
> Hell Stefan,
>
> With phpwiki 1.3.10 I don't see this problem:
>
> After page2 deletion, when I access directly page2, I have the empty
> page with 'Describe page2 here'.
>
> Here we still access to page2 with full history and so on.

I changed (optimized)  the db Cache after 1.3.11 and forgot to add the
purge_cache for the remove action. rename also has a similar problem.
sorry. the browser cache has also to be invalidated. with NO_CACHE
this will not be triggered and your browser will fool you.

Re: [Phpwiki-talk] Removed pages are not really deleted

[Manuel V. <man...@gm...>]

2007/1/19, Stefan <son...@ba...>:
> hello sabri,
>
> it works as designed. thats no bug but it's useless i think. the pages
> are only marked as deleted but shown as i think from the cached version
> table. when you edit a deleted page it is empty. i agree with you that
> deleted pages should'nt be shown anymore.

Hell Stefan,

With phpwiki 1.3.10 I don't see this problem:

After page2 deletion, when I access directly page2, I have the empty
page with 'Describe page2 here'.

Here we still access to page2 with full history and so on.

-- Manuel

Re: [Phpwiki-talk] Removed pages are not really deleted

[Sabri L. <sab...@st...>]

Stefan wrote
>hello sabri,
>
>it works as designed. thats no bug but it's useless i think. 
>the pages are only marked as deleted but shown as i think from 
>the cached version table. when you edit a deleted page it is 
>empty. i agree with you that deleted pages should'nt be shown anymore.

So, I think we should also delete them from the cached version table. Don't
you?
Then any request for a deleted page will show up a "Sorry, this page is not
in the database." message for example.

>The Problem with '_supplanted' timestamp' .... is nearly as 
>old as phpwiki. nobody tried to fix it until today. for us we 
>have disabled all the warnings. 2 years ago i asked about a 
>tool to fix this errors but it seems to have priority 0 to fix 
>it. i tried to fix it by my own but i did'nt understand how it 
>really works.
>
>Stefan
>
>Sabri LABBENE schrieb:
>> Hi all,
>>
>> Suppose that we have two wiki pages already created page1 
>and page2 and that page1 contain a link to page2. If we delete 
>page2 (using /Remove admin action), The link to it in page1 
>become disabled with the question mark at the end. If we want 
>to access page2 directly, the page is displayed ! It was not 
>really removed. 
>>
>> Now back to page1, if I use the question mark to create the 
>page, I have this warning after saving it.
>>
>> lib/ArchiveCleaner.php:109: Notice: Warning: Page 'NewPage', version 
>> '1' has no '_supplanted' timestamp (...repeated 2 times)
>>
>> It seems that it's a bug in phpwiki since removed pages 
>should not be displayed when we directly request them.
>>
>> What do you think ?
>>
>> Cheers,
>> Sabri.
>>
>>
>>
>> 
>----------------------------------------------------------------------
>> --- Take Surveys. Earn Cash. Influence the Future of IT Join 
>> SourceForge.net's Techsay panel and you'll get the chance to share 
>> your opinions on IT & business topics through brief surveys 
>- and earn 
>> cash 
>> 
>http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEV
>> DEV _______________________________________________
>> Phpwiki-talk mailing list
>> Php...@li...
>> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>>
>>
>>   
>
>
>---------------------------------------------------------------
>----------
>Take Surveys. Earn Cash. Influence the Future of IT Join 
>SourceForge.net's Techsay panel and you'll get the chance to 
>share your opinions on IT & business topics through brief 
>surveys - and earn cash 
>http://www.techsay.com/default.php?page=join.php&p=sourceforge&
CID=DEVDEV
>_______________________________________________
>Phpwiki-talk mailing list
>Php...@li...
>https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>

Re: [Phpwiki-talk] Removed pages are not really deleted

[Stefan <son...@ba...>]

hello sabri,

it works as designed. thats no bug but it's useless i think. the pages 
are only marked as deleted but shown as i think from the cached version 
table. when you edit a deleted page it is empty. i agree with you that 
deleted pages should'nt be shown anymore.

The Problem with '_supplanted' timestamp' .... is nearly as old as 
phpwiki. nobody tried to fix it until today. for us we have disabled all 
the warnings. 2 years ago i asked about a tool to fix this errors but it 
seems to have priority 0 to fix it. i tried to fix it by my own but i 
did'nt understand how it really works.

Stefan

Sabri LABBENE schrieb:
> Hi all,
>
> Suppose that we have two wiki pages already created page1 and page2 and that page1 contain a link to page2. If we delete page2 (using /Remove admin action), The link to it in page1 become disabled with the question mark at the end. If we want to access page2 directly, the page is displayed ! It was not really removed. 
>
> Now back to page1, if I use the question mark to create the page, I have this warning after saving it.
>
> lib/ArchiveCleaner.php:109: Notice: Warning: Page 'NewPage', version '1' has no '_supplanted' timestamp (...repeated 2 times)
>
> It seems that it's a bug in phpwiki since removed pages should not be displayed when we directly request them.
>
> What do you think ?
>
> Cheers,
> Sabri.
>
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>
>
>   

[Phpwiki-talk] Removed pages are not really deleted

[Sabri L. <sab...@st...>]

Hi all,

Suppose that we have two wiki pages already created page1 and page2 and =
that page1 contain a link to page2. If we delete page2 (using /Remove =
admin action), The link to it in page1 become disabled with the question =
mark at the end. If we want to access page2 directly, the page is =
displayed ! It was not really removed.=20

Now back to page1, if I use the question mark to create the page, I have =
this warning after saving it.

lib/ArchiveCleaner.php:109: Notice: Warning: Page 'NewPage', version '1' =
has no '_supplanted' timestamp (...repeated 2 times)

It seems that it's a bug in phpwiki since removed pages should not be =
displayed when we directly request them.

What do you think ?

Cheers,
Sabri.

Re: [Phpwiki-talk] Phpwiki and Mysql slowness

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

2007/1/17, Manuel Vacelet <man...@gm...>:
> FYI, today there is 29000+ pages in our wiki_page table (even if most
> of them are automaticatly created from pgsrc).
>
> > For the next release I will work for sql db's on extracting the standard
> > page and version data properties from serialized blobs into real
> > table columns.
> > This will require more sql schema updates, but I hope action=upgrade
> > will be good enough to do that automatically.
>
> This is very intresting, do you exepect any performances enhancement
> with this upgrade ?
> It could be an opportunity for us to contribute our patch to allow
> several wiki instances to be stored in one table.

It will be a trade-off of the SQL-relation access against a php serialize.
serialize with objects is very slow. Here with the pages and versions
we have only hashes.
I wonder also if it will be worth the trouble.

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