Thousands of empty customer records created every day

4 年 前
shahdat45ict wrote:
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.


I am using Nop 3.40 and query returns no records. What to do in that case to prevent identity increasement?
4 年 前
Try this


INSERT INTO [dbo].[Customer]
           ([CustomerGuid]          
           ,[Email]        
           ,[PasswordFormatId]          
           ,[AdminComment]
           ,[IsTaxExempt]
           ,[AffiliateId]
           ,[Active]
           ,[Deleted]
           ,[IsSystemAccount]
           ,[SystemName]          
           ,[CreatedOnUtc]  
       ,[LastActivityDateUtc]
           ,[VendorId]
           ,[HasShoppingCartItems])
     VALUES
           (newid()          
           ,'[email protected]_engine_record.com'          
           ,0          
           ,'Built-in system guest record used for requests from search engines.'
           ,0
           ,0
           ,1
           ,0
           ,1
           ,'SearchEngine'        
           ,GETUTCDATE()
       ,GETUTCDATE()
           ,0
           ,0)

INSERT INTO [dbo].[Customer]
           ([CustomerGuid]          
           ,[Email]        
           ,[PasswordFormatId]          
           ,[AdminComment]
           ,[IsTaxExempt]
           ,[AffiliateId]
           ,[Active]
           ,[Deleted]
           ,[IsSystemAccount]
           ,[SystemName]          
           ,[CreatedOnUtc]  
       ,[LastActivityDateUtc]
           ,[VendorId]
           ,[HasShoppingCartItems])
     VALUES
           (newid()        
           ,'[email protected]'          
           ,0          
           ,'Built-in system record used for background tasks.'
           ,0
           ,0
           ,1
           ,0
           ,1
           ,'BackgroundTask'        
           ,GETUTCDATE()
       ,GETUTCDATE()
           ,0
           ,0)
GO
4 年 前
shahdat45ict wrote:
Try this


INSERT INTO [dbo].[Customer]
           ([CustomerGuid]          
           ,[Email]        
           ,[PasswordFormatId]          
           ,[AdminComment]
           ,[IsTaxExempt]
           ,[AffiliateId]
           ,[Active]
           ,[Deleted]
           ,[IsSystemAccount]
           ,[SystemName]          
           ,[CreatedOnUtc]  
       ,[LastActivityDateUtc]
           ,[VendorId]
           ,[HasShoppingCartItems])
     VALUES
           (newid()          
           ,'[email protected]_engine_record.com'          
           ,0          
           ,'Built-in system guest record used for requests from search engines.'
           ,0
           ,0
           ,1
           ,0
           ,1
           ,'SearchEngine'        
           ,GETUTCDATE()
       ,GETUTCDATE()
           ,0
           ,0)

INSERT INTO [dbo].[Customer]
           ([CustomerGuid]          
           ,[Email]        
           ,[PasswordFormatId]          
           ,[AdminComment]
           ,[IsTaxExempt]
           ,[AffiliateId]
           ,[Active]
           ,[Deleted]
           ,[IsSystemAccount]
           ,[SystemName]          
           ,[CreatedOnUtc]  
       ,[LastActivityDateUtc]
           ,[VendorId]
           ,[HasShoppingCartItems])
     VALUES
           (newid()        
           ,'[email protected]'          
           ,0          
           ,'Built-in system record used for background tasks.'
           ,0
           ,0
           ,1
           ,0
           ,1
           ,'BackgroundTask'        
           ,GETUTCDATE()
       ,GETUTCDATE()
           ,0
           ,0)
GO



I ran that query, those two accounts got created but sill having guest users created continuously.
4 年 前
Can you also check if you have the uas_20140512-01.ini file in App_Data folder?
4 年 前
shahdat45ict wrote:
Can you also check if you have the uas_20140512-01.ini file in App_Data folder?


Yes the file is there. "uas_20140512-01.ini"
4 年 前
Im using 3.80 and i dont see  uas_20140512-01.ini in the app data folder. Is this expected?

If it should exist then can you please tell me how to get this file now?
4 年 前
[email protected] wrote:
Im using 3.80 and i dont see  uas_20140512-01.ini in the app data folder. Is this expected?

If it should exist then can you please tell me how to get this file now?


For 3.80, file name should be browscap.xml. If it's missing, you can get the latest version of user agent strings at http://browscap.org/


To be sure, check web.config file you would find following lines as reference.
<!-- You can get the latest version of user agent strings at http://browscap.org/ -->
<UserAgentStrings databasePath="~/App_Data/browscap.xml" />
4 年 前
shahdat45ict wrote:
Im using 3.80 and i dont see  uas_20140512-01.ini in the app data folder. Is this expected?

If it should exist then can you please tell me how to get this file now?

For 3.80, file name should be browscap.xml. If it's missing, you can get the latest version of user agent strings at http://browscap.org/


To be sure, check web.config file you would find following lines as reference.
<!-- You can get the latest version of user agent strings at http://browscap.org/ -->
<UserAgentStrings databasePath="~/App_Data/browscap.xml" />


Thanks for the information.

I compared the file which is on my hosting with the one on the browscap.org. It seems the file on browscap.org has more lines of code assuming that it might be the latest one, I replaced it on my host. Restarted the IIS. Still i can see guest accounts pouring in every second.
4 年 前
Can you check my previous responses? Make sure you have the two system users in customer table
4 年 前
shahdat45ict wrote:
Can you check my previous responses? Make sure you have the two system users in customer table


I tried the below query and found 2 records:

select * from [dbo].[Customer]
  where IsSystemAccount = 1

Result:

[email protected]_engine_record.com
[email protected]

Both accounts are in active status.

Can you please guide what else could be wrong. My customer id count reached 20K+ now.