4 strange guest posts dated 1/1/1970

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)
thancock
Registered User
Posts: 7
Joined: Fri Aug 01, 2008 7:25 pm

4 strange guest posts dated 1/1/1970

Post by thancock » Thu May 14, 2009 6:15 pm

Support Request Template
What version of phpBB are you using? phpBB 3.0.3
What is your board's URL? http://frontforum.westernfrontassociation.com
Who do you host your board with? Zen Internet
How did you install your board? I used the download package from phpBB.com
Is your board a fresh install or a conversion? Fresh Install
Do you have any MODs installed? No
Please describe your problem. On the first (oldest) page of this sub-forum: http://frontforum.westernfrontassociati ... &start=125 there are four posts in Russian by people who are not registered users. The posts are dated Thurs, Jan 01 1970 1.00am. No replies and no views. The entries are shown as "Guest".

I am wondering how did they get there? I have checked this forums permissions and guests have read-only as far as I can tell.

Can I trace these posts in a log to see how recent they might be? I had a lot of problem with spam posts recently until I added additional registration questions.

The Board opened in September 2008.

Any help will be gratefully received.

Many thanks

David
What styles do you currently have installed? FI Subice plus usual out of the box
What language(s) is your board currently using? English
Which database type/version are you using? MySQL 5
What is your level of experience? Comfortable with PHP and phpBB
Generated by SRT Generator ($Rev: 2968 $)

User avatar
Mick
Support Team Member
Support Team Member
Posts: 21659
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff

Re: 4 strange guest posts dated 1/1/1970

Post by Mick » Thu May 14, 2009 6:53 pm

The question is how do they post if they aren't registered?

They have obviously sussed whatever anti-spam methods you have at the moment.
"The more connected we get the more alone we become" - Kyle Broflovski

User avatar
citricsquid
Registered User
Posts: 74
Joined: Sat Nov 10, 2007 1:07 pm

Re: 4 strange guest posts dated 1/1/1970

Post by citricsquid » Thu May 14, 2009 7:06 pm

Mixstar wrote:The question is how do they post if they aren't registered?

They have obviously sussed whatever anti-spam methods you have at the moment.
If the board hasn't got guest posts enabled, this wouldn't be possible. The way phpbb is set up - afaik - it doesn't allow anyone who isn't logged in to post, whether or not they get past anti spam (which is just for registration?).

Could it be that the posters were deleted, but the posts were saved and something happened to the date of the posts - Could it have been corrupt due to an upgrade?

User avatar
Mick
Support Team Member
Support Team Member
Posts: 21659
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff

Re: 4 strange guest posts dated 1/1/1970

Post by Mick » Thu May 14, 2009 7:09 pm

citricsquid wrote:Could it have been corrupt due to an upgrade?
But in Russian?
"The more connected we get the more alone we become" - Kyle Broflovski

User avatar
Dog Cow
Registered User
Posts: 2495
Joined: Fri Jan 28, 2005 12:14 am
Contact:

Re: 4 strange guest posts dated 1/1/1970

Post by Dog Cow » Thu May 14, 2009 10:23 pm

citricsquid wrote: Could it be that the posters were deleted, but the posts were saved and something happened to the date of the posts - Could it have been corrupt due to an upgrade?
Yes. Are you saying that you upgraded from version 2?
Moof!
Mac GUI Vault: Retro Apple II & Macintosh computing archive.
Inside Allerton bookMac GUIMac 512K Blog

thancock
Registered User
Posts: 7
Joined: Fri Aug 01, 2008 7:25 pm

Re: 4 strange guest posts dated 1/1/1970

Post by thancock » Thu May 14, 2009 10:30 pm

Hi All,

Thank you for the replies

Apologies, I can't remember if this was a 2.0 to 3.0 upgrade. I suspect not. I will check out and post back.

But why there in that thread only, and they've only just been noticed?

As I mentioned, is there any way I can track these entries to find when they actually occurred?

I don't want to open them just yet.

I can get into MySQL vis PHPMyAdmin, just need to know where to look.

Kind regards

David

User avatar
ric323
Former Team Member
Posts: 22909
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric
Contact:

Re: 4 strange guest posts dated 1/1/1970

Post by ric323 » Thu May 14, 2009 10:32 pm

All four posts give "The requested topic does not exist." if you try to read them.
The post authors are NOT guests, they are all registered users. It is just the "last post" field that is showing as "guest".
Has anyone been accessing your database directly in an attempt to "clean up" spam?
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions

thancock
Registered User
Posts: 7
Joined: Fri Aug 01, 2008 7:25 pm

Re: 4 strange guest posts dated 1/1/1970

Post by thancock » Thu May 14, 2009 10:52 pm

Hi Ric

Many thanks.

Nope, I am the only admin and I have never been into the MySQL DB to amend anything directly.

I know some Mods have deleted posts and tried to ban users when we suffered a lot of spam, but I am the only one who can actually delete a user. They use the mod tools, I go via the ACP.

Ah, now, I looked at the first one and there is no "Q" entry for him/her. The second IS shown as a reg user. But nothing for the other two either.

Curious.

Kind regards

David

thancock
Registered User
Posts: 7
Joined: Fri Aug 01, 2008 7:25 pm

Re: 4 strange guest posts dated 1/1/1970

Post by thancock » Fri May 15, 2009 10:30 am

Hi Ric, All,

Can anyone please advise the optimal way to remove these posts (that don't exist) from the Board?

Many thanks

David

User avatar
ric323
Former Team Member
Posts: 22909
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric
Contact:

Re: 4 strange guest posts dated 1/1/1970

Post by ric323 » Fri May 15, 2009 10:34 am

Have you tried to delete them using the MCP (Moderator Control Panel)?
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions

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

Re: 4 strange guest posts dated 1/1/1970

Post by RMcGirr83 » Fri May 15, 2009 10:37 am

I have run across the "topic doesn't exist" thing. I believe you will find that either in the topics table the topic is not set as "approved" and/or the post is not set as "approved" in the posts table. How it would happen though, I haven't an idea.
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

thancock
Registered User
Posts: 7
Joined: Fri Aug 01, 2008 7:25 pm

Re: 4 strange guest posts dated 1/1/1970

Post by thancock » Fri May 15, 2009 12:48 pm

Hi Guys,

Thanks for suggestions.

I went to the ACP to delete the one user shown as registered and when I emerged back to the sub-forum he was still there, although I checked and now gone as a registered user.

I then followed the suggestion to delete all four via the Mod Control Panel for that sub-forum. Here's the result:

Code: Select all

SQL ERROR [ mysql4 ]

Incorrect string value: '\xD0\xA1\xD0\xB0\xD0\xBC...' for column 'log_data' at row 1 [1366]

SQL

INSERT INTO phpbb_log (user_id, log_ip, log_time, log_operation, log_data, log_type, forum_id, topic_id) VALUES ('2', '217.155.204.227', 1242391362, 'LOG_TOPIC_DELETED', 'a:1:{i:0;s:38:\"Самые обычные газеты\";}', 1, 31, 0)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/functions.php
LINE: 2710
CALL: dbal_mysql->sql_query()

FILE: includes/mcp/mcp_main.php
LINE: 784
CALL: add_log()

FILE: includes/mcp/mcp_main.php
LINE: 119
CALL: mcp_delete_topic()

FILE: includes/functions_module.php
LINE: 471
CALL: mcp_main->main()

FILE: mcp.php
LINE: 231
CALL: p_master->load_active()

Please notify the board administrator or webmaster: we
Any thoughts?

David

User avatar
ric323
Former Team Member
Posts: 22909
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric
Contact:

Re: 4 strange guest posts dated 1/1/1970

Post by ric323 » Fri May 15, 2009 12:54 pm

Hmmm, that error usually means the board was installed by Fantastico, or the web host has updated your MySQL from what was there when you installed phpBB.
Either way, the fix is in here: Knowledge Base - Doesn't have a default value errors
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions

thancock
Registered User
Posts: 7
Joined: Fri Aug 01, 2008 7:25 pm

Re: 4 strange guest posts dated 1/1/1970

Post by thancock » Fri May 15, 2009 4:13 pm

You're right - a Fantastico install.

And an upgrade to PHP too from 4 to 5 if I recall correctly subsequently.

Many thanks for this. I will have a good look at it when I next get a couple of mins.

Thanks for all the help - appreciated.

Best wishes

david

Little-Angel
Registered User
Posts: 1
Joined: Mon Dec 29, 2014 8:03 pm

Re: 4 strange guest posts dated 1/1/1970

Post by Little-Angel » Mon Dec 29, 2014 8:11 pm

In case someone stumbles on this post:

I found these post and I believe they are created when the spam-bot sends to post data and does not include a time stamp the same way a browser would if it had been a legitimate user posting on their computer.

After deleting all of the spam users and deleting their posts, many of these were left as posts from a guest that could not be accessed or deleted with error messages like "You don't have permissions / authorisation to access this area" or "This post does not exist".

The way I removed these was to access the ACP and synchronise the forums. I found I had to do the synch on every level and in some cases to it several times.

Locked

Return to “[3.0.x] Support Forum”