Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> v2.4 RN Issues
Author Message
jackalopehunter
New Member
New Member


Joined: Feb 25, 2009
Posts: 16

PostPosted: Fri Jan 08, 2010 6:53 pm Reply with quote

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 Very Happy
 
View user's profile Send private message
hicuxunicorniobestbuildpc
Life Cycles Becoming CPU Cycles


Joined: Aug 13, 2009
Posts: 967
Location: Netherland

PostPosted: Fri Jan 08, 2010 7:26 pm Reply with quote

Run this
Only registered users can see links on this board! Get registered or login!

I suppose you have this file fixgroup.php

This fix will solve your problem.

replace mysite with your domain name
 
View user's profile Send private message Visit poster's website
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17086

PostPosted: Sat Jan 09, 2010 1:35 am Reply with quote

This has been answered many times in this forum over the years Smile. Try searching for 'SQL Error : 1064'. Here are a couple links:
Only registered users can see links on this board! Get registered or login! Only registered users can see links on this board! Get registered or login!
 
View user's profile Send private message
jackalopehunter
PostPosted: Sat Jan 09, 2010 12:20 pm Reply with quote

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
PostPosted: Sat Jan 09, 2010 12:59 pm Reply with quote

Try searching the forum for Invalid Session like this:

Image

or Click on this link: Only registered users can see links on this board! Get registered or login!
 
Raven
PostPosted: Sat Jan 09, 2010 1:05 pm Reply with quote

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
PostPosted: Sat Jan 09, 2010 1:26 pm Reply with quote

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.

Image

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
PostPosted: Sat Jan 09, 2010 1:45 pm Reply with quote

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. Bang Head

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

Image
 
jackalopehunter
PostPosted: Sat Jan 09, 2010 2:45 pm Reply with quote

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

PostPosted: Sun Jan 10, 2010 1:00 pm Reply with quote

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. 
View user's profile Send private message
jackalopehunter
PostPosted: Mon Jan 11, 2010 10:49 am Reply with quote

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.
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> v2.4 RN Issues

View next topic
View previous 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
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©