| Author |
Message |
Thorofin
Nuke Cadet
Joined: Mar 10, 2008
Posts: 3
|
 Posted:
Sun Mar 09, 2008 9:09 pm |
  |
Nuke 8.1 & BBtoNuke 2.0.23
When trying to view group permissions I get the following error:
| Quote: |
Couldn't obtain user/group information
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 'AND ug.group_id = g.group_id AND u.user_id = ug.user_id' at lin
SELECT u.user_id, u.username, u.user_level, g.group_id, g.group_name, g.group_single_user, ug.user_pending FROM nuke_users u, nuke_bbgroups g, nuke_bbuser_group ug WHERE g.group_id = AND ug.group_id = g.group_id AND u.user_id = ug.user_id
Line : 702
File : admin_ug_auth.php |
This is the first time I've looked at these since upgrading from 8.0/2.0.22 |
|
|
   |
|
Evaders99
Site Admin
Joined: Aug 17, 2003
Posts: 12482
|
| Posted:
Mon Mar 10, 2008 11:43 am |
|
|
  |
|
Thorofin
Nuke Cadet
Joined: Mar 10, 2008
Posts: 3
|
| Posted:
Mon Mar 10, 2008 3:14 pm |
|
|
|
|
Thorofin
Nuke Cadet
Joined: Mar 10, 2008
Posts: 3
|
| Posted:
Mon Mar 10, 2008 3:46 pm |
|
Also, I'm looking at the data in my bb tables, and it's looking wacky.
I have 3-4 user groups..but in the bbgroup table I see the groups I created, and about 375 more "Personal User" groups. My user base is less than 300, so this seems odd.
AFAIK, I should only have 1 entry per group in that table, and I should see 1 entry per group member in the bbuser_group table. I checked the bbuser_group table, and the number of entries seems to be in the correct ballpark, but now I have a bunch of users assigned to these mysterious "Personal User" groups.
Or am I mistaken? |
|
|
|
|
Skaery
Nuke Cadet
Joined: Mar 11, 2008
Posts: 4
|
| Posted:
Tue Mar 11, 2008 1:44 pm |
|
I just noticed I have this error too. I'm using PNC 4.4.0, and I think it started after I updated to v.4.4.0 from v.4.3.0, but not really sure. |
|
|
|
|
shu8man
Nuke Cadet
Joined: Feb 08, 2007
Posts: 7
|
| Posted:
Fri Mar 28, 2008 11:29 am |
|
Not working for me either and I tried the fix and I tried another fix and I looked for other fixes, nothing...is it worth noting I'm running nuke 7.9 with bbtonuke 2.0.23? |
|
|
|
|
Skaery
Nuke Cadet
Joined: Mar 11, 2008
Posts: 4
|
| Posted:
Fri Mar 28, 2008 11:43 am |
|
| shu8man wrote: |
| Not working for me either and I tried the fix and I tried another fix and I looked for other fixes, nothing...is it worth noting I'm running nuke 7.9 with bbtonuke 2.0.23? |
Funny thing. I just solved this 5 min. ago.
The only thing I did was replace the admin_ug_auth.php file with an older version. |
|
|
|
|
shu8man
Nuke Cadet
Joined: Feb 08, 2007
Posts: 7
|
| Posted:
Fri Mar 28, 2008 1:20 pm |
|
Could you post or PM me to send me the older version? |
|
|
|
|
Skaery
Nuke Cadet
Joined: Mar 11, 2008
Posts: 4
|
| Posted:
Fri Mar 28, 2008 2:16 pm |
|
|
|
|
shu8man
Nuke Cadet
Joined: Feb 08, 2007
Posts: 7
|
| Posted:
Fri Mar 28, 2008 3:55 pm |
|
gracias! I'll dl it as soon as I get home from work! |
|
|
|
|
Skaery
Nuke Cadet
Joined: Mar 11, 2008
Posts: 4
|
| Posted:
Fri Mar 28, 2008 4:00 pm |
|
| shu8man wrote: |
| gracias! I'll dl it as soon as I get home from work! |
Remember to take a backup first - we are not using the same nuke. |
|
|
|
|
shu8man
Nuke Cadet
Joined: Feb 08, 2007
Posts: 7
|
| Posted:
Fri Mar 28, 2008 4:21 pm |
|
Yes I will! Thank you though! |
|
|
|
|
shu8man
Nuke Cadet
Joined: Feb 08, 2007
Posts: 7
|
| Posted:
Fri Mar 28, 2008 8:14 pm |
|
Works great! that is the trick! |
|
|
|
|
|
|
