logo
Welcome to our new AbleCommerce forums. As a guest, you may view the information here. To post to this forum, you must have a registered account with us, either as a new user evaluating AbleCommerce or an existing user of the application. For all questions related to the older version of Gold and earlier, please go to AbleCommerce Gold forum. Please use your AbleCommerce username and password to Login. New Registrations are disabled.

Notification

Icon
Error

Options
Go to last post Go to first unread
david9688526  
#1 Posted : Friday, June 27, 2025 10:15:44 AM(UTC)
david9688526

Rank: Newbie

Groups: Developers
Joined: 4/17/2020(UTC)
Posts: 2

Thanks: 3 times
I'm currently getting hundreds of these per second and it keeps bringing down my site.
My best guess is there's a bot putting weird chars in the Search box and AbleCommerce isn't handling the weird characters appropriately.
Any suggestions?

2025-06-27 10:08:55,842 ERROR ADOExceptionReporter Unable to translate Unicode character \uD83D at index 81 to specified code page.
2025-06-27 10:08:55,842 WARN ADOExceptionReporter System.Text.EncoderFallbackException: Unable to translate Unicode character \uD83D at index 81 to specified code page.
at System.Text.EncoderExceptionFallbackBuffer.Fallback(Char charUnknown, Int32 index)
at System.Text.EncoderFallbackBuffer.InternalFallback(Char ch, Char*& chars)
at System.Text.UTF8Encoding.GetBytes(Char* chars, Int32 charCount, Byte* bytes, Int32 byteCount, EncoderNLS baseEncoder)
at System.Text.EncoderNLS.GetBytes(Char[] chars, Int32 charIndex, Int32 charCount, Byte[] bytes, Int32 byteIndex, Boolean flush)
at System.IO.StreamWriter.Flush(Boolean flushStream, Boolean flushEncoder)
at System.IO.StreamWriter.Write(Char[] buffer, Int32 index, Int32 count)
at System.IO.TextWriter.SyncTextWriter.WriteLine(String value)
at NHibernate.AdoNet.Util.SqlStatementLogger.LogCommand(String message, DbCommand command, FormatStyle style)
at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(DbCommand cmd)
at NHibernate.Loader.Loader.GetResultSet(DbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session)
at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer)
at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer)
at NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Object id, IType identifierType, Object optionalObject, String optionalEntityName, Object optionalIdentifier, IEntityPersister persister)

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. New Registrations are disabled.

Katie S  
#2 Posted : Monday, June 30, 2025 10:44:34 AM(UTC)
Katie S

Rank: Advanced Member

Groups: System, Administrators, Developers, Registered, HelpDesk
Joined: 10/29/2018(UTC)
Posts: 489

Thanks: 4 times
Was thanked: 36 time(s) in 35 post(s)
Hello,

Every form field has SQL injection prevention added. This won't prevent errors from being logged though.

With hundreds per second, that would likely be an SQL injection attack which is something Ablecommerce can't prevent. The only way to stop that is by identifying the IP and blocking at the firewall. Also, Cloudflare (or similar servcies), when setup properly, should also be able to prevent Denial of Service and similar kinds of attacks.
Thanks for your support!

Katie
Secure eCommerce Software and Hosting
judy e  
#3 Posted : Tuesday, July 1, 2025 8:10:04 AM(UTC)
judy e

Rank: Advanced Member

Groups: Developers
Joined: 11/7/2018(UTC)
Posts: 309

Thanks: 21 times
Was thanked: 6 time(s) in 6 post(s)
Does the AC error log show that the error is on the search page? Do IIS logs show posts are coming from one ip or a variety of ip addresses?
You can prevent some errors from being logged by adding code to the global.asax.cs file, like AC does here:
if (((HttpException)exception).Message.StartsWith("A potentially dangerous"))
return;

david9688526  
#4 Posted : Wednesday, July 9, 2025 12:33:28 PM(UTC)
david9688526

Rank: Newbie

Groups: Developers
Joined: 4/17/2020(UTC)
Posts: 2

Thanks: 3 times
My error log has quite a few errors like the one below. For the last few days, I've just been getting less than 10 of these a day so it isn't causing much of an issue.
Clearly, some bot is just pasting in random text.
I did update the search forms and added maxlength to the text box to prevent these but that didn't help.

Quote:
An error has occurred at mysite.com/Search?Keywords=Pennewell%2520Publishing%2520Inc.%2520(PP)%2520is%2520a%2520zero%2520growth%2520company.%2520It%2520currently%2520has%2520zero%2520debt%2520and%2520its%2520earnings%2520before%2520interest%2520and%2520taxes%2520(EBIT)%2520are%2520%2480%2C000.%2520PP%2527s%2520current%2520cost%2520of%2520equity%2520is%252010%25%2C%2520and%2520its%2520tax%2520rate%2520is%252025%25.%2520The%2520firm%2520has%252010%2C000%2520shares%2520of%2520common%2520stock%2520outstanding%2520selling%2520at%2520a%2520price%2520per%2520share%2520of%2520%2448.00.%250D%250A%250D%250ARefer%2520to%2520the%2520data%2520for%2520Pennewell%2520Publishing%2520Inc.%2520(PP).%2520PP%2520is%2520considering%2520changing%2520its%2520capital%2520structure%2520to%2520one%2520with%252030%25%2520debt%2520and%252070%25%2520equity%2C%2520based%2520on%2520market%2520values.%2520The%2520debt%2520would%2520have%2520an%2520interest%2520rate%2520of%25208%25.%2520The%2520new%2520funds%2520would%2520be%2520used%2520to%2520repurchase%2520stock.%2520It%2520is%2520estimated%2520that%2520the%2520increase%2520in%2520risk%2520resulting%2520from%2520the%2520added%2520leverage%2520would%2520cause%2520the%2520required%2520rate%2520of%2520return%2520on%2520equity%2520to%2520rise%2520to%252012%25.%2520If%2520this%2520plan%2520were%2520carried%2520out%2C%2520what%2520would%2520be%2520PP%2527s%2520new%2520value%2520of%2520operations%3F%250D%250A

Edited by user Wednesday, July 9, 2025 12:37:04 PM(UTC)  | Reason: Made more readable

Katie S  
#5 Posted : Wednesday, July 9, 2025 3:32:54 PM(UTC)
Katie S

Rank: Advanced Member

Groups: System, Administrators, Developers, Registered, HelpDesk
Joined: 10/29/2018(UTC)
Posts: 489

Thanks: 4 times
Was thanked: 36 time(s) in 35 post(s)
Yes, I see this sort of thing all the time. The error message is logged, but I assure you that all input forms are coded to prevent an actual SQL injection. We can't stop the attack of course, but it does log the event.

In this case, the bot is trying to insert a character that isn't supported by the database.

I have seen attacks increase exponentially in the last year or so. As a website host, it's very frustrating.
Thanks for your support!

Katie
Secure eCommerce Software and Hosting
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.