OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
OrdaSoft forum Joomla Real Estate Forums Joomla Real Estate
DB Error inserting a new house (0 viewing) 

Joomla Real Estate

Go to bottom Favoured: 0

DB Error inserting a new house

#6988
johanjaimes (Visitor)
Posts: 0
graphgraph
User Offline
DB Error inserting a new house 11 Years, 2 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: 8243
graph
User Offline Click here to see the profile of this user
Re:DB Error inserting a new house 11 Years, 2 Months ago
Karma: 101  
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
Powered by OrdaSoft
 
What are you looking for?
»