Admin Admin
Сообщения : 74 Очки : 71 Дата регистрации : 2010-08-23
| Тема: Проблема с zuker reports 1.10-1.11 при нажатии на кнопку ON-demand. Вс Сен 05, 2010 4:35 pm | |
| Вылезает ошибка - Код:
-
Error retrieving ListingTemplate list: Query Failed: SELECT zucker_listingtemplates.* , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner , 'Users' created_by_name_mod , jt2.user_name modified_user_name , jt2.created_by modified_user_name_owner , 'Users' modified_user_name_mod , jt3.user_name modified_by_name , jt3.created_by modified_by_name_owner , 'Users' modified_by_name_mod FROM zucker_listingtemplates LEFT JOIN users jt0 ON jt0.id= zucker_reporttemplate.assigned_user_id AND jt0.deleted=0 AND jt0.deleted=0 LEFT JOIN users jt1 ON jt1.id= zucker_reporttemplate.created_by AND jt1.deleted=0 AND jt1.deleted=0 LEFT JOIN users jt2 ON jt2.id= zucker_listingtemplate.modified_user_id AND jt2.deleted=0 AND jt2.deleted=0 LEFT JOIN users jt3 ON jt3.id= zucker_listingtemplate.modified_user_id AND jt3.deleted=0 AND jt3.deleted=0 where zucker_listingtemplates.deleted=0 ORDER BY zucker_listingtemplates.name LIMIT 0,1000::MySQL error 1054: Unknown column 'zucker_reporttemplate.assigned_user_id' in 'on clause' заходим в \modules\ZuckerReports\ReportProviderBase.php и после этой функции - Код:
-
function get_all($order_by = "", $where = "") { $list = parent::get_list($order_by, $where, 0, 1000, 1000, 0); $list = $list["list"];
if (!empty($list)) $list = SimpleTeams::filterBeanList($list); return $list; } вставляем - Код:
-
function create_new_list_query($order_by, $where, $show_deleted = 0) { $custom_join = false;
if(isset($this->custom_fields)) $custom_join = $this->custom_fields->getJOIN(); $query = "SELECT ";
if($custom_join) { $query .= " $this->table_name.*". $custom_join['select']. " FROM $this->table_name " . $custom_join['join']; } else { $query .= " $this->table_name.* FROM $this->table_name "; } $where_auto = '1=1'; if($show_deleted == 0) { $where_auto = "$this->table_name.deleted=0"; } else if($show_deleted == 1) { $where_auto = "$this->table_name.deleted=1"; } if($where != "") $query .= "where ($where) AND $where_auto"; else $query .= "where $where_auto";
if(!empty($order_by)) $query .= " ORDER BY $order_by";
return $query; } | |
|