tracker
tracker copied to clipboard
Issue with Firefox and SQL server database
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)