Upgrading from 1.2.2 -> 1.6.3
Everything goes as expected until error:
mysqlt error: [1054: Unknown column 'processing_order' in 'field list'] in EXECUTE("SELECT MAX(processing_order) FROM contact_field LIMIT 1")
I can add the field to the DB if necessary, but I don't know the field type/properties.
SQL for 1.2.2:
DROP TABLE IF EXISTS `contact_field`;
CREATE TABLE `contact_field` (
`field` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
`type` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
`extra` tinyint(4) DEFAULT '1',
`visible` tinyint(4) DEFAULT '1',
`required` tinyint(4) DEFAULT '1',
`active` tinyint(4) DEFAULT '1',
`position` int(11) DEFAULT NULL,
`filter` tinyint(4) DEFAULT '0',
`param` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`style` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
LOCK TABLES `contact_field` WRITE;
/*!40000 ALTER TABLE `contact_field` DISABLE KEYS */;
INSERT INTO `contact_field` (`field`, `type`, `extra`, `visible`, `required`, `active`, `position`, `filter`, `param`, `style`)
VALUES
('id','foreign index',0,0,1,1,1,0,NULL,NULL),
('General','page_split',0,1,1,1,2,0,NULL,NULL),
('Details','page_split',0,1,1,1,22,0,NULL,NULL),
('Login','integer',0,0,0,1,3,0,'64','number'),
('Last Name','text',0,1,0,1,4,0,'64',''),
('First Name','text',0,1,1,1,5,0,'64',''),
('Company Name','select',0,1,0,1,6,1,'company::Company Name;::',''),
('Related Companies','multiselect',0,0,0,1,7,1,'company::Company Name;::',''),
('Group','multiselect',0,0,0,1,8,0,'__COMMON__::Contacts_Groups',''),
('Title','text',0,1,0,1,9,0,'64',''),
('Work Phone','text',0,1,0,1,10,0,'64',''),
('Mobile Phone','text',0,1,0,1,11,0,'64',''),
('Fax','text',0,0,0,1,12,0,'64',''),
('Email','text',0,1,0,1,13,0,'128',''),
('Web address','text',0,0,0,1,14,0,'64',''),
('Address 1','text',0,0,0,1,15,0,'64',''),
('Address 2','text',0,0,0,1,16,0,'64',''),
('City','text',0,0,0,1,17,0,'64',''),
('Country','commondata',0,0,1,1,18,1,'__Countries',''),
('Zone','commondata',0,0,0,1,19,0,'__Countries::Country',''),
('Postal Code','text',0,1,0,1,20,1,'64',''),
('Permission','commondata',0,0,1,1,21,0,'1__CRM/Access',''),
('Home Phone','text',1,0,0,1,23,0,'64',''),
('Home Address 1','text',1,0,0,1,24,0,'64',''),
('Home Address 2','text',1,0,0,1,25,0,'64',''),
('Home City','text',1,0,0,1,26,0,'64',''),
('Home Country','commondata',1,0,0,1,27,0,'Countries',''),
('Home Zone','commondata',1,0,0,1,28,0,'Countries::Home Country',''),
('Home Postal Code','text',1,0,0,1,29,0,'64',''),
('Birth Date','date',1,0,0,1,30,0,'64','');
/*!40000 ALTER TABLE `contact_field` ENABLE KEYS */;
UNLOCK TABLES;
Can I get the SQL to create the missing field?
Thanx
