conversion error in umbraco folder of tea commerce starter kit

Go to solution

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

Jeremy Holland 20 posts 103 karma points

Aug 29, 2012 @ 18:24

Tea Commerce support

I followed the starter kit installation instructions. The site seems to have no content and when I try to login to the backoffice a conversion failure exception is thrown. I think that I've done everything right up to step 11 in the documentation.

Thanks for your help.

Umbraco version 4.8.1, ASP.NET 4.0, Windows 7, IIS 7.5

Conversion failed when converting from a character string to uniqueidentifier.

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.Data.SqlClient.SqlException: Conversion failed when converting from a character string to uniqueidentifier.

Stack Trace:


[SqlException (0x80131904): Conversion failed when converting from a character string to uniqueidentifier.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +388
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +688
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4403
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6665097
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite) +6667096
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +577
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) +735
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +290
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +167
   umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) +145

[SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery]
   umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) +256
   umbraco.BasePages.BasePage.ClearLogin() +143
   System.EventHandler.Invoke(Object sender, EventArgs e) +0
   umbraco.BasePages.BasePage.OnLoad(EventArgs e) +19
   System.Web.UI.Control.LoadRecursive() +71
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3178

Copy Link

Anders Burla 2560 posts 8256 karma points

Aug 30, 2012 @ 09:15

0

Hi Jeremy

What database do you use? MSSQL?

Did you get any errors when you ran the DB sql script?

Kind regards
Anders

Copy Link
Anthony Candaele 1197 posts 2049 karma points

Aug 30, 2012 @ 09:23

0

Hi,

I experienced the same error and I'm not using Tea Commerce. As Carsten suggests, it might be a problem with cookies and Chrome:

http://our.umbraco.org/forum/getting-started/installing-umbraco/34147-Conversion-failed-when-converting-from-a-character-string-to-uniqueidentifier?p=0#comment125439

hope this helps,

Anthony

Copy Link
Jeremy Holland 20 posts 103 karma points

Aug 31, 2012 @ 17:55

0

Thanks for the fix, Anthony!

Copy Link
Jeremy Holland 20 posts 103 karma points

Aug 31, 2012 @ 17:55

0

Thanks for the fix, Anthony!

Copy Link
Anthony Candaele 1197 posts 2049 karma points

Aug 31, 2012 @ 18:01

0

Hi Jeremy,

Glad I could be of any help.

Anthony

Copy Link
is working on a reply...

Please Sign in or register to post replies