Side 7 spammer  
Error: Error in: Library_global::do_standard_query Line 547
Query Execution failed!
Got error 28 from storage engine
SQL Statement -- SELECT user_accounts.*, user_account_personal_info.*, user_account_system_info.*, access_control_list.*, SUM(account_credit_transactions.amount) as account_credits, user_accounts.id as user_account_id, user_account_personal_info.modified_date as personal_info_modified_date FROM user_accounts LEFT JOIN user_account_personal_info ON user_account_personal_info.user_account_id = user_accounts.id LEFT JOIN user_account_system_info ON user_account_system_info.user_account_id = user_accounts.id LEFT JOIN access_control_list ON access_control_list.id = user_accounts.access_control_list_id LEFT JOIN account_credit_transactions ON account_credit_transactions.user_account_id = user_accounts.id WHERE user_accounts.id = ? GROUP BY account_credit_transactions.user_account_id
Parameters -- 2
Error: Error in: Library_global::do_standard_query Line 547
Query Execution failed!
Got error 28 from storage engine
SQL Statement -- SELECT user_accounts.*, user_account_personal_info.*, user_account_system_info.*, access_control_list.*, SUM(account_credit_transactions.amount) as account_credits, user_accounts.id as user_account_id, user_account_personal_info.modified_date as personal_info_modified_date FROM user_accounts LEFT JOIN user_account_personal_info ON user_account_personal_info.user_account_id = user_accounts.id LEFT JOIN user_account_system_info ON user_account_system_info.user_account_id = user_accounts.id LEFT JOIN access_control_list ON access_control_list.id = user_accounts.access_control_list_id LEFT JOIN account_credit_transactions ON account_credit_transactions.user_account_id = user_accounts.id WHERE user_accounts.id = ? GROUP BY account_credit_transactions.user_account_id
Parameters -- 4095
Update Profile · Private Messages · Manage Watched Threads

Forum IndexSite FeedbackBug Reports
spammer


Page 7 of 8 :: Viewing 61-70 of 72 4 5 6 7 8

BadKarma

File could not be found or doesn't exist.

Total Posts: 553
Subject: RE: spammer Posted: 24 Mar 2018 - 20:36 ET



Hey guys. I'm truly sorry you all are experiencing this. It's utterly frustrating for me, too. I've put some security in place against it, and they keep finding ways around it. I'm going to make some additional changes, probably tonight. And I'm going to see if I can add in a delete comment feature, too.

-- BK


My Side 7 Gallery | Personal Site
Zentron

File could not be found or doesn't exist.

Total Posts: 44
Subject: RE: spammer Posted: 25 Mar 2018 - 23:46 ET



A 'Delete Comment' feature would be a welcome addition, preferably in the Image Management area, as the messages themselves in the gallery view kinda make the browser flip out and blocks the page from displaying. So a 'Delete Comment' or 'Manage Comments' feature would be very very useful!
BadKarma

File could not be found or doesn't exist.

Total Posts: 553
Subject: RE: spammer Posted: 26 Mar 2018 - 16:36 ET



Zentron wrote:
A 'Delete Comment' feature would be a welcome addition, preferably in the Image Management area, as the messages themselves in the gallery view kinda make the browser flip out and blocks the page from displaying. So a 'Delete Comment' or 'Manage Comments' feature would be very very useful!


Working on that right now.

-- BK


My Side 7 Gallery | Personal Site
Zentron

File could not be found or doesn't exist.

Total Posts: 44
Subject: RE: spammer Posted: 26 Mar 2018 - 20:54 ET



Excellent! As another 8 spam posts have just appeared on one of my recent pics, I need to clean house of these adverts!
BadKarma

File could not be found or doesn't exist.

Total Posts: 553
Subject: RE: spammer Posted: 27 Mar 2018 - 22:35 ET



The comment delete tool is in place. You will find it under gallery management. Let me know if there are problems.

-- BK


My Side 7 Gallery | Personal Site
test



Total Posts: 1
Subject: RE: spammer Posted: 28 Mar 2018 - 00:06 ET



I've also done a bunch of cleanup in the database of spammer entries. If you find more, please post their usernames to this thread.
BadKarma

File could not be found or doesn't exist.

Total Posts: 553
Subject: RE: spammer Posted: 28 Mar 2018 - 00:07 ET



test wrote:
I've also done a bunch of cleanup in the database of spammer entries. If you find more, please post their usernames to this thread.


Whoops. That was me.

-- BK


My Side 7 Gallery | Personal Site
Zentron

File could not be found or doesn't exist.

Total Posts: 44
Subject: RE: spammer Posted: 28 Mar 2018 - 22:04 ET



Just seen how spam free the comments are, thank you very much! Also the Manage Image Comments feature is going to come in very handy if those spam bots dare show their badly written html faces again!
BadKarma

File could not be found or doesn't exist.

Total Posts: 553
Subject: RE: spammer Posted: 29 Mar 2018 - 19:04 ET



Zentron wrote:
Just seen how spam free the comments are, thank you very much! Also the Manage Image Comments feature is going to come in very handy if those spam bots dare show their badly written html faces again!


You're more than welcome. Amazingly, though, it's accounts that are getting not only signing up, but also getting confirmed, so they're fully active accounts. Not sure if the account info is then being configured into bots (which would seem to make the most sense).

But, that means I'll likely be adding CAPTCHA to comment submissions, whether you're signed in or not.


My Side 7 Gallery | Personal Site
Zentron

File could not be found or doesn't exist.

Total Posts: 44
Subject: RE: spammer Posted: 20 Apr 2018 - 20:24 ET



Lol, a little late, but I saw your test comment on my pic! I have have deleted it as per request, and can say the feature works nicely

Page 7 of 8 :: Viewing 61-70 of 72 4 5 6 7 8

Forum IndexSite FeedbackBug Reports
spammer


Forum Key
No New Posts New Posts
Hot Topic! Hot Topic w/ New Posts
Locked Topic