phpwiki-talk

[Phpwiki-talk] bug in action=upgrade

[Arnaud F. <ar...@cr...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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 ;

(don't remember if it's LOCK or LOCK_TABLES ... RTFM ;))

Arnaud
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFB/6G/yAf3wgFyy1ARAqG5AKD13RFhUgYjkeE2G2mlfFwgAJ5I9gCglfQz
xYrHHko/NobM4y+v6dCnqJw=
=ftd3
-----END PGP SIGNATURE-----

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/