Re: How to upgrade MySQL DB from PHPWiki 1.3.12p2 to 1.3.14

Greetings to Austria and many thanks for all your help!

> 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().

As far as I can tell the wiki works now, _after_ applying the SQL patch 
above!


(from your other mail)
 > FYI: The fix for this error is in lib/upgrade.php
 >
 >    function CheckDatabaseUpdate() {
 >    global $DBAuthParams, $DBParams;

After fixing this, ?action=upgrade dies at the following check:

  check for mysql LOCK TABLE privilege ...lock_tables_priv missing.
  The  DB   Admin must run mysql_fix_privilege_tables


Is 'mysql_fix_privilege_tables' some file or action that is provided 
with PHPWiki? I can not find anything like that.
If it is something only the host provider can do, how should I instruct him?

Can I savely run the wiki now or should I fix the problem above first?

-Sacha

PS: One minor glitch: Seemingly, I can no longer login into the wiki as 
'SachaSchär'. Is this because of the umlaut? Anyway, no real problem, 
I'm just curious...


-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >>  http://get.splunk.com/