here's the file I attached to the first post, sorry
* JInstaller::install: SQL Error. DB function failed with error number 1074
Too big column length for column 'remote_filename' (max = 255). Use BLOB instead SQL=CREATE TABLE IF NOT EXISTS `jos_ak_stats` ( `id` bigint(20) unsigned NOT NULL auto_increment, `description` varchar(255) NOT NULL, `comment` longtext, `backupstart` timestamp NOT NULL default '0000-00-00 00:00:00', `backupend` timestamp NOT NULL default '0000-00-00 00:00:00', `status` enum('run','fail','complete') NOT NULL default 'run', `origin` VARCHAR(30) NOT NULL DEFAULT 'backend', `type` VARCHAR(30) NOT NULL DEFAULT 'full', `profile_id` bigint(20) NOT NULL default '1', `archivename` longtext, `absolute_path` longtext, `multipart` INT NOT NULL DEFAULT 0, `tag` VARCHAR(255) NULL, `filesexist` TINYINT(3) NOT NULL DEFAULT '1', `remote_filename` varchar(1000) DEFAULT NULL, `total_size` bigint(20) NOT NULL DEFAULT '0', INDEX `idx_fullstatus`(`filesexist`, `status`), INDEX `idx_stale`(`status`, `origin`), PRIMARY KEY (`id`) );
SQL =
CREATE TABLE IF NOT EXISTS `jos_ak_stats` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`description` varchar(255) NOT NULL,
`comment` longtext,
`backupstart` timestamp NOT NULL default '0000-00-00 00:00:00',
`backupend` timestamp NOT NULL default '0000-00-00 00:00:00',
`status` enum('run','fail','complete') NOT NULL default 'run',
`origin` VARCHAR(30) NOT NULL DEFAULT 'backend',
`type` VARCHAR(30) NOT NULL DEFAULT 'full',
`profile_id` bigint(20) NOT NULL default '1',
`archivename` longtext,
`absolute_path` longtext,
`multipart` INT NOT NULL DEFAULT 0,
`tag` VARCHAR(255) NULL,
`filesexist` TINYINT(3) NOT NULL DEFAULT '1',
`remote_filename` varchar(1000) DEFAULT NULL,
`total_size` bigint(20) NOT NULL DEFAULT '0',
INDEX `idx_fullstatus`(`filesexist`, `status`),
INDEX `idx_stale`(`status`, `origin`),
PRIMARY KEY (`id`)
);
* Component Install: SQL error or missing or unreadable SQL file. DB function failed with error number 1074
Too big column length for column 'remote_filename' (max = 255). Use BLOB instead SQL=CREATE TABLE IF NOT EXISTS `jos_ak_stats` ( `id` bigint(20) unsigned NOT NULL auto_increment, `description` varchar(255) NOT NULL, `comment` longtext, `backupstart` timestamp NOT NULL default '0000-00-00 00:00:00', `backupend` timestamp NOT NULL default '0000-00-00 00:00:00', `status` enum('run','fail','complete') NOT NULL default 'run', `origin` VARCHAR(30) NOT NULL DEFAULT 'backend', `type` VARCHAR(30) NOT NULL DEFAULT 'full', `profile_id` bigint(20) NOT NULL default '1', `archivename` longtext, `absolute_path` longtext, `multipart` INT NOT NULL DEFAULT 0, `tag` VARCHAR(255) NULL, `filesexist` TINYINT(3) NOT NULL DEFAULT '1', `remote_filename` varchar(1000) DEFAULT NULL, `total_size` bigint(20) NOT NULL DEFAULT '0', INDEX `idx_fullstatus`(`filesexist`, `status`), INDEX `idx_stale`(`status`, `origin`), PRIMARY KEY (`id`) );
SQL =
CREATE TABLE IF NOT EXISTS `jos_ak_stats` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`description` varchar(255) NOT NULL,
`comment` longtext,
`backupstart` timestamp NOT NULL default '0000-00-00 00:00:00',
`backupend` timestamp NOT NULL default '0000-00-00 00:00:00',
`status` enum('run','fail','complete') NOT NULL default 'run',
`origin` VARCHAR(30) NOT NULL DEFAULT 'backend',
`type` VARCHAR(30) NOT NULL DEFAULT 'full',
`profile_id` bigint(20) NOT NULL default '1',
`archivename` longtext,
`absolute_path` longtext,
`multipart` INT NOT NULL DEFAULT 0,
`tag` VARCHAR(255) NULL,
`filesexist` TINYINT(3) NOT NULL DEFAULT '1',
`remote_filename` varchar(1000) DEFAULT NULL,
`total_size` bigint(20) NOT NULL DEFAULT '0',
INDEX `idx_fullstatus`(`filesexist`, `status`),
INDEX `idx_stale`(`status`, `origin`),
PRIMARY KEY (`id`)
);
Is that what you needed?