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

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

Greetings to Basel.

Sacha Schär schrieb:
> 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.

A mailer error. I meant ?action=upgrade of course ...

> 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

This error is not fatal.
   mysql session.sess_id sanity is not so important in your case.

> 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?

Both. A bug in upgrade and an intermediate mysql schema.
Thanks for using DEBUG to get the failing upgrade lines.
I can fix it now.

Does the wiki work?

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

We still seem to need 'cached_html'
Strange, this should have been there since 1.3.11. Try

   ALTER TABLE page ADD cached_html MEDIUMBLOB;

But I rather believe upgrade fails in mysql_list_fields().
-- 
Reini Urban
http://phpwiki.org/  http://murbreak.at/
http://helsinki.at/  http://spacemovie.mur.at/