Welcome Guest. Please Login or Register  


You are here: Index > Softaculous Auto Installer > Bugs > Topic : Softaculous bug in installing Joomla 2 and 3



Threaded Mode | Print  

 Softaculous bug in installing Joomla 2 and 3 (2 Replies, Read 7229 times)
Jim22
Group: Member
Post Group: Newbie
Posts: 17
Status:
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
IP: --   

Softaculous bug in installing Joomla 2 and 3
Jim22
Group: Member
Post Group: Newbie
Posts: 17
Status:
It seems that this is caused by Softaculous trying to connect to the real domain and if there's some sort of problem it would affect the parsing / replacement of the sql file during installation. The workaround that finally worked was to add the domain into /etc/hosts and point it to 127.0.0.1

The workaround in the previous post is not necessary.
IP: --   

Softaculous bug in installing Joomla 2 and 3
Brijesh
Group: Softaculous Team
Post Group: Super Member
Posts: 5636
Status:
Hi,

We make a curl call to the domain to encrypt the password when the PHP version is less than PHP 5.3 and since the domain was not having correct DNS it could not fetch the encrypted password and hence the database query failed.

-----------------------
Webuzo - Multi User Hosting Control Panel
AMPPS - Best WordPress/PHP/MySQL development tool
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is March 19, 2024, 5:09 am.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.097