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

This forum is for issues with installing Joomla! 3.x on IIS webservers.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
RamonSmitheman
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Thu Dec 01, 2016 3:10 pm

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

Postby RamonSmitheman » Thu Dec 01, 2016 6:38 pm

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.
Last edited by toivo on Sun Dec 04, 2016 8:09 am, edited 1 time in total.
Reason: mod note: moved to IIS forum - please post to the correct forum in the future

RamonSmitheman
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Thu Dec 01, 2016 3:10 pm

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

Postby RamonSmitheman » Tue Dec 06, 2016 6:25 pm

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.

irvfrost
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Thu Mar 31, 2011 7:33 pm

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

Postby irvfrost » Fri Mar 10, 2017 1:42 am

did you ever resolve this? I'm having the exact same issue.


Return to “Joomla! 3.x on IIS webserver”

Who is online

Users browsing this forum: No registered users and 4 guests