Unable to add properties

navneethit commented 6 years ago

I can view the Properties but I cant add the Properties can anyone help me?

typo3ua commented 6 years ago

The database to run this application is missing and too system not connect to database. When install system does not setup and does not configuring database

v03adk commented 6 years ago

@typo3ua and how can I configure and setup database?

typo3ua commented 6 years ago

:) It is need to ask at author estatezilla

vvalchev commented 6 years ago

If you download estatezilla from the web site, it's configured to use sqlite. Still you can't add property unless you do some small changes to the db:

download sqlite binary
run sqlite database.sqlite

invoke the following SQL scripts: -- `drop table properties`

CREATE TABLE `properties` (
`id` integer NOT NULL PRIMARY KEY AUTOINCREMENT
,  `user_id` integer  DEFAULT NULL
,  `property_type_id` integer  DEFAULT NULL
,  `listing_type` text  NOT NULL DEFAULT 'sale'
,  `listing_status` text  DEFAULT NULL
,  `property_condition` text  NOT NULL DEFAULT 'not_specified'
,  `property_size` decimal(11,2) DEFAULT NULL
,  `num_bedrooms` integer DEFAULT NULL
,  `num_bathrooms` integer DEFAULT NULL
,  `num_floors` integer DEFAULT NULL
,  `num_receptions` integer DEFAULT NULL
,  `has_garden` integer DEFAULT NULL
,  `has_parking` integer DEFAULT NULL
,  `is_investment_property` integer DEFAULT NULL
,  `new_home` integer DEFAULT NULL
,  `photos` text COLLATE BINARY
,  `floor_plans` text COLLATE BINARY
,  `documents` text COLLATE BINARY
,  `virtual_tours` text COLLATE BINARY
,  `displayable_address` varchar(255)
,  `street_no` varchar(255) DEFAULT NULL
,  `street_name` varchar(255) DEFAULT NULL
,  `city` varchar(255) DEFAULT NULL
,  `region` varchar(255) DEFAULT NULL
,  `postcode` varchar(255) DEFAULT NULL
,  `country` char(2) DEFAULT NULL
,  `lat` decimal(18,12) DEFAULT NULL
,  `lng` decimal(18,12) DEFAULT NULL
,  `price` decimal(11,2) DEFAULT NULL
,  `reduced_price` decimal(11,2) DEFAULT NULL
,  `negotiable_price` integer DEFAULT NULL
,  `poa` integer DEFAULT NULL
,  `price_period` varchar(255) DEFAULT NULL
,  `price_type` varchar(255) DEFAULT NULL
,  `is_featured` integer NOT NULL DEFAULT '0'
,  `expires_at` datetime DEFAULT '0000-00-00 00:00:00'
,  `published_at` datetime DEFAULT '0000-00-00 00:00:00'
,  `origin` varchar(255) DEFAULT NULL
,  `visible` integer DEFAULT '0'
,  `terms_agree` integer NOT NULL DEFAULT '0'
,  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
,  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
,  `deleted_at` timestamp NULL DEFAULT NULL
);

expresspixel / estatezilla