| mysql error when deleting user [message #6769] |
Thu, 24 October 2002 03:01  |
|
|
I'm trying to delete a user through the user admin control panel and got the following error:
Fatal error: SQL Error has occured, please contact the administrator of the forum and have them review the forum's SQL query log in /home/<domainname>/<domain-directory>/ccnmforum/include/theme/d efault/err.inc on line 102
This is what is in the error log viewer:
(act=del&usr_id=103&rid=1&S=f2caf1c1a30f5b92f5388b9126d60d47) 1100: Table 'fud21_group_members' was not locked with LOCK TABLES
Query: DELETE FROM fud21_group_members WHERE user_id=103
Server Version: 3.23.49-debug
[Referring Page] http://www.<domainname>.com/ccnm/adm/admuser.php?rid=1&S=f2caf1c1a30f5b92f53 88b9126d60d47&usr_login=Daniel
Any ideas?
|
|
|
|
| Re: mysql error when deleting user [message #6770 is a reply to message #6769] |
Thu, 24 October 2002 03:04  |
|
|
just a quick update...i checked the database, and in the fud21_group_members table, there is no user_id that is 103.
It alternates between 0 and 2147483647 between entries. (i.e. first entry user_id=0, second entry user_id=2147483647, third entry user_id=0, etc...)
|
|
|
|
| Re: mysql error when deleting user [message #6771 is a reply to message #6770] |
Thu, 24 October 2002 03:50 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Known error will be fixed in upcomming 2.3.4, in the meanwhile you can fix by downloading users_adm.inc.t from the CVS.
FUDforum Core Developer
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]