| View previous topic :: View next topic |
| Author |
Message |
BCB
Joined: 09 Mar 2007
Posts: 18
|
 Posted: Fri Mar 09, 2007 10:57 pm Post subject: Support Needed |
 |
|
I want to make someone a moderator on my forum but when i go to user admin then click on permissions and when i click on "is moderator" i get this error message
| Quote: |
General Error
Couldn't update private forum permissions
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 ' 1)' at line 2
INSERT INTO upthera_auth_access (forum_id, group_id, auth_mod) VALUES (1, , 1)
Line : 391
File : admin_ug_auth.php
|
Initially i didn't get this message and i was able to make this person a moderator, then i clicked on user level and this person is now an administrator which is ok in the short term but i want to have complete control of the admin functions, is there any way i can just make this person a moderator without getting an error message like this?
Surely there must be a solution to fix this problem, any advice would be appreciated. |
|
| Back to top |
|
 |
support
Site Admin
Joined: 25 Apr 2005
Posts: 377
Location: Inside
|
| Posted: Sat Mar 10, 2007 7:51 am Post subject: |
|
|
Hi !
This problem is a little complicated  , but I hope I will find a solution in few days.
Anyway I was telling you to test all after that problem, because I have mixed two version of two databases to minimise your loss. and....with a risk of problems
I have looked on admin and I saw that the problem it is real, but only for members registered from when that backup was made and restored to you and until I have done all modifications (after your forum was hacked), the users before and after are not afected (I have tested now) (you have registered in working restore period and you are affected ), One solution is to delete user and register again and it will work , but is not very good. I will look in few days on a solution to see how I can solve this without any problems !
_________________
Setup your FREE FORUM now !
Please use the SEARCH FUNCTION before posting.
Please read the PHPBB USERGUIDE first. |
|
| Back to top |
|
|
BCB
Joined: 09 Mar 2007
Posts: 18
|
| Posted: Sat Mar 10, 2007 10:52 am Post subject: |
|
|
Thanks  |
|
| Back to top |
|
|
BCB
Joined: 09 Mar 2007
Posts: 18
|
| Posted: Sat Mar 10, 2007 9:40 pm Post subject: |
|
|
| Was that you on as admin on my forum earlier mate?any luck sorting out the problems. |
|
| Back to top |
|
|
support
Site Admin
Joined: 25 Apr 2005
Posts: 377
Location: Inside
|
| Posted: Sun Mar 11, 2007 6:38 am Post subject: |
|
|
Yes I was . The thing now is more complicated than was before, that's why I told you to test all when I made last modifications. Anyway I have found a posible solution, but I will try to find another to see where exacly is the problem to fix-it. The database of one forum is very complicated and need study to see where is the problem.
Anyway, in one week or less (I have clases that I need to go in next days so....little busy) I will try to solve this. I will make a test forum to see when, where, how, etc etc and try to solve the problem.
Thank You for Your Patience
_________________
Setup your FREE FORUM now !
Please use the SEARCH FUNCTION before posting.
Please read the PHPBB USERGUIDE first. |
|
| Back to top |
|
|
BCB
Joined: 09 Mar 2007
Posts: 18
|
| Posted: Sun Mar 11, 2007 10:54 pm Post subject: |
|
|
| support wrote: |
Yes I was . The thing now is more complicated than was before, that's why I told you to test all when I made last modifications. Anyway I have found a posible solution, but I will try to find another to see where exacly is the problem to fix-it. The database of one forum is very complicated and need study to see where is the problem.
Anyway, in one week or less (I have clases that I need to go in next days so....little busy) I will try to solve this. I will make a test forum to see when, where, how, etc etc and try to solve the problem.
Thank You for Your Patience |
thanks if you could let me know when anyway. |
|
| Back to top |
|
|
support
Site Admin
Joined: 25 Apr 2005
Posts: 377
Location: Inside
|
| Posted: Sun Mar 18, 2007 3:22 pm Post subject: |
|
|
I gave you by e-mail few solutions. The last will work without any problems. Please let me know !
_________________
Setup your FREE FORUM now !
Please use the SEARCH FUNCTION before posting.
Please read the PHPBB USERGUIDE first. |
|
| Back to top |
|
|
BCB
Joined: 09 Mar 2007
Posts: 18
|
| Posted: Tue Mar 20, 2007 11:15 pm Post subject: |
|
|
| support wrote: |
| I gave you by e-mail few solutions. The last will work without any problems. Please let me know ! |
ill give it a go mate cheers for the tips |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
