#58 MySQL error on upgrade

1.3.x
closed
Reini Urban
None
5
2012-10-11
2003-09-30
James Stewart
No

I just upgraded from a previous 1.3.x to 1.3.4, by copying
files across and then editing index.php to put my mysql
details back in. My mysql details are correct but when I load
the page I get the error:

ib/WikiDB/backend/PearDB.php:680: 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=Access
denied for user: 'anthropi_wiki@192.168.1.%' to database
'anthropi_wiki']
)

Fatal PhpWiki Error

lib/WikiDB/backend/PearDB.php:680: 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=Access
denied for user: 'anthropi_wiki@192.168.1.%' to database
'anthropi_wiki']
)

Discussion

  • Logged In: NO

    I have the same error, i had my wiki running on a webserver
    and someday it stopped working. I have not done any changes
    to the config, isuspect that the database or the apache
    installation on the server has changed. The PhpWiki Version
    i use is 1.3.4, i also tryed 1.3.6, i get the same error
    message:

    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: 'nesh_peter@localhost' to database
    'nesh_peter']
    )
    *

    lib/config.php:145: Notice[8]: Object to string conversion
    lib/config.php:145: Notice[1024]: Object

    for more information contact me at nessus (at) gmx (dot) de

     
  • Reini Urban
    Reini Urban
    2004-05-08

    Logged In: YES
    user_id=13755

    You need to grant the new LOCK permission for your wikiuser
    anthropi_wiki