All the other plugins install correctly. I was finalizing plans for a site that is to go live next week and realized I didn't install this plugin (or I may have and got the error initially and didn't pay attention. I looked through the forums and only found one other person with this issue, but it was related to another plugin (which I don't have installed. I changed the max_execution_time to 60 in my php.ini and restarted the apache server.
Server information:
Database Version: 4.1.22
Database Collation: utf8_general_ci
PHP Version: 5.2.16
Web Server: Apache/2.0.52 (Red Hat)
Web Server to PHP interface: apache2handler
Joomla! Version: Joomla! 1.5.22 Stable [ senu takaa ama woi ] 04-November-2010 18:00 GMT
Running CB 1.31, CB Subs 1.1.2.
There are no errors in the apache error log (which I believe all php errors are being logged to as well.
The actual installation error is:
Plugin database XML SQL Error CBSQLupgrader::createTableof Table #__cbsubs_geo_zones_entries failed with SQL error: Column length too big for column 'zip_code_regexp' (max = 255); use BLOB or TEXT instead SQL=CREATE TABLE `jos_cbsubs_geo_zones_entries` ( `id` int(11) unsigned NOT NULL auto_increment, `geo_zone_id` int(20) unsigned NOT NULL DEFAULT 0, `country_iso_code2` char(2) NOT NULL DEFAULT '', `province_iso_code` varchar(12) NOT NULL DEFAULT '', `zip_code_condition` int(2) unsigned NOT NULL DEFAULT 0, `zip_code_regexp` varchar(1024) NOT NULL DEFAULT '', `zip_code_min` int(20) unsigned DEFAULT NULL, `zip_code_max` int(20) unsigned DEFAULT NULL, `ordering` int(11) NOT NULL DEFAULT 0, `owner` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `province_iso_code` (`province_iso_code`), KEY `geozone_country_province` (`geo_zone_id`, `country_iso_code2`, `province_iso_code`), KEY `ordering` (`ordering`) )AUTO_INCREMENT=100000, ENGINE=MyISAM
Post edited by: krileon, at: 2011/01/07 21:05