After upgrading to 5.0.3, the between searches that worked a minute ago, didn't work. I don't have the debug info, but I remember that instead of seeing a single digit (the 'search' part of a between search), I now saw both the 'search' and the 'searchmax' numbers in the DB query. So technically it was search a single field in the DB for 2 numbers.
I had to revert to 5.0.2, so I couldn't spend time on getting the debug info, but please test this on your WSN.
An error occoured at c-ccc.com/search.php?action...r&filled=1&whichtype=links on 2008-09-05 21:57:53. 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:
An error occoured at cccc.com/search.php?action=...r&filled=1&whichtype=links on 2008-09-05 21:57:53. 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:
That was the original error, and now I just got it again. Still figuring out why exactly...
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
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
Probably a template issue, tested between searches in the default template and they work, changed to <br />and the number of comments <select name="numcommentscondition"> <option value="between">is between</option> </select> <input type="text" name="numcommentssearch" size="5" /> and <input type="text" name="numcommentssearchmax" size="5" />
Query 3: SELECT `name`,`value` FROM wsnlinks_switches
Load time so far: 0.05 seconds.
Query 4: 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`,`canviewownfulltrc`,`canviewallfulltrc` FROM wsnlinks_membergroups
Load time so far: 0.06 seconds.
Query 5: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`location`,`homepage`,`occupation`,`bio`,`aim`,`icq`,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`buddies`,`ignored`,`isonline`,`acceptims`,`adminpermissions`,`referrer`,`groupreverttime`,`grouprevertto`,`moderationpm`,`secondarygroups`,`linksperpage`,`commentsperpage`,`shouts`,`customtitle`,`shoutban`,`topicbans`,`forumbans`,`visibility`,`birthdate`,`lastsession`,`interests`,`posteditor`,`forumaccess`,`pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,`lastmodnote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote`,`autosubscribe`,`notifymethod`,`showavatars`,`showsigs`,`warninglevel`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct`,`notifytrader`,`minar`,`maxar`,`varos`,`epitoanyag`,`minalapterulet`,`maxalapterulet`,`minszobaszam`,`maxszobaszam`,`minfelszobaszam`,`maxfelszobaszam`,`erkely`,`futes`,`kilatas`,`tajolas`,`komfort`,`lift`,`minemeleten`,`maxemeleten`,`parkolas`,`lakasallapot`,`extrak`,`butorozott`,`minszintek`,`maxszintek`,`telefon`,`minkiadoar`,`maxkiadoar`,`megye`,`kerulet`,`eladokategoria`,`gepesitett`,`mintelek`,`maxtelek`,`inactiveemail`,`minkiadoareuro`,`maxkiadoareuro`,`kiadokategoria` FROM wsnlinks_members WHERE id = '1' AND validated = 1
Load time so far: 0.07 seconds.
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.08 seconds.
Number of rows is 0
Creating search with new as new
Query 7: INSERT INTO wsnlinks_searches(`id`,`value`,`memberid`,`catid`,`time`) VALUES('','2 33 between','1','','1220694317')
Query 8: SELECT `id` FROM wsnlinks_searches ORDER BY id DESC
Load time so far: 0.11 seconds.
Setting cookie with name testcookie, value 74 and expiration time 3441388633
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 < 1220694317) AND (ar '2 33')) 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 ''2 33')) 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 ''2 33')) 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 < 1220694317) AND (ar '2 33'))
An error occoured at cccc.com/search.php?action=...r&filled=1&whichtype=links on 2008-09-06 09:45:17. 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 cccc.com/search.php?action=...r&filled=1&whichtype=links on 2008-09-06 09:45:17. 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 ''2 33'))' at line 1
Load time so far: 0.16 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 ''2 33'))' at line 1
Query 11: SELECT COUNT(id) FROM wsnlinks_sessions WHERE memberid>0 Count is 1
Load time so far: 0.16 seconds.
Query 12: SELECT COUNT(id) FROM wsnlinks_sessions WHERE memberid=0 AND isrobot=0 Count is 0
Load time so far: 0.16 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 > 1220693417 AND (memberid>0) ORDER BY time DESC LIMIT 0,100
Load time so far: 0.2 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.47 seconds.
Number of rows is 1
Creating online with Array as row
Load time so far: 0.47 seconds.
Query 16: UPDATE wsnlinks_sessions SET starttime = '1220687660', name = 'c@gmail.com', time = '1220694317', location = 'http://cccc.com/search.php?action=filter&&whichtype=links', catid = '', threadid = '', areaname = 'Search Results for {SEARCHTERM}', nopermission = '0', inchat = '0', ip = 'xx.99.29.241' WHERE id=26
I remember that WSN 4.x produced a between search query with a single number (the value of the '...search' field from the form, and not something like this:
AND ((effectivetime < 1220694317) AND (ar '2 33'))
See how it was searching for a number in the 'ar' link field, that has a value of '2 33'. it cannot find such a thing, since that would mean looking for a number with a space in it... or am I wrong in that assumption?
Comments on between search broken
Forum Regular
Usergroup: Customer
Joined: Jun 22, 2005
Total Topics: 91
Total Comments: 305
Hi Paul,
After upgrading to 5.0.3, the between searches that worked a minute ago, didn't work. I don't have the debug info, but I remember that instead of seeing a single digit (the 'search' part of a between search), I now saw both the 'search' and the 'searchmax' numbers in the DB query. So technically it was search a single field in the DB for 2 numbers.
I had to revert to 5.0.2, so I couldn't spend time on getting the debug info, but please test this on your WSN.
Thanks
David
Forum Regular
Usergroup: Customer
Joined: Jun 22, 2005
Total Topics: 91
Total Comments: 305
I think I figured out the problem. I had one of the searchmax fields mistyped, and it threw the search into a frenzy.
Forum Regular
Usergroup: Customer
Joined: Jun 22, 2005
Total Topics: 91
Total Comments: 305
An error occoured at c-ccc.com/search.php?action...r&filled=1&whichtype=links on 2008-09-05 21:57:53. 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:
An error occoured at cccc.com/search.php?action=...r&filled=1&whichtype=links on 2008-09-05 21:57:53. 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:
That was the original error, and now I just got it again. Still figuring out why exactly...
Forum Regular
Usergroup: Customer
Joined: Jun 22, 2005
Total Topics: 91
Total Comments: 305
the above error comes up when using both a min. and max. number to search between. if you just enter only a min. or a max. then everything is fine.
Forum Regular
Usergroup: Customer
Joined: Jun 22, 2005
Total Topics: 91
Total Comments: 305
Here is a debug info:
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Probably a template issue, tested between searches in the default template and they work, changed to
<br />and the number of comments
<select name="numcommentscondition">
<option value="between">is between</option>
</select>
<input type="text" name="numcommentssearch" size="5" /> and <input type="text" name="numcommentssearchmax" size="5" />
and it still works.
Forum Regular
Usergroup: Customer
Joined: Jun 22, 2005
Total Topics: 91
Total Comments: 305
This is all I have in a template, with no wrappers of any kind:
and produces this:
I remember that WSN 4.x produced a between search query with a single number (the value of the '...search' field from the form, and not something like this:
See how it was searching for a number in the 'ar' link field, that has a value of '2 33'. it cannot find such a thing, since that would mean looking for a number with a space in it... or am I wrong in that assumption?
Thanks
David
Forum Regular
Usergroup: Customer
Joined: Jun 22, 2005
Total Topics: 91
Total Comments: 305
DAMN! I put "arsearchcondition" instead of "arcondition"....
My bad.