phpBB 3.2.2 group forum permission: can see forum NO SQL ERROR [ mysqli ] [0]

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
User avatar
Neuropass
Registered User
Posts: 1158
Joined: Fri Apr 17, 2009 2:02 pm
Location: SciTE4AutoIt3

phpBB 3.2.2 group forum permission: can see forum NO SQL ERROR [ mysqli ] [0]

Post by Neuropass » Thu Mar 01, 2018 5:57 pm

This doesn't work any longer:

viewtopic.php?p=13114641#p13114641



Fresh board, set group permission to:
group forum permission for Guests: "can see forum NO"

you get:

Code: Select all

SQL ERROR [ mysqli ]

[0]

is this a bug on 3.2.2?
Last edited by Neuropass on Thu Mar 01, 2018 6:47 pm, edited 1 time in total.

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 50571
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: phpBB 3.2.2 group forum permission: can see forum NO SQL ERROR [ mysqli ] [0]

Post by stevemaury » Thu Mar 01, 2018 6:23 pm

It still works. There is no bug. Please fill out the Support Request Template and post it back here to enable us to assist you better.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)

User avatar
Neuropass
Registered User
Posts: 1158
Joined: Fri Apr 17, 2009 2:02 pm
Location: SciTE4AutoIt3

Re: phpBB 3.2.2 group forum permission: can see forum NO SQL ERROR [ mysqli ] [0]

Post by Neuropass » Thu Mar 01, 2018 6:46 pm

what do you mean its not a bug? It returns a MySQL error. Its a clean board installation, 3.2.2.
Surely not working as intended? or am I missing anything?


Why do I need to file a template when its explained in the post?
anyway


Support Request Template
What version of phpBB are you using? phpBB 3.2.2
What is your board's URL? No answer given
Who do you host your board with? No answer given
How did you install your board? I used the download package from phpBB.com
What is the most recent action performed on your board? Fresh Install
Is registration required to reproduce this issue? No
Do you have any MODs installed? No
Do you have any extensions installed? No
What styles do you currently have installed? Prosilver
What language(s) is your board currently using? EN
Which database type/version are you using? MySQL 5
What is your level of experience? New to PHP but not phpBB
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? Fresh install
Please describe your problem. group forum permission for Guests: "can see forum NO"

you get:

SQL ERROR [ mysqli ]

[0]
Generated by SRT Generator

User avatar
kinerity
Community Team Member
Community Team Member
Posts: 2308
Joined: Mon Sep 01, 2014 1:00 am
Location: sudo rm -rf /
Name: Kailey Truscott
Contact:

Re: phpBB 3.2.2 group forum permission: can see forum NO SQL ERROR [ mysqli ] [0]

Post by kinerity » Fri Mar 02, 2018 3:13 am

When do you get that error? I was just able to set that permission with no issue.
Kailey Truscott - Community Team

User avatar
Neuropass
Registered User
Posts: 1158
Joined: Fri Apr 17, 2009 2:02 pm
Location: SciTE4AutoIt3

Re: phpBB 3.2.2 group forum permission: can see forum NO SQL ERROR [ mysqli ] [0]

Post by Neuropass » Fri Mar 02, 2018 4:13 am

yes sets fine. But now when you visit the board as a guest and try to visit viewtopic page you get the error.

User avatar
kinerity
Community Team Member
Community Team Member
Posts: 2308
Joined: Mon Sep 01, 2014 1:00 am
Location: sudo rm -rf /
Name: Kailey Truscott
Contact:

Re: phpBB 3.2.2 group forum permission: can see forum NO SQL ERROR [ mysqli ] [0]

Post by kinerity » Fri Mar 02, 2018 4:26 am

I still can't reproduce this. I was able to set the permission and then view a topic as a guest. It has to be an error on your board, not a bug in the software.
Kailey Truscott - Community Team

User avatar
Neuropass
Registered User
Posts: 1158
Joined: Fri Apr 17, 2009 2:02 pm
Location: SciTE4AutoIt3

Re: phpBB 3.2.2 group forum permission: can see forum NO SQL ERROR [ mysqli ] [0]

Post by Neuropass » Fri Mar 02, 2018 1:10 pm

but its a fresh install.
PHP 7.0.22 and MySQL 5.7.21

User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21034
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: phpBB 3.2.2 group forum permission: can see forum NO SQL ERROR [ mysqli ] [0]

Post by RMcGirr83 » Fri Mar 02, 2018 1:44 pm

Is it a main forum or sub forum or a sub forum of a sub forum?

Why not post a link to the forum, as guests we will see the error.
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored

User avatar
kinerity
Community Team Member
Community Team Member
Posts: 2308
Joined: Mon Sep 01, 2014 1:00 am
Location: sudo rm -rf /
Name: Kailey Truscott
Contact:

Re: phpBB 3.2.2 group forum permission: can see forum NO SQL ERROR [ mysqli ] [0]

Post by kinerity » Fri Mar 02, 2018 3:08 pm

Neuropass wrote:
Thu Mar 01, 2018 6:46 pm
What is your board's URL? No answer given
It would be really helpful to provide a link to your board so we can see the issue. It's not reproducible on our end.
Kailey Truscott - Community Team

User avatar
Leinad4Mind
Translator
Posts: 851
Joined: Sun Jun 01, 2008 11:08 pm
Contact:

Re: phpBB 3.2.2 group forum permission: can see forum NO SQL ERROR [ mysqli ] [0]

Post by Leinad4Mind » Thu May 10, 2018 10:31 am

The error exist. I've a clean board too at 3.2.2. That means only Your first forum inside Your first category

Go to ACP - Permisions - Permission Roles - Forum Roles -> Select "Read Only Access"

I've all to No except Actions Tab where I've some at Yes:

Image

Then go to : /viewforum.php?f=2 as a guest and puff error WILL appear.

Basically, if "Can see topics" is YES and "Can read forum" is NO = Error.
But, If "Can see topics" is NO and "Can read forum" is NO = Works.

And here you've the PR that create this bug: https://github.com/phpbb/phpbb/pull/4973

And to be more precise:
if (!$auth->acl_gets('f_read', 'f_list_topics', $forum_id))
{
$template->assign_vars(array(
'S_NO_READ_ACCESS' => true,
));

page_footer();
}
Solution? Easy Peazy:

If that if returns false it will bug, so we need an else statement. So After that if we add:

Code: Select all

else
{
	$template->assign_vars(array(
		'S_NO_READ_ACCESS'		=> false,
	));

	page_footer();
}
Problem solved. ;) You're welcomed. :geek:
Want to access all my portuguese MOD and Extension translations?
Become my Patreon!
phpBB Portugal Translator and Moderator

User avatar
Leinad4Mind
Translator
Posts: 851
Joined: Sun Jun 01, 2008 11:08 pm
Contact:

Re: phpBB 3.2.2 group forum permission: can see forum NO SQL ERROR [ mysqli ] [0]

Post by Leinad4Mind » Thu May 24, 2018 8:49 am

Just to inform that today I had some extra time and I opened a new ticket on the tracker about this: https://tracker.phpbb.com/browse/PHPBB3-15670
Want to access all my portuguese MOD and Extension translations?
Become my Patreon!
phpBB Portugal Translator and Moderator

Senky
Extension Customisations
Extension Customisations
Posts: 2124
Joined: Thu Apr 30, 2009 8:49 pm
Name: Jakub
Contact:

Re: phpBB 3.2.2 group forum permission: can see forum NO SQL ERROR [ mysqli ] [0]

Post by Senky » Mon Jun 18, 2018 10:05 am

I followed your instructions but couldn't reproduce the SQL error...

User avatar
kamaleon
Registered User
Posts: 500
Joined: Tue Sep 09, 2014 9:47 am
Location: Barcelona

Re: phpBB 3.2.2 group forum permission: can see forum NO SQL ERROR [ mysqli ] [0]

Post by kamaleon » Tue Jun 26, 2018 4:24 pm

Just change from Can read forum from Yes to No and you will see the error.

I also reported this long ago in here

viewtopic.php?f=556&t=2470616

User avatar
Leinad4Mind
Translator
Posts: 851
Joined: Sun Jun 01, 2008 11:08 pm
Contact:

Re: phpBB 3.2.2 group forum permission: can see forum NO SQL ERROR [ mysqli ] [0]

Post by Leinad4Mind » Tue Jun 26, 2018 6:34 pm

Kamaleon, it was already solved by senky. Just take a look to the tracker link above. ;)
Want to access all my portuguese MOD and Extension translations?
Become my Patreon!
phpBB Portugal Translator and Moderator

User avatar
kamaleon
Registered User
Posts: 500
Joined: Tue Sep 09, 2014 9:47 am
Location: Barcelona

Re: phpBB 3.2.2 group forum permission: can see forum NO SQL ERROR [ mysqli ] [0]

Post by kamaleon » Tue Jun 26, 2018 7:15 pm

Great.

It will be solved in the next release then?

Post Reply

Return to “[3.2.x] Support Forum”