{"id":579,"date":"2018-08-07T16:02:44","date_gmt":"2018-08-07T11:32:44","guid":{"rendered":"https:\/\/day.ir\/blog\/?p=579"},"modified":"2022-04-05T22:37:40","modified_gmt":"2022-04-05T18:07:40","slug":"websitepanel-auditlog-error-sql-collation","status":"publish","type":"post","link":"https:\/\/day.ir\/blog\/en\/websitepanel-auditlog-error-sql-collation\/","title":{"rendered":"WebsitePanel AuditLog Error SQL Collation"},"content":{"rendered":"

Fix Web Site panel 2.1.0 – WebsitePanel AuditLog Error SQL Collation<\/strong><\/p>\n

WebsitePanel<\/a> 2.1.0 AuditLog Error Collation on GetPackageExceedingQuotas<\/p>\n

You will see an error below on your WSP AuditLog and the disk quota or bandwidth calculator will not work<\/p>\n

 <\/p>\n

 <\/p>\n

WebsitePanel AuditLog Error SQL Collation<\/h2>\n

——————————————————————————————————————————–<\/p>\n

Page URL: http:\/\/x.x.x.x\/Default.aspx?pid=AuditLog&UserID=1\r\n\r\nLogged User: serveradmin\r\n\r\nWork on Behalf: serveradmin\r\n\r\nHosting Space: 0\r\n\r\nStack Trace: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: Cannot resolve the collation conflict between \"Latin1_General_CI_AS\" and \"SQL_Latin1_General_CP1256_CI_AS\" in the equal to operation.\r\n\r\nat System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n\r\nat System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n\r\nat System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n\r\nat System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()\r\n\r\nat System.Data.SqlClient.SqlDataReader.get_MetaData()\r\n\r\nat System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)\r\n\r\nat System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)\r\n\r\nat System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)\r\n\r\nat System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)\r\n\r\nat System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)\r\n\r\nat System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)\r\n\r\nat System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)\r\n\r\nat System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)\r\n\r\nat Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)\r\n\r\nat Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)\r\n\r\nat WebsitePanel.EnterpriseServer.DataProvider.GetAuditLogRecordsPaged(Int32 actorId, Int32 userId, Int32 packageId, Int32 itemId, String itemName, DateTime startDate, DateTime endDate, Int32 severityId, String sourceName, String taskName, String sortColumn, Int32 startRow, Int32 maximumRows)\r\n\r\nat WebsitePanel.EnterpriseServer.AuditLog.GetAuditLogRecordsPaged(Int32 userId, Int32 packageId, Int32 itemId, String itemName, DateTime startDate, DateTime endDate, Int32 severityId, String sourceName, String taskName, String sortColumn, Int32 startRow, Int32 maximumRows)\r\n\r\nat WebsitePanel.EnterpriseServer.esAuditLog.GetAuditLogRecordsPaged(Int32 userId, Int32 packageId, Int32 itemId, String itemName, DateTime startDate, DateTime endDate, Int32 severityId, String sourceName, String taskName, String sortColumn, Int32 startRow, Int32 maximumRows)\r\n\r\n--- End of inner exception stack trace ---\r\n\r\nat System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)\r\n\r\nat System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)\r\n\r\nat WebsitePanel.EnterpriseServer.esAuditLog.GetAuditLogRecordsPaged(Int32 userId, Int32 packageId, Int32 itemId, String itemName, DateTime startDate, DateTime endDate, Int32 severityId, String sourceName, String taskName, String sortColumn, Int32 startRow, Int32 maximumRows)\r\n\r\nat WebsitePanel.Portal.AuditLogHelper.GetAuditLogRecordsPaged(Int32 maximumRows, Int32 startRowIndex, String sortColumn, String sStartDate, String sEndDate, Int32 packageId, Int32 itemId, String itemName, Int32 severityId, String sourceName, String taskName)\r\n\r\n--- End of inner exception stack trace ---\r\n\r\nat System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)\r\n\r\nat System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)\r\n\r\nat System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)\r\n\r\nat System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance)\r\n\r\n--------------------------------------------------------------------------------------------------------------------------------\r\nThis is a bug or problem on Website Panel.<\/pre>\n
To solve this problem open your MS SQL and browse your WebsitePanel database to found GetPackageExceedingQuotas<\/p>\n
1- Databases > WebsitePanel (Or any name you add for WSP db) > Programmability > Functions> Table-valued Function > GetPackageExceedingQuotas<\/p>\n
Right Click on function and delete it.<\/p>\n
 <\/p>\n
\"functions<\/p>\n
Databases > WebsitePanel (Or any name you add for WSP db) > Programmability > Functions> Table-valued Function > GetPackageExceedingQuotas
\nRight Click on the function and delete it.<\/p>\n
2- Run this query on SQL server:<\/p>\n
 <\/p>\n
——————————————————————————————————————————–<\/p>\n
ALTER DATABASE websitepanel SET SINGLE_USER WITH ROLLBACK IMMEDIATE;\r\n\r\nGO\r\n\r\nALTER DATABASE websitepanel COLLATE Latin1_General_CI_AS;\r\n\r\nGO\r\n\r\nALTER DATABASE websitepanel SET MULTI_USER;\r\n\r\nGO<\/pre>\n
\n
\"paste<\/p>\n
3- Run This query, your WebsitePanel database name may be different:<\/p>\n
——————————————————————————————————————————–<\/p>\n
USE [WebsitePanel]\r\n\r\nGO\r\n\r\n\/****** Object: UserDefinedFunction [dbo].[GetPackageExceedingQuotas] Script Date: 02\/28\/2016 11:30:34 AM ******\/\r\n\r\nSET ANSI_NULLS ON\r\n\r\nGO\r\n\r\nSET QUOTED_IDENTIFIER ON\r\n\r\nGO\r\n\r\nCREATE FUNCTION [dbo].[GetPackageExceedingQuotas]\r\n\r\n@PackageID int\r\n)\r\n\r\nRETURNS @quotas TABLE (QuotaID int, QuotaName nvarchar(50), QuotaValue int)\r\n\r\nAS\r\n\r\nBEGIN\r\n\r\nDECLARE @ParentPackageID int\r\n\r\nDECLARE @PlanID int\r\n\r\nDECLARE @OverrideQuotas bit\r\n\r\nSELECT\r\n\r\n@ParentPackageID = ParentPackageID,\r\n\r\n@PlanID = PlanID,\r\n\r\n@OverrideQuotas = OverrideQuotas\r\n\r\nFROM Packages WHERE PackageID = @PackageID\r\n\r\nIF @ParentPackageID IS NOT NULL -- not root package\r\n\r\nBEGIN\r\n\r\nIF @OverrideQuotas = 0 -- hosting plan quotas\r\n\r\nBEGIN\r\n\r\nINSERT INTO @quotas (QuotaID, QuotaName, QuotaValue)\r\n\r\nSELECT\r\n\r\nQ.QuotaID,\r\n\r\nQ.QuotaName,\r\n\r\ndbo.CheckExceedingQuota(@PackageID, Q.QuotaID, Q.QuotaTypeID) AS QuotaValue\r\n\r\nFROM HostingPlanQuotas AS HPQ\r\n\r\nINNER JOIN Quotas AS Q ON HPQ.QuotaID = Q.QuotaID\r\n\r\nWHERE HPQ.PlanID = @PlanID AND Q.QuotaTypeID 3\r\n\r\nEND\r\n\r\nELSE -- overriden quotas\r\n\r\nBEGIN\r\n\r\nINSERT INTO @quotas (QuotaID, QuotaName, QuotaValue)\r\n\r\nSELECT\r\n\r\nQ.QuotaID,\r\n\r\nQ.QuotaName,\r\n\r\ndbo.CheckExceedingQuota(@PackageID, Q.QuotaID, Q.QuotaTypeID) AS QuotaValue\r\n\r\nFROM PackageQuotas AS PQ\r\n\r\nINNER JOIN Quotas AS Q ON PQ.QuotaID = Q.QuotaID\r\n\r\nWHERE PQ.PackageID = @PackageID AND Q.QuotaTypeID 3\r\n\r\nEND\r\n\r\nEND -- if 'root' package\r\n\r\nRETURN\r\n\r\nEND\r\n\r\nGO<\/pre>\n
——————————————————————————————————————————–<\/p>\n
4- Finished, Just refresh Table-valued Function to make sure the function is recreated.<\/p>\n
\u0627\u06af\u0631 \u0628\u0627 \u0648\u0628 \u0633\u0627\u06cc\u062a \u067e\u0646\u0644 \u0622\u0634\u0646\u0627\u06cc\u06cc \u0646\u062f\u0627\u0631\u06cc\u062f \u0648\u0628 \u0633\u0627\u06cc\u062a \u067e\u0646\u0644 \u06cc\u06a9 \u0646\u0631\u0645 \u0627\u0641\u0632\u0627\u0631 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0633\u0631\u0648\u0631\u0647\u0627\u06cc \u0645\u0634\u062a\u0631\u06cc \u0648 \u0648\u0628 \u0633\u0627\u06cc\u062a \u0647\u0627 \u0648 \u0633\u0631\u0648\u06cc\u0633 \u0647\u0627\u0633\u062a\u06cc\u0646\u06af \u0627\u0633\u062a \u06a9\u0647 \u062f\u0631 \u0627\u0628\u062a\u062f\u0627 \u0644\u0627\u06cc\u0633\u0646\u0633 \u0622\u0646 \u0631\u0627\u06cc\u06af\u0627\u0646 \u0628\u0648\u062f \u0648 \u062f\u0631 \u062d\u0627\u0644 \u062d\u0627\u0636\u0631 \u062a\u0648\u0633\u0639\u0647 \u062f\u0647\u0646\u062f\u06af\u0627\u0646 \u0622\u0646 \u0628\u0631\u0627\u06cc \u0646\u0635\u0628 \u0644\u0627\u06cc\u0633\u0646\u0633 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u0646\u062f. \u0627\u06cc\u0646 \u06a9\u0646\u062a\u0631\u0644 \u067e\u0646\u0644 \u0627\u0632 \u0642\u0627\u0628\u0644\u06cc\u062a \u0645\u0627\u0644\u062a\u06cc \u0633\u0631\u0648\u0631 \u06cc\u0627 \u0686\u0646\u062f \u0633\u0631\u0648\u0631\u06cc \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc\u06a9\u0646\u062f \u0648 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u0627 \u062a\u0646\u0647\u0627 \u06cc\u06a9 \u0633\u0631\u0648\u0631 \u06cc\u0627 \u0647\u0645\u0632\u0645\u0627\u0646 \u0686\u0646\u062f\u06cc\u0646 \u0633\u0631\u0648\u0631 \u0647\u0645\u0627\u0647\u0646\u06af\u06cc \u0628\u06cc\u0646 \u062a\u0645\u0627\u0645 \u0633\u0631\u0648\u06cc\u0633 \u0647\u0627 \u0627\u0632 \u062c\u0645\u0644\u0647 \u0627\u06cc\u0645\u06cc\u0644 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0648\u0628\u00a0 \u062f\u06cc \u0627\u0646 \u0627\u0633 \u0648 \u063a\u06cc\u0631\u0647 \u0631\u0627 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f.<\/p>\n
 <\/p>\n
\u0645\u0637\u0627\u0644\u0628 \u0645\u0631\u062a\u0628\u0637:<\/p>\n
\u0633\u0631\u0648\u0631 VPS \u062f\u0631 \u0627\u06cc\u0631\u0627\u0646<\/strong><\/a><\/p>\n
\u0647\u0627\u0633\u062a \u0648\u06cc\u0646\u062f\u0648\u0632<\/strong><\/a><\/p>\n
\u0645\u06cc\u0632\u0628\u0627\u0646\u06cc \u0627\u06cc\u0645\u06cc\u0644<\/strong><\/a><\/p>\n
 <\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
Fix Web Site panel 2.1.0 – WebsitePanel AuditLog Error SQL Collation WebsitePanel 2.1.0 AuditLog Error Collation on GetPackageExceedingQuotas You will see an error below on your WSP AuditLog and the disk quota or bandwidth calculator will not work     […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[],"class_list":["post-579","post","type-post","status-publish","format-standard","hentry","category-en"],"yoast_head":"\nWebsitePanel AuditLog Error SQL Collation - \u0648\u0628\u0644\u0627\u06af \u062f\u06cc \u062a\u0644\u06a9\u0627\u0645<\/title>\n<meta name=\"description\" content=\"You will see error below on your WSP AuditLog and disk quota or bandwidth calculator not work WebsitePanel AuditLog Error SQL Collation\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/day.ir\/blog\/en\/websitepanel-auditlog-error-sql-collation\/\" \/>\n<meta property=\"og:locale\" content=\"fa_IR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"WebsitePanel AuditLog Error SQL Collation - \u0648\u0628\u0644\u0627\u06af \u062f\u06cc \u062a\u0644\u06a9\u0627\u0645\" \/>\n<meta property=\"og:description\" content=\"You will see error below on your WSP AuditLog and disk quota or bandwidth calculator not work WebsitePanel AuditLog Error SQL Collation\" \/>\n<meta property=\"og:url\" content=\"https:\/\/day.ir\/blog\/en\/websitepanel-auditlog-error-sql-collation\/\" \/>\n<meta property=\"og:site_name\" content=\"\u0648\u0628\u0644\u0627\u06af \u062f\u06cc \u062a\u0644\u06a9\u0627\u0645\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-07T11:32:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-05T18:07:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/day.ir\/blog\/wp-content\/uploads\/2022\/03\/WSP-2.1.0-Error-Collation-01.jpg\" \/>\n<meta name=\"author\" content=\"jafar broujerdi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0646\u0648\u0634\u062a\u0647\u200c\u0634\u062f\u0647 \u0628\u062f\u0633\u062a\" \/>\n\t<meta name=\"twitter:data1\" content=\"jafar broujerdi\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u0632\u0645\u0627\u0646 \u062a\u0642\u0631\u06cc\u0628\u06cc \u0628\u0631\u0627\u06cc \u062e\u0648\u0627\u0646\u062f\u0646\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 \u062f\u0642\u06cc\u0642\u0647\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/day.ir\\\/blog\\\/en\\\/websitepanel-auditlog-error-sql-collation\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/day.ir\\\/blog\\\/en\\\/websitepanel-auditlog-error-sql-collation\\\/\"},\"author\":{\"name\":\"jafar broujerdi\",\"@id\":\"https:\\\/\\\/day.ir\\\/blog\\\/#\\\/schema\\\/person\\\/8896e645096b6a8528b1bb57617f4b8b\"},\"headline\":\"WebsitePanel AuditLog Error SQL Collation\",\"datePublished\":\"2018-08-07T11:32:44+00:00\",\"dateModified\":\"2022-04-05T18:07:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/day.ir\\\/blog\\\/en\\\/websitepanel-auditlog-error-sql-collation\\\/\"},\"wordCount\":161,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\\\/\\\/day.ir\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/day.ir\\\/blog\\\/en\\\/websitepanel-auditlog-error-sql-collation\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/day.ir\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/WSP-2.1.0-Error-Collation-01.jpg\",\"articleSection\":[\"Day Blog\"],\"inLanguage\":\"fa-IR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/day.ir\\\/blog\\\/en\\\/websitepanel-auditlog-error-sql-collation\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/day.ir\\\/blog\\\/en\\\/websitepanel-auditlog-error-sql-collation\\\/\",\"url\":\"https:\\\/\\\/day.ir\\\/blog\\\/en\\\/websitepanel-auditlog-error-sql-collation\\\/\",\"name\":\"WebsitePanel AuditLog Error SQL Collation - \u0648\u0628\u0644\u0627\u06af \u062f\u06cc \u062a\u0644\u06a9\u0627\u0645\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/day.ir\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/day.ir\\\/blog\\\/en\\\/websitepanel-auditlog-error-sql-collation\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/day.ir\\\/blog\\\/en\\\/websitepanel-auditlog-error-sql-collation\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/day.ir\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/WSP-2.1.0-Error-Collation-01.jpg\",\"datePublished\":\"2018-08-07T11:32:44+00:00\",\"dateModified\":\"2022-04-05T18:07:40+00:00\",\"description\":\"You will see error below on your WSP AuditLog and disk quota or bandwidth calculator not work WebsitePanel AuditLog Error SQL Collation\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/day.ir\\\/blog\\\/en\\\/websitepanel-auditlog-error-sql-collation\\\/#breadcrumb\"},\"inLanguage\":\"fa-IR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/day.ir\\\/blog\\\/en\\\/websitepanel-auditlog-error-sql-collation\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fa-IR\",\"@id\":\"https:\\\/\\\/day.ir\\\/blog\\\/en\\\/websitepanel-auditlog-error-sql-collation\\\/#primaryimage\",\"url\":\"https:\\\/\\\/day.ir\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/WSP-2.1.0-Error-Collation-01.jpg\",\"contentUrl\":\"https:\\\/\\\/day.ir\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/WSP-2.1.0-Error-Collation-01.jpg\",\"width\":458,\"height\":471,\"caption\":\"WebsitePanel-2.1.0-Error-Collation wsp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/day.ir\\\/blog\\\/en\\\/websitepanel-auditlog-error-sql-collation\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u062e\u0627\u0646\u0647\",\"item\":\"https:\\\/\\\/day.ir\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"WebsitePanel AuditLog Error SQL Collation\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/day.ir\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/day.ir\\\/blog\\\/\",\"name\":\"\u0648\u0628\u0644\u0627\u06af \u062f\u06cc \u062a\u0644\u06a9\u0627\u0645\",\"description\":\"\u0645\u0642\u0627\u0644\u0627\u062a \u0645\u0631\u062a\u0628\u0637 \u0628\u0627 \u0648\u0628\u060c \u0627\u06cc\u0645\u06cc\u0644\u060c \u062f\u0627\u0645\u0646\u0647\u060c \u0634\u0628\u06a9\u0647\u060c \u0637\u0631\u0627\u062d\u06cc \u0633\u0627\u06cc\u062a \u0648 ...\",\"publisher\":{\"@id\":\"https:\\\/\\\/day.ir\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/day.ir\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fa-IR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/day.ir\\\/blog\\\/#organization\",\"name\":\"\u0648\u0628\u0644\u0627\u06af \u062f\u06cc \u062a\u0644\u06a9\u0627\u0645\",\"url\":\"https:\\\/\\\/day.ir\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fa-IR\",\"@id\":\"https:\\\/\\\/day.ir\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/day.ir\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/cropped-favicon.png\",\"contentUrl\":\"https:\\\/\\\/day.ir\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/cropped-favicon.png\",\"width\":511,\"height\":512,\"caption\":\"\u0648\u0628\u0644\u0627\u06af \u062f\u06cc \u062a\u0644\u06a9\u0627\u0645\"},\"image\":{\"@id\":\"https:\\\/\\\/day.ir\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/day.ir\\\/blog\\\/#\\\/schema\\\/person\\\/8896e645096b6a8528b1bb57617f4b8b\",\"name\":\"jafar broujerdi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fa-IR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/163109584cb1bc8719ac5b0cb7d280a96523792861596b891d46ef3d55c7b1b2?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/163109584cb1bc8719ac5b0cb7d280a96523792861596b891d46ef3d55c7b1b2?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/163109584cb1bc8719ac5b0cb7d280a96523792861596b891d46ef3d55c7b1b2?s=96&d=mm&r=g\",\"caption\":\"jafar broujerdi\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"WebsitePanel AuditLog Error SQL Collation - \u0648\u0628\u0644\u0627\u06af \u062f\u06cc \u062a\u0644\u06a9\u0627\u0645","description":"You will see error below on your WSP AuditLog and disk quota or bandwidth calculator not work WebsitePanel AuditLog Error SQL Collation","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/day.ir\/blog\/en\/websitepanel-auditlog-error-sql-collation\/","og_locale":"fa_IR","og_type":"article","og_title":"WebsitePanel AuditLog Error SQL Collation - \u0648\u0628\u0644\u0627\u06af \u062f\u06cc \u062a\u0644\u06a9\u0627\u0645","og_description":"You will see error below on your WSP AuditLog and disk quota or bandwidth calculator not work WebsitePanel AuditLog Error SQL Collation","og_url":"https:\/\/day.ir\/blog\/en\/websitepanel-auditlog-error-sql-collation\/","og_site_name":"\u0648\u0628\u0644\u0627\u06af \u062f\u06cc \u062a\u0644\u06a9\u0627\u0645","article_published_time":"2018-08-07T11:32:44+00:00","article_modified_time":"2022-04-05T18:07:40+00:00","og_image":[{"url":"https:\/\/day.ir\/blog\/wp-content\/uploads\/2022\/03\/WSP-2.1.0-Error-Collation-01.jpg","type":"","width":"","height":""}],"author":"jafar broujerdi","twitter_card":"summary_large_image","twitter_misc":{"\u0646\u0648\u0634\u062a\u0647\u200c\u0634\u062f\u0647 \u0628\u062f\u0633\u062a":"jafar broujerdi","\u0632\u0645\u0627\u0646 \u062a\u0642\u0631\u06cc\u0628\u06cc \u0628\u0631\u0627\u06cc \u062e\u0648\u0627\u0646\u062f\u0646":"5 \u062f\u0642\u06cc\u0642\u0647"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/day.ir\/blog\/en\/websitepanel-auditlog-error-sql-collation\/#article","isPartOf":{"@id":"https:\/\/day.ir\/blog\/en\/websitepanel-auditlog-error-sql-collation\/"},"author":{"name":"jafar broujerdi","@id":"https:\/\/day.ir\/blog\/#\/schema\/person\/8896e645096b6a8528b1bb57617f4b8b"},"headline":"WebsitePanel AuditLog Error SQL Collation","datePublished":"2018-08-07T11:32:44+00:00","dateModified":"2022-04-05T18:07:40+00:00","mainEntityOfPage":{"@id":"https:\/\/day.ir\/blog\/en\/websitepanel-auditlog-error-sql-collation\/"},"wordCount":161,"commentCount":1,"publisher":{"@id":"https:\/\/day.ir\/blog\/#organization"},"image":{"@id":"https:\/\/day.ir\/blog\/en\/websitepanel-auditlog-error-sql-collation\/#primaryimage"},"thumbnailUrl":"https:\/\/day.ir\/blog\/wp-content\/uploads\/2022\/03\/WSP-2.1.0-Error-Collation-01.jpg","articleSection":["Day Blog"],"inLanguage":"fa-IR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/day.ir\/blog\/en\/websitepanel-auditlog-error-sql-collation\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/day.ir\/blog\/en\/websitepanel-auditlog-error-sql-collation\/","url":"https:\/\/day.ir\/blog\/en\/websitepanel-auditlog-error-sql-collation\/","name":"WebsitePanel AuditLog Error SQL Collation - \u0648\u0628\u0644\u0627\u06af \u062f\u06cc \u062a\u0644\u06a9\u0627\u0645","isPartOf":{"@id":"https:\/\/day.ir\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/day.ir\/blog\/en\/websitepanel-auditlog-error-sql-collation\/#primaryimage"},"image":{"@id":"https:\/\/day.ir\/blog\/en\/websitepanel-auditlog-error-sql-collation\/#primaryimage"},"thumbnailUrl":"https:\/\/day.ir\/blog\/wp-content\/uploads\/2022\/03\/WSP-2.1.0-Error-Collation-01.jpg","datePublished":"2018-08-07T11:32:44+00:00","dateModified":"2022-04-05T18:07:40+00:00","description":"You will see error below on your WSP AuditLog and disk quota or bandwidth calculator not work WebsitePanel AuditLog Error SQL Collation","breadcrumb":{"@id":"https:\/\/day.ir\/blog\/en\/websitepanel-auditlog-error-sql-collation\/#breadcrumb"},"inLanguage":"fa-IR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/day.ir\/blog\/en\/websitepanel-auditlog-error-sql-collation\/"]}]},{"@type":"ImageObject","inLanguage":"fa-IR","@id":"https:\/\/day.ir\/blog\/en\/websitepanel-auditlog-error-sql-collation\/#primaryimage","url":"https:\/\/day.ir\/blog\/wp-content\/uploads\/2022\/03\/WSP-2.1.0-Error-Collation-01.jpg","contentUrl":"https:\/\/day.ir\/blog\/wp-content\/uploads\/2022\/03\/WSP-2.1.0-Error-Collation-01.jpg","width":458,"height":471,"caption":"WebsitePanel-2.1.0-Error-Collation wsp"},{"@type":"BreadcrumbList","@id":"https:\/\/day.ir\/blog\/en\/websitepanel-auditlog-error-sql-collation\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u062e\u0627\u0646\u0647","item":"https:\/\/day.ir\/blog\/"},{"@type":"ListItem","position":2,"name":"WebsitePanel AuditLog Error SQL Collation"}]},{"@type":"WebSite","@id":"https:\/\/day.ir\/blog\/#website","url":"https:\/\/day.ir\/blog\/","name":"\u0648\u0628\u0644\u0627\u06af \u062f\u06cc \u062a\u0644\u06a9\u0627\u0645","description":"\u0645\u0642\u0627\u0644\u0627\u062a \u0645\u0631\u062a\u0628\u0637 \u0628\u0627 \u0648\u0628\u060c \u0627\u06cc\u0645\u06cc\u0644\u060c \u062f\u0627\u0645\u0646\u0647\u060c \u0634\u0628\u06a9\u0647\u060c \u0637\u0631\u0627\u062d\u06cc \u0633\u0627\u06cc\u062a \u0648 ...","publisher":{"@id":"https:\/\/day.ir\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/day.ir\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fa-IR"},{"@type":"Organization","@id":"https:\/\/day.ir\/blog\/#organization","name":"\u0648\u0628\u0644\u0627\u06af \u062f\u06cc \u062a\u0644\u06a9\u0627\u0645","url":"https:\/\/day.ir\/blog\/","logo":{"@type":"ImageObject","inLanguage":"fa-IR","@id":"https:\/\/day.ir\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/day.ir\/blog\/wp-content\/uploads\/2024\/09\/cropped-favicon.png","contentUrl":"https:\/\/day.ir\/blog\/wp-content\/uploads\/2024\/09\/cropped-favicon.png","width":511,"height":512,"caption":"\u0648\u0628\u0644\u0627\u06af \u062f\u06cc \u062a\u0644\u06a9\u0627\u0645"},"image":{"@id":"https:\/\/day.ir\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/day.ir\/blog\/#\/schema\/person\/8896e645096b6a8528b1bb57617f4b8b","name":"jafar broujerdi","image":{"@type":"ImageObject","inLanguage":"fa-IR","@id":"https:\/\/secure.gravatar.com\/avatar\/163109584cb1bc8719ac5b0cb7d280a96523792861596b891d46ef3d55c7b1b2?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/163109584cb1bc8719ac5b0cb7d280a96523792861596b891d46ef3d55c7b1b2?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/163109584cb1bc8719ac5b0cb7d280a96523792861596b891d46ef3d55c7b1b2?s=96&d=mm&r=g","caption":"jafar broujerdi"}}]}},"_links":{"self":[{"href":"https:\/\/day.ir\/blog\/wp-json\/wp\/v2\/posts\/579","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/day.ir\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/day.ir\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/day.ir\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/day.ir\/blog\/wp-json\/wp\/v2\/comments?post=579"}],"version-history":[{"count":12,"href":"https:\/\/day.ir\/blog\/wp-json\/wp\/v2\/posts\/579\/revisions"}],"predecessor-version":[{"id":1209,"href":"https:\/\/day.ir\/blog\/wp-json\/wp\/v2\/posts\/579\/revisions\/1209"}],"wp:attachment":[{"href":"https:\/\/day.ir\/blog\/wp-json\/wp\/v2\/media?parent=579"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/day.ir\/blog\/wp-json\/wp\/v2\/categories?post=579"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/day.ir\/blog\/wp-json\/wp\/v2\/tags?post=579"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}