| Message Text |
Hi Paul,
I have a BETWEEN type search in my advanced search page. Looks like this:
<form action="https://www.webmastersite.net/forums/search.php?action=filter&filled=1&whichtype=links" method="post">
<select name="titlecondition">
<option value="like">contains</option>
</select>
<input type="text" size="{STANDARDSIZE}" name="titlesearch" />
<input type="hidden" name="eletkorconditon" value="between">
<input type="text" name="eletkorsearch" size="2" value="0"> and <input type="text" name="eletkorsearchmax" size="2">
<input type="submit" value="Keresés" class="button" />
</form>
When I leave the minimum value blank and enter a max value, I get a result fine.
When I leave the maximum value blank and enter a min value, I get a result fine.
When I enter a value for both, I get this:
Load time so far: 0.08 seconds.
Query 2: SELECT `name`,`value` FROM wsnlinks_switches WHERE id>0
Number of rows is 87
Load time so far: 0.09 seconds.
Query 3: SELECT `id`,`title`,`caneditown`,`caneditall`,`canvote`,`isadmin`,`canpost`,`canemail`,`validatecats`,`validatecomments`,`validatelinks`,`validateedits`,`cansubmitlinks`,`cansubmitcategories`,`cansubmitcomments`,`caneditownlinks`,`caneditowncategories`,`caneditowncomments`,`caneditownprofile`,`caneditalllinks`,`caneditallcategories`,`caneditallcomments`,`caneditallprofiles`,`candownloadfiles`,`canupload`,`canviewip`,`limitlinks`,`canemailmembers`,`canusehtml`,`limitlinksdaily`,`canalias`,`cancopy`,`candeleteown`,`candeleteall`,`candofulledit`,`candeletecategories`,`candeletecomments`,`candeleteowncategories`,`candeleteowncomments`,`candeletemembers`,`candeleteownmembers`,`canaliascategories`,`canviewpages`,`caneditvotes`,`numaliases`,`canviewvotes`,`canhideownlinks`,`canhideowncategories`,`canhideowncomments`,`canhidealllinks`,`canhideallcategories`,`canhideallcomments`,`canratecomments`,`bytespermem`,`canpm`,`canim`,`canharddelete`,`limitpms`,`limitpmsdaily`,`canviewdeleted`,`cansubmitpolls`,`candeletepolls`,`candeleteownpolls`,`caneditpolls`,`caneditownpolls`,`attachperpost`,`attachperpm`,`canviewshouts`,`caneditshouts`,`caneditownshouts`,`candeleteshouts`,`candeleteownshouts`,`cansubmitshouts`,`canpollvote`,`customtitle`,`canviewinvisible`,`namestyle`,`canpmimportant`,`canviewmodlog`,`isleader`,`cansubmitquotes`,`validatequotes`,`candeletequotes`,`candeleteownquotes`,`canreport`,`canusesearch`,`attachperlink`,`validateattachments`,`caneditownquotes`,`caneditallquotes`,`canviewchat`,`caneditownevents`,`caneditallevents`,`candeleteownevents`,`candeleteevents`,`cansubmitevents`,`validateevents`,`bulkpms`,`issupermod`,`numinv`,`allowugspec`,`validateemails`,`validatesponsorlinks`,`cansubmittags`,`candeletetags`,`cansubmitfeeds`,`validatefeeds`,`validatefeeditems`,`numaliasestot`,`shoutsperday`,`validatetrader`,`renewdays`,`renewtimes` FROM wsnlinks_membergroups WHERE id>0
Query 4: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE
Load time so far: 0.12 seconds.
Query 5: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM wsnlinks_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10
Number of rows is 0
Query 6: UNLOCK TABLES
Query 7: INSERT INTO wsnlinks_searches(`value`,`memberid`,`catid`,`time`) VALUES('1 2','0','','1194224590')
Load time so far: 0.14 seconds.
Query 8: SELECT `id`,`title`,`url`,`description`,`rating`,`votes`,`validated`,`catid`,`sumofvotes`,`email`,`time`,`hits`,`numcomments`,`hide`,`ownerid`,`voterips`,`voterids`,`lastedit`,`type`,`notify`,`suspect`,`pendingedit`,`funds`,`suspended`,`alias`,`expire`,`ip`,`inalbum`,`typeorder`,`recipurl`,`hitsin`,`recipwith`,`hitsinips`,`hitsoutips`,`lastcomment`,`related`,`inhidden`,`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`,`timesrenewed`,`mellboseg`,`derekboseg`,`csipoboseg`,`cipo`,`suly`,`teljesnev`,`orszag`,`megye`,`telepules`,`magassag`,`konfekcio`,`gyakorlat`,`iranyitoszam`,`hajszin`,`szemszin`,`tevekenyseg`,`oltozet`,`magamrol`,`megjelenes`,`referencia`,`nyelvtudas`,`tiltott`,`telefon`,`eletkor`,`szulinap` FROM wsnlinks_links WHERE (validated=1 AND hide=0 AND inhidden=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1194224590) AND (eletkor '1 2')) ORDER BY hits DESC LIMIT 0,60
Load time so far: 0.14 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 ''1 2')) ORDER BY hits DESC LIMIT 0,60' at line 1
Query 9: SELECT COUNT(id) FROM wsnlinks_links WHERE (validated=1 AND hide=0 AND inhidden=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1194224590) AND (eletkor '1 2'))
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/apollo/public_html/databases/mysql.php on line 29
Count is
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/apollo/public_html/databases/mysql.php on line 26
Number of rows is 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 ''1 2'))' at line 1
Load time so far: 0.2 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 ''1 2'))' at line 1
Query 10: SELECT COUNT(id) FROM wsnlinks_sessions WHERE memberid>0
Count is 1
Load time so far: 0.2 seconds.
Query 11: SELECT COUNT(id) FROM wsnlinks_sessions WHERE memberid=0 AND isrobot=0
Count is 1
Load time so far: 0.2 seconds.
Query 12: SELECT COUNT(id) FROM wsnlinks_sessions WHERE memberid=0 AND isrobot=1
Count is 0
Load time so far: 0.2 seconds.
Query 13: SELECT COUNT(
id) FROM wsnlinks_sessions WHERE time > 1194223690
Count is 2
Load time so far: 0.2 seconds.
Query 14: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl` FROM wsnlinks_sessions WHERE time > 1194223690 ORDER BY memberid desc,time desc LIMIT 0,300
Number of rows is 2
Load time so far: 0.3 seconds.
Query 15: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl` FROM wsnlinks_sessions WHERE ip='78.92.0.55' AND memberid=0
Number of rows is 1
Load time so far: 0.3 seconds.
Query 16: UPDATE wsnlinks_sessions SET starttime='1194217700', time='1194224590', location='http://www.apollomodel.net/search.php?action=filter&&whichtype=links', catid='', threadid='', areaname='Search Results', nopermission='0', inchat='0', ip='78.92.0.55' WHERE id=49
Any thoughts?
Thanks
David |
