Биллинговая система Nodeny

tail -100 /usr/local/nodeny/logs/citypay_err.log 

================================================================================
29.07.2015 09:34:20 [skysend.pl(14) paysystem.pm::new(37)]
ip: 91.217.8.11
29.07.2015 09:34:20 [skysend.pl(14) paysystem.pm::new(53) Db.pm::line(143) Db.pm::sql(112) Db.pm::connect(94)]
Connecting to DBI:mysql:database=nodeny;host=localhost;port=3306;mysql_connect_timeout=5 : 0.01576 sec
29.07.2015 09:34:20 [skysend.pl(14) paysystem.pm::new(53) Db.pm::line(143) Db.pm::sql(133) Db.pm::sql(320)]
SELECT *, UNIX_TIMESTAMP() AS t FROM config ORDER BY time DESC LIMIT 1
Строк: 1. Время выполнения sql: 0.0004 сек
29.07.2015 09:34:20 [skysend.pl(14) paysystem.pm::new(86)]
Received data: ProviderId=318&TerminalId=14391&QueryType=pay&TransactionDate=20150729112658&Amount=1&PayElementId=1412&Account=111&TransactionId=218099449
29.07.2015 09:34:20 [skysend.pl(14) paysystem.pm::new(123)]
  Account          = '111'
  Amount           = '1'
  PayElementId     = '1412'
  ProviderId       = '318'
  QueryType        = 'pay'
  TerminalId       = '14391'
  TransactionDate  = '20150729112658'
  TransactionId    = '218099449'
29.07.2015 09:34:20 [skysend.pl(75) skysend.pl::make_pay(116) paysystem.pm::Make_pay(233) paysystem.pm::Get_account(199) Db.pm::line(143) Db.pm::sql(133) Db.pm::sql(320)]
SELECT * FROM users WHERE name='111'
Строк: 0. Время выполнения sql: 0.0003 сек
29.07.2015 09:34:20 [skysend.pl(75) skysend.pl::make_pay(116) paysystem.pm::Make_pay(233) paysystem.pm::Get_account(225) paysystem.pm::Error_exit(176)]
Account not found
29.07.2015 09:34:20 [skysend.pl(75) skysend.pl::make_pay(116) paysystem.pm::Make_pay(233) paysystem.pm::Get_account(225) paysystem.pm::Error_exit(178) paysystem.pm::Save_err_log(140) paysystem.pm::Save_log(149)]
Elapsed time: 0.038714 sec

================================================================================
29.07.2015 09:39:09 [skysend.pl(14) paysystem.pm::new(37)]
ip: 91.217.8.11
29.07.2015 09:39:09 [skysend.pl(14) paysystem.pm::new(53) Db.pm::line(143) Db.pm::sql(112) Db.pm::connect(94)]
Connecting to DBI:mysql:database=nodeny;host=localhost;port=3306;mysql_connect_timeout=5 : 0.016972 sec
29.07.2015 09:39:09 [skysend.pl(14) paysystem.pm::new(53) Db.pm::line(143) Db.pm::sql(133) Db.pm::sql(320)]
SELECT *, UNIX_TIMESTAMP() AS t FROM config ORDER BY time DESC LIMIT 1
Строк: 1. Время выполнения sql: 0.0004 сек
29.07.2015 09:39:09 [skysend.pl(14) paysystem.pm::new(86)]
Received data: ProviderId=318&TerminalId=14391&QueryType=pay&TransactionDate=20150729112658&Amount=1&PayElementId=1412&Account=1111&TransactionId=218099449
29.07.2015 09:39:09 [skysend.pl(14) paysystem.pm::new(123)]
  Account          = '1111'
  Amount           = '1'
  PayElementId     = '1412'
  ProviderId       = '318'
  QueryType        = 'pay'
  TerminalId       = '14391'
  TransactionDate  = '20150729112658'
  TransactionId    = '218099449'
29.07.2015 09:39:09 [skysend.pl(75) skysend.pl::make_pay(116) paysystem.pm::Make_pay(233) paysystem.pm::Get_account(199) Db.pm::line(143) Db.pm::sql(133) Db.pm::sql(320)]
SELECT * FROM users WHERE name='1111'
Строк: 1. Время выполнения sql: 0.0003 сек
29.07.2015 09:39:09 [skysend.pl(75) skysend.pl::make_pay(116) paysystem.pm::Make_pay(241) Db.pm::begin_work(165)]
start transaction
29.07.2015 09:39:09 [skysend.pl(75) skysend.pl::make_pay(116) paysystem.pm::Make_pay(244) Db.pm::do(157) Db.pm::sql(133) Db.pm::sql(304)]
Field 'comment' doesn't have a default value

{
  'sql' => 'INSERT INTO pays SET category=20, time=UNIX_TIMESTAMP(), mid=?, cash=?, reason=?, creator_ip=INET_ATON(?), creator=?, creator_id=?',
  'param' => [
    '1',
    1,
    'skysend:1438162749:1:14391:20150729112658:218099449',
    '91.217.8.11',
    'other',
    0
  ]
};

 INSERT INTO pays SET category=20, time=UNIX_TIMESTAMP(), mid='1', cash='1', reason='skysend:1438162749:1:14391:20150729112658:218099449', creator_ip=INET_ATON('91.217.8.11'), creator='other', creator_id='0'
29.07.2015 09:39:09 [skysend.pl(75) skysend.pl::make_pay(116) paysystem.pm::Make_pay(252) Db.pm::do(157) Db.pm::sql(114) Db.pm::connect(94)]
Connecting to DBI:mysql:database=nodeny;host=localhost;port=3306;mysql_connect_timeout=5 : 0.000374 sec
29.07.2015 09:39:09 [skysend.pl(75) skysend.pl::make_pay(116) paysystem.pm::Make_pay(252) Db.pm::do(157) Db.pm::sql(133) Db.pm::sql(320)]
UPDATE users SET state = IF(balance+('1') >= limit_balance, 'on', state), balance=balance+('1') WHERE id='1'
Строк: 1. Время выполнения sql: 0.0016 сек
29.07.2015 09:39:09 [skysend.pl(75) skysend.pl::make_pay(116) paysystem.pm::Make_pay(258) Db.pm::line(143) Db.pm::sql(133) Db.pm::sql(320)]
SELECT * FROM pays WHERE id<>'0' AND category=20 AND mid='1' AND reason LIKE 'skysend:%' AND reason LIKE '%:218099449'
Строк: 0. Время выполнения sql: 0.0003 сек
29.07.2015 09:39:09 [skysend.pl(75) skysend.pl::make_pay(116) paysystem.pm::Make_pay(277) Db.pm::rollback(181)]
rollback
29.07.2015 09:39:09 [skysend.pl(75) skysend.pl::make_pay(116) paysystem.pm::Make_pay(278) paysystem.pm::__ANON__(30)]
transaction error at /usr/local/nodeny/nod/paysystem.pm line 278.

29.07.2015 09:39:09 [skysend.pl(75) skysend.pl::make_pay(116) paysystem.pm::Make_pay(278) paysystem.pm::__ANON__(31) paysystem.pm::Save_err_log(140) paysystem.pm::Save_log(149)]
Elapsed time: 0.047618 sec

================================================================================