J3 Issue ?
avatar HLeithner
HLeithner
12 Jul 2019

The metadata insert query seam to fail on sqlsrv.

INSERT INTO [#__session] ([session_id],[guest],[time],[userid],[username],[client_id])VALUES (N'qc4jsu8lppn2672m2rb5hadjg8', 1, 1562944378, 0, N'', 0)

Error message:
JDatabaseExceptionExecuting: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Implicit conversion from data type nvarchar to varbinary is not allowed. Use the CONVERT function to run this query.

Steps to reproduce the issue

Install Joomla 3.9.10 on Mssql server 2017 and open the frontpage. In 1 of 3 call the request failed with "Error: Failed to start application: Error starting the session.".

Expected result

Nice page

Actual result

Error: Failed to start application: Error starting the session.

System information (as much as possible)

MSSQL Server 2017 Linux

Additional comments

avatar HLeithner HLeithner - open - 12 Jul 2019
avatar joomla-cms-bot joomla-cms-bot - change - 12 Jul 2019
Labels Added: ?
avatar joomla-cms-bot joomla-cms-bot - labeled - 12 Jul 2019
avatar franz-wohlkoenig franz-wohlkoenig - change - 12 Jul 2019
Labels Added: J3 Issue
avatar franz-wohlkoenig franz-wohlkoenig - labeled - 12 Jul 2019
avatar SharkyKZ
SharkyKZ - comment - 12 Jul 2019

There's this closed PR #23213.

avatar HLeithner HLeithner - change - 12 Jul 2019
Status New Closed
Closed_Date 0000-00-00 00:00:00 2019-07-12 16:54:41
Closed_By HLeithner
avatar HLeithner
HLeithner - comment - 12 Jul 2019

Solved by PR #23213

avatar HLeithner HLeithner - close - 12 Jul 2019

Add a Comment

Login with GitHub to post a comment