Categories and forums not showing on index

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
User avatar
Lumpy Burgertushie
Registered User
Posts: 64852
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Categories and forums not showing on index

Post by Lumpy Burgertushie » Tue Apr 24, 2018 3:33 pm

check the board to see if you can see the forums now.
purge the cache first.
robert
I am available for custom work on a donation basis. Please send me a PM with your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

OK, so what's the speed of dark?

x-rated
Registered User
Posts: 25
Joined: Mon Dec 29, 2014 2:52 pm
Location: Prague

Re: Categories and forums not showing on index

Post by x-rated » Tue Apr 24, 2018 4:12 pm

tried Purge the cache, Purge all sessions, but no change :|

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

Re: Categories and forums not showing on index

Post by stevemaury » Tue Apr 24, 2018 4:42 pm

Does the Registered user group have a Standard access permission role on the categories nd forums?
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. PM or email me.

All unsolicited PMs will be ignored.

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51308
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Categories and forums not showing on index

Post by Brf » Tue Apr 24, 2018 5:33 pm

The new user I created is the only one in the Registered Users. The admin user is still not a member.

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

Re: Categories and forums not showing on index

Post by stevemaury » Tue Apr 24, 2018 5:56 pm

What is the user_id of the member you created?
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. PM or email me.

All unsolicited PMs will be ignored.

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51308
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Categories and forums not showing on index

Post by Brf » Tue Apr 24, 2018 7:31 pm

x-rated is user #3 oddly enough. I wonder how that happened.
xxx is #95

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

Re: Categories and forums not showing on index

Post by stevemaury » Tue Apr 24, 2018 7:42 pm

OK, try this SQL:

Code: Select all

INSERT INTO phpbb_user_group (group_id, user_id, group_leader, user_pending) VALUES (2, 3, 1, 0) ;
INSERT INTO phpbb_user_group (group_id, user_id, group_leader, user_pending) VALUES (4, 3, 1, 0) ;
INSERT INTO phpbb_user_group (group_id, user_id, group_leader, user_pending) VALUES (5, 3, 1, 0) ;
UPDATE phpbb_users SET group_id = 2 WHERE user_id = 3;
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. PM or email me.

All unsolicited PMs will be ignored.

x-rated
Registered User
Posts: 25
Joined: Mon Dec 29, 2014 2:52 pm
Location: Prague

Re: Categories and forums not showing on index

Post by x-rated » Wed Apr 25, 2018 4:46 pm

i have done this, cleared cache & sessions and something has changed, now i can see private messages link, visit user profiles and probably something else :)
+ i gave you admin rights on account xxx if you want to check it out in ACP and db access in pm there

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51308
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Categories and forums not showing on index

Post by Brf » Wed Apr 25, 2018 6:58 pm

Now you are only a member of Coppa Users. It looks like your numbering is all wrong. Are you sure you used the package downloaded from here?

I am betting your auto-increment is set to 2, instead of 1. Your The Team page is showing Coppa Users, rather than Administrators, and it is showing Guest as a member of that group. If your numbering is off, the wrong groups are getting the defaults.

x-rated
Registered User
Posts: 25
Joined: Mon Dec 29, 2014 2:52 pm
Location: Prague

Re: Categories and forums not showing on index

Post by x-rated » Wed Apr 25, 2018 7:47 pm

im 101% sure, i always download it from phpbb.com
if you wanna try it yourself, i can create ftp access for you
i tried already manytimes, but always with same result on this webhosting
or do you have any idea what can be wrong with this webhosting? some database numbering or... i dont know :D i can ask webhosting company to check it out

x-rated
Registered User
Posts: 25
Joined: Mon Dec 29, 2014 2:52 pm
Location: Prague

Re: Categories and forums not showing on index

Post by x-rated » Thu Apr 26, 2018 11:32 am

i have info from webhosting company
it seems there is definitely problem with IDs assigning which is caused by mysql master-master replication with another machine
autoincrement on webhosting cant be modified and they are asking if you know any solution for such problem :(

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51308
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Categories and forums not showing on index

Post by Brf » Thu Apr 26, 2018 11:54 am

Yes. Get a proper host.

x-rated
Registered User
Posts: 25
Joined: Mon Dec 29, 2014 2:52 pm
Location: Prague

Re: Categories and forums not showing on index

Post by x-rated » Thu Apr 26, 2018 1:15 pm

told them, here is reply:
this database setting is absolutely standard and ensures high endurance against outages
same problem has prestashop, but without any solution yet
this phpbb issue with auto-increment is mentioned here https://tracker.phpbb.com/browse/PHPBB3-7215 and closed because of some other database incompatibility

but the question is - is this problem from 2014 still relevant? or current databases already support this feature and can be fixed?

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

Re: Categories and forums not showing on index

Post by stevemaury » Thu Apr 26, 2018 2:05 pm

Run this SQL and report the results:

Code: Select all

SELECT group_id, group_name FROM phpbb_groups WHERE group_type = 3
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. PM or email me.

All unsolicited PMs will be ignored.

x-rated
Registered User
Posts: 25
Joined: Mon Dec 29, 2014 2:52 pm
Location: Prague

Re: Categories and forums not showing on index

Post by x-rated » Thu Apr 26, 2018 2:10 pm

groups.png

Post Reply

Return to “[3.2.x] Support Forum”

Who is online

Users browsing this forum: brado23, invenio, janurmas and 23 guests