| Author |
Message |
jackalopehunter
New Member
Joined: Feb 25, 2009
Posts: 17
|
 Posted:
Fri Jan 08, 2010 6:53 pm |
|
OK I setup a new site for my EVE Online Alliance. The site seems to be working great. It is running RavenNuke 2.4 and all is good until members try to post in the members only sections. They can post in any forum open to the public but if the try to post in a forum that is private they can not.
1. It lets them see the forum
2. They have permissions to post
3. When they go to post it says that only members can view the topic in the review post section at the bottom.
4. If I try to grant a member personal access to that forum I get this error
Could not obtain moderator status
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 aa.group_id = ug.group_id AND aa.auth_mod = 1 GROUP BY ug.user_' at line 3
SELECT ug.user_id, COUNT(auth_mod) AS is_auth_mod FROM nuke_bbauth_access aa, nuke_bbuser_group ug WHERE ug.user_id IN () AND aa.group_id = ug.group_id AND aa.auth_mod = 1 GROUP BY ug.user_id
Line : 561
File : admin_ug_auth.php
I assume there is some problem with the user groups in the database. Can anyone tell me how to fix this issue? PLEASE keep in mind I am no programming guru so act like I am a nood, I am  |
| |
|
|
|
hicuxunicorniobestbuildpc
The Mouse Is Extension Of Arm
Joined: Aug 13, 2009
Posts: 1123
|
| Posted:
Fri Jan 08, 2010 7:26 pm |
|
|
|
|
|
Raven
Site Admin/Owner
Joined: Aug 27, 2002
Posts: 17088
|
| Posted:
Sat Jan 09, 2010 1:35 am |
|
|
|
|
|
jackalopehunter
|
| Posted:
Sat Jan 09, 2010 12:20 pm |
|
Thank you all.
Its hard when you are frustrated from trying to fix an issue to search the forums, specially when you are not sure what to search for. I see now that this is a common error.
This fixed the problem with getting a member access to a forum but, it did not fix the group access issue. If I go in and give a specific member access to the forum then it works. If I put the member in a group and give the group access they can see the thread but not post. They have access in the admin section of the forums. The member gets this error "Invalid Session. Please resubmit the form." |
Last edited by jackalopehunter on Sat Jan 09, 2010 1:01 pm; edited 1 time in total |
|
|
|
|
Raven
|
| Posted:
Sat Jan 09, 2010 12:59 pm |
|
Try searching the forum for Invalid Session like this:
or Click on this link: Only registered users can see links on this board! Get registered or login! |
| |
|
|
|
|
Raven
|
| Posted:
Sat Jan 09, 2010 1:05 pm |
|
unicornio, the email address that you have on file is incorrect. All attempted emails to you are bouncing. Please email to me your correct email address ASAP and I will change it. Thanks! |
| |
|
|
|
|
jackalopehunter
|
| Posted:
Sat Jan 09, 2010 1:26 pm |
|
OK this is not an IP issue.
1. I have setup 2 accounts to test this
A. The admin account can post
B. The user account setup on a group can not.
This is what they see at the bottom when they try to post. Normally this would be the topic they are posting on.
I tried changing the rnconfig file just to see and it makes no change to the error. Since both accounts are logged in from the same computer I don't think its an IP issue. |
| |
|
|
|
|
jackalopehunter
|
| Posted:
Sat Jan 09, 2010 1:45 pm |
|
OK I also tried the sessions.php change from 6 to 4 and this has not fixed this issue.
What am I doing wrong? It seems like a permissions issue. All of the people setup with higher access to the forums are working OK but the base users are not. 
If I make the user a moderator then all is good.
I checked one of my other sites that I am setting up with RavenNuke 2.4 and it has the same issue. Is this something I am not setting up correctly? Is there something different between the PHPBB on 2.3 and 2.4?
Here is a look at the usergroup permissions
 |
| |
|
|
|
|
jackalopehunter
|
| Posted:
Sat Jan 09, 2010 2:45 pm |
|
OK I guess if you beat your head against a wall long enough you will find the light. It may be from stars while you lay on the floor but its still the light.
The problem was in the cookies. The default install set it the forums cookies to .http://mysite.com and it really needed to be mysite.com. I have not run into this issue on the previous versions of RavenNuke and don't know if PHPBB changes something in the install or what.
Here is the post that I found the answer in.
| montego wrote: | If you move the site forward, you simply need to change the Site URL within Preferences and the Domain Name within the Forums configuration to match your new path.
Just remember that in Preferences the URL must have the "http://" in front, but in Forums configuration, leave OFF the "http://".
In addition, if you are using the .staccess file (CGIAuth) for NukeSentinel protection of your admin.php file, you will need to also fix the absolute path to that file in .htaccess. |
Thanks Raven for pointing me in the right direction. |
| |
|
|
|
|
Palbin
Site Admin
Joined: Mar 30, 2006
Posts: 2583
Location: Pittsburgh, Pennsylvania
|
| Posted:
Sun Jan 10, 2010 1:00 pm |
|
We are aware of the issue and it has been corrected for the next release. It may work with "mysite.com", but technically it should be .mysite.com and if you have a sub-domain it should be sub.mysite.com. If your site is working I would not worry about changing anything. |
_________________
"Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it." — Brian W. Kernighan. |
|
|
|
|
jackalopehunter
|
| Posted:
Mon Jan 11, 2010 10:49 am |
|
Thanks
I know that you guys work very hard to provide RavenNuke and tech support. I have installed RavenNuke on a number of sites and with each version it gets easier and better.
Thanks for everything. |
| |
|
|
|
|
|
|
. Try searching for 'SQL Error : 1064'. Here are a couple links:
![[Valid RSS]](https://www.ravenphpscripts.com/images/valid-rss.png "Validate my RSS feed"){kind=small}
