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 %')))
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.
Comments on wsnlinks forum search error
Forum Regular
Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA
Total Topics: 94
Total Comments: 339
While researching the category alias problem tried a quick search on this site and got the following errors.
Forum Regular
Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA
Total Topics: 94
Total Comments: 339
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.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Use the regular search instead of the category-only search for a couple of days.