Moderation Queue Question

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Suggested Hosts
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
imagedude
Registered User
Posts: 296
Joined: Wed Sep 25, 2002 10:28 pm
Location: /home/kai
Name: Kai Ponte
Contact:

Moderation Queue Question

Post by imagedude » Mon Dec 05, 2011 8:01 pm

I am wondering what is going on. I have my board setup to moderate new posts from new users. In October, I noticed a user posting multiple spam posts. (I have teh question/challenge on registration, which has all but eliminated bots.)

I deleted the user but cannot delete the posts. My question is - where are the posts located? They don't seem to exist anywhere in the database.

I did find this topic - which was partially helpful.

http://www.phpbb.com/community/viewtopi ... &t=2123385





Support Request Template
What version of phpBB are you using? phpBB 3.0.9
What is your board's URL? http://www.ecmplace.com
Who do you host your board with? hostgator.com
How did you install your board? I used the download package from phpBB.com
Is your board a fresh install or a conversion? Update from a previous version of phpBB3
Do you have any MODs installed? No
Is registration required to reproduce this issue? No
What version of phpBB3 did you update from? phpBB 3.0.8
What styles do you currently have installed? Prosilver, serenity
What language(s) is your board currently using? English
Which database type/version are you using? MySQL 4
What is your level of experience? Experienced with PHP and phpBB
When did your problem begin? November 2011
Please describe your problem. I have some posts in the moderator queue, which I cannot delete. I have searched the database for them, but they don't exist. They are all spam and I have since deleted the user.

I looked at this topic - http://www.phpbb.com/community/viewtopi ... &t=2123385 - which appears to describe the same issue. The post id doesn't exist in the database. In fact, I don't even see a topic table anymore.

Maybe if I knew where these posts are being stored it would help.

TIA!
Generated by SRT Generator
Attachments
ScreenShot350.png
ScreenShot350.png (65.66 KiB) Viewed 394 times

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

Re: Moderation Queue Question

Post by stevemaury » Mon Dec 05, 2011 9:11 pm

Your serenity style is 6 version out-of-date. Just for laughs, switch to prosilver and see what happens. Also, you need to update serenity.

Are you saying there is no topics table in your database? Do the posts show up anywhere besides the moderation queue. How did you delete the user?
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)

imagedude
Registered User
Posts: 296
Joined: Wed Sep 25, 2002 10:28 pm
Location: /home/kai
Name: Kai Ponte
Contact:

Re: Moderation Queue Question

Post by imagedude » Tue Dec 06, 2011 12:04 am

Thank you for your answer.

I switched to prosilver and got the same message when deleting - "you are not authorized..."

As for the topics, yes. There seems to be no topics table. There used to be under PHPbb 2.x if I recall.
Attachments
ScreenShot351.png
ScreenShot351.png (27.62 KiB) Viewed 365 times

User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: Moderation Queue Question

Post by Oyabun1 » Tue Dec 06, 2011 12:39 am

Are you looking at the database with an interface such as phpMyAdmin? I've never heard of a functioning phpBB3 board without a topics table.
imagedude wrote:My question is - where are the posts located?
Posts are held in the posts table, but related details are held in other tables, such as the topics table. Unless you know what you are doing it is usually very unwise to delete things directly from the database.
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests

imagedude
Registered User
Posts: 296
Joined: Wed Sep 25, 2002 10:28 pm
Location: /home/kai
Name: Kai Ponte
Contact:

Re: Moderation Queue Question

Post by imagedude » Tue Dec 06, 2011 1:06 am

Oyabun1 wrote:Are you looking at the database with an interface such as phpMyAdmin? I've never heard of a functioning phpBB3 board without a topics tab.
that's what I figured. I'm using phpmyadmin as well as looking at a backup using Notepad++

Ill look again.

User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: Moderation Queue Question

Post by Oyabun1 » Tue Dec 06, 2011 3:56 am

The tables in your database will likely be shown with the table prefix as well, so it will be phpbb_topics you're looking for (assuming the default prefix of phpbb_).
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests

imagedude
Registered User
Posts: 296
Joined: Wed Sep 25, 2002 10:28 pm
Location: /home/kai
Name: Kai Ponte
Contact:

Re: Moderation Queue Question

Post by imagedude » Tue Dec 06, 2011 4:19 pm

Yeah, it is very odd. I used to be quite familiar with the phpBB structure. At one point I was running three sites with phpBB. This is my last one - almost ten years now.

The prefix I use has always been fs_. I just don't see a fs_topics table.

Could something have changed a few years back when converting from 2.x to 3.x?
Attachments
ScreenShot353.png
ScreenShot353.png (24.12 KiB) Viewed 312 times

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

Re: Moderation Queue Question

Post by stevemaury » Tue Dec 06, 2011 5:32 pm

What is the table prefix in your config.php file? And you need to scroll down in that list of tables.
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)

imagedude
Registered User
Posts: 296
Joined: Wed Sep 25, 2002 10:28 pm
Location: /home/kai
Name: Kai Ponte
Contact:

Re: Moderation Queue Question

Post by imagedude » Tue Dec 06, 2011 9:38 pm

Thanks for checking.

The prefix is "fs_" and there are listed 29 tables.

fs_acl_groups
fs_acl_options
fs_acl_roles
fs_acl_roles_data
fs_acl_users
fs_attachments
fs_banlist
fs_bbcodes
fs_bookmarks
fs_bots
fs_config
fs_confirm
fs_disallow
fs_drafts
fs_extensions
fs_extension_groups
fs_forums
fs_forums_access
fs_forums_track
fs_forums_watch
fs_groups
fs_icons
fs_lang
fs_log
fs_moderator_cache
fs_modules
fs_poll_options
fs_poll_votes
fs_posts

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

Re: Moderation Queue Question

Post by Brf » Tue Dec 06, 2011 9:49 pm

That is only the first page of a multi-page listing

imagedude
Registered User
Posts: 296
Joined: Wed Sep 25, 2002 10:28 pm
Location: /home/kai
Name: Kai Ponte
Contact:

Re: Moderation Queue Question

Post by imagedude » Tue Dec 06, 2011 9:59 pm

That's what I was wondering also, except, I did a SQL dump and only see those tables.
Attachments
ecmplace_main.sql.txt
SQL schema of ecmplace.com
(24.69 KiB) Downloaded 3 times

imagedude
Registered User
Posts: 296
Joined: Wed Sep 25, 2002 10:28 pm
Location: /home/kai
Name: Kai Ponte
Contact:

Re: Moderation Queue Question

Post by imagedude » Tue Dec 06, 2011 10:00 pm

Do'oh!

I just figured it out.

I'd forgotten that i started with another domain name in '02 and then switched in '06. I kept the original phpBB tables under the old domain. They still reside there.

All the tables exist in filesite.org.

I'll look for the topics table now.

Sorry about all that!!!

Locked

Return to “[3.0.x] Support Forum”