In suitecrm.log I have a lot of SQL query error
This is my settup:
Windows Server 2012 R1
Apache 2.4.18 (x64)
PHP 5.6.18 (x64)
Not use Wampserver
MSSQL 2014 with Unofficial Microsoft SQL Server Driver for PHP x64
This is one simple exemple of mistake query :
SELECT
TOP 30 *
FROM(
select
ROW_NUMBER() OVER ( order by sum( relevance ) desc) AS row_number,
*
FROM (
select
id,
name,
description,
status,
sum(relevance)
from (
select id, name, description, status, 10 as relevance from aok_knowledgebase where name = N'ber review' and deleted = '0'
union
select id, name, description, status, 5 as relevance from aok_knowledgebase where name like N'%ber review%' and deleted = '0'
union
select id, name, description, status, 2 as relevance from aok_knowledgebase where description like N'%ber review%' and deleted = '0'
) results group by id
) As numbered
) As top_count_limit
WHERE row_number > 0 order by sum( relevance ) desc
Error on this query
1 : Column ‘results.name’ is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
2 : No column name was specified for column 5 of ‘numbered’.
3 : Invalid column name ‘relevance’.
Somebady have same case of me
I’m don’t know is appear only with MSSQL version.