1 reply [Last post]
justinammerlaan's picture
Offline
Joined: 02/02/2012
Juice: 8
Was this information Helpful?

Hi

I am getting this exception in a new store installed on MSSQL for anonymous users only

PDOException: SQLSTATE[22018]: [Microsoft][SQL Server Native Client 10.0][SQL Server]Conversion failed when converting the nvarchar value 'd929b1c85caf037db99d7820c0ccf607' to data type int.: SELECT base.[uid] AS [uid], base.[name] AS [name], base.[pass] AS [pass], base.[mail] AS [mail], base.[theme] AS [theme], base.[signature] AS [signature], base.[signature_format] AS [signature_format], base.[created] AS [created], base.[access] AS [access], base.[login] AS [login], base.[status] AS [status], base.[timezone] AS [timezone], base.[language] AS [language], base.[picture] AS [picture], base.[init] AS [init], base.[data] AS [data] FROM {users} base WHERE ( ([base].[uid] IN (:db_condition_placeholder_0)) ); Array ( [:db_condition_placeholder_0] => d929b1c85caf037db99d7820c0ccf607

It seems the anonymous user is a guid in the code, but in the database the anonymous user is a 0

What do you suggest i do to resolve this issue?

Thanks

TR
TR's picture
Offline
Bug FinderFAQ ModeratorGetting busy with the Ubercode.
Joined: 11/05/2007
Juice: 3286
Re: MS SQL Exception when anonymous user clicks 'add to cart'

Why are you posting this question a second time? You already posted at http://www.ubercart.org/forum/support/30545/ms_sql_exception_when_anonym..., and you received and answer.

<tr>.