You are missing our premiere tool bar navigation system! Register and use it for FREE!

NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 
Readme First
- Readme First! -

Read and follow the rules, otherwise your posts will be closed
Modules
· Home
· FAQ
· Buy a Theme
· Advertising
· AvantGo
· Bookmarks
· Columbia
· Community
· Donations
· Downloads
· Feedback
· Forums
· PHP-Nuke HOWTO
· Private Messages
· Search
· Statistics
· Stories Archive
· Submit News
· Surveys
· Theme Gallery
· Top
· Topics
· Your Account
Who's Online
There are currently, 181 guest(s) and 0 member(s) that are online.

You are Anonymous user. You can register for free by clicking here
Nuke Cops :: View topic - Couldn't obtain user/group information [ ]
 Forum FAQ  •  Search  •   •  Memberlist  •  Usergroups   •  Register  •  Profile •    •  Log in to check your private messages  •  Log in

 
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
Author Message
Thorofin
Nuke Cadet
Nuke Cadet


Joined: Mar 10, 2008
Posts: 3


PostPosted: Sun Mar 09, 2008 9:09 pm Reply with quoteBack to top

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
Find all posts by ThorofinView user's profileSend private message
Evaders99
Site Admin
Site Admin


Joined: Aug 17, 2003
Posts: 12482


PostPosted: Mon Mar 10, 2008 11:43 am Reply with quoteBack to top

Find and run the FixGroup script

_________________
Helping those that help themselves
Read FIRST or DIE!

"Fighting is terrible, but not as terrible as losing the will to fight."
Star Wars Rebellion Network - Need Help? Evaders Squadron Coding
Find all posts by Evaders99View user's profileSend private messageVisit poster's websiteAIM Address
Thorofin
Nuke Cadet
Nuke Cadet


Joined: Mar 10, 2008
Posts: 3


PostPosted: Mon Mar 10, 2008 3:14 pm Reply with quoteBack to top

Ran the script I found here:
http://nukecops.com/postlite53969-fixgroup+script.html

Still receiving same issue, and again, it's only when trying to view group Permissions. I can still use Group: Management, but not Group: Permissions.
Find all posts by ThorofinView user's profileSend private message
Thorofin
Nuke Cadet
Nuke Cadet


Joined: Mar 10, 2008
Posts: 3


PostPosted: Mon Mar 10, 2008 3:46 pm Reply with quoteBack to top

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?
Find all posts by ThorofinView user's profileSend private message
Skaery
Nuke Cadet
Nuke Cadet


Joined: Mar 11, 2008
Posts: 4


PostPosted: Tue Mar 11, 2008 1:44 pm Reply with quoteBack to top

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.
Find all posts by SkaeryView user's profileSend private message
shu8man
Nuke Cadet
Nuke Cadet


Joined: Feb 08, 2007
Posts: 7


PostPosted: Fri Mar 28, 2008 11:29 am Reply with quoteBack to top

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?
Find all posts by shu8manView user's profileSend private messageVisit poster's website
Skaery
Nuke Cadet
Nuke Cadet


Joined: Mar 11, 2008
Posts: 4


PostPosted: Fri Mar 28, 2008 11:43 am Reply with quoteBack to top

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.
Find all posts by SkaeryView user's profileSend private message
shu8man
Nuke Cadet
Nuke Cadet


Joined: Feb 08, 2007
Posts: 7


PostPosted: Fri Mar 28, 2008 1:20 pm Reply with quoteBack to top

Could you post or PM me to send me the older version?
Find all posts by shu8manView user's profileSend private messageVisit poster's website
Skaery
Nuke Cadet
Nuke Cadet


Joined: Mar 11, 2008
Posts: 4


PostPosted: Fri Mar 28, 2008 2:16 pm Reply with quoteBack to top

shu8man wrote:
Could you post or PM me to send me the older version?

Try this http://rapidshare.com/files/103130027/admin_ug_auth.php.html
Find all posts by SkaeryView user's profileSend private message
shu8man
Nuke Cadet
Nuke Cadet


Joined: Feb 08, 2007
Posts: 7


PostPosted: Fri Mar 28, 2008 3:55 pm Reply with quoteBack to top

gracias! I'll dl it as soon as I get home from work!
Find all posts by shu8manView user's profileSend private messageVisit poster's website
Skaery
Nuke Cadet
Nuke Cadet


Joined: Mar 11, 2008
Posts: 4


PostPosted: Fri Mar 28, 2008 4:00 pm Reply with quoteBack to top

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.
Find all posts by SkaeryView user's profileSend private message
shu8man
Nuke Cadet
Nuke Cadet


Joined: Feb 08, 2007
Posts: 7


PostPosted: Fri Mar 28, 2008 4:21 pm Reply with quoteBack to top

Yes I will! Thank you though!
Find all posts by shu8manView user's profileSend private messageVisit poster's website
shu8man
Nuke Cadet
Nuke Cadet


Joined: Feb 08, 2007
Posts: 7


PostPosted: Fri Mar 28, 2008 8:14 pm Reply with quoteBack to top

Works great! that is the trick!
Find all posts by shu8manView user's profileSend private messageVisit poster's website
Display posts from previous:      
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2005 phpBB Group

Ported by Nuke Cops © 2003 www.nukecops.com
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::
Powered by TOGETHER TEAM srl ITALY http://www.togetherteam.it - DONDELEO E-COMMERCE http://www.DonDeLeo.com - TUTTISU E-COMMERCE http://www.tuttisu.it
Web site engine's code is Copyright © 2002 by PHP-Nuke. All Rights Reserved. PHP-Nuke is Free Software released under the GNU/GPL license.
Page Generation: 0.138 Seconds - 229 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::