abills.net.ua

Обновление не помогли
2013-02-11 20:59:12 LOG_ERR: [].
insert into docs_invoice (invoice_id, date, created, customer, phone, aid, uid,
by_proxy_seria,
by_proxy_person,
by_proxy_date,
payment_id,
deposit,
delivery_status)
values ('1', '2013-02-11', now(), '-', '',.
'3', '99',
'',
'',
'',
'1940',
'',
'');
--1054
--Unknown column 'deposit' in 'field list'



mysql> CREATE TABLE `docs_invoices` (
-> `id` int(11) unsigned NOT NULL auto_increment,
-> `date` date NOT NULL default '0000-00-00',
-> `created` datetime NOT NULL default '0000-00-00 00:00:00',
-> `customer` varchar(200) NOT NULL default '',
-> `phone` varchar(16) NOT NULL default '0',
-> `user` varchar(20) NOT NULL default '',
-> `invoice_num` int(10) unsigned NOT NULL default '0',
-> `uid` int(11) unsigned NOT NULL default '0',
-> `aid` smallint(6) unsigned NOT NULL default '0',
-> `vat` double(5,2) unsigned NOT NULL default '0.00',
-> `domain_id` smallint(6) unsigned not null default 0,
-> `payment_id` int(11) unsigned NOT NULL default 0,
-> `deposit` double(15,6) NOT NULL default '0.000000',
`delivery_status` tinyint(2) unsigned NOT NULL default '0',
-> `delivery_status` tinyint(2) unsigned NOT NULL default '0',
-> `exchange_rate` double(12,4) NOT NULL default '0.0000',
-> `currency` smallint unsigned NOT NULL default 0,
-> PRIMARY KEY (`id`),
-> KEY `payment_id` (`payment_id`),
-> KEY `domain_id` (`domain_id`)
-> ) COMMENT='Docs Invoices' ;

нет колонки депозит скорее всего пропустили при обновлении