Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#210 DB table locks not freed ? (MySQL)

closed
Reini Urban
None
5
2012-10-11
2003-10-22
Rafael Vuijk
No

I'm using MySQL + phpwiki-1.3.4 and after loading a few
pages, it comes with this error:

"
lib/WikiDB/backend/PearDB.php:681: Fatal[256]:
wikidb_backend_mysql: fatal database error

DB Error: unknown error
(LOCK TABLES page WRITE,version WRITE,link
WRITE,recent WRITE,nonempty WRITE
[nativecode=1044 ** Access denied for
user: 'wikiuser@localhost' to database 'phpwiki']
)
"

Discussion

  • Logged In: NO

    I experienced the same issue and added LOCK TABLES to the
    GRANT statement for the 'wikiuser' in MySQL, which solved
    the problem.

     
  • Johan Viberg
    Johan Viberg
    2004-02-14

    Logged In: YES
    user_id=176477

    I experienced the same issue and added LOCK TABLES to the
    GRANT statement for the wiki user in MySQL, and that solved
    the problem.

     
  • Reini Urban
    Reini Urban
    2004-04-10

    Logged In: YES
    user_id=13755

    The mysql README has to be updated.

     
  • Reini Urban
    Reini Urban
    2004-04-18

    Logged In: YES
    user_id=13755

    added notes to doc/INSTALL.mysql