I am instilling CBsubs on a Godaddy server. Ioncube is installed and i have previously done a succcesful install on another site hosted on Godaddy. I am getting the same error installing on CB 1.71 or 1.8 using respectively CBsubs 1.22 or 1.3 - I paid for this software but I cant see any way to get support unless I pay more!!! error is as follows
Plugin database XML SQL Error CBSQLupgrader::createTableof Table #__cbsubs_plans failed with SQL error: Column length too big for column 'cond_1_plans_required' (max = 255); use BLOB or TEXT instead SQL=CREATE TABLE `jos_cbsubs_plans` ( `id` int(11) unsigned NOT NULL auto_increment, `item_type` varchar(16) NOT NULL DEFAULT '', `published` tinyint(4) NOT NULL DEFAULT 1, `allow_newsubscriptions` tinyint(4) NOT NULL DEFAULT 1, `allow_registration` tinyint(4) NOT NULL DEFAULT 1, `allow_upgrade_to_this` tinyint(4) NOT NULL DEFAULT 1, `allow_frontend` tinyint(4) NOT NULL DEFAULT 1, `propose_registration` tinyint(4) NOT NULL DEFAULT 1, `propose_upgrade` tinyint(4) NOT NULL DEFAULT 1, `auto_compute_upgrade` tinyint(4) NOT NULL DEFAULT 1, `multiple` tinyint(4) NOT NULL DEFAULT 0, `access` int(11) NOT NULL DEFAULT 0, `name` varchar(255) NOT NULL DEFAULT '', `alias` varchar(64) NOT NULL DEFAULT '', `description` mediumtext NOT NULL, `pricedisplay` varchar(255) DEFAULT NULL, `item_text` varchar(255) NOT NULL DEFAULT '', `item_alias` varchar(255) NOT NULL DEFAULT '', `currency` varchar(3) NOT NULL DEFAULT '', `rate` decimal(16,5) DEFAULT NULL, `validity` varchar(24) NOT NULL DEFAULT '', `calstart` varchar(5) NOT NULL DEFAULT '01-01', `bonustime` varchar(24) NOT NULL DEFAULT '', `graceperiod` varchar(24) NOT NULL DEFAULT '', `renewableinadvanceby` varchar(24) NOT NULL DEFAULT '', `prorate` tinyint(4) NOT NULL DEFAULT 1, `renewal_start` tinyint(4) NOT NULL DEFAULT 0, `recurring_max_times` int(11) NOT NULL DEFAULT 0, `autorecurring` tinyint(4) NOT NULL DEFAULT 0, `action_at_last_recurring` tinyint(4) NOT NULL DEFAULT 0, `first_different` tinyint(4) NOT NULL DEFAULT 0, `first_rate` decimal(16,5) DEFAULT NULL, `first_validity` varchar(24) NOT NULL DEFAULT '', `first_calstart` varchar(5) NOT NULL DEFAULT '01-01', `default` tinyint(4) NOT NULL DEFAULT 0, `hideregistrationfields` mediumtext NOT NULL, `confirmed` tinyint(4) NOT NULL DEFAULT 2, `approved` tinyint(4) NOT NULL DEFAULT 2, `usergroup` int(11) NOT NULL DEFAULT 0, `owner` int(11) NOT NULL DEFAULT 0, `thankyoutextcompleted` mediumtext NOT NULL, `thankyoutextpending` mediumtext NOT NULL, `thankyouemailsubject` mediumtext NOT NULL, `thankyouemailbody` mediumtext NOT NULL, `thankyouemailhtml` tinyint(4) NOT NULL DEFAULT 0, `thankyouemailcc` varchar(255) NOT NULL DEFAULT '', `thankyouemailbcc` varchar(255) NOT NULL DEFAULT '', `thankyouemailattachments` text NOT NULL, `pendingfirstemailsubject` mediumtext NOT NULL, `pendingfirstemailbody` mediumtext NOT NULL, `pendingfirstemailhtml` tinyint(4) NOT NULL DEFAULT 0, `pendingfirstemailcc` varchar(255) NOT NULL DEFAULT '', `pendingfirstemailbcc` varchar(255) NOT NULL DEFAULT '', `pendingfirstemailattachments` text NOT NULL, `renewalemailsubject` mediumtext NOT NULL, `renewalemailbody` mediumtext NOT NULL, `renewalemailhtml` tinyint(4) NOT NULL DEFAULT 0, `renewalemailcc` varchar(255) NOT NULL DEFAULT '', `renewalemailbcc` varchar(255) NOT NULL DEFAULT '', `renewalemailattachments` text NOT NULL, `pendingrenewalemailsubject` mediumtext NOT NULL, `pendingrenewalemailbody` mediumtext NOT NULL, `pendingrenewalemailhtml` tinyint(4) NOT NULL DEFAULT 0, `pendingrenewalemailcc` varchar(255) NOT NULL DEFAULT '', `pendingrenewalemailbcc` varchar(255) NOT NULL DEFAULT '', `pendingrenewalemailattachments` text NOT NULL, `autorenewalemailsubject` mediumtext NOT NULL, `autorenewalemailbody` mediumtext NOT NULL, `autorenewalemailhtml` tinyint(4) NOT NULL DEFAULT 0, `autorenewalemailcc` varchar(255) NOT NULL DEFAULT '', `autorenewalemailbcc` varchar(255) NOT NULL DEFAULT '', `autorenewalemailattachments` text NOT NULL, `expirationemailsubject` mediumtext NOT NULL, `expirationemailbody` mediumtext NOT NULL, `expirationemailhtml` tinyint(4) NOT NULL DEFAULT 0, `expirationemailcc` varchar(255) NOT NULL DEFAULT '', `expirationemailbcc` varchar(255) NOT NULL DEFAULT '', `expirationemailattachments` text NOT NULL, `cancelledemailsubject` mediumtext NOT NULL, `cancelledemailbody` mediumtext NOT NULL, `cancelledemailhtml` tinyint(4) NOT NULL DEFAULT 0, `cancelledemailcc` varchar(255) NOT NULL DEFAULT '', `cancelledemailbcc` varchar(255) NOT NULL DEFAULT '', `cancelledemailattachments` text NOT NULL, `parent` int(11) NOT NULL DEFAULT 0, `ordering` int(11) NOT NULL DEFAULT 0, `exclusive` tinyint(4) NOT NULL DEFAULT 1, `hidechildren` tinyint(4) NOT NULL DEFAULT 0, `firstloginurl` varchar(255) NOT NULL DEFAULT '', `eachloginurl` varchar(255) NOT NULL DEFAULT '', `template` varchar(48) NOT NULL DEFAULT '', `cssclass` varchar(48) NOT NULL DEFAULT '', `tax_rule_id` int(11) unsigned NOT NULL DEFAULT 0, `reg_conds` tinyint(4) NOT NULL DEFAULT 0, `reg_conds_plans_required` varchar(255) NOT NULL DEFAULT '', `reg_conds_plans_disallowing` varchar(255) NOT NULL DEFAULT '', `reg_conds_fields_required` varchar(255) NOT NULL DEFAULT '', `reg_conds_fields_disallowing` varchar(255) NOT NULL DEFAULT '', `reg_conds_cbfield_1` int(11) NOT NULL DEFAULT 0, `reg_conds_cbfield_1_operator` varchar(7) NOT NULL DEFAULT '', `reg_conds_value_1` varchar(255) NOT NULL DEFAULT '', `cond_1_operator` varchar(7) NOT NULL DEFAULT '', `cond_1_plans_required` varchar(1024) NOT NULL DEFAULT '', `cond_1_plans_status` varchar(40) NOT NULL DEFAULT '', `cond_1_purchase_ok` tinyint(4) NOT NULL DEFAULT 0, `cond_1_date_1` varchar(20) NOT NULL DEFAULT '', `cond_1_date_cbfield_1` int(11) NOT NULL DEFAULT 0, `cond_1_value_1` varchar(1024) NOT NULL DEFAULT '', `cond_1_dates_diff_a` varchar(21) NOT NULL DEFAULT '', `cond_1_dates_diff_b` varchar(21) NOT NULL DEFAULT '', `cond_1_date_2` varchar(20) NOT NULL DEFAULT '', `cond_1_date_cbfield_2` int(11) NOT NULL DEFAULT 0, `cond_1_value_2` varchar(1024) NOT NULL DEFAULT '', `cond_2_operator` varchar(7) NOT NULL DEFAULT '', `cond_2_plans_required` varchar(1024) NOT NULL DEFAULT '', `cond_2_plans_status` varchar(40) NOT NULL DEFAULT '', `cond_2_purchase_ok` tinyint(4) NOT NULL DEFAULT 0, `cond_2_date_1` varchar(20) NOT NULL DEFAULT '', `cond_2_date_cbfield_1` int(11) NOT NULL DEFAULT 0, `cond_2_value_1` varchar(1024) NOT NULL DEFAULT '', `cond_2_dates_diff_a` varchar(21) NOT NULL DEFAULT '', `cond_2_dates_diff_b` varchar(21) NOT NULL DEFAULT '', `cond_2_date_2` varchar(20) NOT NULL DEFAULT '', `cond_2_date_cbfield_2` int(11) NOT NULL DEFAULT 0, `cond_2_value_2` varchar(1024) NOT NULL DEFAULT '', `upgrade_conds` tinyint(4) NOT NULL DEFAULT 0, `upgrade_conds_plans_required` varchar(255) NOT NULL DEFAULT '', `upgrade_conds_plans_disallowing` varchar(255) NOT NULL DEFAULT '', `integrations` text NOT NULL, `params` text NOT NULL, PRIMARY KEY (`id`), KEY `published_allownew_allowreg_parent_ordering` (`published`, `allow_newsubscriptions`, `allow_registration`, `parent`, `ordering`), KEY `fe_published_allownew_allowreg_parent_order` (`allow_frontend`, `published`, `allow_newsubscriptions`, `allow_registration`, `parent`, `ordering`), KEY `upgrade_published_allownew_parent_ordering` (`allow_upgrade_to_this`, `published`, `allow_newsubscriptions`, `parent`, `ordering`), KEY `allownew_published_upgrade_fe_parent_order` (`allow_newsubscriptions`, `published`, `allow_upgrade_to_this`, `allow_frontend`, `parent`, `ordering`) )AUTO_INCREMENT=1, ENGINE=MyISAM
Any thoughts? or did I just pay $130 for nothing?