Go Back   Mosets Community > Archives > Mosets Hot Property 1.0 > Discussions, Troubleshooting and Problems

 
 
Thread Tools Search this Thread Display Modes
  #1  
Old 07-16-2009, 07:35 PM
icey icey is offline
Junior Member
 
Join Date: Jul 2009
Posts: 2
Default Hot Property Beta 4 Install Error

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?
  #2  
Old 07-17-2009, 05:42 PM
dknight dknight is offline
Mosets Team - Lead Developer
 
Join Date: Dec 2004
Posts: 26,568
Default

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.
__________________
Lee
Lead Developer
Mosets.com - Quality Joomla! Solutions
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Hot Property 1.0.0 Beta 3 dknight Announcements 2 10-09-2008 11:42 PM
Error On Component Install screenmutt Discussions, Troubleshooting and Problems 1 08-27-2008 10:18 AM
Hot Property 1.0.0 Beta 2 dknight Announcements 0 06-18-2008 09:30 PM
Hot Property 1.0.0 First Beta dknight Announcements 0 05-21-2008 04:25 PM


All times are GMT +8. The time now is 08:49 PM.

Copyright © 2005-2010 Mosets Consulting

Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.