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

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

Thank you for the quick reply! I did not receive this email. So I just 
copied the text from the archieves, thereby probably creating a new 
thread... sorry.


 > Oops, upgrade error. I forgot something.
 > Best is to use your phpMyAdmin with the following snippet:
 >
 > ALTER TABLE accesslog CHANGE remote_host VARCHAR(100);
 >
 > <enter> // this may fail.

Failed indeed:

#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 'VARCHAR(100)' at line 1


 > ALTER TABLE link ADD relation INT DEFAULT 0;
 > CREATE INDEX link_relation ON link (relation);
 >
 > <enter> // this is required.

This worked!


 > And then optionally again ?action=3Dupgrade to fill in the relations.

This failed, seemingly, 3Dupgrade is an unknown action in my setup:

...(snipped some text)
[nativecode=1054 ** Unknown column 'cached_html' in 'field list'])
     *

lib/main.php:873 Notice[1024]: 3Dupgrade: Unknown action


I tried ?upgrade instead. With this, the migration went further as 
before, but still failed:

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 ... OK
check for table accesslog ...OK
check for table rating ...OK
check for new session.sess_ip column ... SKIP
check for mysql session.sess_id sanity ...
Fatal Error:

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

     * DB Error: syntax error
     * (DESCRIBE [nativecode=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])
     *

lib/upgrade.php:472 Notice[8]: Undefined variable: DBParams

lib/WikiDB/backend/PearDB.php:1151 Warning[2]: mysql_list_fields() [<a 
href='function.mysql-list-fields'>function.mysql-list-fields</a>]: 
Unable to save MySQL query result

lib/WikiDB/backend/PearDB.php:1152 Warning[512]: 
/home/httpd/vhosts/scanita.net/httpdocs/phpwiki/lib/WikiDB/backend/PearDB.php:1152 
Table 'spice_phpwiki.' doesn't exist


(spice_phpwiki is the name of the DB as well as the name of the admin user)

Is there a bug in upgrade.php or do you think there is a problem with my 
settings?

-Sacha