by Izertis

Advanced Marketing Lists automatically fill Target Lists and keep updated the Campaigns to which they are associated.

Includes a 30 day guarantee
Try it Now

#1779 - Database Error

Open Bug? created by edv1 3 years ago

Hey, I have createt an easy Advanced Marketing Lists with "SELECT * FROM accounts where name = 'test' ;" in the Accountsfilter. This selections gives me 1 record. But i get the fallowing error in the suitecrm.log:

Fri Feb 22 15:08:54 2019 [20359][40a192a6-2267-21cc-7a12-57bc167c6e7f][FATAL] Mysqli_query failed. Fri Feb 22 15:08:54 2019 [20359][40a192a6-2267-21cc-7a12-57bc167c6e7f][FATAL] Error running count query for DHA_Mkt_List List: Query Failed: ( SELECT count(*) c FROM accounts LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c where ( accounts.deleted = 0 and accounts.id IN (SELECT * FROM accounts where name = 'test' ;) ) AND accounts.deleted=0 ): MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';) ) AND accounts.deleted=0 )' at line 1 Fri Feb 22 15:08:54 2019 [20359][40a192a6-2267-21cc-7a12-57bc167c6e7f][FATAL] Exception handling in /var/www/sugarcrm/include/MVC/Controller/SugarController.php:400 Fri Feb 22 15:08:54 2019 [20359][40a192a6-2267-21cc-7a12-57bc167c6e7f][FATAL] Exception in Controller: Datenbank Fehler. Bitte sehen Sie in der Datei sugarcrm.log nach. Fri Feb 22 15:08:54 2019 [20359][40a192a6-2267-21cc-7a12-57bc167c6e7f][FATAL] backtrace:

0 /var/www/sugarcrm/include/database/DBManager.php(353): sugar_die('Datenbank Fehle...')

1 /var/www/sugarcrm/include/database/DBManager.php(328): DBManager->registerError('Error running c...', 'Error running c...', true)

2 /var/www/sugarcrm/include/database/MysqliManager.php(179): DBManager->checkError('Error running c...', true)

3 /var/www/sugarcrm/data/SugarBean.php(1502): MysqliManager->query('( SELECT count(...', true, 'Error running c...')

4 /var/www/sugarcrm/data/SugarBean.php(1253): SugarBean->_get_num_rows_in_query('( SELECT count(...', false)

5 /var/www/sugarcrm/data/SugarBean.php(1016): SugarBean->process_union_list_query(Object(DHA_Mkt_List), '(SELECT account...', '', -1, 10, '', Object(aSubPanel), '( SELECT count(...', Array)

6 /var/www/sugarcrm/include/ListView/ListView.php(1141): SugarBean::get_union_related_list(Object(DHA_Mkt_List), 'accounts.name a...', 'asc', '', '', -1, 10, '', Object(aSubPanel))

7 /var/www/sugarcrm/include/ListView/ListViewSubPanel.php(142): ListView->processUnionBeans(Object(DHA_Mkt_List), Object(aSubPanel), 'dha_mkt_list__a...', false)

8 /var/www/sugarcrm/include/SubPanel/SubPanel.php(220): ListViewSubPanel->process_dynamic_listview('DHA_Mkt_List', Object(DHA_Mkt_List), Object(aSubPanel), false)

9 /var/www/sugarcrm/include/SubPanel/SubPanelTiles.php(357): SubPanel->ProcessSubPanelListView('include/SubPane...', Array)

10 /var/www/sugarcrm/include/MVC/View/SugarView.php(1167): SubPanelTiles->display()

11 /var/www/sugarcrm/include/MVC/View/SugarView.php(239): SugarView->_displaySubPanels()

12 /var/www/sugarcrm/include/MVC/Controller/SugarController.php(435): SugarView->process()

13 /var/www/sugarcrm/include/MVC/Controller/SugarController.php(375): SugarController->processView()

14 /var/www/sugarcrm/include/MVC/SugarApplication.php(113): SugarController->execute()

15 /var/www/sugarcrm/index.php(52): SugarApplication->execute()

16

We use SuiteCRM Versionen 7.10.11 Sugar Versionen 6.5.25 (Build 344). mysql version: mysql Ver 14.14 Distrib 5.7.24, for Linux (x86_64) using EditLine wrapper php version: PHP 7.2.15-1+0~20190209065123.16+stretch~1.gbp3ad8c0 (cli) (built: Feb 9 2019 06:51:24) ( NTS )

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...