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
/Admin/Store Error - "Value must be between 1714871127 and 99999999" - /Admin/Store Error - "Value must be between 1714871127 and 99999999"
Options
Go to last post Go to first unread
Previous Topic Next Topic
brant25348293  
#1 Posted : Sunday, October 12, 2025 2:26:25 PM(UTC)
brant25348293

Rank: Advanced Member

Groups: HelpDesk
Joined: 1/20/2020(UTC)
Posts: 57
I am using Version: 9.0.11.9287, when I go to /Admin/Store and make a change, I cannot save it due to an invalid error. The error is "Value must be between 1714871127 and 99999999".

We have high order numbers, and the error says the order number is too great. Orders are still being processed, but I am unable to make any changes on this page, and I need to make a change. Can you fix this in the next release, or let me know how to resolve this error without editing code and recompiling?

Admin-Store-General-Failure.png (13kb) downloaded 1 time(s).

We are also unable to reduce the size of the order number because it is not an editable field in the store!
2025-10-12 16_49_09-AbleCommerce _ Store.png (8kb) downloaded 0 time(s).

Edited by user Sunday, October 12, 2025 3:50:49 PM(UTC)  | Reason: Not specified
Back to top

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. New Registrations are disabled.
Back to top  
Katie S  
#2 Posted : Monday, October 13, 2025 12:32:43 PM(UTC)
Katie S

Rank: Advanced Member

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

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

It looks like the validation code might be incorrect, because the database table is still accepting large integers.

Most of the settings on this page should be in the ac_StoreSettings table. You should be able to work-around the issue by doing a quick manual edit of the database. What setting are you trying to change. I can point you to the correct entry if you share this info.

The store settings are cached, so if you make changes, you will need to recycle the application pool.

I will report this as a bug.
Thanks for your support!

Katie
Secure eCommerce Software and Hosting
Back to top
brant25348293  
#3 Posted : Monday, October 13, 2025 5:20:52 PM(UTC)
brant25348293

Rank: Advanced Member

Groups: HelpDesk
Joined: 1/20/2020(UTC)
Posts: 57
I want to reset the order number to a smaller one so I can make edits on this page. I tried this SQL command and it does not work. Can you help me get the correct command?
UPDATE ac_Sequence
SET NextValue = 25010001
WHERE SequenceName = 'OrderNumber';
Back to top
Katie S  
#4 Posted : Tuesday, October 14, 2025 10:37:12 AM(UTC)
Katie S

Rank: Advanced Member

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

Thanks: 4 times
Was thanked: 36 time(s) in 35 post(s)
If you reset the order number to a smaller (used) value, it will cause problems in the data because the order number needs to be unique. That's why the validation code will not allow the order number to decrease.

If you let me know what other store setting you are trying to change, I can provide the SQL query.
Thanks for your support!

Katie
Secure eCommerce Software and Hosting
Back to top
brant25348293  
#5 Posted : Tuesday, October 14, 2025 10:50:30 AM(UTC)
brant25348293

Rank: Advanced Member

Groups: HelpDesk
Joined: 1/20/2020(UTC)
Posts: 57
I need to replace the HTML code in the Checkout terms and Conditions.
2025-10-14 11_48_39-AbleCommerce _ Store.png (15kb) downloaded 0 time(s).
Back to top
Katie S  
#6 Posted : Tuesday, October 14, 2025 11:30:45 AM(UTC)
Katie S

Rank: Advanced Member

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

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

Sure, no problem. You can either directly edit the table ac_StoreSettings, fieldname = CheckoutTermsAndConditions and change the fieldValue text, or you can run this update query on the database.

Be sure to change the html sample text below to the new html that you want to use.

Quote:
UPDATE ac_StoreSettings
SET FieldValue = '<h2>New Return Policy</h2><ul><li>Here is some new text</li><li>Here is some more new text</li></ul>'
WHERE FieldName = 'CheckoutTermsAndConditions';


This table data is cached, so remember to restart the website's application pool When finished.
Thanks for your support!

Katie
Secure eCommerce Software and Hosting
Back to top
brant25348293  
#7 Posted : Tuesday, October 14, 2025 2:03:10 PM(UTC)
brant25348293

Rank: Advanced Member

Groups: HelpDesk
Joined: 1/20/2020(UTC)
Posts: 57
Thanks, I am a beginner when it comes to databases.
Step by step, how can I directly edit the table ac_StoreSettings, fieldname = CheckoutTermsAndConditions, and change the fieldValue text?
Back to top
Katie S  
#8 Posted : Tuesday, October 14, 2025 3:32:23 PM(UTC)
Katie S

Rank: Advanced Member

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

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

You will need to connect to that database with SSMS (SQL Server management studio). I assume that you can do that. If not, it might be best to have someone make the SQL update to the database using the query I provided.

Once you connect, then expand the databases from Object Explorer.

Expand the database for Ablecommerce store.

Expand the Tables.

2025-10-14_13-22-11.png (28kb) downloaded 0 time(s).

Then scroll down until you find the table ac_StoreSettings.

Right-click this table to show the options and click the Edit Top ## Rows.

2025-10-14_12-55-15.png (13kb) downloaded 0 time(s).

Next, scroll down until you find the FieldName "CheckoutTermsAndConditions" and manually edit the html in the FieldValue column adjacent.

2025-10-14_13-26-25.png (20kb) downloaded 0 time(s).

Let me know if this works.



Thanks for your support!

Katie
Secure eCommerce Software and Hosting
Back to top
brant25348293  
#9 Posted : Tuesday, October 14, 2025 8:32:40 PM(UTC)
brant25348293

Rank: Advanced Member

Groups: HelpDesk
Joined: 1/20/2020(UTC)
Posts: 57
Thank you, that worked!

So now all of our products are digital, is it easily possible to eliminate the shipping option screen during checkout? Meaning instead of
Billing > Shipping > Payment
the user only sees
Billing > Payment
Back to top
Katie S  
#10 Posted : Tuesday, October 14, 2025 10:17:22 PM(UTC)
Katie S

Rank: Advanced Member

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

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

You are very welcome!

For digital goods, it will automatically bypass the select shipping method page as long as there are no shippable items.

To do that, you will need make sure each digital good uses the setting "Product is not shippable"

2025-10-14_20-15-42.png (12kb) downloaded 0 time(s).

Hopefully this helps,

Katie
Thanks for your support!

Katie
Secure eCommerce Software and Hosting
Back to top
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.

Privacy Policy | Powered by YAF.NET 2.2.4.14 | YAF.NET © 2003-2025, Yet Another Forum.NET
This page was generated in 0.162 seconds.