Magnum72 писал(а):
Кстати ты в архивных табличках структуру правил? Недавно поле появилось action
Сам думал, что в этом дело, специально перепроверил.
Код: Выделить всё
mysql> show fields from user_log;
+---------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| user_id | int(11) | NO | | NULL | |
| date | int(11) | NO | | NULL | |
| who | int(11) | NO | | NULL | |
| what | varchar(255) | NO | | NULL | |
| comment | varchar(255) | NO | | | |
| action | int(11) | NO | | 0 | |
+---------+--------------+------+-----+---------+----------------+
Код: Выделить всё
mysql> show fields from `UTM5-archives`.user_log_201407;
+---------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| user_id | int(11) | NO | | NULL | |
| date | int(11) | NO | | NULL | |
| who | int(11) | NO | | NULL | |
| what | varchar(255) | NO | | NULL | |
| comment | varchar(255) | NO | | | |
| action | int(11) | NO | | 0 | |
+---------+--------------+------+-----+---------+----------------+
Странно конечно. Запрос, на который ругается в debug.log вручную отрабатывает без проблем:
Код: Выделить всё
mysql> SELECT user_id,date,who,what,comment,action FROM `UTM5-archives`.user_log_201407 LIMIT 10;
+---------+------------+-----+--------------+--------------------------------------------------------------------------------+--------+
| user_id | date | who | what | comment | action |
+---------+------------+-----+--------------+--------------------------------------------------------------------------------+--------+
| 5857 | 1404162005 | -1 | add IP group | service link <193432>, ip group <68174>, login '', ip '109.229.0.64', MAC '' | 0 |
| 2898 | 1404162141 | -1 | add IP group | service link <219522>, ip group <77410>, login '', ip '109.229.17.228', MAC '' | 0 |
| 15174 | 1404162141 | -1 | add IP group | service link <179993>, ip group <63795>, login '', ip '10.0.0.7', MAC '' | 0 |
| 19694 | 1404162142 | -1 | add IP group | service link <180925>, ip group <64262>, login '', ip '10.0.32.244', MAC '' | 0 |
| 20165 | 1404162142 | -1 | add IP group | service link <187127>, ip group <65987>, login '', ip '10.0.32.167', MAC '' | 0 |
| 22328 | 1404162142 | -1 | add IP group | service link <220213>, ip group <77756>, login '', ip '10.0.33.63', MAC '' | 0 |
| 22085 | 1404162142 | -1 | add IP group | service link <220095>, ip group <77697>, login '', ip '10.0.0.132', MAC '' | 0 |
| 3044 | 1404162142 | -1 | add IP group | service link <165232>, ip group <58806>, login '', ip '176.120.55.201', MAC '' | 0 |
| 8685 | 1404162142 | -1 | add IP group | service link <106219>, ip group <41745>, login '', ip '109.229.8.202', MAC '' | 0 |
| 20567 | 1404162142 | -1 | add IP group | service link <201655>, ip group <72272>, login '', ip '10.0.33.83', MAC '' | 0 |
+---------+------------+-----+--------------+--------------------------------------------------------------------------------+--------+