Hello Hassa,

Where you able to successfully complete the localization process?

Also, do you see any errors regarding localization in the admin logs?

At last, do you've a backup of the website prior to enabling localization?

Regards,

1- Where you able to successfully complete the localization process? -yes 

2- Also, do you see any errors regarding localization in the admin logs? - This is all I see but I don't think this is related:

2023-08-17 16:24:19.632-04:00 [TOR-WEB-DEV-P02][D:2][T:333][ERROR] DotNetNuke.Data.PetaPoco.PetaPocoHelper - [3] Error executing SQL: ;Exec dbo.GetAvailableUsersForIndex @0, @1, @2, @3
The column name "Username" specified in the PIVOT operator conflicts with the existing column name in the PIVOT argument.
The column 'Username' was specified multiple times for 'T'.
2023-08-17 16:24:19.632-04:00 [TOR-WEB-DEV-P02][D:2][T:333][ERROR] DotNetNuke.Services.Exceptions.Exceptions - System.Data.SqlClient.SqlException (0x80131904): The column name "Username" specified in the PIVOT operator conflicts with the existing column name in the PIVOT argument.
The column 'Username' was specified multiple times for 'T'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at DotNetNuke.Data.PetaPoco.PetaPocoExt.ExecuteReader(Database database, String sql, Object[] args)
   at DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteReader(String connectionString, CommandType type, Int32 timeoutSec, String sql, Object[] args)
   at DotNetNuke.Data.SqlDataProvider.ExecuteReader(Int32 timeoutSec, String procedureName, Object[] commandParameters)
   at DotNetNuke.Data.DataProvider.GetAvailableUsersForIndex(Int32 portalId, DateTime startDate, Int32 startUserId, Int32 numberOfUsers)
   at DotNetNuke.Services.Search.UserIndexer.FindModifiedUsers(Int32 portalId, DateTime startDateLocal, IDictionary`2 searchDocuments, IList`1 profileDefinitions, IList`1& indexedUsers, Int32& startUserId)
   at DotNetNuke.Services.Search.UserIndexer.IndexSearchDocuments(Int32 portalId, ScheduleHistoryItem schedule, DateTime startDateLocal, Action`1 indexer)
ClientConnectionId:8bfc2ea4-dfaf-4fa9-9277-1401c72acefc
Error Number:265,State:1,Class:16

3- At last, do you've a backup of the website prior to enabling localization? - I don't think 

My first guess is that something went wrong with the configuration of localization, or a step was different than expected or something...  🤔 

Was this what you did, or did you do something more/less/different?  

What do you suggest I try at this point. I am not able to restore the db due to bunch of changes in module settings and html contents.

Did you take a look at the video?  Did any of the steps sound like something you missed or something?  

As far as next steps, when something like this happens and you didn't do it in Test/Staging, you may need to perform a restore to get yourself back to a good point.  Otherwise, someone who knows DNN well, might need to dig into a backup of your site to determine what's not working.  It might be a conflict with an extension, even.