SOS ! SQL

Help please. Changed the password on the server, now all nopcommerce 1.9 do not work. Where to nopcommerce 1.9 perepropisat password to the server?

Hi,

Go into SQL Server Management Studio and go to the Customer table, right click and select edit 1234 selected and then change your password, dont forget to save and restart.

What password have you changed? The password of nopCommerce admin user or SQL Server one?

Поменял пароль на сервер, сайты вырубились. Говорят, что нужно переписать где то в нопе новый пароль к серверу. Но помимо смены пароля у меня еще проблемы с SQL  Evaluation, пришлось перезаливать ее с вебсайтспарка. Вот пример - http://shinamart.com/, http://kharkov-shina.com/

Have a look at ConnectionStrings.config file at the root of your site. Open it and update the password. Find more info about connection strings here

thank you

SOS!
Now the site works, but in the admin panel does not start. Shows this error.

Item has already been added. Key in dictionary: 'Int32 Single[Int32](System.Collections.Generic.IEnumerable`1[System.Int32])'  Key being added: 'Int32 Single[Int32](System.Collections.Generic.IEnumerable`1[System.Int32])'

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: Item has already been added. Key in dictionary: 'Int32 Single[Int32](System.Collections.Generic.IEnumerable`1[System.Int32])'  Key being added: 'Int32 Single[Int32](System.Collections.Generic.IEnumerable`1[System.Int32])'

Source Error:


Line 78:                         };
Line 79:             if (count > 0)
Line 80:                 query = query.Take(count);
Line 81:             var tmp1 = query.ToList();
Line 82:             List<SearchTermReportLine> report = new List<SearchTermReportLine>();

Source File: C:\Climatteh new store\Libraries\Nop.BusinessLogic\Audit\SearchLogService.cs    Line: 80

Stack Trace:


[ArgumentException: Item has already been added. Key in dictionary: 'Int32 Single[Int32](System.Collections.Generic.IEnumerable`1[System.Int32])'  Key being added: 'Int32 Single[Int32](System.Collections.Generic.IEnumerable`1[System.Int32])']
   System.Reflection.CerHashtable`2.Insert(K[] keys, V[] values, Int32& count, K key, V value) +9599675
   System.Reflection.CerHashtable`2.Preallocate(Int32 count) +307
   System.RuntimeTypeCache.GetGenericMethodInfo(RuntimeMethodHandleInternal genericMethod) +299
   System.RuntimeType.GetMethodBase(RuntimeType reflectedType, RuntimeMethodHandleInternal methodHandle) +543
   System.Reflection.RuntimeMethodInfo.MakeGenericMethod(Type[] methodInstantiation) +196
   System.Linq.Queryable.Take(IQueryable`1 source, Int32 count) +168
   NopSolutions.NopCommerce.BusinessLogic.Audit.SearchLogService.SearchTermReport(Nullable`1 startTime, Nullable`1 endTime, Int32 count) in C:\Climatteh new store\Libraries\Nop.BusinessLogic\Audit\SearchLogService.cs:80
   NopSolutions.NopCommerce.Web.Administration.Modules.SearchTermStatControl.BindData() in C:\Climatteh new store\NopCommerceStore\Administration\Modules\SearchTermStat.ascx.cs:49
   NopSolutions.NopCommerce.Web.Administration.Modules.SearchTermStatControl.Page_Load(Object sender, EventArgs e) in C:\Climatteh new store\NopCommerceStore\Administration\Modules\SearchTermStat.ascx.cs:43
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +91
   System.Web.UI.Control.LoadRecursive() +74
   System.Web.UI.Control.LoadRecursive() +146
   System.Web.UI.Control.LoadRecursive() +146
   System.Web.UI.Control.LoadRecursive() +146
   System.Web.UI.Control.LoadRecursive() +146
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207

Really weird. You're first person who gets this error. Just try to disable this report.
1. Open \Administration\Default.aspx
2. Remove the following line of code

<nopCommerce:SearchTermStat runat="server" ID="ctrlSearchTermStat" />