Re: [Phpwiki-talk] bug in action=upgrade

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

Arnaud Fontaine schrieb:
> -----BEGIN PGP SIGNED MESSAGE-----
> Yet another bug :
> 
> On the CVS version, with ADODB as a SQL lib, when trying to upgrade
> (action=upgrade) a 1.3.10 wiki, I have this error :
> 
> Error: mysql error: [1109: Unknown table 'mysql' in where clause] in
> EXECUTE("UPDATE mysql.db SET lock_tables_priv='Y' WHERE mysql.user='wiki'")
> 
> PLEASE ! Don't do this but use something like
> 
> GRANT LOCK ON `ecosol` . * TO 'wiki'@ 'localhost' WITH GRANT OPTION ;

I used the UPDATE / FLUSH statements because I have to query before if 
the mysql table already has the lock_tables_priv column.
Should check against errors here.
GRANT is better, ok.
Esp. when you may select the table, but are not allowed to change it.

> (don't remember if it's LOCK or LOCK_TABLES ... RTFM ;))
-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/