Error number 1280

PitipongJ
PitipongJ
Offline
0
I received error

JInstaller: :Install: Error SQL DB function failed with error number 1280
Incorrect index name 'album_id ' SQL=CREATE TABLE IF NOT EXISTS `jn53b_muscol_songs` ( `id` int(6) NOT NULL auto_increment, `album_id` int(11) NOT NULL, `num` tinyint(3) NOT NULL, `disc_num` tinyint(2) NOT NULL, `length` varchar(8) NOT NULL, `name` varchar(255) NOT NULL, `lyrics` text NOT NULL, `artist_id` int(11) NOT NULL, `composer_id` int(6) NOT NULL, `filename` varchar(255) NOT NULL, `extension` varchar(5) NOT NULL, `added` datetime NOT NULL, `review` text NOT NULL, `songwriters` tinytext NOT NULL, `chords` text NOT NULL, `genre_id` int(3) NOT NULL, `hits` INT( 11 ) NOT NULL , `buy_link` VARCHAR( 255 ) NOT NULL , `video` VARCHAR( 255 ) NOT NULL , `position` varchar(6) NOT NULL, `downloaded` int(11) NOT NULL, `user_id` int(11) NOT NULL, `tags` varchar(255) NOT NULL, `external_type` varchar(255) NOT NULL, `external_id` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `artist_id` (`artist_id`), KEY `album_id ` (`album_id`), KEY `user_id` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SQL =

SQL =
CREATE TABLE IF NOT EXISTS `#__muscol_songs` (
`id` int(6) NOT NULL auto_increment,
`album_id` int(11) NOT NULL,
`num` tinyint(3) NOT NULL,
`disc_num` tinyint(2) NOT NULL,
`length` varchar(8) NOT NULL,
`name` varchar(255) NOT NULL,
`lyrics` text NOT NULL,
`artist_id` int(11) NOT NULL,
`composer_id` int(6) NOT NULL,
`filename` varchar(255) NOT NULL,
`extension` varchar(5) NOT NULL,
`added` datetime NOT NULL,
`review` text NOT NULL,
`songwriters` tinytext NOT NULL,
`chords` text NOT NULL,
`genre_id` int(3) NOT NULL,
`hits` INT( 11 ) NOT NULL ,
`buy_link` VARCHAR( 255 ) NOT NULL ,
`video` VARCHAR( 255 ) NOT NULL ,
`position` varchar(6) NOT NULL,
`downloaded` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`tags` varchar(255) NOT NULL,
`external_type` varchar(255) NOT NULL,
`external_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `artist_id` (`artist_id`),
KEY `album_id ` (`album_id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Component Install: SQL error file DB function failed with error number 1280
Incorrect index name 'album_id ' SQL=CREATE TABLE IF NOT EXISTS `jn53b_muscol_songs` ( `id` int(6) NOT NULL auto_increment, `album_id` int(11) NOT NULL, `num` tinyint(3) NOT NULL, `disc_num` tinyint(2) NOT NULL, `length` varchar(8) NOT NULL, `name` varchar(255) NOT NULL, `lyrics` text NOT NULL, `artist_id` int(11) NOT NULL, `composer_id` int(6) NOT NULL, `filename` varchar(255) NOT NULL, `extension` varchar(5) NOT NULL, `added` datetime NOT NULL, `review` text NOT NULL, `songwriters` tinytext NOT NULL, `chords` text NOT NULL, `genre_id` int(3) NOT NULL, `hits` INT( 11 ) NOT NULL , `buy_link` VARCHAR( 255 ) NOT NULL , `video` VARCHAR( 255 ) NOT NULL , `position` varchar(6) NOT NULL, `downloaded` int(11) NOT NULL, `user_id` int(11) NOT NULL, `tags` varchar(255) NOT NULL, `external_type` varchar(255) NOT NULL, `external_id` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `artist_id` (`artist_id`), KEY `album_id ` (`album_id`), KEY `user_id` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SQL =
CREATE TABLE IF NOT EXISTS `#__muscol_songs` (
`id` int(6) NOT NULL auto_increment,
`album_id` int(11) NOT NULL,
`num` tinyint(3) NOT NULL,
`disc_num` tinyint(2) NOT NULL,
`length` varchar(8) NOT NULL,
`name` varchar(255) NOT NULL,
`lyrics` text NOT NULL,
`artist_id` int(11) NOT NULL,
`composer_id` int(6) NOT NULL,
`filename` varchar(255) NOT NULL,
`extension` varchar(5) NOT NULL,
`added` datetime NOT NULL,
`review` text NOT NULL,
`songwriters` tinytext NOT NULL,
`chords` text NOT NULL,
`genre_id` int(3) NOT NULL,
`hits` INT( 11 ) NOT NULL ,
`buy_link` VARCHAR( 255 ) NOT NULL ,
`video` VARCHAR( 255 ) NOT NULL ,
`position` varchar(6) NOT NULL,
`downloaded` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`tags` varchar(255) NOT NULL,
`external_type` varchar(255) NOT NULL,
`external_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `artist_id` (`artist_id`),
KEY `album_id ` (`album_id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Could you tell me how to solve the problem.


-------------------------------------------------------------------------------------
My system information:
PHP Built On Linux gator3276.hostgator.com 3.2.54 #9 SMP Thu Feb 13 08:17:11 CST 2014 x86_64
Database Version 5.5.33-31.1
Database Collation utf8_general_ci
PHP Version 5.2.17
Web Server Apache
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 2.5.9 Stable [ Ember ] 4-February-2013 14:00 GMT
Joomla! Platform Version Joomla Platform 11.4.0 Stable [ Brian Kernighan ] 03-Jan-2012 00:00 GMT
User Agent Mozilla/5.0 (Windows NT 6.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/33.0.1750.154 Safari/537.36

Best regards,

Pete Jaidee
Responses (1)
  • Accepted Answer

    Friday, March 28 2014, 10:01 AM - #Permalink
    0
    apologies for this, there was a little bug in the installation file.

    Please, download it again and try to reinstall.this error should be gone!

    Thanks!
    The reply is currently minimized Show
Your Reply