phpwiki-talk

[Phpwiki-talk] upgrading: some problems

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

Hi all,

(I hope I'm writing this to the right wiki now. This mail accidentally
ended up in pmwiki's mailing list first. Oops.)

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*.

Since Debian now offers packages of phpwiki, I figured it's about time
to upgrade, using the Debian packages. apt-get install phpwiki
blablabla ...

Debian installs version 1.3.12p3. Now the question. having read
INSTALL.mysql, I concluded that normally phpwiki should upgrade the
database when you start load phpwiki in a browser. If not, you could
add ?action=upgrade to the url.

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])

Fatal PhpWiki 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])

 Notice: Undefined property: WikiRequest::$_user in
/usr/share/phpwiki/lib/main.php on line 736
 DB Error: no such fieldDB Error: no such field


I did not forget to give the phpwiki mysql user create table/alter
table privileges.

Could someone give me a gentle push in the back please?

-- 
Frank Van Damme

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

Re: [Phpwiki-talk] upgrading: some problems

[Matt B. <ma...@ma...>]

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.

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

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

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.

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.