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
9.0.4 bug saving product after changing url for long urls
Options
Go to last post Go to first unread
Previous Topic Next Topic
Joe Payne2  
#1 Posted : Tuesday, August 24, 2021 5:34:51 AM(UTC)
Joe Payne2

Rank: Advanced Member

Groups: HelpDesk, Developers
Joined: 11/9/2018(UTC)
Posts: 564

Thanks: 122 times
Was thanked: 26 time(s) in 25 post(s)
The field lengths are wrong in the ac_Redirects table

The default url length in CatalogUrls is 300 characters, and elsewhere in Able code.

The ac_Redirects.SourceUrl and .LoweredSourceUrl are set to 255 characters.

Editing the url on a product with a url > 255 in length throws a SQL error when the ac_Redirects entry is created if the checkbox is checked. The ac_Redirects entry needs to contain the original url which is too long for the field size in the table.
Back to top
thanks 1 user thanked Joe Payne2 for this useful post.
nadeem on 8/30/2021(UTC)

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. New Registrations are disabled.
Back to top  
nadeem  
#2 Posted : Monday, August 30, 2021 9:54:19 AM(UTC)
nadeem

Rank: Advanced Member

Groups: Administrators, Developers, Registered, HelpDesk, Authorized User, Admin, System
Joined: 10/11/2018(UTC)
Posts: 109

Thanks: 17 times
Was thanked: 18 time(s) in 18 post(s)
This is registered as a bug.Thank you!
Back to top
thanks 1 user thanked nadeem for this useful post.
Joe Payne2 on 8/30/2021(UTC)
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-2024, Yet Another Forum.NET
This page was generated in 0.107 seconds.