Joomla! Issue Tracker - CMS

Download
Launch
Feeling Lucky

[#13508] - Mssql: Syntax error when installing a language in backend

?
avatar waader
waader
8 Jan 2017

Steps to reproduce the issue

You will get:
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'use'.

Expected result

Actual result

System information (as much as possible)

Additional comments

avatar waader waader - open - 8 Jan 2017
avatar joomla-cms-bot joomla-cms-bot - change - 8 Jan 2017
Labels Added: ?
avatar joomla-cms-bot joomla-cms-bot - labeled - 8 Jan 2017
avatar zero-24
zero-24 - comment - 8 Jan 2017

do you have the failing SQL query?

avatar waader
waader - comment - 8 Jan 2017

Most likely it is this query:

SELECT [us].[location]
FROM [jz8km_extensions] AS [e]
LEFT JOIN [jz8km_update_sites_extensions] AS [use]
ON use.extension_id = e.extension_id
LEFT JOIN [jz8km_update_sites] AS [us]
ON us.update_site_id = use.update_site_id

Reason is, that use is a reserved word.

avatar andrepereiradasilva
andrepereiradasilva - comment - 8 Jan 2017

and that why we always need to quote the db fields ?

avatar andrepereiradasilva
andrepereiradasilva - comment - 8 Jan 2017

Please test #13512

avatar zero-24 zero-24 - change - 8 Jan 2017
Status New ⇒ Closed
Closed_Date 0000-00-00 00:00:00 ⇒ 2017-01-08 14:29:24
Closed_By ⇒ zero-24
avatar zero-24 zero-24 - close - 8 Jan 2017
avatar zero-24
zero-24 - comment - 8 Jan 2017

Thanks

Add a Comment

Login with GitHub to post a comment