tracker icon indicating copy to clipboard operation
tracker copied to clipboard

Issue with Firefox and SQL server database

Open sudinem opened this issue 4 years ago • 0 comments

I am getting this error when I open the page from firefox browser.

I found that the data in tracker_devices tables are like webkit(string) and some 0 (integer) for model column.

How to fix this issue ?

[2019-08-30 12:24:19] production.ERROR: SQLSTATE[22018]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Conversion failed when converting the nvarchar value 'WebKit' to data type int. (SQL: select top 1 * from [tracker_devices] where [kind] = Computer and [model] = 0 and [platform] = Windows and [platform_version] = 10) {"exception":"[object] (Illuminate\Database\QueryException(code: 22018): SQLSTATE[22018]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Conversion failed when converting the nvarchar value 'WebKit' to data type int. (SQL: select top 1 * from [tracker_devices] where [kind] = Computer and [model] = 0 and [platform] = Windows and [platform_version] = 10) at C:\wamp64\www\blog\vendor\laravel\framework\src\Illuminate\Database\Connection.php:664, Doctrine\DBAL\Driver\PDOException(code: 22018): SQLSTATE[22018]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Conversion failed when converting the nvarchar value 'WebKit' to data type int. at C:\wamp64\www\blog\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php:119, PDOException(code: 22018): SQLSTATE[22018]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Conversion failed when converting the nvarchar value 'WebKit' to data type int. at C:\wamp64\www\blog\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php:117)

sudinem avatar Aug 30 '19 11:08 sudinem