Re: [Phpwiki-talk] upgrading: some problems

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

Frank Van Damme schrieb:
> On 3/15/07, Matt Brown <ma...@ma...> wrote:
>> Hi Frank,
>>
>> I'm the Debian Maintainer for PHPwiki, so I'll see if I can help you out.
>>
>> On 3/15/07, Frank Van Damme < fra...@gm...> wrote:
>>> I have a phpwiki running. It's on version 1.3.4 and when I upgraded my
>>> distribution to Debian Etch lately, phpwiki stopped serving me wiki
>>> pages but opted for error messages instead. They probably have
>>> something to do with php being upgraded, but I'm not too concerned
>>> about *that*.
>> That's not very good. What version of the package were you upgrading from?
>> If you can send me some details about teh upgrade process, versions,
>> database backend, error messages, etc. I'll be happy to look into it and
>> make sure it's not a bug in the package. I have not had any other failed
>> upgrade reports recently.
> 
> Well, maybe I haven't been entirely clear about this, but my previous
> installation was not installed with a package. It was installed by
> extracting the projects zipfile/tarbal into /var/www/wiki and
> configuring a virtual host for it in Apache. The backend has always
> been MySQL. This is a home server I upgraded to Etch, and I just
> decided to install by package from now on. I admit it's probably quit
> a version jump.
> 
>>> That doesn't work for me. I get asked to sign in. I enter the values of
>>> ADMIN_USER and ADMIN_PASSWD in /etc/phpwiki/config.ini respectively.
>>> The result:
>>>
>>> Fatal Error:
>>> lib/WikiDB/backend/PearDB.php:1032: Error:
>>> WikiDB_backend_PearDB_mysql: fatal database error
>>> DB Error: no such table
>>> (SELECT prefs FROM pref WHERE userid='phpwiki' [nativecode=1146 **
>>> Table 'phpwiki.pref' doesn't exist])
>> Is this while trying to load upgrade.php?
>>  Cheers
> 
> This is what I get when loading /?action=upgrade .well, there is a
> sign-in page in between, where I get a similar error at the bottom.
> I'll include that one too:
> 
> lib/WikiDB/backend/PearDB.php:1032: Error:
> WikiDB_backend_PearDB_mysql: fatal database error
>  DB Error: no such table
>  (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(1174335080,'192.168.0.72','-','GET','GET /?action=upgrade
> HTTP/1.1','/?action=upgrade','action=upgrade','19/Mar/2007:21:11:20
> 0100',200,0,'','Mozilla/5.0 (compatible; Konqueror/3.5) KHTML/3.5.5
> (like Gecko)','8.97388792038') [nativecode=1146 ** Table
> 'phpwiki.accesslog' doesn't exist])
> 
> if I request /lib/upgrade.php the error is pretty similar:
> 
> Fatal Error:
> lib/WikiDB/backend/PearDB.php:1032: Error:
> WikiDB_backend_PearDB_mysql: fatal database error
>  DB Error: no such field
>  (SELECT cached_html FROM page WHERE pagename='lib/upgrade.php'
> [nativecode=1054 ** Unknown column 'cached_html' in 'field list'])
> 
> Fatal PhpWiki Error
> lib/WikiDB/backend/PearDB.php:1032: Error:
> WikiDB_backend_PearDB_mysql: fatal database error
>  DB Error: no such field
>  (SELECT cached_html FROM page WHERE pagename='lib/upgrade.php'
> [nativecode=1054 ** Unknown column 'cached_html' in 'field list'])
> DB Error: no such fieldDB Error: no such field

You have to upgrade your database structure.
Best done by exporting all your pages, running 
schemas/mysql-initialize.sql and importing all your pages again.