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 forums.ablecommerce.com. 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
Joe Payne @ AbleMods LLC  
#1 Posted : Friday, August 27, 2021 7:52:08 AM(UTC)
Joe Payne @ AbleMods LLC

Rank: Advanced Member

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

Thanks: 89 times
Was thanked: 14 time(s) in 13 post(s)
Our dev site has suddenly started showing native urls ie /Category/Index/7 in the browser address bar instead of the actual url

Any ideas on where to look? I don't even know where to start.

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

shaharyar  
#2 Posted : Friday, August 27, 2021 9:09:48 AM(UTC)
shaharyar

Rank: Advanced Member

Groups: Admin, Developers, Registered, HelpDesk, Authorized User
Joined: 10/5/2018(UTC)
Posts: 578

Thanks: 2 times
Was thanked: 88 time(s) in 87 post(s)
It seems that the ac_CatalogUrls has no Url saved for that category. You can confirm by looking into the table data.
Joe Payne @ AbleMods LLC  
#3 Posted : Friday, August 27, 2021 10:07:46 AM(UTC)
Joe Payne @ AbleMods LLC

Rank: Advanced Member

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

Thanks: 89 times
Was thanked: 14 time(s) in 13 post(s)
Yup. That's it. How they disappeared, I have no idea. Somebody must have fired the rebuild.

This RebuildUrls() routine is killing me. I'm having to rewrite it to properly identify when a generated url already exists and needs the -P123. And even then, I'm running into problems.

I still can't fully explain why it won't identify a url that actually does already exist in the table. My only theory is it has something to do with how SQL transactions are isolated from each other. If the nHibernate query to look up a url is in a different sql transaction than the transaction that created the new url, I don't think it will see the created url until that transaction is committed.

At least in my app it's not seeing it at all.
Users browsing this topic
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.