Hot Property Beta 4 Install Error

[icey]

JInstaller::install: SQL Error. DB function failed with error number 1050
Table 'jos_hp_agents' already exists SQL=CREATE TABLE `jos_hp_agents` ( `id` int(11) NOT NULL auto_increment, `user` int(10) unsigned NOT NULL default '0', `name` varchar(100) NOT NULL default '', `mobile` varchar(60) NOT NULL default '', `email` varchar(255) NOT NULL default '', `photo` varchar(100) NOT NULL default '', `company` int(11) NOT NULL default '0', `desc` text NOT NULL, `need_approval` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM ;
SQL =
CREATE TABLE `jos_hp_agents` (
`id` int(11) NOT NULL auto_increment,
`user` int(10) unsigned NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
`mobile` varchar(60) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`photo` varchar(100) NOT NULL default '',
`company` int(11) NOT NULL default '0',
`desc` text NOT NULL,
`need_approval` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM ;
Component Install: SQL error or missing or unreadable SQL file. DB function failed with error number 1050
Table 'jos_hp_agents' already exists SQL=CREATE TABLE `jos_hp_agents` ( `id` int(11) NOT NULL auto_increment, `user` int(10) unsigned NOT NULL default '0', `name` varchar(100) NOT NULL default '', `mobile` varchar(60) NOT NULL default '', `email` varchar(255) NOT NULL default '', `photo` varchar(100) NOT NULL default '', `company` int(11) NOT NULL default '0', `desc` text NOT NULL, `need_approval` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM ;
SQL =
CREATE TABLE `jos_hp_agents` (
`id` int(11) NOT NULL auto_increment,
`user` int(10) unsigned NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
`mobile` varchar(60) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`photo` varchar(100) NOT NULL default '',
`company` int(11) NOT NULL default '0',
`desc` text NOT NULL,
`need_approval` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM ;


does anybody have any ideas whats wrong?

[dknight]

It appears that you have previously attempted to install Hot Property and still have the tables in your database. Remove all tables that have this prefix - jos_hp_ - and try the reinstall again.