?
avatar waader
waader
23 Feb 2015

The Similar tags module gives the following error:

42 [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'count'.SQL=SELECT [m].[core_content_id],[m].[content_item_id],[m].[type_alias],COUNT( [tag_id]) AS [count],[ct].[router],[cc].[core_title],[cc].[core_alias],[cc].[core_catid],[cc].[core_language],[cc].[core_params] , ROW_NUMBER() OVER (ORDER BY [count] DESC) AS RowNumber FROM [aqmag_contentitem_tag_map] AS [m] INNER JOIN [aqmag_tags] AS [t] ON m.tag_id = t.id INNER JOIN [aqmag_ucm_content] AS [cc] ON m.core_content_id = cc.core_content_id INNER JOIN [aqmag_content_types] AS [ct] ON m.type_alias = ct.type_alias WHERE [m].[tag_id] IN (2,3,4,5) AND t.access IN (1,1) AND (cc.core_access IN (1,1) OR cc.core_access = 0) AND ([m].[content_item_id] <> 24 OR [m].[type_alias] <> 'com_content.article') AND [cc].[core_state] = 1 AND ([cc].[core_publish_up]='1900-01-01 00:00:00' OR [cc].[core_publish_up]<='2015-02-23 18:18:17') AND ([cc].[core_publish_down]='1900-01-01 00:00:00' OR [cc].[core_publish_down]>='2015-02-23 18:18:17') GROUP BY [m].[core_content_id],[m].[content_item_id],[m].[type_alias],[ct].[router],[cc].[core_title],[cc].[core_alias],[cc].[core_catid],[cc].[core_language],[cc].[core_params]

avatar waader waader - open - 23 Feb 2015
avatar joomla-cms-bot joomla-cms-bot - change - 23 Feb 2015
Labels Added: ?
avatar pmorrisarctg
pmorrisarctg - comment - 23 Feb 2015

At first look of the error it looks like the column [count] is still being referenced for tag sorting. The core test data must be updated for conform to MS SQL code. Does that help? We can take a look at this module and update the data if needed. Looks like it may be.

avatar waader
waader - comment - 23 Feb 2015

I have install the testing sample data but could not spot a problem here. I suspect that the query is not build in a compatible way.

avatar pmorrisarctg
pmorrisarctg - comment - 23 Feb 2015

Yes the sample data has column=count. There must be another instance that needs to be corrected in the sample data. We can take a look?

Thanks again.
Patrick

avatar waader
waader - comment - 23 Feb 2015

That would be great. Thanks!

avatar zero-24 zero-24 - change - 24 Feb 2015
Category MS SQL
avatar brianteeman brianteeman - change - 25 Feb 2015
Labels Removed: ?
avatar brianteeman brianteeman - change - 25 Feb 2015
Labels Added: ?
avatar brianteeman brianteeman - change - 12 Nov 2015
Status New Information Required
avatar brianteeman
brianteeman - comment - 12 Nov 2015

It has been 9 months since the last comment - is this still an issue or has it been resolved elsewhere and can be closed?


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/6160.

avatar waader
waader - comment - 12 Nov 2015

I will retest at the weekend.

avatar waader
waader - comment - 15 Nov 2015

This issue can be closed as it is not present anymore. Thanks!

avatar zero-24
zero-24 - comment - 15 Nov 2015

Thanks

avatar zero-24 zero-24 - change - 15 Nov 2015
Status Information Required Closed
Closed_Date 0000-00-00 00:00:00 2015-11-15 19:10:49
Closed_By zero-24
avatar zero-24 zero-24 - close - 15 Nov 2015
avatar zero-24 zero-24 - close - 15 Nov 2015

Add a Comment

Login with GitHub to post a comment