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
jdepoy24549696  
#1 Posted : Tuesday, May 4, 2021 3:19:35 PM(UTC)
jdepoy24549696

Rank: Advanced Member

Groups: Authorized User, Developers, Registered
Joined: 4/17/2019(UTC)
Posts: 80

My client was trying to set up the Google Authenticator.

When they click "Setup Google Authenticator" on the Login page to get the QR code they are sent an email using the Subscription Expired Template (29).

I see in the Admin User Controller:
EmailTemplate emailTemplate = _emailTemplateRepo.Load(AbleContext.Current.Store.Settings.TFAEmailTemplateId);

I can't find any place in the Admin to set the Email Template for the Google Authenticator.

So I went in the database and ran this:
update ac_storesettings set fieldvalue = '38' where fieldname = 'tfaemailtemplateId'

Then about 10 minutes later it went back to the original value of 29.

How can I set this to use the correct template and have it stick?

Thanks

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

shaharyar  
#2 Posted : Wednesday, May 5, 2021 2:03:42 AM(UTC)
shaharyar

Rank: Advanced Member

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

Thanks: 5 times
Was thanked: 113 time(s) in 112 post(s)
The issue occurred because of the upgrade. We are forcing the template Id to 29 on the upgrade which produced this bug.
I am reporting the issue as a bug. Thanks for identifying.

Quote:
Then about 10 minutes later it went back to the original value of 29.


This might happen because of the cached value. After updating the value directly in the database, you need to restart the website/IIS.
Joe Payne2  
#3 Posted : Wednesday, May 5, 2021 6:31:18 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)
Originally Posted by: shaharyar Go to Quoted Post
This might happen because of the cached value. After updating the value directly in the database, you need to restart the website/IIS.


What is the cache duration on ac_StoreSettings values?

shaharyar  
#4 Posted : Thursday, May 6, 2021 1:39:30 AM(UTC)
shaharyar

Rank: Advanced Member

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

Thanks: 5 times
Was thanked: 113 time(s) in 112 post(s)
Once loaded from the database, store settings are stored at the application level and it only reloads the values from the database when the application is restarted.

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.