g'day Sunny,
I can't confirm thsi right now, but I'm pretty sure I fixed a similar
error without having to go the INNODB way (innodb ought to work ok, I
don't think that's what this error refers to).
Make sure the MySQL user used by your wiki has lock access to your
tables. i.e., grant lock etc etc
Beto
Sunny James Fugate wrote:
> I am on a hosted webserver and have had problems getting phpwiki
> installed properly. I initially assumed that the following error was
> due to lack of page locking capability on the tables and have added
> the necessary Type=INNODB . Is my assumption correct or is this an
> error due to some other misconfiguration or version incompatability?
> Error message on load of base wiki site:
> ------------------
> lib/WikiDB/backend/PearDB.php:698: Fatal[256]: wikidb_backend_mysql:
> fatal database error
> DB Error: unknown error
> (LOCK TABLES phpwiki_page WRITE,phpwiki_version WRITE,phpwiki_link
> WRITE,phpwiki_recent WRITE,phpwiki_nonempty WRITE [nativecode=1142 **
> select command denied to user: 'use...@XX...' for table
> 'phpwiki_page'])
> ------------------
> Thanks in advance for any help in this matter.
> -sunny
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Perforce Software.
> Perforce is the Fast Software Configuration Management System offering
> advanced branching capabilities and atomic changes on 50+ platforms.
> Free Eval! http://www.perforce.com/perforce/loadprog.html
> _______________________________________________
> Phpwiki-talk mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwiki-talk
>
--
Norberto Meijome | numard at meijome dot net
"Everything is interesting if you go into it deeply enough." - Richard Feynman
|