Thousands of empty customer records created every day

4 年 前
Hello, I am using 3.20 Version. I read same problems and solutions but I couldn't find answer for my problem. So, My website have not "real" guest but every second recording one or more new guest row to database. I have to delete empty guest record hourly.

Unfortunately, Schedule Task doesn't work. I can delete guest records from Maintenance but it's very hard for hourly as you guess...

Any solution?


Etc.
dbo.Customer Table (41 record in 10 second):

CreatedOnUtc  LastIpAddress
3/18/2016 8:06:08 PM  130.193.51.59
3/18/2016 8:06:08 PM  5.255.253.109
3/18/2016 8:06:08 PM  5.255.253.52
3/18/2016 8:06:09 PM  141.8.142.19
3/18/2016 8:06:09 PM  130.193.37.26
3/18/2016 8:06:09 PM  178.154.189.28
3/18/2016 8:06:09 PM  130.193.50.25
3/18/2016 8:06:10 PM  130.193.51.103
3/18/2016 8:06:10 PM  93.158.152.21
3/18/2016 8:06:10 PM  141.8.142.75
3/18/2016 8:06:11 PM  141.8.142.37
3/18/2016 8:06:11 PM  141.8.142.5
3/18/2016 8:06:11 PM  141.8.142.54
3/18/2016 8:06:12 PM  178.154.189.13
3/18/2016 8:06:12 PM  130.193.50.9
3/18/2016 8:06:12 PM  5.255.253.49
3/18/2016 8:06:12 PM  93.158.152.18
3/18/2016 8:06:12 PM  141.8.183.26
3/18/2016 8:06:13 PM  130.193.50.6
3/18/2016 8:06:13 PM  141.8.132.5
3/18/2016 8:06:13 PM  130.193.37.18
3/18/2016 8:06:13 PM  141.8.142.57
3/18/2016 8:06:14 PM  130.193.37.14
3/18/2016 8:06:14 PM  5.255.253.12
3/18/2016 8:06:14 PM  130.193.37.18
3/18/2016 8:06:14 PM  130.193.51.59
3/18/2016 8:06:15 PM  130.193.51.23
3/18/2016 8:06:15 PM  5.255.253.109
3/18/2016 8:06:15 PM  5.255.253.52
3/18/2016 8:06:16 PM  5.255.253.71
3/18/2016 8:06:16 PM  141.8.142.19
3/18/2016 8:06:16 PM  141.8.142.73
3/18/2016 8:06:16 PM  178.154.189.28
3/18/2016 8:06:17 PM  130.193.50.25
3/18/2016 8:06:17 PM  130.193.51.103
3/18/2016 8:06:17 PM  141.8.142.73
3/18/2016 8:06:18 PM  141.8.142.75
3/18/2016 8:06:18 PM  5.255.253.65
3/18/2016 8:06:18 PM  141.8.142.37
3/18/2016 8:06:18 PM  141.8.142.5
3/18/2016 8:06:18 PM  93.158.152.19
4 年 前
I have the same problem as mrblackman.
Something keeps inserting records to the database.
I have over 42k new records in less than 24 hours inserted, with nulls on most of the columns.

ANy idea what could be wrong and how it could be fixed?
4 年 前
I found that there were only about 100 IP addresses that were being a problem, so I ended up installing a new plugin which can ban IP addresses from entering your site...and creating guest records.

I also bought and installed this plugin, which converts all guests to registered customers immediately after the sale...this makes life so much easier.

Steve
4 年 前
Since the max value we can have for ID in Customers table is 2,147,483,647, do we need to also reset the identity column (Id) of Customer table as well after each Delete guests task?
4 年 前
arlen_bs wrote:
Since the max value we can have for ID in Customers table is 2,147,483,647, do we need to also reset the identity column (Id) of Customer table as well after each Delete guests task?


Make sure that Customer table has following system accounts active.

[email protected]_engine_record.com  (Built-in system guest record used for requests from search engines.)
[email protected] (Built-in system record used for background tasks.)
4 年 前
What is the workflow?
4 年 前
arlen_bs wrote:
What is the workflow?


Check Customer table in the database.
4 年 前
shahdat45ict wrote:
Since the max value we can have for ID in Customers table is 2,147,483,647, do we need to also reset the identity column (Id) of Customer table as well after each Delete guests task?

Make sure that Customer table has following system accounts active.

[email protected]_engine_record.com  (Built-in system guest record used for requests from search engines.)
[email protected] (Built-in system record used for background tasks.)



I do not have those users in Customer table (Nop3.40), what are these accounts for? And what it has to do with resting identity column?
4 年 前
What if we add this section to DeleteGuests stored procedure?


------------------------------------------reseed to next Id available
DBCC CHECKIDENT ('[Customer]', RESEED)

------------------------------------------reseed to next Id available

DBCC CHECKIDENT ('[GenericAttribute]', RESEED)
--------------------------------------------------------------------------
4 年 前
select * from [dbo].[Customer]
  where IsSystemAccount = 1


[email protected]_engine_record.com
[email protected]


Query should return two records. When site get crawled, system consider the bot as  [email protected]_engine_record.com instead of creating new customer records(eventually increasing identity value).

If you already have the system accounts, check if you have any third party monitoring system (like monitis, pingdom) setup to do automated testing on your site which can create guest customers and increase identity, in that case you need to modify code to assign the testing tool as a system user.