| between search broken |
david |
Here is a debug info:
Query 6: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM wsnlinks_email WHERE timesent=0 AND inprogress=0 ORDER BY id ASC LIMIT 0,10
Load time so far: 0.1 seconds.
Number of rows is 0
Creating search with new as new
Query 7: INSERT INTO wsnlinks_searches(`id`,`value`,`memberid`,`catid`,`time`) VALUES('','budapest , kiado 1 223 2 222','1','','1220653959')
Query 8: SELECT `id` FROM wsnlinks_searches ORDER BY id DESC
Load time so far: 0.11 seconds.
Setting cookie with name testcookie, value 25 and expiration time 3441307917
Query 9: 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`,`timedeleted`,`helyseg`,`ar`,`varos`,`epitoanyag`,`alapterulet`,`kertmeret`,`szobaszam`,`felszobaszam`,`erkely`,`futes`,`kilatas`,`tajolas`,`komfort`,`lift`,`emeleten`,`parkolas`,`lakasallapot`,`extrak`,`butorozott`,`szintek`,`kiadoar`,`helysegenglish`,`epitoanyagenglish`,`erkelyenglish`,`futesenglish`,`kilatasenglish`,`tajolasenglish`,`komfortenglish`,`liftenglish`,`parkolasenglish`,`lakasallapotenglish`,`extrakenglish`,`butorozottenglish`,`descriptionenglish`,`kerulet`,`megye`,`eladokiado`,`gepesitett`,`gepesitettenglish`,`cim`,`hazszam`,`adminnotes`,`telek`,`sponsorend`,`address`,`city`,`state`,`country`,`latitude`,`longitude`,`zip`,`kiadoareuro` FROM wsnlinks_links WHERE (validated=1 AND invisibleto NOT LIKE '%|3|%' AND hide=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1220653959) AND (helyseg = 'budapest' AND eladokiado LIKE '%, kiado%' AND kiadoareuro '1 223')) ORDER BY typeorder ASC,time DESC LIMIT 0,60
Load time so far: 0.12 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 223')) ORDER BY typeorder ASC,time DESC LIMIT 0,60' at line 1
Load time so far: 0.12 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 223')) ORDER BY typeorder ASC,time DESC LIMIT 0,60' at line 1
Query 10: SELECT COUNT(id) FROM wsnlinks_links WHERE (validated=1 AND invisibleto NOT LIKE '%|3|%' AND hide=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1220653959) AND (helyseg = 'budapest' AND eladokiado LIKE '%, kiado%' AND kiadoareuro '1 223'))
An error occoured at ccc.com/search.php?action=f...r&filled=1&whichtype=links on 2008-09-05 22:32:39. Please relay this data to support. Error #2: 'mysql_fetch_row(): supplied argument is not a valid MySQL result resource' in /home/ccc/public_html/cventura/databases/mysql.php on line 50. Debug info:
Count is
An error occoured at ccc.com/search.php?action=f...r&filled=1&whichtype=links on 2008-09-05 22:32:39. Please relay this data to support. Error #2: 'mysql_num_rows(): supplied argument is not a valid MySQL result resource' in /home/ccc/public_html/cventura/databases/mysql.php on line 47. Debug info:
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 223'))' at line 1
Load time so far: 0.13 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 223'))' at line 1
Query 11: SELECT COUNT(id) FROM wsnlinks_sessions WHERE memberid>0
Count is 1
Load time so far: 0.13 seconds.
Query 12: SELECT COUNT(id) FROM wsnlinks_sessions WHERE memberid=0 AND isrobot=0
Count is 0
Load time so far: 0.13 seconds.
Query 13: SELECT COUNT(id) FROM wsnlinks_sessions WHERE memberid=0 AND isrobot=1
Count is 1
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 > 1220653059 AND (memberid>0) ORDER BY time DESC LIMIT 0,100
Load time so far: 0.14 seconds.
Number of rows is 1
Creating online with Array as row
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 memberid=1
Load time so far: 0.32 seconds.
Number of rows is 1
Creating online with Array as row
Load time so far: 0.32 seconds.
Query 16: UPDATE wsnlinks_sessions SET starttime = '1220653410', name = 'daa@gmail.com', time = '1220653959', location = 'http://cccc.com/search.php?action=filter&&whichtype=links', catid = '', threadid = '', areaname = 'Search Results for {SEARCHTERM}', nopermission = '0', inchat = '0', ip = 'xxx.xxx.29.241' WHERE id=20
|
Sep 05, 2008 - 5:34 PM |
Paid Scripts Support |
| Advanced search bug? or... |
david |
Interesting. I changed the input fields to search for catids like this
<form action="search.php?action=filter&filled=1&whichtype=links&condition=and" method="post" name="searchadvanced">
<input type="text" class="bordered" name="catidsearch"/>
<input type="hidden" name="catidcondition" value="or" />
<input type="submit" value="Search" class="button" />
</form>
and it didn't do the same
`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`,`timedeleted`,`helyseg`,`ar`,`varos`,`epitoanyag`,`alapterulet`,`kertmeret`,`szobaszam`,`felszobaszam`,`erkely`,`futes`,`kilatas`,`tajolas`,`komfort`,`lift`,`emeleten`,`parkolas`,`lakasallapot`,`extrak`,`butorozott`,`szintek`,`kiadoar`,`helysegenglish`,`epitoanyagenglish`,`erkelyenglish`,`futesenglish`,`kilatasenglish`,`tajolasenglish`,`komfortenglish`,`liftenglish`,`parkolasenglish`,`lakasallapotenglish`,`extrakenglish`,`butorozottenglish`,`descriptionenglish`,`kerulet`,`megye`,`eladokiado`,`gepesitett`,`gepesitettenglish`,`cim`,`hazszam`,`adminnotes`,`telek`,`sponsorend`,`address`,`city`,`state`,`country`,`latitude`,`longitude`,`zip`,`kiadoareuro` FROM wsnlinks_links WHERE (validated=1 AND invisibleto NOT LIKE '%|3|%' AND hide=0 AND deleted=0 AND inalbum=0) AND ((effectivetime < 1220283618) AND ((catid = 63))) ORDER BY typeorder ASC,time DESC LIMIT 0,60
Granted I changed the condition to OR, instead of LIKE, but I still don't understand. |
Sep 01, 2008 - 10:40 AM |
Paid Scripts Support |
| Advanced search bug? or... |
david |
Hi Paul,
I don't know if this is a bug, or something else.
Take a very simple advanced search, with a single field to search in the links for. This is a text field. I enter 'I.' (without single quotation marks), and the system does the below:
`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`,`timedeleted`,`helyseg`,`ar`,`varos`,`epitoanyag`,`alapterulet`,`kertmeret`,`szobaszam`,`felszobaszam`,`erkely`,`futes`,`kilatas`,`tajolas`,`komfort`,`lift`,`emeleten`,`parkolas`,`lakasallapot`,`extrak`,`butorozott`,`szintek`,`kiadoar`,`helysegenglish`,`epitoanyagenglish`,`erkelyenglish`,`futesenglish`,`kilatasenglish`,`tajolasenglish`,`komfortenglish`,`liftenglish`,`parkolasenglish`,`lakasallapotenglish`,`extrakenglish`,`butorozottenglish`,`descriptionenglish`,`kerulet`,`megye`,`eladokiado`,`gepesitett`,`gepesitettenglish`,`cim`,`hazszam`,`adminnotes`,`telek`,`sponsorend`,`address`,`city`,`state`,`country`,`latitude`,`longitude`,`zip`,`kiadoareuro` FROM wsnlinks_links WHERE (validated=1 AND invisibleto NOT LIKE '%|3|%' AND hide=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1220281754) AND ((kerulet LIKE '% I. %'))) ORDER BY typeorder ASC,time DESC LIMIT 0,60
Load time so far: 0.09 seconds.
Load time so far: 0.09 seconds.
Query 10: SELECT COUNT(id) FROM wsnlinks_links WHERE (validated=1 AND invisibleto NOT LIKE '%|3|%' AND hide=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1220281754) AND ((kerulet LIKE '% I. %')))
What is interesting is the LIKE '% I. %'. Why is there a space around my 'I.'? If there wouldn't be, the search would find what I was looking for (I think, I hope).
Thanks
David |
Sep 01, 2008 - 10:14 AM |
Paid Scripts Support |
it would have been for internal use, but it's not worth the trouble if it takes more than 10 minutes.