Mandatory information about my setup:
Have I read the related troubleshooter articles above before posting (which pages?)? yes
Have I searched the tickets before posting? yes
Have I read the documentation before posting (which pages?)? yes
Joomla! version: 2.5.5
PHP version: 5.3.1 (Local), 5.2.12 (Server)
MySQL version: 5.1.41 (Local), 4.1.22 (Server)
Host: Nativespace
Akeeba Backup version which took the backup: 3.5.2
Kickstart version used to extract the backup: 3.5.1
Description of my issue:
In order to upgrade my site from Joomla 1.5 to 2.5 I used Akeeba Backup for the live website, rebuilt the site on a local server, upgraded it there using SpUpgrade and was now trying to restore the upgraded website using Kickstart.
I'm getting the following error message:
Error at the line 76: CREATE TABLE `#__languages` ( `lang_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `lang_code` char(7) NOT NULL, `title` varchar(50) NOT NULL, `title_native` varchar(50) NOT NULL, `sef` varch ... MySQL: MySQL query failed with error 1074 (Column length too big for column 'sitename' (max = 255); use BLOB or TEXT instead). The query was:CREATE TABLE `c26_languages` ( `lang_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `lang_code` char(7) NOT NULL, `title` varchar(50) NOT NULL, `title_native` varchar(50) NOT NULL, `sef` varchar(50) NOT NULL, `image` varchar(50) NOT NULL, `description` varchar(512) NOT NULL, `metakey` text NOT NULL, `metadesc` text NOT NULL, `sitename` varchar(1024) NOT NULL DEFAULT '', `published` int(11) NOT NULL DEFAULT '0', `access` int(10) unsigned NOT NULL DEFAULT '0', `ordering` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`lang_id`), UNIQUE KEY `idx_sef` (`sef`), UNIQUE KEY `idx_image` (`image`), UNIQUE KEY `idx_langcode` (`lang_code`), KEY `idx_access` (`access`), KEY `idx_ordering` (`ordering`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8
Any ideas would be greatly appreciated. Thanks in advance!
Have I read the related troubleshooter articles above before posting (which pages?)? yes
Have I searched the tickets before posting? yes
Have I read the documentation before posting (which pages?)? yes
Joomla! version: 2.5.5
PHP version: 5.3.1 (Local), 5.2.12 (Server)
MySQL version: 5.1.41 (Local), 4.1.22 (Server)
Host: Nativespace
Akeeba Backup version which took the backup: 3.5.2
Kickstart version used to extract the backup: 3.5.1
Description of my issue:
In order to upgrade my site from Joomla 1.5 to 2.5 I used Akeeba Backup for the live website, rebuilt the site on a local server, upgraded it there using SpUpgrade and was now trying to restore the upgraded website using Kickstart.
I'm getting the following error message:
Error at the line 76: CREATE TABLE `#__languages` ( `lang_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `lang_code` char(7) NOT NULL, `title` varchar(50) NOT NULL, `title_native` varchar(50) NOT NULL, `sef` varch ... MySQL: MySQL query failed with error 1074 (Column length too big for column 'sitename' (max = 255); use BLOB or TEXT instead). The query was:CREATE TABLE `c26_languages` ( `lang_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `lang_code` char(7) NOT NULL, `title` varchar(50) NOT NULL, `title_native` varchar(50) NOT NULL, `sef` varchar(50) NOT NULL, `image` varchar(50) NOT NULL, `description` varchar(512) NOT NULL, `metakey` text NOT NULL, `metadesc` text NOT NULL, `sitename` varchar(1024) NOT NULL DEFAULT '', `published` int(11) NOT NULL DEFAULT '0', `access` int(10) unsigned NOT NULL DEFAULT '0', `ordering` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`lang_id`), UNIQUE KEY `idx_sef` (`sef`), UNIQUE KEY `idx_image` (`image`), UNIQUE KEY `idx_langcode` (`lang_code`), KEY `idx_access` (`access`), KEY `idx_ordering` (`ordering`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8
Any ideas would be greatly appreciated. Thanks in advance!
