Webmastersite.net
Register Log In

Errors in Advanced Search

Comments on Errors in Advanced Search

webac01
Member

Usergroup: Customer
Joined: Feb 08, 2007
Location: France

Total Topics: 20
Total Comments: 40
webac01
Posted Sep 28, 2008 - 6:11 AM:

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
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Sep 29, 2008 - 4:34 AM:

Fixed.
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



Sorry, you don't have permission to post posts. Log in, or register if you haven't yet.