Page 1 of 1

Moderation Queue Question

Posted: Mon Dec 05, 2011 8:01 pm
by imagedude
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

Re: Moderation Queue Question

Posted: Mon Dec 05, 2011 9:11 pm
by stevemaury
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?

Re: Moderation Queue Question

Posted: Tue Dec 06, 2011 12:04 am
by imagedude
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.

Re: Moderation Queue Question

Posted: Tue Dec 06, 2011 12:39 am
by Oyabun1
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.

Re: Moderation Queue Question

Posted: Tue Dec 06, 2011 1:06 am
by imagedude
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.

Re: Moderation Queue Question

Posted: Tue Dec 06, 2011 3:56 am
by Oyabun1
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_).

Re: Moderation Queue Question

Posted: Tue Dec 06, 2011 4:19 pm
by imagedude
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?

Re: Moderation Queue Question

Posted: Tue Dec 06, 2011 5:32 pm
by stevemaury
What is the table prefix in your config.php file? And you need to scroll down in that list of tables.

Re: Moderation Queue Question

Posted: Tue Dec 06, 2011 9:38 pm
by imagedude
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

Re: Moderation Queue Question

Posted: Tue Dec 06, 2011 9:49 pm
by Brf
That is only the first page of a multi-page listing

Re: Moderation Queue Question

Posted: Tue Dec 06, 2011 9:59 pm
by imagedude
That's what I was wondering also, except, I did a SQL dump and only see those tables.

Re: Moderation Queue Question

Posted: Tue Dec 06, 2011 10:00 pm
by imagedude
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!!!