starred/SuiteCRM-SuiteCRM

Fork 0

mirror of https://github.com/SuiteCRM/SuiteCRM.git synced 2026-03-02 19:16:58 -05:00

Knowledge base - "No suggestions" #1049

New issue

Closed

opened 2026-02-20 15:04:34 -05:00 by deekerman · 5 comments

deekerman commented

2026-02-20 15:04:34 -05:00

Owner

Originally created by @bojkic on GitHub (Aug 4, 2016).

Issue

Suite 7.7 fresh installation. When entering Case subject, even though there is Knowledge base article with identical name, no suggestions are given

Your Environment

SuiteCRM Version used: 7.7
Browser name and version (e.g. Chrome Version 51.0.2704.63 (64-bit)): Crhome, Win10
Environment name and version (e.g. MySQL, PHP 7): Ubuntu php7 mysql
Operating System and version (e.g Ubuntu 16.04): 16.04

Originally created by @bojkic on GitHub (Aug 4, 2016). #### Issue Suite 7.7 fresh installation. When entering Case subject, even though there is Knowledge base article with identical name, no suggestions are given #### Your Environment  - SuiteCRM Version used: 7.7 - Browser name and version (e.g. Chrome Version 51.0.2704.63 (64-bit)): Crhome, Win10 - Environment name and version (e.g. MySQL, PHP 7): Ubuntu php7 mysql - Operating System and version (e.g Ubuntu 16.04): 16.04

deekerman

2026-02-20 15:04:34 -05:00

closed this issue
added the
Type: Bug

Priority:Important
labels

deekerman commented

2026-02-20 15:04:36 -05:00

Author

Owner

@bojkic commented on GitHub (Aug 5, 2016):

Here is log excerpt:

"Thu Aug 4 18:24:14 2016 [3590][1][FATAL] Query Failed: SELECT id, name, description, status, sum(relevance)
FROM (
SELECT id, name, description, status, 10 AS relevance
FROM aok_knowledgebase
WHERE name = 'proba'
AND deleted = '0'
UNION SELECT id, name, description, status, 5 AS relevance
FROM aok_knowledgebase
WHERE name LIKE '%proba%'
AND deleted = '0'
UNION SELECT id, name, description, status, 2 AS relevance
FROM aok_knowledgebase
WHERE description LIKE '%proba%'
AND deleted = '0'
)results
GROUP BY id
ORDER BY sum( relevance ) DESC
LIMIT 0,30: MySQL error 1055: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'results.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by "

@bojkic commented on GitHub (Aug 5, 2016): Here is log excerpt: "Thu Aug 4 18:24:14 2016 [3590][1][FATAL] Query Failed: SELECT id, name, description, status, sum(relevance) FROM ( SELECT id, name, description, status, 10 AS relevance FROM aok_knowledgebase WHERE name = 'proba' AND deleted = '0' UNION SELECT id, name, description, status, 5 AS relevance FROM aok_knowledgebase WHERE name LIKE '%proba%' AND deleted = '0' UNION SELECT id, name, description, status, 2 AS relevance FROM aok_knowledgebase WHERE description LIKE '%proba%' AND deleted = '0' )results GROUP BY id ORDER BY sum( relevance ) DESC LIMIT 0,30: MySQL error 1055: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'results.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by "

deekerman commented

2026-02-20 15:04:36 -05:00

Author

Owner

@shogunpol commented on GitHub (Aug 15, 2016):

The issue has been checked on SuiteCRM 7.7.1, and PHP 5.5.9, and do not appear.
The issue has been checked on SuiteCRM 7.7.1, and PHP 7, and it appear.
1st - The version of PHP (suggest use more stabil, older version);
2nd - Also if "Knowledge base" is not created "suggestion" does not apear (because is nothing to suggest).

@shogunpol commented on GitHub (Aug 15, 2016): The issue has been checked on SuiteCRM 7.7.1, and PHP 5.5.9, and do not appear. The issue has been checked on SuiteCRM 7.7.1, and PHP 7, **and it appear**. 1st - The version of PHP (suggest use more stabil, older version); 2nd - Also if "Knowledge base" is not created "suggestion" does not apear (because is nothing to suggest).

deekerman commented

2026-02-20 15:04:36 -05:00

Author

Owner

@bojkic commented on GitHub (Aug 15, 2016):

Yes, I am using php7. Bug still exists in 7.7.1

@bojkic commented on GitHub (Aug 15, 2016): Yes, I am using php7. Bug still exists in 7.7.1

deekerman commented

2026-02-20 15:04:36 -05:00

Author

Owner

@mminnie commented on GitHub (Sep 1, 2016):

I don't know if this qualifies as a "bug". It is introduced because as of MySQL 5.7.5, the ONLY_FULL_GROUP_BY was added as a default value to the sql_mode MySQL system variable.

See here

Disabling this setting in MySQL either through the configuration or through code resolves the issue.

This being said, moving forward the code causing the issue should be fixed as it will probably remain to be a default setting in MySQL.

@mminnie commented on GitHub (Sep 1, 2016): I don't know if this qualifies as a "bug". It is introduced because as of MySQL 5.7.5, the ONLY_FULL_GROUP_BY was added as a default value to the sql_mode MySQL system variable. [See here](http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html) Disabling this setting in MySQL either through the configuration or through code resolves the issue. This being said, moving forward the code causing the issue should be fixed as it will probably remain to be a default setting in MySQL.

deekerman commented

2026-02-20 15:04:36 -05:00

Author

Owner

@ijdavie commented on GitHub (Sep 19, 2016):

@mminnie, I would agree, however disabling this in MySQL I dont see is a permanent work around. In the long term the software will need to handle this.

I will mark this as a low priority due to the work around.

@ijdavie commented on GitHub (Sep 19, 2016): @mminnie, I would agree, however disabling this in MySQL I dont see is a permanent work around. In the long term the software will need to handle this. I will mark this as a low priority due to the work around.