[Phpwiki-talk] How to upgrade MySQL DB from PHPWiki 1.3.12p2 to 1.3.14

[<sac...@un...>]

Hi there,

my host provider recently upgraded PHP from 4.3.9 to 5.1.6, and on the 
same time, MySQL from 4.0 to 4.1.21.

As a consequence, my Phpwiki version 1.3.12p2 stopped working.
I got the following error:

  Fatal error: Cannot redeclare hash() in
  /home/httpd/vhosts/scanita.net/httpdocs/phpwiki_old/lib/stdlib.php
  on line 1276

(I do understand this problem)


In order to fix it, I installed Phpwiki 1.3.14. But when I tried to use 
      the same DB as before, I got the following error:

  lib/WikiDB/backend/PearDB.php:1059 Error[256]:
  WikiDB_backend_PearDB_mysql: fatal database error

      * DB Error: no such field
      * (SELECT cached_html FROM page WHERE pagename='HomePage' 
[nativecode=1054 ** Unknown column 'cached_html' in 'field list'])
      *

(I do understand this problem too)


I tried the upgrade action (.../phpwiki/index.php&action=upgrade), but 
this did not seem to work:

  Upgrading this PhpWiki
  check for necessary database updates - SQL
  db version: we want 1030.14
  db version: we have 0
  Backend type: mysql
  check for table session ...OK
  check for table pref ...OK
  check for table member ...OK
  Rebuild entire database to upgrade relation links ...
  Fatal Error:

  lib/WikiDB/backend/PearDB.php:1059 Error[256]: 
WikiDB_backend_PearDB_mysql: fatal database error

      * DB Error: no such field
      * (INSERT INTO link (linkfrom, linkto, relation) VALUES (2, 3, 0) 
  [nativecode=1054 ** Unknown column 'relation' in 'field list'])
     *

  lib/WikiDB/backend/PearDB.php:98 Warning[512]: WARNING: database still 
   locked (lock_count = $this->_lock_count)

      * <br />


Here I do not understand what is going on.


I guess there are many possibilities to migrate the DB, but my knowledge 
  about PHP and MySQL are very limited (I'm willing to learn if 
necessary). I also have only limited rights on the host where I run the 
Wiki (Basically I can modify files inside the http directories, change 
permissions of these file and have access to phpMyAdmin 2.8.2.4).

Can you guide me into the right direction, or maybe even present a 
simple solution for this?

Thanks in advance for any help!

-Sacha