Unable to do a clean install

I was mistaken, I still get the exact same error, as below. I am using MAMP 2.0.1 with MySQL 5.5.9, PHP 5.3.6 and Apache 2.2.17. The strange thing is when I tested a Joomla 1.5.23 install there were absolutely no problems. I could even install a free template.

What is the issue with the Hot Furniture Store template that can cause all these problems?

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`

Where did you find Furniture Store template for Joomla 1.6/1.7? It's currently available for Joomla 1.5 only.

Sorry, I did not read last message well. Can you take file sample_data.sql and try to import it manually via PhpMyAdmin? Will you get any errors then?

For your information an administrator at our hosting service tried to install the same template and he copied me the message below:

I ran the create table you gave on MySQL 5.0.88 and while it did create the
table, it also gave 4 warnings.

Perhaps MySQL 5.5 is more strict and will refuse to create the table?

Here's what my create table session looked like. Pay SPECIAL ATTENTION to
the 4 warnings it gave:

mysql> 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`;
Query OK, 0 rows affected, 4 warnings (0.01 sec)

mysql> show warnings;
+

---

+

---

+

---

+
| Level | Code | Message
|
+

---

+

---

+

---

+
| Warning | 1101 | BLOB/TEXT column 'description' can't have a default value
|
| Warning | 1101 | BLOB/TEXT column 'tags' can't have a default value
|
| Warning | 1101 | BLOB/TEXT column 'params' can't have a default value
|
| Warning | 1287 | 'TYPE=storage_engine' is deprecated; use
'ENGINE=storage_engine' instead |
+

---

+

---

+

---

+
4 rows in set (0.00 sec)

mysql> show columns from wa89g_banner;
+

---

+

---

+

---

+

---

+

---

+

---

+
| Field | Type | Null | Key | Default
| Extra |
+

---

+

---

+

---

+

---

+

---

+

---

+
| bid | int(11) | NO | PRI | NULL
| auto_increment |
| cid | int(11) | NO | | 0
| |
| type | varchar(30) | NO | | banner
| |
| name | varchar(255) | NO | |
| |
| alias | varchar(255) | NO | |
| |
| imptotal | int(11) | NO | | 0
| |
| impmade | int(11) | NO | | 0
| |
| clicks | int(11) | NO | | 0
| |
| imageurl | varchar(100) | NO | |
| |
| clickurl | varchar(200) | NO | |
| |
| date | datetime | YES | | NULL
| |
| showBanner | tinyint(1) | NO | MUL | 0
| |
| checked_out | tinyint(1) | NO | | 0
| |
| checked_out_time | datetime | NO | | 0000-00-00 00:00:00
| |
| editor | varchar(50) | YES | | NULL
| |
| custombannercode | text | YES | | NULL
| |
| catid | int(10) unsigned | NO | MUL | 0
| |
| description | text | NO | | NULL
| |
| sticky | tinyint(1) unsigned | NO | | 0
| |
| ordering | int(11) | NO | | 0
| |
| publish_up | datetime | NO | | 0000-00-00 00:00:00
| |
| publish_down | datetime | NO | | 0000-00-00 00:00:00
| |
| tags | text | NO | | NULL
| |
| params | text | NO | | NULL
| |
+

---

+

---

+

---

+

---

+

---

+

---

+
24 rows in set (0.00 sec)

mysql>

If these problems cannot be resolved with the Hot Furniture Store template can I use a different Virtuemart template? Rather than a refund. And who do I contact to request this?

Sorry, can you use an older version of MySQL, such as 5.1.44? Perhaps, VirtueMart is not compatible with 5.5.

Anyway, the HotStart installation is nothing but copy of all Joomla's and VirtueMart's databases. It's not something that we developed, so we can't fix any bugs with newer MySQL versions.

You will most likely have the same issues with other VirtueMart based templates. You will have the same problem if you try to copy any other VM's database into your server based on MySQL 5.5.