I have a created a webpage with phpwiki-1.3.12p3 and mysql on a debian-system.
With Admin-User I have no problem at all (editing and viewing pages). The only problem is, that I cannot create a new account, and if I enter an unknown LoginName I get this error:
Fatal Error:
lib/WikiDB/backend/PearDB.php:1028: Error: wikidb_backend_peardb_mysql: fatal database error
* DB Error: unknown error
* ( [nativecode=1065 ** Query was empty])
*
lib/WikiUser/PearDb.php:186: Warning: sprintf(): Too few arguments
Any idea, where my bug is? I suppose it is a wrong DB-Layout and my authentification does not work correct but the queries in my config.ini should work.
DBAUTH_AUTH_USER_EXISTS = "SELECT userid FROM pref WHERE userid='$userid'"
DBAUTH_AUTH_CHECK = "SELECT IF(passwd='$password',1,0) as ok FROM pref WHERE userid='$userid'"
DBAUTH_AUTH_CRYPT_METHOD = crypt
DBAUTH_AUTH_UPDATE = "UPDATE pref SET passwd='$password' WHERE userid='$userid'"
DBAUTH_PREF_SELECT = "SELECT prefs FROM pref WHERE userid='$userid'"
DBAUTH_PREF_UPDATE = "UPDATE pref SET prefs='$pref_blob' WHERE userid='$userid'"
DBAUTH_PREF_INSERT = "INSERT INTO pref (prefs,userid) VALUES ('$pref_blob','$userid')"
DBAUTH_IS_MEMBER = "SELECT userid FROM pref WHERE userid='$userid' AND groupname='$groupname'"
DBAUTH_GROUP_MEMBERS = "SELECT userid FROM pref WHERE groupname='$groupname'"
DBAUTH_USER_GROUPS = "SELECT groupname FROM pref WHERE userid='$userid'"
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I think I've just posted exactly the same problem, and as far as I can see we have entirely different settings which suggests it is a real bug. I'm surprised you have not had a response - I beginning to seriously doubt my choice of PHPwiki!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have a created a webpage with phpwiki-1.3.12p3 and mysql on a debian-system.
With Admin-User I have no problem at all (editing and viewing pages). The only problem is, that I cannot create a new account, and if I enter an unknown LoginName I get this error:
Fatal Error:
lib/WikiDB/backend/PearDB.php:1028: Error: wikidb_backend_peardb_mysql: fatal database error
* DB Error: unknown error
* ( [nativecode=1065 ** Query was empty])
*
lib/WikiUser/PearDb.php:186: Warning: sprintf(): Too few arguments
Any idea, where my bug is? I suppose it is a wrong DB-Layout and my authentification does not work correct but the queries in my config.ini should work.
Some of my settings are:
DATABASE_DBA_HANDLER = db4
ALLOW_ANON_USER = true
ALLOW_ANON_EDIT = false
ALLOW_BOGO_LOGIN = false
ALLOW_USER_PASSWORDS = true
USER_AUTH_ORDER = "Db"
ENABLE_USER_NEW = true
ENABLE_PAGEPERM = true
GROUP_METHOD = DB
DBAUTH_AUTH_USER_EXISTS = "SELECT userid FROM pref WHERE userid='$userid'"
DBAUTH_AUTH_CHECK = "SELECT IF(passwd='$password',1,0) as ok FROM pref WHERE userid='$userid'"
DBAUTH_AUTH_CRYPT_METHOD = crypt
DBAUTH_AUTH_UPDATE = "UPDATE pref SET passwd='$password' WHERE userid='$userid'"
DBAUTH_PREF_SELECT = "SELECT prefs FROM pref WHERE userid='$userid'"
DBAUTH_PREF_UPDATE = "UPDATE pref SET prefs='$pref_blob' WHERE userid='$userid'"
DBAUTH_PREF_INSERT = "INSERT INTO pref (prefs,userid) VALUES ('$pref_blob','$userid')"
DBAUTH_IS_MEMBER = "SELECT userid FROM pref WHERE userid='$userid' AND groupname='$groupname'"
DBAUTH_GROUP_MEMBERS = "SELECT userid FROM pref WHERE groupname='$groupname'"
DBAUTH_USER_GROUPS = "SELECT groupname FROM pref WHERE userid='$userid'"
Thats is a bug fixed only in latest CVS, which will be released soon as 1.3.13
Hi,
I think I've just posted exactly the same problem, and as far as I can see we have entirely different settings which suggests it is a real bug. I'm surprised you have not had a response - I beginning to seriously doubt my choice of PHPwiki!