1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
| hello this is my return
INITIALIZING WEBSERVICE...FAILED TO SETUP convertlead WEBSERVICE HALFWAY THOURGH
Going to apply the Database Changes...
510 ==> 520rc Database changes -- Starts.
FAILURE CREATE TABLE IF NOT EXISTS vtiger_tab_info (tabid INT, prefname VARCHAR(256), prefvalue VARCHAR(256), FOREIGN KEY fk_1_vtiger_tab_info(tabid) REFERENCES vtiger_tab(tabid) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8;
FAILURE update vtiger_field set quickcreate=3 where tabid = 8 and columnname = 'filelocationtype'
FAILURE INSERT INTO vtiger_field(tabid, fieldid, columnname, tablename, generatedtype, uitype, fieldname, fieldlabel, readonly, presence, selected, maximumlength, sequence, block, displaytype, typeofdata, quickcreate, quickcreatesequence, info_type, masseditable, helpinfo) VALUES (4,1, 'campaignrelstatus', 'vtiger_campaignrelstatus', 1, '16', 'campaignrelstatus', 'Status', 1, 0, 0, 100, 1, NULL, 1, 'V~O', 1, NULL, 'BAS', 0, NULL)
FAILURE INSERT INTO vtiger_field(tabid, fieldid, columnname, tablename, generatedtype, uitype, fieldname, fieldlabel, readonly, presence, selected, maximumlength, sequence, block, displaytype, typeofdata, quickcreate, quickcreatesequence, info_type, masseditable, helpinfo) VALUES (6,2, 'campaignrelstatus', 'vtiger_campaignrelstatus', 1, '16', 'campaignrelstatus', 'Status', 1, 0, 0, 100, 1, NULL, 1, 'V~O', 1, NULL, 'BAS', 0, NULL)
FAILURE INSERT INTO vtiger_field(tabid, fieldid, columnname, tablename, generatedtype, uitype, fieldname, fieldlabel, readonly, presence, selected, maximumlength, sequence, block, displaytype, typeofdata, quickcreate, quickcreatesequence, info_type, masseditable, helpinfo) VALUES (7,3, 'campaignrelstatus', 'vtiger_campaignrelstatus', 1, '16', 'campaignrelstatus', 'Status', 1, 0, 0, 100, 1, NULL, 1, 'V~O', 1, NULL, 'BAS', 0, NULL)
FAILURE INSERT INTO vtiger_field(tabid, fieldid, columnname, tablename, generatedtype, uitype, fieldname, fieldlabel, readonly, presence, selected, maximumlength, sequence, block, displaytype, typeofdata, quickcreate, quickcreatesequence, info_type, masseditable, helpinfo) VALUES (26,4, 'campaignrelstatus', 'vtiger_campaignrelstatus', 1, '16', 'campaignrelstatus', 'Status', 1, 0, 0, 100, 1, NULL, 1, 'V~O', 1, NULL, 'BAS', 0, NULL)
SUCCESS CREATE TABLE vtiger_campaignrelstatus ( campaignrelstatusid INTEGER, campaignrelstatus VARCHAR(200), sortorderid INT, presence INT) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SUCCESS INSERT INTO vtiger_campaignrelstatus VALUES (1, '--None--',1,1)
SUCCESS INSERT INTO vtiger_campaignrelstatus VALUES (2, 'Contacted - Successful',2,1)
SUCCESS INSERT INTO vtiger_campaignrelstatus VALUES (3, 'Contected - Unsuccessful',3,1)
SUCCESS INSERT INTO vtiger_campaignrelstatus VALUES (4, 'Contacted - Never Contact Again',4,1)
SUCCESS CREATE TABLE vtiger_campaignaccountrel ( campaignid INTEGER UNSIGNED NOT NULL, accountid INTEGER UNSIGNED NOT NULL, campaignrelstatusid INTEGER UNSIGNED DEFAULT 1) ENGINE = InnoDB DEFAULT CHARSET=utf8;
SUCCESS ALTER TABLE vtiger_campaignaccountrel ADD PRIMARY KEY (campaignid, accountid)
FAILURE ALTER TABLE vtiger_campaigncontrel ADD COLUMN campaignrelstatusid INTEGER UNSIGNED NOT NULL DEFAULT 1
FAILURE ALTER TABLE vtiger_campaignleadrel ADD COLUMN campaignrelstatusid INTEGER UNSIGNED NOT NULL DEFAULT 1
FAILURE INSERT INTO vtiger_relatedlists VALUES (1, 6, 26, 'get_campaigns', 13, 'Campaigns', 0, 'select')
FAILURE INSERT INTO vtiger_relatedlists VALUES (2, 26, 6, 'get_accounts', 5, 'Accounts', 0, 'add,select')
FAILURE ALTER TABLE vtiger_systems ADD from_email_field varchar(50);
FAILURE update vtiger_field set masseditable=0 where tablename='vtiger_products' and columnname='unit_price'
thanks for any help |
Partager