Webmastersite.net
Register Log In

wsnlinks forum search error

Comments on wsnlinks forum search error

hai
Forum Regular

Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA

Total Topics: 94
Total Comments: 339
hai
Posted Oct 24, 2008 - 6:54 AM:

While researching the category alias problem tried a quick search on this site and got the following errors.


An error occoured at www.webmastersite.net/forum...php?filled=1&condition=and on 2008-10-24 13:48:13. 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/forums/databases/mysqli.php on line 45. Debug info:
filetitle`,`suspect`,`downloads`,`funds`,`hitsin`,`hitsinips`,`timesdead`,`deletionreason`,`status`,`movedto`,`pollid`,`deletedby`,`posticon`,`timevalidated`,`savedby`,`filefield`,`validatedemail`,`unpaid`,`effectivetime`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`feedcache`,`feedcachetime`,`sversion`,`sugcatid`,`tags`,`xmlsource`,`ordercomments`,`lastpadupdate`,`invisibleto`,`profileurl`,`lastprofileurl`,`timesrenewed`,`timedeleted`,`sponsorend`,`url`,`recipurl`,`recipwith`,`recipverified`,`pagerank`,`padfile`,`lastmonthlycheck`,`address`,`city`,`state`,`country`,`latitude`,`zip`,`longtude`,`longitude`,`phone`,`summary` FROM wsnforum_links WHERE (validated=1 AND invisibleto NOT LIKE '%|5|%' AND hide=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1224856093) AND ((title LIKE '% category %' AND title LIKE '% alias %') OR (description LIKE '% category %' AND description LIKE '% alias %') OR (message LIKE '% category %' AND message LIKE '% alias %') OR (title LIKE '% category %' AND allfields LIKE '% alias %' OR description LIKE '% category %' AND allfields LIKE '% alias %' OR message LIKE '% category %' AND allfields LIKE '% alias %'))) ORDER BY lastcomment DESC LIMIT 0,45

Load time so far: 1.46 seconds.


Unknown column 'allfields' in 'where clause'

Load time so far: 1.46 seconds.


Unknown column 'allfields' in 'where clause'

Query 12: SELECT COUNT(id) FROM wsnforum_links WHERE (validated=1 AND invisibleto NOT LIKE '%|5|%' AND hide=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1224856093) AND ((title LIKE '% category %' AND title LIKE '% alias %') OR (description LIKE '% category %' AND description LIKE '% alias %') OR (message LIKE '% category %' AND message LIKE '% alias %') OR (title LIKE '% category %' AND allfields LIKE '% alias %' OR description LIKE '% category %' AND allfields LIKE '% alias %' OR message LIKE '% category %' AND allfields LIKE '% alias %')))

An error occoured at www.webmastersite.net/forum...php?filled=1&condition=and on 2008-10-24 13:48:13. 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/forums/databases/mysqli.php on line 42. Debug info:
ect`,`downloads`,`funds`,`hitsin`,`hitsinips`,`timesdead`,`deletionreason`,`status`,`movedto`,`pollid`,`deletedby`,`posticon`,`timevalidated`,`savedby`,`filefield`,`validatedemail`,`unpaid`,`effectivetime`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`feedcache`,`feedcachetime`,`sversion`,`sugcatid`,`tags`,`xmlsource`,`ordercomments`,`lastpadupdate`,`invisibleto`,`profileurl`,`lastprofileurl`,`timesrenewed`,`timedeleted`,`sponsorend`,`url`,`recipurl`,`recipwith`,`recipverified`,`pagerank`,`padfile`,`lastmonthlycheck`,`address`,`city`,`state`,`country`,`latitude`,`zip`,`longtude`,`longitude`,`phone`,`summary` FROM wsnforum_links WHERE (validated=1 AND invisibleto NOT LIKE '%|5|%' AND hide=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1224856093) AND ((title LIKE '% category %' AND title LIKE '% alias %') OR (description LIKE '% category %' AND description LIKE '% alias %') OR (message LIKE '% category %' AND message LIKE '% alias %') OR (title LIKE '% category %' AND allfields LIKE '% alias %' OR description LIKE '% category %' AND allfields LIKE '% alias %' OR message LIKE '% category %' AND allfields LIKE '% alias %'))) ORDER BY lastcomment DESC LIMIT 0,45

Load time so far: 1.46 seconds.


Unknown column 'allfields' in 'where clause'

Load time so far: 1.46 seconds.


Unknown column 'allfields' in 'where clause'

Query 12: SELECT COUNT(id) FROM wsnforum_links WHERE (validated=1 AND invisibleto NOT LIKE '%|5|%' AND hide=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1224856093) AND ((title LIKE '% category %' AND title LIKE '% alias %') OR (description LIKE '% category %' AND description LIKE '% alias %') OR (message LIKE '% category %' AND message LIKE '% alias %') OR (title LIKE '% category %' AND allfields LIKE '% alias %' OR description LIKE '% category %' AND allfields LIKE '% alias %' OR message LIKE '% category %' AND allfields LIKE '% alias %')))

Count is
hai
Forum Regular

Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA

Total Topics: 94
Total Comments: 339
hai
Posted Oct 24, 2008 - 6:57 AM:

Sorry Paul, I know I posted this to the wsnlinks forum. It did give me a 404 upon my first submit didn't realize I was in the Pre-Sales forum when I refreshed the page and re-submitted.
Paul
developer

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

Total Topics: 61
Total Comments: 7868
Paul
Posted Oct 25, 2008 - 6:15 AM:

Use the regular search instead of the category-only search for a couple of days.
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.