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

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

Sacha Schär schrieb:
> Greetings to Austria and many thanks for all your help!
> As far as I can tell the wiki works now, _after_ applying the SQL patch 
> above!

Ah, good.

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

This error says that it seems that wikiuser has no privileges to LOCK 
tables.  Your provider has to grant you LOCK TABLE privileges for your 
own databases, best done with mysql_fix_privilege_tables.

However if you CAN edit pages, you don't need this and the upgrade 
check is wrong.

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

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

Hmm, that depends on many other things. If the new database has a 
different default locale, it will lead to those effects.
-- 
Reini Urban
http://phpwiki.org/  http://murbreak.at/
http://helsinki.at/  http://spacemovie.mur.at/