Re: [Phpwiki-talk] upgrading: some problems

[Frank V. D. <fra...@gm...>]

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

> --
> Matt Brown
> ma...@ma...
> Mob +64 21 611 544 www.mattb.net.nz

Thanks for wanting to help me out.

-- 
Frank Van Damme

This weekend, I've been mostly wearing geeky T-shirts.