Модуль «Files»

#10433 27 апреля 2017 22:20

Профиль

Обнаружил баг, когда не зарегистрированный пользователь заходит на страницу добавления, возникает ошибка

SQL error 42000: Syntax error or access violation: 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 'WHERE g.grp_id IN ( SELECT gru_groupid FROM cot_groups_users WHERE gru_userid = ' at line 5

#0  cot_diefatal(SQL error 42000: Syntax error or access violation: 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 'WHERE g.grp_id IN ( SELECT gru_groupid FROM cot_groups_users WHERE gru_userid = ' at line 5) called at [/home/========/============net./=====/system/database.php:582]
#1  CotDB->query(SELECT MAX(g.grp_pfs_maxfile) AS size_maxfile,  MAX(g.grp_pfs_maxtotal) AS size_maxtotal,
            SUM(f.file_size) as size_used, MAX(g.grp_files_perpost) as count_max
          FROM cot_groups as g
          LEFT JOIN cot_files as f ON f.file_source!='sfs' AND f.user_id=
          WHERE g.grp_id IN ( SELECT gru_groupid FROM cot_groups_users WHERE gru_userid =   )) called at [/home/=====/=======.net/=====/modules/files/inc/files.functions.php:279]

То есть ошибка возникает при запросе в файле files.functions.php

    $tmp = cot::$db->query("SELECT MAX(g.grp_pfs_maxfile) AS size_maxfile,  MAX(g.grp_pfs_maxtotal) AS size_maxtotal,
            SUM(f.file_size) as size_used, MAX(g.grp_files_perpost) as count_max
          FROM $db_groups as g
          LEFT JOIN $db_files as f ON f.file_source!='sfs' AND f.user_id={$urr['user_id']}
          WHERE g.grp_id IN ( SELECT gru_groupid FROM $db_groups_users WHERE gru_userid = {$urr['user_id']}  )")->fetch();

Когда зарегистрированый пользователь открывает страницу добавления, то такой ошибки нет.

prostogorod