Page 1 of 1

New Install (MS SQL Svr) invalid object supplied / SQL Syntax errors

Posted: Thu Dec 01, 2016 6:38 pm
by RamonSmitheman
Just installed Joomla 3.6.4 on hosting site usiing MS SQL Server. install went well but there are program error everywhere.

For example:
Popular Tags

Warning: Invalid argument supplied for foreach() in E:\HostingSpaces\dreamcat\learning360.expert\wwwroot\libraries\joomla\database\query\sqlsrv.php on line 394

----
Error


[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near ')'. SQL=SELECT * FROM ( SELECT a.tag_id,a.count,a.title,a.access,a.alias , ROW_NUMBER() OVER (ORDER BY count DESC) AS RowNumber FROM [#__contentitem_tag_map] AS [m] INNER JOIN [#__tags] AS [t] ON [tag_id] = t.id INNER JOIN [#__ucm_content] AS [c] ON [m].[core_content_id] = [c].[core_content_id] WHERE [t].[access] IN (1,5,1) AND [t].[published] = 1 AND [m].[type_alias] = [c].[core_type_alias] AND [c].[core_state] = 1 AND ([c].[core_publish_up] = '1900-01-01 00:00:00' OR [c].[core_publish_up] <= '2016-12-01 18:34:38') AND ([c].[core_publish_down] = '1900-01-01 00:00:00' OR [c].[core_publish_down] >= '2016-12-01 18:34:38') GROUP BY [tag_id],[title],[access],[alias], ) A WHERE A.RowNumber BETWEEN 1 AND 8) AS a ORDER BY a.title DESC) AS RowNumber FROM (SELECT * FROM ( SELECT MAX([tag_id]) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX([t].[access]) AS access,MAX([t].[alias]) AS alias,MAX([t].[params]) AS params , ROW_NUMBER() OVER () A WHERE A.RowNumber BETWEEN 1 AND 8

An error has occurred.

Re: New Install (MS SQL Svr) invalid object supplied / SQL Syntax errors

Posted: Tue Dec 06, 2016 6:25 pm
by RamonSmitheman
does anyone have any idea how I should go about getting this to work. It appears to me that Joomla using SQL Sver is dead on arrival.

Re: New Install (MS SQL Svr) invalid object supplied / SQL Syntax errors

Posted: Fri Mar 10, 2017 1:42 am
by irvfrost
did you ever resolve this? I'm having the exact same issue.