[Phpwiki-talk] Re: Wiki Blues

[Thomas H. <tom...@gm...>]

I am upgrading my old phpwiki.

http://www.hawsedc.com/pwnew/index.php?action=3Dupgrade with user admin
and pw admin gives this error:

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

The jaguarpc senior tech says:

 The privileges are already assigned. Please provide this output to
the phpwiki developers:

mysql> select * from db where user=3D'jconstru_phpwiki' and
db=3D'jconstru_phpwiki1';

+-------------+--------------------+------------------+
| Host        | Db                 | User             |
+-------------+--------------------+------------------+
| localhost   | jconstru_phpwiki1  | jconstru_phpwiki |
| 192.168.1.% | jconstru_phpwiki1  | jconstru_phpwiki |
+-------------+--------------------+------------------+

-------------+-------------+-------------+-------------+
 Select_priv | Insert_priv | Update_priv | Delete_priv |
-------------+-------------+-------------+-------------+
 Y           | Y           | Y           | Y           |
 Y           | Y           | Y           | Y           |
-------------+-------------+-------------+-------------+

-------------+-----------+------------+-----------------+
 Create_priv | Drop_priv | Grant_priv | References_priv |
-------------+-----------+------------+-----------------+
 Y           | Y         | N          | Y               |
 Y           | Y         | N          | Y               |
-------------+-----------+------------+-----------------+

------------+------------+-----------------------+------------------+
 Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv |
------------+------------+-----------------------+------------------+
 Y          | Y          | Y                     | Y                |
 Y          | Y          | Y                     | Y                |
------------+------------+-----------------------+------------------+

2 rows in set (0.00 sec)



--
Tom Haws 480-201-5476
"There are many causes that I am prepared to die for but no causes
that I am prepared to kill for" Gandhi