VtigerCRM часто с ошибками формирует отчёт по платежам или любой другой отчёт по кастомному модулю, если добавлять связанные поля (т.е. поле контрагент, связан с). К примеру, при попытке построить отчет по платежам и вывести поля "Плательщик" или "Связан с" отчет падает.
После анализа логов ошибок выяснилось, что причина лежит в некорректном SQL-запросе, который дублирует названия полей.
Решение проблемы:
Файл data/CRMEntity.php. Строка 2198, т.е. это
между строками
$ui10_modules_query = $adb->pquery("SELECT relmodule FROM vtiger_fieldmodulerel WHERE fieldid=?", array($field_id));
и
if ($adb->num_rows($ui10_modules_query) > 0) {
Вставить вот эту строчку:
$field_id .= $i;
My most popular posts
I started my own business and intentionally did my best to work from anywhere in the world. Sometimes I sit with my office with a large 27-inch monitor in my apartment in Cheboksary. Sometimes I’m in the office or in some cafe in another city.
I have been working at a remote place for a long time - about 10 years. During this period, I implemented about 7 projects and provided dozens of consultations.
I am a programmer. I am an entrepreneur in my heart. I started making money from the age of 11, in the harsh 90s, handing over glassware to a local store and exchanging it for sweets. I earned so much that was enough for various snacks.
I will make time for your project. Knowledge of Vtiger CRM, SuiteCRM, Laravel, and Vue.js. I offer cooperation options that will help you take advantage of external experience, optimize costs and reduce risks. Full transparency of all stages of work and accounting for time costs. Pay only development working hours after accepting the task. Accept PayPal and Payoneer payment systems. How to hire professional developer? Just fill in the form
