Добрый день, помогите разобраться с проблемой: не могу создать тариф "Создание услуги не выполнено", в дебаге:
Field 'category' doesn't have a default value
{
'param' => [
'inet_unlim',
'test511',
'',
'0',
0,
0,
',4,5,1,3,',
'$VAR1 = {\'speed_out4\' => \'\',\'min_traf\' => \'\',\'speed_in1\' => 1000000,\'speed_out2\' => \'\',\'speed_in2\' => \'\',\'speed_in3\' => \'\',\'speed_out3\' => \'\',\'tags\' => \'\',\'period\' => 2592000,\'finish_count\' => \'1\',\'script\' => \'\',\'mode\' => \'\',\'speed_in4\' => \'\',\'wait_pos_balance\' => \'0\',\'speed_out1\' => 1000000};'
],
'sql' => 'INSERT INTO services SET module=?, title=?, description=?, price=?, auto_renew=?, no_renew=?, grp_list=?, param=?'
};
INSERT INTO services SET module='inet_unlim', title='test511', description='', price='0', auto_renew='0', no_renew='0', grp_list=',4,5,1,3,', param='$VAR1 = {\'speed_out4\' => \'\',\'min_traf\' => \'\',\'speed_in1\' => 1000000,\'speed_out2\' => \'\',\'speed_in2\' => \'\',\'speed_in3\' => \'\',\'speed_out3\' => \'\',\'tags\' => \'\',\'period\' => 2592000,\'finish_count\' => \'1\',\'script\' => \'\',\'mode\' => \'\',\'speed_in4\' => \'\',\'wait_pos_balance\' => \'0\',\'speed_out1\' => 1000000};'
root@localhost [nodeny]> DESCRIBE services;
+-------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+---------------------+------+-----+---------+----------------+
| service_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| module | varchar(64) | NO | | NULL | |
| category | varchar(64) | NO | | NULL | |
| title | varchar(64) | NO | | NULL | |
| description | varchar(512) | NO | | NULL | |
| grp_list | longtext | NO | | NULL | |
| conditions | varchar(512) | NO | | | |
| price | float | NO | | 0 | |
| auto_renew | tinyint(3) unsigned | NO | | 0 | |
| no_renew | tinyint(3) unsigned | NO | | 0 | |
| param | longtext | NO | | NULL | |
+-
------------+---------------------+------+-----+---------+----------------+
