Message Text |
When I try to make an "advanced search" I have this errors
(I tried with this options for example: "Find links where" "and the rating" "is greater than" "10")
An error occoured at links.website.net/search.ph...r&filled=1&whichtype=links on 2008-09-28 10:46:38. Please relay this data to support. Error #2: 'mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given' in /home/wmaster/public_html/links/databases/mysqli.php on line 45. Debug info:
tid`,`sumofvotes`,`email`,`time`,`hits`,`numcomments`,`hide`,`ownerid`,`hitsin`,`voterips`,`voterids`,`lastedit`,`type`,`filename`,`filetitle`,`notify`,`suspect`,`downloads`,`pendingedit`,`funds`,`suspended`,`recipwith`,`alias`,`expire`,`ip`,`inalbum`,`typeorder`,`hitsinips`,`hitsoutips`,`lastcomment`,`related`,`inhidden`,`viewers`,`threadviewers`,`hitsintemp`,`hitsouttemp`,`origtype`,`importance`,`parentids`,`timesdead`,`timesemailed`,`threadclosed`,`threadposters`,`xwidth`,`yheight`,`lastposterid`,`lastpostername`,`sticky`,`ownername`,`deleted`,`deletionreason`,`movedto`,`pollid`,`deletedby`,`posticon`,`timevalidated`,`filefield`,`message`,`savedby`,`fundssponsor1`,`fundssponsor3`,`validatedemail`,`unpaid`,`recipverified`,`effectivetime`,`sugcatid`,`pagerank`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`feedcache`,`feedcachetime`,`tags`,`xmlsource`,`ordercomments`,`lastpadupdate`,`padfile`,`lastmonthlycheck`,`invisibleto`,`profileurl`,`lastprofileurl`,`timesrenewed`,`timedeleted`,`sponsorend`,`address`,`city`,`state`,`country`,`latitude`,`longtude`,`zip`,`longitude`,`phone` FROM wsnlinks_links WHERE (validated=1 AND invisibleto NOT LIKE '%|1|%' AND hide=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1222598798) AND (rating > 10)) AND (type != 'sponsor') ORDER BY typeorder ASC,rating DESC LIMIT 0,42
Load time so far: 0.21 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 '' at line 1
Load time so far: 0.21 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 '' at line 1
Query 9: SELECT COUNT(id) FROM wsnlinks_links WHERE (validated=1 AND invisibleto NOT LIKE '%|1|%' AND hide=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1222598798) AND (rating > 10)) AND (type != 'sponsor')
An error occoured at links.website.net/search.ph...r&filled=1&whichtype=links on 2008-09-28 10:46:38. Please relay this data to support. Error #2: 'mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given' in /home/wmaster/public_html/links/databases/mysqli.php on line 42. Debug info:
`,`email`,`time`,`hits`,`numcomments`,`hide`,`ownerid`,`hitsin`,`voterips`,`voterids`,`lastedit`,`type`,`filename`,`filetitle`,`notify`,`suspect`,`downloads`,`pendingedit`,`funds`,`suspended`,`recipwith`,`alias`,`expire`,`ip`,`inalbum`,`typeorder`,`hitsinips`,`hitsoutips`,`lastcomment`,`related`,`inhidden`,`viewers`,`threadviewers`,`hitsintemp`,`hitsouttemp`,`origtype`,`importance`,`parentids`,`timesdead`,`timesemailed`,`threadclosed`,`threadposters`,`xwidth`,`yheight`,`lastposterid`,`lastpostername`,`sticky`,`ownername`,`deleted`,`deletionreason`,`movedto`,`pollid`,`deletedby`,`posticon`,`timevalidated`,`filefield`,`message`,`savedby`,`fundssponsor1`,`fundssponsor3`,`validatedemail`,`unpaid`,`recipverified`,`effectivetime`,`sugcatid`,`pagerank`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`feedcache`,`feedcachetime`,`tags`,`xmlsource`,`ordercomments`,`lastpadupdate`,`padfile`,`lastmonthlycheck`,`invisibleto`,`profileurl`,`lastprofileurl`,`timesrenewed`,`timedeleted`,`sponsorend`,`address`,`city`,`state`,`country`,`latitude`,`longtude`,`zip`,`longitude`,`phone` FROM wsnlinks_links WHERE (validated=1 AND invisibleto NOT LIKE '%|1|%' AND hide=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1222598798) AND (rating > 10)) AND (type != 'sponsor') ORDER BY typeorder ASC,rating DESC LIMIT 0,42
Load time so far: 0.21 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 '' at line 1
Load time so far: 0.21 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 '' at line 1
Query 9: SELECT COUNT(id) FROM wsnlinks_links WHERE (validated=1 AND invisibleto NOT LIKE '%|1|%' AND hide=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1222598798) AND (rating > 10)) AND (type != 'sponsor')
Count is
An error occoured at links.website.net/search.ph...r&filled=1&whichtype=links on 2008-09-28 10:46:38. Please relay this data to support. Error #2: 'mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given' in /home/wmaster/public_html/links/databases/mysqli.php on line 42. Debug info:
ated=1 AND invisibleto NOT LIKE '%|1|%' AND hide=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1222598798) AND (rating > 10)) AND (type != 'sponsor')
Count is
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 '' at line 1
Query 10: SELECT `id`,`title`,`url`,`description`,`rating`,`votes`,`validated`,`recipurl`,`catid`,`sumofvotes`,`email`,`time`,`hits`,`numcomments`,`hide`,`ownerid`,`hitsin`,`voterips`,`voterids`,`lastedit`,`type`,`filename`,`filetitle`,`notify`,`suspect`,`downloads`,`pendingedit`,`funds`,`suspended`,`recipwith`,`alias`,`expire`,`ip`,`inalbum`,`typeorder`,`hitsinips`,`hitsoutips`,`lastcomment`,`related`,`inhidden`,`viewers`,`threadviewers`,`hitsintemp`,`hitsouttemp`,`origtype`,`importance`,`parentids`,`timesdead`,`timesemailed`,`threadclosed`,`threadposters`,`xwidth`,`yheight`,`lastposterid`,`lastpostername`,`sticky`,`ownername`,`deleted`,`deletionreason`,`movedto`,`pollid`,`deletedby`,`posticon`,`timevalidated`,`filefield`,`message`,`savedby`,`fundssponsor1`,`fundssponsor3`,`validatedemail`,`unpaid`,`recipverified`,`effectivetime`,`sugcatid`,`pagerank`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`feedcache`,`feedcachetime`,`tags`,`xmlsource`,`ordercomments`,`lastpadupdate`,`padfile`,`lastmonthlycheck`,`invisibleto`,`profileurl`,`lastprofileurl`,`timesrenewed`,`timedeleted`,`sponsorend`,`address`,`city`,`state`,`country`,`latitude`,`longtude`,`zip`,`longitude`,`phone` FROM wsnlinks_links WHERE (validated=1 AND invisibleto NOT LIKE '%|1|%' AND hide=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1222598798) AND (rating > 10)) AND type = 'sponsor' ORDER BY rating DESC LIMIT 0,5
Load time so far: 0.22 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 '' at line 1 |