Environment: Hsphere 3.6.3 - latest Softaculous version 4.5.5
When installing Joomla 3 or Joomla 2 (3.3.6, 2.5.27 ) Softaculous will complain with a mysql syntax error.
This is caused by the file /var/softaculous/joomla30/joomla30.sql and /var/softaculous/joomla16/joomla16.sql containing the character "#" inside the COMMENT when creating a table.
To fix it temporarily:
Change by removing the "#" character from:
Quote CREATE TABLE `[[dbprefix]]user_usergroup_map` (
`user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Foreign Key to #__users.id',
`group_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Foreign Key to #__usergroups.id',
PRIMARY KEY (`user_id`,`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
change to
Quote CREATE TABLE `[[dbprefix]]user_usergroup_map` (
`user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Foreign Key to __users.id',
`group_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Foreign Key to __usergroups.id',
PRIMARY KEY (`user_id`,`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
There might be some parsing issues with Softaculous that caused this bug.
Edited by Jim22 : October 16, 2014, 12:04 am |