OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
RealEstateManager component support
Go to bottom Favoured: 0
TOPIC: DB Error inserting a new house
#6988
johanjaimes (User)
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
DB Error inserting a new house 3 Years, 7 Months ago Karma: 0  
Hi,

I was running RealEstateManager (don't remember wich version) on Joomla 1.7.3. Then, I had to update Joomla to 2.5.8, but RealEstateManager didn't work properly, so I had to update it to the most recent version. Everything seems to be working OK but when I tried to upload a new house I got a DB error: Unknown column 'hdistrict' in 'field list' SQL=INSERT INTO `PREFIX_rem_houses` (`id`,`houseid`,`description`,`listing_type`,`price`,`priceunit`,`htitle`,`hcountry`,`hregion`,`hcity`,`hdistrict`, ...

How can I solve this? Do I have to update the DB manually?

Thanks in advance for your help,

--
Johan
 
Logged Logged  
  The administrator has disabled public write access.
#6998
admin (Admin)
Admin
Posts: 4856
graph
User Offline Click here to see the profile of this user
Re:DB Error inserting a new house 3 Years, 7 Months ago Karma: 61  
Hello Johan,

Now very difficult say where error and what version you use before.

Please go to yours database and check:
In table #__rem_houses, exist fields:
hdistrict, hzipcode, area, area_unit, land_area, land_area_unit, featured_shows, featured_clicks ?

If not exist please run for Database below script:

Code:

ALTER TABLE #__rem_houses
                    ADD COLUMN hdistrict varchar(50) NOT NULL default '',
                    ADD COLUMN hzipcode varchar(50) NOT NULL default '',
                    ADD COLUMN area varchar(45) default '',
                    ADD COLUMN area_unit varchar(45) default '',
                    ADD COLUMN land_area varchar(45) default '',
                    ADD COLUMN land_area_unit varchar(45) default '',
                    ADD COLUMN featured_shows varchar(100) default '',
                    ADD COLUMN featured_clicks varchar(100) default ''



Please replace "#_" prefix to yours tables prefix

also please check exist for you table: `#__rem_rent_sal`

If not exist please run for yours database below script:
Code:

CREATE TABLE IF NOT EXISTS `#__rem_rent_sal` (
              `id` int(11) unsigned NOT NULL auto_increment,
              `fk_houseid` int(11),
              `monthW` int(4) NOT NULL default 0,
              `yearW` int(4) NOT NULL default 0,
              `week` varchar(1250) default '',
              `weekend` varchar(1250) default '',
              `midweek` varchar(1250) default '',
              PRIMARY KEY  (`id`),
              UNIQUE (`yearW`, `monthW`, `fk_houseid`),
              FOREIGN KEY (`fk_houseid`) REFERENCES `#__rem_houses`(`houseid`)
              ) ENGINE=MyISAM AUTO_INCREMENT=2 CHARACTER SET `utf8`;



Thanks,
OrdaSoft team
 
Logged Logged  
  The administrator has disabled public write access.
Go to top
What are you looking for?
Anti-spam question: How many eyes has a typical person?