PDA

View Full Version : adding search



Anonymous
06-25-2003, 09:57 AM
I get this when I try to add search to comminity_feature in admin

There's been a problem -- please contact the

Using 1.10 beta 3

greengiant
06-25-2003, 10:43 AM
Hi,

Does that email you an error, or does it just die there..

I am awake again now, i was so tired i programmed for way to many hours yesterday. I am going to start applying patches and see if i can get you guy a cleaner beta.

Anonymous
06-25-2003, 11:05 AM
It emaild me this error for community features

216.221.81.96 -- June 25, 2003, 10:36:04 am -- UPDATE or_listingsFormElements SET field_type = 'checkbox', field_name = 'community_features', field_caption = 'Community Features', default_text = '', field_elements = 'Fitness Center||Golf Course||Pool||Spa/Jacuzzi||Sports Complex||Tennis Courts||Bike Paths||Boating||Courtyard||Playground/Park||Association Fee||Clubhouse||Controlled Access||Public Transportation', rank = '85', required = 'No', location = 'feature2', searchable = '1', search_type = 'Community'
, search_label = 'Community Features', search_step = '', display_on_browse = 'No' WHERE id = 22



This this for type

216.221.81.96 -- June 25, 2003, 10:38:01 am -- UPDATE or_listingsFormElements SET field_type = 'select', field_name = 'type', field_caption = 'Type', default_text = '', field_elements = 'Home||Land||Farms||Commercial||Rental', rank = '15', required = 'No', location = 'top_right', searchable = '1', search_type = 'optionlist', search_label = 'Type', search_step = '', display_on_browse = '' WHERE id = 14

and this for price (range 1000 minmax++)

216.221.81.96 -- June 25, 2003, 10:39:28 am -- UPDATE or_listingsFormElements SET field_type = 'price', field_name = 'price', field_caption = 'Price', default_text = '', field_elements = '', rank = '9', required = 'No', location = 'top_left', searchable = '1', search_type = 'minmax', search_label = 'Price', search_step = '1000', display_on_browse = '' WHERE id = 18


Does it help to know that all the Search Label fields come up with a default 0 in admin edit Listing Template ???


I hope this helps

I was just about to launch this site
http://www.canadarealty.ca

(July first). I paid to get a Amember plugin written for open-realty. sould let the guy stop and wait for this realease. If yes, How long before it will be released. (you think)

Anonymous
06-25-2003, 11:21 AM
The errpr was because I changed the prefix from default_ to or_
so i guess that can help ypu to figure out what to do.

I changed my database prefix back to default and now it is working.


So I there got to be a way for this to work if someone changes the prefix.

Anonymous
06-25-2003, 11:23 AM
Now that that is gone, it is saying this



Fatal error: Call to undefined function: searchbox_community() in /home/canreal/public_html/test/listingsearch.php on line 30


when I try yo search..

Sorry for all this bug report but I would like to see this thin up and running.

greengiant
06-25-2003, 11:48 AM
Did you use the configurator to build the database or did you load from the sql file? THe sql file is goign to use default_ as the table prefix if you want to change that just search and replace all occurances of default_ with or_ in the sql file before loading it..

Anonymous
06-25-2003, 11:51 AM
Did you use the configurator to build the database or did you load from the sql file? THe sql file is goign to use default_ as the table prefix if you want to change that just search and replace all occurances of default_ with or_ in the sql file before loading it..

configurator not working so I use sql file...

greengiant
06-25-2003, 11:54 AM
I am going to try and figure out what is wrong with the confiugrator in a few minutes.. Can you test this new open-realty.sql file...



-- MySQL dump 8.22
--
-- Host: localhost Database: openrealtyprefix
---------------------------------------------------------
-- Server version 3.23.56

--
-- Table structure for table 'default_UserDB'
--

CREATE TABLE `default_UserDB` (
`ID` int(11) NOT NULL auto_increment,
`user_name` varchar(80) NOT NULL default '',
`emailAddress` varchar(80) NOT NULL default '',
`Comments` text NOT NULL,
`user_password` varchar(50) NOT NULL default '',
`isAdmin` char(3) NOT NULL default 'No',
`canEditForms` char(3) NOT NULL default 'No',
`creation_date` date NOT NULL default '0000-00-00',
`canFeatureListings` char(3) NOT NULL default 'No',
`canViewLogs` char(3) NOT NULL default 'No',
`last_modified` timestamp(14) NOT NULL,
`hitcount` int(11) NOT NULL default '0',
`canModerate` char(3) NOT NULL default 'no',
`active` char(3) NOT NULL default 'no',
`isAgent` char(3) NOT NULL default 'no',
PRIMARY KEY (`ID`),
UNIQUE KEY `ID` (`ID`,`user_name`),
KEY `ID_2` (`ID`)
) TYPE=MyISAM;

--
-- Dumping data for table 'default_UserDB'
--


INSERT INTO `default_UserDB` VALUES (1,'admin','ryan@open-realty.org','','5f4dcc3b5aa765d61d8327deb882cf99', 'yes','yes','2002-07-01','yes','yes',20020701223850,1,'yes','yes','yes' );

--
-- Table structure for table 'default_UserDBElements'
--

CREATE TABLE `default_UserDBElements` (
`ID` int(11) NOT NULL auto_increment,
`field_name` varchar(80) NOT NULL default '',
`field_value` text NOT NULL,
`user_id` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`),
UNIQUE KEY `ID` (`ID`)
) TYPE=MyISAM;

--
-- Dumping data for table 'default_UserDBElements'
--


INSERT INTO `default_UserDBElements` VALUES (1,'edit_user_name','admin',1);
INSERT INTO `default_UserDBElements` VALUES (2,'phone','215.850.0710',1);
INSERT INTO `default_UserDBElements` VALUES (3,'mobile','215.850.0710',1);
INSERT INTO `default_UserDBElements` VALUES (4,'fax','702.995.6591',1);
INSERT INTO `default_UserDBElements` VALUES (5,'homepage','http://jonroig.com',1);
INSERT INTO `default_UserDBElements` VALUES (6,'info','I am the system administrator!',1);

--
-- Table structure for table 'default_activityLog'
--

CREATE TABLE `default_activityLog` (
`id` int(11) NOT NULL auto_increment,
`log_date` datetime NOT NULL default '0000-00-00 00:00:00',
`user` int(11) NOT NULL default '0',
`action` varchar(150) NOT NULL default '',
`ip_address` varchar(15) NOT NULL default '',
KEY `id` (`id`)
) TYPE=MyISAM;

--
-- Dumping data for table 'default_activityLog'
--

--
-- Table structure for table 'default_agentFormElements'
--

CREATE TABLE `default_agentFormElements` (
`ID` int(11) NOT NULL auto_increment,
`field_type` varchar(20) NOT NULL default '',
`field_name` varchar(20) NOT NULL default '',
`field_caption` varchar(80) NOT NULL default '',
`default_text` text NOT NULL,
`field_elements` text NOT NULL,
`rank` int(11) NOT NULL default '0',
`required` char(3) NOT NULL default '',
PRIMARY KEY (`ID`)
) TYPE=MyISAM;

--
-- Dumping data for table 'default_agentFormElements'
--


INSERT INTO `default_agentFormElements` VALUES (3,'textarea','info','Info','','',10,'No');
INSERT INTO `default_agentFormElements` VALUES (4,'text','phone','Phone','','',1,'No');
INSERT INTO `default_agentFormElements` VALUES (5,'text','mobile','Mobile','','',3,'No');
INSERT INTO `default_agentFormElements` VALUES (6,'text','fax','Fax','','',5,'No');
INSERT INTO `default_agentFormElements` VALUES (7,'url','homepage','Homepage','','',7,'No');

--
-- Table structure for table 'default_listingsDB'
--

CREATE TABLE `default_listingsDB` (
`ID` int(11) NOT NULL auto_increment,
`user_ID` int(11) NOT NULL default '0',
`Title` varchar(80) NOT NULL default '',
`expiration` date NOT NULL default '0000-00-00',
`notes` text NOT NULL,
`creation_date` date NOT NULL default '0000-00-00',
`last_modified` timestamp(14) NOT NULL,
`hitcount` int(11) NOT NULL default '0',
`featured` char(3) NOT NULL default 'no',
`active` char(3) NOT NULL default 'yes',
PRIMARY KEY (`ID`),
UNIQUE KEY `ID` (`ID`),
KEY `ID_2` (`ID`)
) TYPE=MyISAM;

--
-- Dumping data for table 'default_listingsDB'
--


INSERT INTO `default_listingsDB` VALUES (1,1,'Example Listing','2003-07-01','This is an example listing!','2002-07-01',20030624232253,26,'yes','yes');

--
-- Table structure for table 'default_listingsDBElements'
--

CREATE TABLE `default_listingsDBElements` (
`ID` int(11) NOT NULL auto_increment,
`field_name` varchar(20) NOT NULL default '',
`field_value` text NOT NULL,
`listing_id` int(11) NOT NULL default '0',
`user_id` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`),
UNIQUE KEY `ID` (`ID`)
) TYPE=MyISAM;

--
-- Dumping data for table 'default_listingsDBElements'
--


INSERT INTO `default_listingsDBElements` VALUES (983,'community_features','Golf Course||Pool||Spa/Jacuzzi||Sports Complex||Tennis Courts||Bike Paths||Boating||Courtyard||Playground/Park||Association Fee||Clubhouse||Controlled Access||Public Transportation',1,1);
INSERT INTO `default_listingsDBElements` VALUES (980,'status','Active',1,1);
INSERT INTO `default_listingsDBElements` VALUES (981,'mls','13013',1,1);
INSERT INTO `default_listingsDBElements` VALUES (982,'home_features','Balcony||Patio/Deck||Waterfront||Dishwasher||Disposal||Gas Range||Microwave||Washer/Dryer||Carpeted Floors||Hardwood Floors||Air Conditioning||Alarm||Cable/Satellite TV||Fireplace||Wheelchair Access ',1,1);
INSERT INTO `default_listingsDBElements` VALUES (979,'garage_size','40 car',1,1);
INSERT INTO `default_listingsDBElements` VALUES (978,'prop_tax','0',1,1);
INSERT INTO `default_listingsDBElements` VALUES (977,'lot_size','20 Acres',1,1);
INSERT INTO `default_listingsDBElements` VALUES (976,'sq_feet','35,000',1,1);
INSERT INTO `default_listingsDBElements` VALUES (975,'year_built','1800',1,1);
INSERT INTO `default_listingsDBElements` VALUES (974,'floors','6',1,1);
INSERT INTO `default_listingsDBElements` VALUES (973,'baths','35',1,1);
INSERT INTO `default_listingsDBElements` VALUES (972,'beds','10',1,1);
INSERT INTO `default_listingsDBElements` VALUES (971,'type','Home',1,1);
INSERT INTO `default_listingsDBElements` VALUES (970,'full_desc','Exclusive to this site! For two hundred years, the White House has\r\n\r\n stood as a symbol of the Presidency, the United States government,\r\nand the American people.',1,1);
INSERT INTO `default_listingsDBElements` VALUES (969,'price','2500400',1,1);
INSERT INTO `default_listingsDBElements` VALUES (968,'neighborhood','Capitol',1,1);
INSERT INTO `default_listingsDBElements` VALUES (967,'zip','20500',1,1);
INSERT INTO `default_listingsDBElements` VALUES (966,'state','District of Columbia',1,1);
INSERT INTO `default_listingsDBElements` VALUES (965,'city','Washington',1,1);
INSERT INTO `default_listingsDBElements` VALUES (964,'address','1600 Pennsylvania Avenue',1,1);

--
-- Table structure for table 'default_listingsFormElements'
--

CREATE TABLE `default_listingsFormElements` (
`ID` int(11) NOT NULL auto_increment,
`field_type` varchar(20) NOT NULL default '',
`field_name` varchar(20) NOT NULL default '',
`field_caption` varchar(80) NOT NULL default '',
`default_text` text NOT NULL,
`field_elements` text NOT NULL,
`rank` int(11) NOT NULL default '0',
`required` char(3) NOT NULL default '',
`location` varchar(15) NOT NULL default '',
`display_on_browse` char(3) NOT NULL default 'No',
`searchable` int(10) unsigned NOT NULL default '0',
`search_type` varchar(10) default NULL,
`search_label` varchar(50) default NULL,
`search_step` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`),
KEY `idx_searchable` (`searchable`)
) TYPE=MyISAM;

--
-- Dumping data for table 'default_listingsFormElements'
--


INSERT INTO `default_listingsFormElements` VALUES (1,'text','city','City','','',2,'Yes','top_left',' Yes',0,NULL,NULL,0);
INSERT INTO `default_listingsFormElements` VALUES (2,'text','address','Address','','',0,'Yes','top_l eft','Yes',0,NULL,NULL,0);
INSERT INTO `default_listingsFormElements` VALUES (3,'text','mls','mls','','',33,'No','top_right','' ,0,NULL,NULL,0);
INSERT INTO `default_listingsFormElements` VALUES (21,'checkbox','home_features','Home Features','','Balcony||Patio/Deck||Waterfront||Dishwasher||Disposal||Gas Range||Microwave||Washer/Dryer||Carpeted Floors||Hardwood Floors||Air Conditioning||Alarm||Cable/Satellite TV||Fireplace||Wheelchair Access ',80,'No','feature1','No',0,NULL,NULL,0);
INSERT INTO `default_listingsFormElements` VALUES (5,'number','prop_tax','Annual Property Tax','','',29,'No','top_right','',0,NULL,NULL,0);
INSERT INTO `default_listingsFormElements` VALUES (6,'select','status','Status','','Active||Pending| |Sold',31,'No','top_right','',0,NULL,NULL,0);
INSERT INTO `default_listingsFormElements` VALUES (7,'text','lot_size','Lot Size','','',27,'No','top_right','',0,NULL,NULL,0);
INSERT INTO `default_listingsFormElements` VALUES (8,'text','garage_size','Garage Size','','',29,'No','top_right','',0,NULL,NULL,0);
INSERT INTO `default_listingsFormElements` VALUES (9,'text','year_built','Year Built','','',23,'No','top_left','',0,NULL,NULL,0);
INSERT INTO `default_listingsFormElements` VALUES (10,'number','sq_feet','Square Feet','','',25,'No','top_right','',0,NULL,NULL,0);
INSERT INTO `default_listingsFormElements` VALUES (11,'text','baths','Baths','','',19,'No','top_left ','',0,NULL,NULL,0);
INSERT INTO `default_listingsFormElements` VALUES (12,'number','floors','Floors','','',21,'No','top_ left','',0,NULL,NULL,0);
INSERT INTO `default_listingsFormElements` VALUES (13,'text','beds','Beds','','',17,'No','top_left', '',0,NULL,NULL,0);
INSERT INTO `default_listingsFormElements` VALUES (14,'select','type','Type','','Home||Land||Farms|| Commercial||Rental',15,'No','top_right','',0,NULL, NULL,0);
INSERT INTO `default_listingsFormElements` VALUES (16,'textarea','full_desc','Full Description','','',13,'No','center','',0,NULL,NULL ,0);
INSERT INTO `default_listingsFormElements` VALUES (17,'text','neighborhood','Neighborhood','','',7,' No','top_left','',0,NULL,NULL,0);
INSERT INTO `default_listingsFormElements` VALUES (18,'price','price','Price','','',9,'No','top_left ','',1,'minmax','Price',5000);
INSERT INTO `default_listingsFormElements` VALUES (19,'text','zip','Zip','','',5,'Yes','top_left','Y es',0,NULL,NULL,0);
INSERT INTO `default_listingsFormElements` VALUES (20,'select','state','State','','Alabama||Alaska|| Arizona||Arkansas||California||Colorado||Connectic ut||Delaware||District of Columbia||Florida||Georgia||Hawaii||Idaho||Illinoi s||Indiana||Iowa||Kansas||Kentucky||Louisiana||Mai ne||Maryland||Massachusetts||Alabama||Alaska||Ariz ona||Arkansas||California||Colorado||Connecticut|| Delaware||District of Columbia||Florida||Georgia||Hawaii||Idaho||Illinoi s||Indiana||Iowa||Kansas||Kentucky||Louisiana||Mai ne||Maryland||Massachusetts||Michigan||Minnesota|| Mississippi||Missouri||Montana||Nebraska||Nevada|| New Hampshire||New Jersey||New Mexico||New York||North Carolina||North Dakota||Ohio||Oklahoma||Oregon||Pennsylvania||Rhod e Island||South Carolina||South Dakota||Tennessee||Texas||Utah||Vermont||Virginia| |Washington||West Virginia||Wisconsin||Wyoming',4,'Yes','top_left',' Yes',0,NULL,NULL,0);
INSERT INTO `default_listingsFormElements` VALUES (22,'checkbox','community_features','Community Features','','Fitness Center||Golf Course||Pool||Spa/Jacuzzi||Sports Complex||Tennis Courts||Bike Paths||Boating||Courtyard||Playground/Park||Association Fee||Clubhouse||Controlled Access||Public Transportation',85,'No','feature2','No',1,'optionl ist','Community Features',0);

--
-- Table structure for table 'default_listingsImages'
--

CREATE TABLE `default_listingsImages` (
`ID` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '0',
`caption` varchar(255) NOT NULL default '',
`file_name` varchar(80) NOT NULL default '',
`thumb_file_name` varchar(80) NOT NULL default '',
`description` text NOT NULL,
`listing_id` int(11) NOT NULL default '0',
`rank` int(11) NOT NULL default '5',
`active` char(3) NOT NULL default 'yes',
PRIMARY KEY (`ID`)
) TYPE=MyISAM;

--
-- Dumping data for table 'default_listingsImages'
--


INSERT INTO `default_listingsImages` VALUES (1,1,'View From the Lawn','1_white-house.jpg','thumb_1_white-house.jpg','This property has six floors, 132 rooms, 35 bathrooms, 147 windows, 412 doors, 12 chimneys, 8 staircases, and 3 elevators.',1,1,'yes');
INSERT INTO `default_listingsImages` VALUES (2,1,'Vermeil Room','1_vermeil_room.jpg','thumb_1_vermeil_room.j pg','The Vermeil Room, sometimes called the Gold Room, was last refurbished in 1991; it serves as a display room and, for formal occasions, as a ladies sitting room. The soft yellow of the paneled walls complements the collection of vermeil, or gilded silver, bequeathed to the White House in 1956 by Mrs. Margaret Thompson Biddle.',1,5,'yes');
INSERT INTO `default_listingsImages` VALUES (3,1,'The China Room','1_china_room.jpg','thumb_1_china_room.jpg', 'The Presidential Collection Room, now the China Room, was designated by Mrs. Woodrow Wilson in 1917 to display the growing collection of White House china. The room was redecorated in 1970, retaining the traditional red color scheme determined by the portrait of Mrs. Calvin Coolidge--painted by Howard Chandler Christy in 1924. President Coolidge, who was scheduled to sit for Christy, was too occupied that day with events concerning the Teapot Dome oil scandal. So the President postponed his appointment, and Mrs. Coolidge posed instead.',1,5,'yes');
INSERT INTO `default_listingsImages` VALUES (4,1,'State Dining Room','1_dining_room.jpg','thumb_1_dining_room.jpg ','The State Dining Room, which now seats as many as 140 guests, was originally much smaller and served at various times as a drawing room, office, and Cabinet Room. Not until the Andrew Jackson administration was it called the State Dining Room, although it had been used for formal dinners by previous Presidents.',1,5,'yes');
INSERT INTO `default_listingsImages` VALUES (5,1,'The Green Room','1_green_room.jpg','thumb_1_green_room.jpg', 'Although intended by architect James Hoban to be the Common Dining Room, the Green Room has served many purposes since the White House was first occupied in 1800. The inventory of February 1801 indicates that it was first used as a Lodging Room. Thomas Jefferson, the second occupant of the White House, used it as a dining room with a canvas floor cloth, painted green, foreshadowing the present color scheme. James Madison made it a sitting room since his Cabinet met in the East Room next door, and the Monroes used it as the Card Room with two tables for the whist players among their guests. ',1,5,'yes');

--
-- Table structure for table 'default_memberFormElements'
--

CREATE TABLE `default_memberFormElements` (
`ID` int(11) NOT NULL auto_increment,
`field_type` varchar(20) NOT NULL default '',
`field_name` varchar(20) NOT NULL default '',
`field_caption` varchar(80) NOT NULL default '',
`default_text` text NOT NULL,
`field_elements` text NOT NULL,
`rank` int(11) NOT NULL default '0',
`required` char(3) NOT NULL default '',
PRIMARY KEY (`ID`)
) TYPE=MyISAM;

--
-- Dumping data for table 'default_memberFormElements'
--


INSERT INTO `default_memberFormElements` VALUES (3,'textarea','info','Info','','',10,'No');
INSERT INTO `default_memberFormElements` VALUES (4,'text','phone','Phone','','',1,'No');
INSERT INTO `default_memberFormElements` VALUES (5,'text','mobile','Mobile','','',3,'No');
INSERT INTO `default_memberFormElements` VALUES (6,'text','fax','Fax','','',5,'No');
INSERT INTO `default_memberFormElements` VALUES (7,'url','homepage','Homepage','','',7,'No');

--
-- Table structure for table 'default_userFavoriteListings'
--

CREATE TABLE `default_userFavoriteListings` (
`ID` int(11) NOT NULL auto_increment,
`user_ID` int(11) NOT NULL default '0',
`listing_ID` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`)
) TYPE=MyISAM;

--
-- Dumping data for table 'default_userFavoriteListings'
--



--
-- Table structure for table 'default_userFormElements'
--

CREATE TABLE `default_userFormElements` (
`ID` int(11) NOT NULL auto_increment,
`field_type` varchar(20) NOT NULL default '',
`field_name` varchar(20) NOT NULL default '',
`field_caption` varchar(80) NOT NULL default '',
`default_text` text NOT NULL,
`field_elements` text NOT NULL,
`rank` int(11) NOT NULL default '0',
`required` char(3) NOT NULL default '',
PRIMARY KEY (`ID`)
) TYPE=MyISAM;

--
-- Dumping data for table 'default_userFormElements'
--


INSERT INTO `default_userFormElements` VALUES (3,'textarea','info','Info','','',10,'No');
INSERT INTO `default_userFormElements` VALUES (4,'text','phone','Phone','','',1,'No');
INSERT INTO `default_userFormElements` VALUES (5,'text','mobile','Mobile','','',3,'No');
INSERT INTO `default_userFormElements` VALUES (6,'text','fax','Fax','','',5,'No');
INSERT INTO `default_userFormElements` VALUES (7,'url','homepage','Homepage','','',7,'No');

--
-- Table structure for table 'default_userImages'
--

CREATE TABLE `default_userImages` (
`ID` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '0',
`caption` varchar(255) NOT NULL default '',
`file_name` varchar(80) NOT NULL default '',
`thumb_file_name` varchar(80) NOT NULL default '',
`description` text NOT NULL,
`rank` int(11) NOT NULL default '5',
`active` char(3) NOT NULL default 'yes',
PRIMARY KEY (`ID`)
) TYPE=MyISAM;

--
-- Dumping data for table 'default_userImages'
--



--
-- Table structure for table 'default_userSavedSearches'
--

CREATE TABLE `default_userSavedSearches` (
`ID` int(11) NOT NULL auto_increment,
`user_ID` int(11) NOT NULL default '0',
`Title` varchar(255) NOT NULL default '',
`query_string` longtext NOT NULL,
`last_viewed` timestamp(14) NOT NULL,
`new_listings` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`ID`)
) TYPE=MyISAM;

--
-- Dumping data for table 'default_userSavedSearches'
--

Anonymous
06-25-2003, 12:16 PM
Thanks but that is the one I have already.

I will just wait it out.

The error is gone but when the selection comes up. The search result is blank.

try it
http://www.canadarealty.ca/test/listingsearch.php