Создал вручную таблицу:
Код:
CREATE TABLE `customer_log` (
`id` int(11) NOT NULL,
`title` varchar(255) NOT NULL,
`title_pattern` varchar(255),
`title_pattern_id` int(11) NOT NULL DEFAULT '-1',
`param_group_id` int(11) NOT NULL DEFAULT '0',
`date_changed` datetime NOT NULL,
`user_id_changed` int(11) NOT NULL );
Стал доступен интерфейс создания контрагентов. Но созданные контрагенты не отображаются, хотя в таблицах записи появляются.
Код:
mysql> select * from customer_log;
+----+---------------------+---------------+------------------+----------------+---------------------+-----------------+
| id | title | title_pattern | title_pattern_id | param_group_id | date_changed | user_id_changed |
+----+---------------------+---------------+------------------+----------------+---------------------+-----------------+
| 15 | ▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒ | NULL | -1 | 0 | 2011-12-13 02:49:31 | -1 |
| 15 | ▒▒▒ "▒▒▒▒ ▒ ▒▒▒▒▒▒" | | -1 | 1 | 2011-12-13 02:53:17 | -1 |
| 16 | ▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒ | NULL | -1 | 0 | 2011-12-13 02:54:05 | -1 |
| 1 | ▒▒▒ "▒▒▒▒ ▒ ▒▒▒▒▒▒" | | -1 | 0 | 2011-12-13 02:55:18 | -1 |
| 17 | ▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒ | NULL | -1 | 0 | 2011-12-13 03:21:26 | -1 |
| 18 | ▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒ | NULL | -1 | 0 | 2011-12-13 03:22:32 | -1 |
| 18 | 1111 | | 0 | 1 | 2011-12-13 03:23:00 | -1 |
+----+---------------------+---------------+------------------+----------------+---------------------+-----------------+
7 rows in set (0.00 sec)
mysql> select * from customer;
+----+---------------------+------------------+---------------+----------------+---------------------+-----------------+------+
| id | title | title_pattern_id | title_pattern | param_group_id | date_created | user_id_created | pswd |
+----+---------------------+------------------+---------------+----------------+---------------------+-----------------+------+
| 2 | ▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒ | -1 | NULL | 0 | 2011-12-12 01:04:07 | -1 | |
| 3 | ▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒ | -1 | NULL | 0 | 2011-12-12 01:06:04 | -1 | |
| 4 | ▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒ | -1 | NULL | 0 | 2011-12-12 01:06:13 | -1 | |
| 5 | ▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒ | -1 | NULL | 0 | 2011-12-12 01:13:18 | -1 | |
| 6 | ▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒ | -1 | NULL | 0 | 2011-12-12 01:30:22 | -1 | |
| 7 | ▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒ | -1 | NULL | 0 | 2011-12-12 02:56:29 | -1 | |
| 8 | ▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒ | -1 | NULL | 0 | 2011-12-12 03:20:46 | -1 | |
| 9 | ▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒ | -1 | NULL | 0 | 2011-12-12 15:30:10 | -1 | |
| 10 | ▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒ | -1 | NULL | 0 | 2011-12-12 15:44:54 | -1 | |
| 11 | ▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒ | -1 | NULL | 0 | 2011-12-12 15:58:50 | -1 | |
| 12 | ▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒ | -1 | NULL | 0 | 2011-12-13 01:45:51 | -1 | |
| 13 | ▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒ | -1 | NULL | 0 | 2011-12-13 01:53:17 | -1 | |
| 14 | ▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒ | -1 | NULL | 0 | 2011-12-13 02:25:49 | -1 | |
| 15 | ▒▒▒ "▒▒▒▒ ▒ ▒▒▒▒▒▒" | -1 | | 1 | 2011-12-13 02:49:31 | -1 | |
| 16 | ▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒ | -1 | NULL | 0 | 2011-12-13 02:54:05 | -1 | |
| 17 | ▒▒▒▒▒ ▒▒▒▒▒▒▒▒▒▒ | -1 | NULL | 0 | 2011-12-13 03:21:26 | -1 | |
| 18 | 1111 | 0 | | 1 | 2011-12-13 03:22:32 | -1 | |
+----+---------------------+------------------+---------------+----------------+---------------------+-----------------+------+
17 rows in set (0.00 sec)
Вызвали подозрение user_id_changed и user_id_created, заменил их на id создавшего из пользователя - не помогло!