Проблема с модулем после обновления на некст
mysql 5.7
Не дает создать новую услугу
Unknown column 'plain_description' in 'field list'
{
'param' => [
'trinitytv',
'1',
'1',
'',
1,
1,
0,
',,',
'$VAR1 = {\'mode\' => \'\',\'subscrid\' => \'1488\',\'wait_pos_balance\' => \'0\',\'period\' => 2592000,\'finish_count\' => \'1\'};'
],
'sql' => 'INSERT INTO services SET module=?, title=?, description=?, plain_description=?, price=?, auto_renew=?, no_renew=?, grp_list=?, param=?'
};
INSERT INTO services SET module='trinitytv', title='1', description='1', plain_description='', price='1', auto_renew='1', no_renew='0', grp_list=',,', param='$VAR1 = {\'mode\' => \'\',\'subscrid\' => \'1488\',\'wait_pos_balance\' => \'0\',\'period\' => 2592000,\'finish_count\' => \'1\'};'
Поможет DROP TABLE services; и заново пересоздать?
CREATE TABLE `services` (
`service_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`module` varchar(64) NOT NULL,
`category` varchar(64) NOT NULL DEFAULT '',
`title` varchar(64) NOT NULL,
`description` varchar(512) NOT NULL,
`plain_description` varchar(512) NOT NULL DEFAULT '',
`grp_list` longtext NOT NULL,
`conditions` varchar(512) NOT NULL DEFAULT '',
`price` float NOT NULL DEFAULT '0',
`auto_renew` tinyint(3) unsigned NOT NULL DEFAULT '0',
`no_renew` tinyint(3) unsigned NOT NULL DEFAULT '0',
`param` longtext NOT NULL,
PRIMARY KEY (`service_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;