 | SQL error |  |
 Posted: 10/13/2006 12:59 AM |
 |
|
|
|
|
| Citation |
| Posts |
2152 |
| Word Cnt. |
78,257 |
| BDay |
Jun 15 |
| Sign |
Gemini |
| Sex |
 |
|
|
|
Joined: Apr 22, 2005
Local time: 10:08 AM
Location: Upside down
|
|
|
|
|
 |
I received the following error when giving a member temporary admin rights and now I can't remove their status. Any ideas how I can fix this?
| Code:
|
Could not update auth access
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group_id = 188' at line 3
UPDATE phpbb_auth_access SET auth_view = 0, auth_read = 0, auth_post = 0, auth_reply = 0, auth_edit = 0, auth_delete = 0, auth_sticky = 0, auth_announce = 0 , auth_globalannounce = 0WHERE group_id = 188
Line : 224
File : admin_ug_auth.php
|
|
|
|
|
|
| Back to Top |
|
|
| Re: SQL error | |
| Posted: 10/13/2006 1:12 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 8:08 PM
Location: St Pete, FL
|
|
|
|
|
|
Yes, this is the problem:
| Code:
|
|
auth_globalannounce = 0WHERE
|
There needs to be a space between the 0 and WHERE. If you can't see the problem in the admin_ug_auth.php file, post a text link to it so I can tell you what needs to be corrected. The problem is probably a few lines above line 224 in the admin_ug_auth.php file...
 |
|
|
|
|
| Back to Top |
|
|
| Re: SQL error | |
| Posted: 10/13/2006 1:50 AM |
|
|
|
|
|
| Citation |
| Posts |
2152 |
| Word Cnt. |
78,257 |
| BDay |
Jun 15 |
| Sign |
Gemini |
| Sex |
|
|
|
|
Joined: Apr 22, 2005
Local time: 10:08 AM
Location: Upside down
|
|
|
|
|
|
There were 2 places in that file where I had to add a space. It works now thanks   |
|
|
|
|
| Back to Top |
|
|
| Re: SQL error | |
| Posted: 10/13/2006 2:03 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 8:08 PM
Location: St Pete, FL
|
|
|
|
|
|
Awesome. Which MOD caused that problem???
 |
|
|
|
|
| Back to Top |
|
|
| Re: SQL error | |
| Posted: 10/13/2006 2:05 AM |
|
|
|
|
|
| Citation |
| Posts |
2152 |
| Word Cnt. |
78,257 |
| BDay |
Jun 15 |
| Sign |
Gemini |
| Sex |
|
|
|
|
Joined: Apr 22, 2005
Local time: 10:08 AM
Location: Upside down
|
|
|
|
|
|
| No idea. Could have been like that for a while |
|
|
|
|
| Back to Top |
|
|
| Re: SQL error | |
| Posted: 10/13/2006 2:16 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 8:08 PM
Location: St Pete, FL
|
|
|
|
|
|
Oh well, at least the problem is corrected now...
 |
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
