| Message Text |
Is my terminology correct here?
I used the manual to build it but the page just reloads when I choose an option. My guess is that you aren't allowed to put numbers in the value statement?
field to search is called property_size
< form action="search.php?action=filled=1&whichtype=items" method="post" >
Search for a property that is:
< select name="property_sizecondition">
< option value="< 3000">Under 3,000 sq. ft</option>
< option value="between 3000,5000">3,000 to 5,000 sq. ft.</option>
< option value="between 5000,10000">5,000 to 10,000 sq. ft.</option>
< option value="between 3000,5000">3,000 to 5,000 sq. ft.</option>
< option value="> 10000">Over 10,000 sq. ft. </option>
< /select>
< input type="hidden" name="property_sizesearch" />
< input type="submit" value="Find" class="button" />
</form>
property_size is chosen as a valid field to search in settings.
------------
Update: I'm also getting errors for searches that were originally a part of the advancedsearch.tpl.
I know that one item has over 100 visits (hits) so I plug in "find item where hits are < 100" to find the other item that hasn't been visited as often.
I get this error: (I'm getting it on quite a few of the searches listed on advancedsearch.tpl, now that I've had time to test them)
An error occoured at http://www.reellocations.
com/dir/search.php?action=filter&filled=1&whichtype=items on 2008-09-22 02:19:23. Please relay this data to support. Error #2: 'mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given' in /home/reelloca/public_html/dir/databases/mysqli.php on line 45. Debug info:
`viewers`,`threadviewers`,`hitsintemp`,`hitsouttemp`,`origtype`,`importance`,`parentids`,`timesdead`,`timesemailed`,`threadclosed`,`threadposters`,`lastposterid`,`lastpostername`,`ownername`,`deleted`,`deletionreason`,`movedto`,`deletedby`,`timevalidated`,`filefield`,`message`,`sticky`,`downloads`,`pollid`,`posticon`,`savedby`,`validatedemail`,`unpaid`,`recipverified`,`effectivetime`,`sugcatid`,`pagerank`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`feedcache`,`feedcachetime`,`tags`,`xmlsource`,`ordercomments`,`lastpadupdate`,`padfile`,`lastmonthlycheck`,`invisibleto`,`profileurl`,`lastprofileurl`,`price`,`summary`,`timesrenewed`,`timedeleted`,`address`,`city`,`state`,`country`,`latitude`,`zip`,`sponsorend`,`longitude`,`contact_name`,`contact_phone_office`,`contact_phone_home`,`contact_phone_mobile`,`contact_email`,`property_style_other`,`property_architect`,`property_size`,`property_features`,`property_credits`,`filefield_mainattach`,`contact_phone_other`,`contact_phone_other_label`,`property_style`,`mainphotoattach` FROM wsnclassifieds_links WHERE (validated=1 AND invisibleto NOT LIKE '%|3|%' AND hide=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1222049963) AND (hits < 100)) ORDER BY typeorder ASC,hits DESC LIMIT 0,42
Load time so far: 0.1 seconds.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; 100)) ORDER BY typeorder ASC,hits DESC LIMIT 0,42' at line 1
Load time so far: 0.1 seconds.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; 100)) ORDER BY typeorder ASC,hits DESC LIMIT 0,42' at line 1
Query 10: SELECT COUNT(id) FROM wsnclassifieds_links WHERE (validated=1 AND invisibleto NOT LIKE '%|3|%' AND hide=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1222049963) AND (hits < 100))
An error occoured at www.reellocations.com/dir/s...r&filled=1&whichtype=items on 2008-09-22 02:19:23. Please relay this data to support. Error #2: 'mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given' in /home/reelloca/public_html/dir/databases/mysqli.php on line 42. Debug info:
dviewers`,`hitsintemp`,`hitsouttemp`,`origtype`,`importance`,`parentids`,`timesdead`,`timesemailed`,`threadclosed`,`threadposters`,`lastposterid`,`lastpostername`,`ownername`,`deleted`,`deletionreason`,`movedto`,`deletedby`,`timevalidated`,`filefield`,`message`,`sticky`,`downloads`,`pollid`,`posticon`,`savedby`,`validatedemail`,`unpaid`,`recipverified`,`effectivetime`,`sugcatid`,`pagerank`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`feedcache`,`feedcachetime`,`tags`,`xmlsource`,`ordercomments`,`lastpadupdate`,`padfile`,`lastmonthlycheck`,`invisibleto`,`profileurl`,`lastprofileurl`,`price`,`summary`,`timesrenewed`,`timedeleted`,`address`,`city`,`state`,`country`,`latitude`,`zip`,`sponsorend`,`longitude`,`contact_name`,`contact_phone_office`,`contact_phone_home`,`contact_phone_mobile`,`contact_email`,`property_style_other`,`property_architect`,`property_size`,`property_features`,`property_credits`,`filefield_mainattach`,`contact_phone_other`,`contact_phone_other_label`,`property_style`,`mainphotoattach` FROM wsnclassifieds_links WHERE (validated=1 AND invisibleto NOT LIKE '%|3|%' AND hide=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1222049963) AND (hits < 100)) ORDER BY typeorder ASC,hits DESC LIMIT 0,42
Load time so far: 0.1 seconds.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; 100)) ORDER BY typeorder ASC,hits DESC LIMIT 0,42' at line 1
Load time so far: 0.1 seconds.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; 100)) ORDER BY typeorder ASC,hits DESC LIMIT 0,42' at line 1
Query 10: SELECT COUNT(id) FROM wsnclassifieds_links WHERE (validated=1 AND invisibleto NOT LIKE '%|3|%' AND hide=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1222049963) AND (hits < 100))
Count is |
