Search found 17 matches

by arclight
Mon Jun 17, 2019 9:51 pm
Forum: [3.2.x] Support Forum
Topic: Posts not publicly visible / bulk approve posts? (Updated 3.1-3.2- All posts need approval)
Replies: 8
Views: 594

Re: Posts not publicly visible / bulk approve posts? (Updated 3.1-3.2- All posts need approval)

Ok, will do that, but first things to consider are: 1. Posts I approved manually, show up properly - publicly visible to all users incl anonymous/guest, which is what I want. 2. After running Stevemaury's MySQL query above in the thread to shortcut approval of the remaining tens of thousands of post...
by arclight
Mon Jun 17, 2019 8:45 pm
Forum: [3.2.x] Support Forum
Topic: Posts not publicly visible / bulk approve posts? (Updated 3.1-3.2- All posts need approval)
Replies: 8
Views: 594

Re: How to bulk approve posts? (Updated 3.1-3.2- All posts now need approval)

Bumping this one again.

Still cant see all posts unless logged in as Admin so some flag still left to change for full public visibility.

Thanks.
by arclight
Sat Jun 08, 2019 10:13 pm
Forum: [3.2.x] Support Forum
Topic: Posts not publicly visible / bulk approve posts? (Updated 3.1-3.2- All posts need approval)
Replies: 8
Views: 594

Re: How to bulk approve posts? (Updated 3.1-3.2- All posts now need approval)

Bump... Posts are still not visible to public or regular users when logged out of admin account. Thanks
by arclight
Sat Jun 08, 2019 6:54 am
Forum: [3.2.x] Support Forum
Topic: Replies count shows -1 after upgrading 3.1-3.2. How to repair/refresh?
Replies: 9
Views: 298

Re: Replies count shows -1 after upgrading 3.1-3.2. How to repair/refresh?

Ok did that, results are below... Showing rows 0 - 24 (89 total, Query took 0.0005 seconds.) SELECT `topic_posts_approved` FROM `topics` WHERE `forum_id` = 8 GROUP BY `topic_id` Profiling [Edit inline] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh] | Show all | Number of rows: Filter rows: ...
by arclight
Sat Jun 08, 2019 5:05 am
Forum: [3.2.x] Support Forum
Topic: Replies count shows -1 after upgrading 3.1-3.2. How to repair/refresh?
Replies: 9
Views: 298

Re: Replies count shows -1 after upgrading 3.1-3.2. How to repair/refresh?

Yep, did a resync from the ACP - post counts, stats, and dotted topics.

No change. Threads still show -1 replies across the board. Any ideas?
by arclight
Fri Jun 07, 2019 6:21 pm
Forum: [3.2.x] Support Forum
Topic: Replies count shows -1 after upgrading 3.1-3.2. How to repair/refresh?
Replies: 9
Views: 298

Replies count shows -1 after upgrading 3.1-3.2. How to repair/refresh?

I recently upgraded and now when viewing a forum, it will show the proper number of views next to a topic, but will show -1 as the number of replies, for all topics.

How to I fix this or force a refresh to recalculate the number or replies correctly? Thanks.
by arclight
Wed Jun 05, 2019 11:45 pm
Forum: [3.2.x] Support Forum
Topic: Posts not publicly visible / bulk approve posts? (Updated 3.1-3.2- All posts need approval)
Replies: 8
Views: 594

Re: How to bulk approve posts? (Updated 3.1-3.2- All posts need approval)

Executing SQL Queries in phpMyAdmin UPDATE phpbb_posts SET post_visibility = 1 WHERE post_visibility = 0; UPDATE phpbb_topics SET topic_visibility = 1 WHERE topic_visibility = 0; If your table prefix is not phpbb_ change accordingly and backup both tables first. Ok thanks. UPDATE: I ran the query a...
by arclight
Wed Jun 05, 2019 5:17 pm
Forum: [3.2.x] Support Forum
Topic: Posts not publicly visible / bulk approve posts? (Updated 3.1-3.2- All posts need approval)
Replies: 8
Views: 594

Posts not publicly visible / bulk approve posts? (Updated 3.1-3.2- All posts need approval)

I recently updated from 3.1 to 3.2 via command line and it appears not everything took correctly. Now, all my old posts are unapproved and need to be approved via the MCP to appear. I have tens of thousands of old posts so doing it via the MCP would take forever. Is there any way to approve them in ...
by arclight
Wed Jun 05, 2019 5:12 pm
Forum: [3.2.x] Support Forum
Topic: FIXED - Updated 3.1-3.2. Now all posts and topics are gone
Replies: 1
Views: 134

Re: Updated 3.1-3.2. Now all posts and topics are gone

Fixed - had to go into admin control panel, and re-do all the forum permissions and re-save them, since they didnt take with the database update. Now posts and topics appear.
by arclight
Wed Jun 05, 2019 4:23 pm
Forum: [3.2.x] Support Forum
Topic: FIXED - Updated 3.1-3.2. Now all posts and topics are gone
Replies: 1
Views: 134

FIXED - Updated 3.1-3.2. Now all posts and topics are gone

hi everyone. I recently updated from 3.1 to the latest 3.2. I uploaded the new files via FTP and since the old board was gigantic, I did the DB update via command line instead of via browser. It completed successfully. However now when I go to my board, it does show the right forum names and site na...
by arclight
Fri May 31, 2019 5:56 am
Forum: [3.2.x] Support Forum
Topic: Upgrade stops at 26% - A module already exist: UCP_AUTH_LINK_MANAGE
Replies: 1
Views: 138

Upgrade stops at 26% - A module already exist: UCP_AUTH_LINK_MANAGE

This is EXACTLY the same issue as in this old thread: https://www.phpbb.com/community/viewtopic.php?t=2465686 My error is exactly the same and stopped at exactly the same point, at 26%, with the same error. There was never a resolution to the thread. Anyone have any ideas on how to get it sorted? We...
by arclight
Wed Apr 24, 2002 2:06 am
Forum: 2.0.x Support Forum
Topic: Import from UBB - messages not in date order. Help.
Replies: 4
Views: 176

top

Go to advanced search