abills.net.ua

Код: Выделить всё

DBD::mysql::st execute failed: Unknown column 'dv.disabl' in 'where clause' at /usr/abills/libexec/../Abills/mysql/main.pm line 178.

Код: Выделить всё

/usr/abills/libexec/periodic daily

<p>SELECT u.id, pi.email, dv.tp_id, u.credit, b.deposit, tp.name, tp.uplimit, pi.phone,
      pi.fio
         FROM (users u,
               dv_main dv,
               bills b,
               tarif_plans tp)
         LEFT JOIN users_pi pi ON u.uid = pi.uid
         WHERE
               u.uid=dv.uid
           and u.disable = 0
           and u.bill_id=b.id
           and dv.tp_id = tp.id
           and dv.disable = 0
           and b.deposit<tp.uplimit AND tp.uplimit > 0 AND b.deposit+u.credit>0
         GROUP BY u.uid
         ORDER BY u.id;</p>