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

longwave's picture
Offline
Joined: 09/20/2008
Juice: 487
Re: MS SQL Exception when anonymous user clicks 'add to cart'

Please repost this bug report over at http://drupal.org/project/issues/ubercart where it will be investigated properly.

--
These forums are for general support questions about Ubercart.
Bug reports and feature requests should be posted at http://drupal.org/project/issues/ubercart
Latest API documentation can be found at http://api.ubercart.me/