Search Form and Social Buttons

HotThemes Logo and Top Menu

To request a forum account, please login here and open support ticket. Only customers with active order(s) can open forum account!

× Discussion about "Furniture Store" VirtueMart/Joomla template

Topic-icon Unable to do a clean install

More
6 years 2 months ago #10897 by kiwikidusa
kiwikidusa created the topic: Unable to do a clean install
I purchased this very well designed template for a small project non-profit group. Using MAMP 2.01 I have tried to do a clean install of the HotStart Installation locally. After creating a new database with utf_general_ci collation, then starting the Joomla install process, I get the error below after entering the default info on the Database Configuration screen:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM CHARACTER SET `utf8`' at line 29 SQL=CREATE TABLE `wa89g_banner` ( `bid` int(11) NOT NULL auto_increment, `cid` int(11) NOT NULL default '0', `type` varchar(30) NOT NULL default 'banner', `name` varchar(255) NOT NULL default '', `alias` varchar(255) NOT NULL default '', `imptotal` int(11) NOT NULL default '0', `impmade` int(11) NOT NULL default '0', `clicks` int(11) NOT NULL default '0', `imageurl` varchar(100) NOT NULL default '', `clickurl` varchar(200) NOT NULL default '', `date` datetime default NULL, `showBanner` tinyint(1) NOT NULL default '0', `checked_out` tinyint(1) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `editor` varchar(50) default NULL, `custombannercode` text, `catid` INTEGER UNSIGNED NOT NULL DEFAULT 0, `description` TEXT NOT NULL DEFAULT '', `sticky` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, `ordering` INTEGER NOT NULL DEFAULT 0, `publish_up` datetime NOT NULL default '0000-00-00 00:00:00', `publish_down` datetime NOT NULL default '0000-00-00 00:00:00', `tags` TEXT NOT NULL DEFAULT '', `params` TEXT NOT NULL DEFAULT '', PRIMARY KEY (`bid`), KEY `viewbanner` (`showBanner`), INDEX `idx_banner_catid`(`catid`) ) TYPE=MyISAM CHARACTER SET `utf8`

Please Log in to join the conversation.

More
6 years 2 months ago #10899 by milos
milos replied the topic: Re: Unable to do a clean install
I am also using MAMP on Mac and it works fine. Make sure that you have PHP 5 and MySQL 5 installed in MAMP (both are required). If not, please upgrade your MAMP.

Please Log in to join the conversation.

More
6 years 2 months ago #10902 by kiwikidusa
kiwikidusa replied the topic: Re: Unable to do a clean install
A completely fresh install on my MacBook Pro, using MAMP Pro 2.0.1 (PHP 5.2.17 & MySQL 5.5.9) the same error above is what I receive when trying to use the HotStart Installation. Changing the collation does not change the error. Yes, Web Sharing is off.

I need this resolved as soon as possible.

On my iMac trying to install this template completely messed up 2 other SQL databases. Cannot work out how to resolve that problem either.

Please Log in to join the conversation.

More
6 years 2 months ago #10904 by milos
milos replied the topic: Re: Unable to do a clean install
Please open file /installation/sql/mysql/sample_data.sql in plain text editor (like TextEdit in plain textmode, SHIFT+CMD+T).

Can you find this "ENGINE=MyISAM" or this "TYPE=MyISAM". Try to switch this part everywhere (Find and Replace). Save file and try installing again.

BTW, I have MySQL 5.1.44 and PHP 5.3.2. Also, try to switch to PHP 5.3 in MAMP preferences.

Please Log in to join the conversation.

More
6 years 2 months ago #10907 by kiwikidusa
kiwikidusa replied the topic: Re: Unable to do a clean install
I followed your suggestion and got the same error with PHP 5.2.17, and then I changed MAMP PHP version to 5.3.6 and managed to get a bit further along in the process. Now I get 'Unable to connect to the database:Could not connect to MySQL'

What is going on? Should I go back to MAMP 1.9.4?

Please Log in to join the conversation.

More
6 years 2 months ago #10908 by milos
milos replied the topic: Re: Unable to do a clean install
"Could not connect to MySQL" means that either DB host, DB name, DB user or DB pass are typed incorrectly during Joomla installation.

Please Log in to join the conversation.

Time to create page: 0.086 seconds

Links, Partners and Social Media