Detail View & Print Errors: WSN Support

Quick Links open

New Posts Member List

WSN Support » WSN Knowledge Base » Detail View & Print Errors » Detail View & Print Errors

Detail View & Print Errors
mysqli.php on article view and blank page on print

Version: 4.1.17
Example URL: http://www.pikecountyillinoishistory.com/comments.php?id=1

Detail View & Print Errors

AutumnWindz
Member

Usergroup: Customer
Joined: Oct 01, 2004
Total Topics: 9
Total Posts: 30

Posted 01/13/08 - 08:01 AM:	#1
A 100% clean install - everything other than the cgi-bin was deleted from the server before installing a test version. With just the detail page and with the 'combine detail and comments page' on, the following is produced: Load time so far: 0.1 seconds. Query 2: SELECT `name`,`value` FROM wsnkb_switches WHERE id>0 Number of rows is 94 Load time so far: 0.11 seconds. Query 3: SELECT `id`,`type`,`original`,`replacement`,`description`,`original close`,`replacementclose`,`sortorder` FROM wsnkb_markup WHERE type='wsncode' ORDER BY sortorder Number of rows is 26 Load time so far: 0.12 seconds. Query 4: SELECT `id`,`title`,`caneditown`,`caneditall`,`canvote`,`isadmin`,` canpost`,`canemail`,`validatecats`,`validatecomments`,`valid atelinks`,`validateedits`,`cansubmitlinks`,`cansubmitcategor ies`,`cansubmitcomments`,`caneditownlinks`,`caneditowncatego ries`,`caneditowncomments`,`caneditownprofile`,`caneditallli nks`,`caneditallcategories`,`caneditallcomments`,`caneditall profiles`,`candownloadfiles`,`canupload`,`canviewip`,`limitl inks`,`canemailmembers`,`canusehtml`,`limitlinksdaily`,`cana lias`,`cancopy`,`candeleteown`,`candeleteall`,`candofulledit `,`candeletecategories`,`candeletecomments`,`candeleteowncat egories`,`candeleteowncomments`,`candeletemembers`,`candelet eownmembers`,`canaliascategories`,`canviewpages`,`caneditvot es`,`numaliases`,`canviewvotes`,`canhideownlinks`,`canhideow ncategories`,`canhideowncomments`,`canhidealllinks`,`canhide allcategories`,`canhideallcomments`,`canratecomments`,`bytes permem`,`canpm`,`canim`,`canharddelete`,`limitpms`,`limitpms daily`,`canviewdeleted`,`cansubmitpolls`,`candeletepolls`,`c andeleteownpolls`,`caneditpolls`,`caneditownpolls`,`attachpe rpost`,`attachperpm`,`canviewshouts`,`caneditshouts`,`canedi townshouts`,`candeleteshouts`,`candeleteownshouts`,`cansubmi tshouts`,`canpollvote`,`customtitle`,`canviewinvisible`,`nam estyle`,`canpmimportant`,`canviewmodlog`,`isleader`,`cansubm itquotes`,`validatequotes`,`candeletequotes`,`candeleteownqu otes`,`canreport`,`canusesearch`,`attachperlink`,`validateat tachments`,`caneditownquotes`,`caneditallquotes`,`canviewcha t`,`caneditownevents`,`caneditallevents`,`candeleteownevents `,`candeleteevents`,`cansubmitevents`,`validateevents`,`bulk pms`,`issupermod`,`numinv`,`allowugspec`,`validateemails`,`v alidatesponsorlinks`,`cansubmittags`,`candeletetags`,`cansub mitfeeds`,`validatefeeds`,`validatefeeditems`,`numaliasestot `,`shoutsperday`,`validatetrader`,`renewdays`,`renewtimes`,` canviewownfulltrc`,`canviewallfulltrc` FROM wsnkb_membergroups WHERE id>0 Load time so far: 0.13 seconds. Query 5: SELECT `id`,`name`,`comments`,`time`,`usergroup`,`password`,`ip`,`t otalhits`,`totalhitsin`,`email`,`validated`,`template`,`lang uage`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`s tylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`tota lbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rati ng`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,` banned`,`location`,`homepage`,`occupation`,`bio`,`aim`,`icq` ,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`buddies`, `ignored`,`isonline`,`acceptims`,`adminpermissions`,`referre r`,`groupreverttime`,`grouprevertto`,`moderationpm`,`seconda rygroups`,`linksperpage`,`commentsperpage`,`shouts`,`customt itle`,`shoutban`,`topicbans`,`forumbans`,`visibility`,`birth date`,`lastsession`,`interests`,`posteditor`,`forumaccess`,` pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,`lastmodn ote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote`,`autosu bscribe`,`notifymethod`,`showavatars`,`showsigs`,`warninglev el`,`articles`,`chatcolor`,`traderrating`,`invitessent`,`val idatedemail`,`newemail`,`calsub`,`macros`,`autosubscribepost `,`blogrss`,`positivepct`,`links`,`topics`,`posts`,`guestnot ify`,`keychecktime`,`notifykeywords`,`notifytrader` FROM wsnkb_members WHERE id='1' AND validated=1 Load time so far: 0.15 seconds. Query 6: SELECT `original`,`replacement`,`description`,`id`,`sortorder` FROM wsnkb_markup WHERE type='smilie' ORDER BY sortorder Number of rows is 14 Load time so far: 0.17 seconds. Query 7: SELECT `id`,`title`,`description`,`rating`,`votes`,`validated`,`cat id`,`sumofvotes`,`email`,`time`,`hits`,`numcomments`,`hide`, `ownerid`,`voterips`,`voterids`,`lastedit`,`type`,`notify`,` suspect`,`pendingedit`,`funds`,`suspended`,`alias`,`expire`, `ip`,`inalbum`,`typeorder`,`hitsin`,`hitsinips`,`hitsoutips` ,`lastcomment`,`related`,`inhidden`,`viewers`,`threadviewers `,`hitsintemp`,`hitsouttemp`,`origtype`,`importance`,`parent ids`,`timesdead`,`timesemailed`,`threadclosed`,`threadposter s`,`lastposterid`,`lastpostername`,`ownername`,`deleted`,`de letionreason`,`movedto`,`deletedby`,`timevalidated`,`filefie ld`,`savedby`,`text`,`priority`,`disablehtml`,`disablewsn`,` disableline`,`pollid`,`validatedemail`,`unpaid`,`effectiveti me`,`sugcatid`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`f eedcache`,`feedcachetime`,`sticky`,`downloads`,`posticon`,`r ecipverified`,`pagerank`,`tags`,`xmlsource`,`ordercomments`, `lastpadupdate`,`padfile`,`lastmonthlycheck`,`invisibleto`,` profileurl`,`lastprofileurl`,`timesrenewed`,`timedeleted` FROM wsnkb_links WHERE id=1 Load time so far: 0.19 seconds. Query 8: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`paren tnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom `,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`t ype`,`permissions`,`subscribers`,`subscriber`,`mixtypes`,`is album`,`orderlinks`,`totalcomments`,`ulsearchmax`,`ulsearchq uery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`sponsorl inks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`r eqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpo stername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle` ,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actas link`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,` numonline`,`lastprofileurl`,`defaultnoaccess`,`dmozpath`,`sp onsorship`,`lastthreadurl`,`lastposturl` FROM wsnkb_categories WHERE id=1 Query 9: LOCK TABLES wsnkb_email WRITE, wsnkb_links WRITE, wsnkb_categories WRITE, wsnkb_members WRITE Load time so far: 0.19 seconds. Query 10: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM wsnkb_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10 Number of rows is 0 Query 11: UNLOCK TABLES Load time so far: 0.2 seconds. Query 12: SELECT `id`,`name`,`comments`,`time`,`usergroup`,`password`,`ip`,`t otalhits`,`totalhitsin`,`email`,`validated`,`template`,`lang uage`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`s tylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`tota lbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rati ng`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,` banned`,`location`,`homepage`,`occupation`,`bio`,`aim`,`icq` ,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`buddies`, `ignored`,`isonline`,`acceptims`,`adminpermissions`,`referre r`,`groupreverttime`,`grouprevertto`,`moderationpm`,`seconda rygroups`,`linksperpage`,`commentsperpage`,`shouts`,`customt itle`,`shoutban`,`topicbans`,`forumbans`,`visibility`,`birth date`,`lastsession`,`interests`,`posteditor`,`forumaccess`,` pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,`lastmodn ote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote`,`autosu bscribe`,`notifymethod`,`showavatars`,`showsigs`,`warninglev el`,`articles`,`chatcolor`,`traderrating`,`invitessent`,`val idatedemail`,`newemail`,`calsub`,`macros`,`autosubscribepost `,`blogrss`,`positivepct`,`links`,`topics`,`posts`,`guestnot ify`,`keychecktime`,`notifykeywords`,`notifytrader` FROM wsnkb_members WHERE id=1 Number of rows is 1 Setting cookie with name returnto, value http://www.pikecountyillinoishistory.com/comments... and expiration time 0 Setting cookie with name commentsread, value and expiration time 2401477031 Load time so far: 0.23 seconds. Query 13: SELECT COUNT(id) FROM wsnkb_comments WHERE linkid=1 AND validated=1 AND hide=0 AND internalto=0 AND deleted=1 Count is 0 Load time so far: 0.23 seconds. Query 14: SELECT `time` FROM wsnkb_comments WHERE linkid=1 AND validated=1 AND hide=0 AND internalto=0 AND deleted=0 ORDER BY time ASC LIMIT 0,1 Load time so far: 0.23 seconds. Query 15: SELECT COUNT(id) FROM wsnkb_comments WHERE linkid=1 AND validated=1 AND hide=0 AND internalto=0 AND deleted=1 Count is 0 Load time so far: 0.23 seconds. Query 16: SELECT COUNT(id) FROM wsnkb_comments WHERE linkid=1 AND validated=1 AND hide=0 AND internalto=0 AND deleted=0 Count is 0 Load time so far: 0.23 seconds. Query 17: SELECT `deleted` FROM wsnkb_comments WHERE linkid=1 AND validated=1 AND hide=0 AND internalto=0 ORDER BY time DESC LIMIT 0,1 Load time so far: 0.23 seconds. Query 18: SELECT `id`,`linkid`,`postername`,`message`,`time`,`linkname`,`vali dated`,`ip`,`ownerid`,`lastedit`,`type`,`approved`,`votes`,` hide`,`typeorder`,`lasteditby`,`catid`,`editreason`,`prevent edit`,`inhidden`,`deleted`,`deletionreason`,`usernoteon`,`mo dnote`,`filefield`,`title`,`deletedby`,`parentids`,`disables milies`,`disablesig`,`icon`,`disablewsn`,`disablehtml`,`orig inalmessage`,`flagged`,`posterid`,`wysihtml`,`unrevised`,`in ternalto`,`hasinternal`,`invisibleto`,`hostname` FROM wsnkb_comments WHERE linkid=1 AND validated=1 AND hide=0 AND internalto=0 ORDER BY time ASC LIMIT 0,14 Number of rows is 0 Freeing result. Load time so far: 0.23 seconds. Query 19: SELECT `id`,`title`,`description`,`rating`,`votes`,`validated`,`cat id`,`sumofvotes`,`email`,`time`,`hits`,`numcomments`,`hide`, `ownerid`,`voterips`,`voterids`,`lastedit`,`type`,`notify`,` suspect`,`pendingedit`,`funds`,`suspended`,`alias`,`expire`, `ip`,`inalbum`,`typeorder`,`hitsin`,`hitsinips`,`hitsoutips` ,`lastcomment`,`related`,`inhidden`,`viewers`,`threadviewers `,`hitsintemp`,`hitsouttemp`,`origtype`,`importance`,`parent ids`,`timesdead`,`timesemailed`,`threadclosed`,`threadposter s`,`lastposterid`,`lastpostername`,`ownername`,`deleted`,`de letionreason`,`movedto`,`deletedby`,`timevalidated`,`filefie ld`,`savedby`,`text`,`priority`,`disablehtml`,`disablewsn`,` disableline`,`pollid`,`validatedemail`,`unpaid`,`effectiveti me`,`sugcatid`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`f eedcache`,`feedcachetime`,`sticky`,`downloads`,`posticon`,`r ecipverified`,`pagerank`,`tags`,`xmlsource`,`ordercomments`, `lastpadupdate`,`padfile`,`lastmonthlycheck`,`invisibleto`,` profileurl`,`lastprofileurl`,`timesrenewed`,`timedeleted` FROM wsnkb_links WHERE deleted=0 AND validated=1 AND alias=0 AND inalbum=0 AND inhidden=0 AND hide=0 AND MATCH (title) AGAINST('Testing') and id != 1 LIMIT 0, Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/pikecoun/public_html/databases/mysqli.php on line 20 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 Warning: mysql_get_server_info() [function.mysql-get-server-info]: Access denied for user 'nobody'@'localhost' (using password: NO) in /home/pikecoun/public_html/classes/onelink.php on line 1930 Warning: mysql_get_server_info() [function.mysql-get-server-info]: A link to the server could not be established in /home/pikecoun/public_html/classes/onelink.php on line 1930 Load time so far: 0.24 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 20: SELECT COUNT(id) FROM wsnkb_links WHERE deleted=0 AND validated=1 AND inalbum=0 AND inhidden=0 AND alias=0 AND hide=0 AND MATCH (title) AGAINST('Testing') and id != 1 Count is Load time so far: 0.24 seconds. Query 21: SELECT COUNT(id) FROM wsnkb_ratings WHERE memberid=1 AND linkid=1 AND custom='' Count is 0 Load time so far: 0.24 seconds. Query 22: SELECT `id`,`name`,`comments`,`time`,`usergroup`,`password`,`ip`,`t otalhits`,`totalhitsin`,`email`,`validated`,`template`,`lang uage`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`s tylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`tota lbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rati ng`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,` banned`,`location`,`homepage`,`occupation`,`bio`,`aim`,`icq` ,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`buddies`, `ignored`,`isonline`,`acceptims`,`adminpermissions`,`referre r`,`groupreverttime`,`grouprevertto`,`moderationpm`,`seconda rygroups`,`linksperpage`,`commentsperpage`,`shouts`,`customt itle`,`shoutban`,`topicbans`,`forumbans`,`visibility`,`birth date`,`lastsession`,`interests`,`posteditor`,`forumaccess`,` pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,`lastmodn ote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote`,`autosu bscribe`,`notifymethod`,`showavatars`,`showsigs`,`warninglev el`,`articles`,`chatcolor`,`traderrating`,`invitessent`,`val idatedemail`,`newemail`,`calsub`,`macros`,`autosubscribepost `,`blogrss`,`positivepct`,`links`,`topics`,`posts`,`guestnot ify`,`keychecktime`,`notifykeywords`,`notifytrader` FROM wsnkb_members WHERE id='1' Number of rows is 1 Load time so far: 0.27 seconds. Query 23: SELECT `id` FROM wsnkb_links WHERE catid=1 AND validated=1 AND hide=0 AND deleted=0 ORDER BY time DESC Number of rows is 1 Load time so far: 0.34 seconds. Query 24: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime` ,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,` inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`accept ims`,`visibility`,`profileurl` FROM wsnkb_sessions WHERE time > 1200237616 AND (threadid=1 AND memberid>0) ORDER BY time DESC LIMIT 0,100 Number of rows is 0 Load time so far: 0.47 seconds. Query 25: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime` ,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,` inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`accept ims`,`visibility`,`profileurl` FROM wsnkb_sessions WHERE memberid=1 Number of rows is 1 Load time so far: 0.47 seconds. Query 26: UPDATE wsnkb_sessions SET starttime='1200182637', time='1200238516', location='http://www.pikecountyillinoishistory.com/comments.php?id=1', catid='1', threadid='1', areaname='Comments on Testing', nopermission='0', inchat='0', ip='76.0.47.38' WHERE id=2 ________________________________________ Next item, when you click on 'print' a blank page is produced with the following: Load time so far: 0.09 seconds. Query 2: SELECT `name`,`value` FROM wsnkb_switches WHERE id>0 Number of rows is 94 Load time so far: 0.1 seconds. Query 3: SELECT `id`,`type`,`original`,`replacement`,`description`,`original close`,`replacementclose`,`sortorder` FROM wsnkb_markup WHERE type='wsncode' ORDER BY sortorder Number of rows is 26 Load time so far: 0.1 seconds. Query 4: SELECT `id`,`title`,`caneditown`,`caneditall`,`canvote`,`isadmin`,` canpost`,`canemail`,`validatecats`,`validatecomments`,`valid atelinks`,`validateedits`,`cansubmitlinks`,`cansubmitcategor ies`,`cansubmitcomments`,`caneditownlinks`,`caneditowncatego ries`,`caneditowncomments`,`caneditownprofile`,`caneditallli nks`,`caneditallcategories`,`caneditallcomments`,`caneditall profiles`,`candownloadfiles`,`canupload`,`canviewip`,`limitl inks`,`canemailmembers`,`canusehtml`,`limitlinksdaily`,`cana lias`,`cancopy`,`candeleteown`,`candeleteall`,`candofulledit `,`candeletecategories`,`candeletecomments`,`candeleteowncat egories`,`candeleteowncomments`,`candeletemembers`,`candelet eownmembers`,`canaliascategories`,`canviewpages`,`caneditvot es`,`numaliases`,`canviewvotes`,`canhideownlinks`,`canhideow ncategories`,`canhideowncomments`,`canhidealllinks`,`canhide allcategories`,`canhideallcomments`,`canratecomments`,`bytes permem`,`canpm`,`canim`,`canharddelete`,`limitpms`,`limitpms daily`,`canviewdeleted`,`cansubmitpolls`,`candeletepolls`,`c andeleteownpolls`,`caneditpolls`,`caneditownpolls`,`attachpe rpost`,`attachperpm`,`canviewshouts`,`caneditshouts`,`canedi townshouts`,`candeleteshouts`,`candeleteownshouts`,`cansubmi tshouts`,`canpollvote`,`customtitle`,`canviewinvisible`,`nam estyle`,`canpmimportant`,`canviewmodlog`,`isleader`,`cansubm itquotes`,`validatequotes`,`candeletequotes`,`candeleteownqu otes`,`canreport`,`canusesearch`,`attachperlink`,`validateat tachments`,`caneditownquotes`,`caneditallquotes`,`canviewcha t`,`caneditownevents`,`caneditallevents`,`candeleteownevents `,`candeleteevents`,`cansubmitevents`,`validateevents`,`bulk pms`,`issupermod`,`numinv`,`allowugspec`,`validateemails`,`v alidatesponsorlinks`,`cansubmittags`,`candeletetags`,`cansub mitfeeds`,`validatefeeds`,`validatefeeditems`,`numaliasestot `,`shoutsperday`,`validatetrader`,`renewdays`,`renewtimes`,` canviewownfulltrc`,`canviewallfulltrc` FROM wsnkb_membergroups WHERE id>0 Load time so far: 0.12 seconds. Query 5: SELECT `id`,`name`,`comments`,`time`,`usergroup`,`password`,`ip`,`t otalhits`,`totalhitsin`,`email`,`validated`,`template`,`lang uage`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`s tylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`tota lbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rati ng`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,` banned`,`location`,`homepage`,`occupation`,`bio`,`aim`,`icq` ,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`buddies`, `ignored`,`isonline`,`acceptims`,`adminpermissions`,`referre r`,`groupreverttime`,`grouprevertto`,`moderationpm`,`seconda rygroups`,`linksperpage`,`commentsperpage`,`shouts`,`customt itle`,`shoutban`,`topicbans`,`forumbans`,`visibility`,`birth date`,`lastsession`,`interests`,`posteditor`,`forumaccess`,` pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,`lastmodn ote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote`,`autosu bscribe`,`notifymethod`,`showavatars`,`showsigs`,`warninglev el`,`articles`,`chatcolor`,`traderrating`,`invitessent`,`val idatedemail`,`newemail`,`calsub`,`macros`,`autosubscribepost `,`blogrss`,`positivepct`,`links`,`topics`,`posts`,`guestnot ify`,`keychecktime`,`notifykeywords`,`notifytrader` FROM wsnkb_members WHERE id='1' AND validated=1 Load time so far: 0.13 seconds. Query 6: SELECT `original`,`replacement`,`description`,`id`,`sortorder` FROM wsnkb_markup WHERE type='smilie' ORDER BY sortorder Number of rows is 14 Query 7: LOCK TABLES wsnkb_email WRITE, wsnkb_links WRITE, wsnkb_categories WRITE, wsnkb_members WRITE Load time so far: 0.14 seconds. Query 8: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM wsnkb_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10 Number of rows is 0 Query 9: UNLOCK TABLES Load time so far: 0.14 seconds. Query 10: SELECT `id` FROM wsnkb_links WHERE id=1 Load time so far: 0.16 seconds. Query 11: SELECT `id`,`title`,`description`,`rating`,`votes`,`validated`,`cat id`,`sumofvotes`,`email`,`time`,`hits`,`numcomments`,`hide`, `ownerid`,`voterips`,`voterids`,`lastedit`,`type`,`notify`,` suspect`,`pendingedit`,`funds`,`suspended`,`alias`,`expire`, `ip`,`inalbum`,`typeorder`,`hitsin`,`hitsinips`,`hitsoutips` ,`lastcomment`,`related`,`inhidden`,`viewers`,`threadviewers `,`hitsintemp`,`hitsouttemp`,`origtype`,`importance`,`parent ids`,`timesdead`,`timesemailed`,`threadclosed`,`threadposter s`,`lastposterid`,`lastpostername`,`ownername`,`deleted`,`de letionreason`,`movedto`,`deletedby`,`timevalidated`,`filefie ld`,`savedby`,`text`,`priority`,`disablehtml`,`disablewsn`,` disableline`,`pollid`,`validatedemail`,`unpaid`,`effectiveti me`,`sugcatid`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`f eedcache`,`feedcachetime`,`sticky`,`downloads`,`posticon`,`r ecipverified`,`pagerank`,`tags`,`xmlsource`,`ordercomments`, `lastpadupdate`,`padfile`,`lastmonthlycheck`,`invisibleto`,` profileurl`,`lastprofileurl`,`timesrenewed`,`timedeleted` FROM wsnkb_links WHERE id=1 Load time so far: 0.18 seconds. Query 12: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`paren tnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom `,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`t ype`,`permissions`,`subscribers`,`subscriber`,`mixtypes`,`is album`,`orderlinks`,`totalcomments`,`ulsearchmax`,`ulsearchq uery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`sponsorl inks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`r eqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpo stername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle` ,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actas link`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,` numonline`,`lastprofileurl`,`defaultnoaccess`,`dmozpath`,`sp onsorship`,`lastthreadurl`,`lastposturl` FROM wsnkb_categories WHERE id=1 Load time so far: 0.18 seconds. Query 13: SELECT `id` FROM wsnkb_links WHERE catid=1 AND validated=1 AND hide=0 Number of rows is 1 Load time so far: 0.18 seconds. Query 14: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`paren tnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom `,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`t ype`,`permissions`,`subscribers`,`subscriber`,`mixtypes`,`is album`,`orderlinks`,`totalcomments`,`ulsearchmax`,`ulsearchq uery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`sponsorl inks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`r eqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpo stername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle` ,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actas link`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,` numonline`,`lastprofileurl`,`defaultnoaccess`,`dmozpath`,`sp onsorship`,`lastthreadurl`,`lastposturl` FROM wsnkb_categories WHERE id=1 Load time so far: 0.19 seconds. Query 15: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`paren tnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom `,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`t ype`,`permissions`,`subscribers`,`subscriber`,`mixtypes`,`is album`,`orderlinks`,`totalcomments`,`ulsearchmax`,`ulsearchq uery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`sponsorl inks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`r eqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpo stername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle` ,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actas link`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,` numonline`,`lastprofileurl`,`defaultnoaccess`,`dmozpath`,`sp onsorship`,`lastthreadurl`,`lastposturl` FROM wsnkb_categories WHERE id=1 Load time so far: 0.2 seconds. Query 16: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime` ,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,` inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`accept ims`,`visibility`,`profileurl` FROM wsnkb_sessions WHERE memberid=1 Number of rows is 1 Load time so far: 0.2 seconds. Query 17: UPDATE wsnkb_sessions SET starttime='1200182637', time='1200239273', location='http://www.pikecountyillinoishistory.com/print.php?id=1', catid='1', threadid='1', areaname=': Testing', nopermission='0', inchat='0', ip='76.0.47.38' WHERE id=2 17 total queries This page was created in 0.2 seconds Memory used: 5188824 bytes Server Status: time since last reboot is 10 days, 12:06, load average: 1.30, 1.75, 1.44

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 49
Total Posts: 5516

Posted 01/13/08 - 03:25 PM:	#2
The mysql warning must be a member-only thing, since I see no error as a guest there. I don't get one setting up my own KB either (did combine detail/comments as mentioned). The problem is the number of similar articles it's trying to fetch being blank. What do you see at Admin Panel -> Settings -> Articles? It should say 5: http://www.webmastersite.net/screenshots/13469.jp... . Fixed printing for the release which will come out in a couple hours. Edited by Paul on 01/13/08 - 04:00 PM

AutumnWindz
Member

Usergroup: Customer
Joined: Oct 01, 2004
Total Topics: 9
Total Posts: 30

Posted 01/13/08 - 04:44 PM:	#3
I received the same error both as a guest and as a member when viewing the article page. I had the Admin Panel -> Settings -> Articles -> Similar Articles blank. Since I did not want to show similar articles I simply removed the 5 from the option. By putting the 5 back in, the error went away. I looked at the error message from my post again and I still do not see where it gives me a clue that the 'Similar Articles' setting was the cause of the error. Obviously it was, since putting a number back in the field corrected the error. What am I missing? I do really try to figure these problems out on my own before coming to you since many errors are caused by something we as users do to customize it to suit our sites. Thank you for your time, Barbara

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 49
Total Posts: 5516

Posted 01/14/08 - 01:28 PM:	#4
Since I did not want to show similar articles Go to Admin Panel -> Settings -> Switches and uncheck the 'show similar articles' box there in the articles section. I looked at the error message from my post again and I still do not see where it gives me a clue that the 'Similar Articles' setting was the cause of the error. It's not easy to recongize without knowing PHP and SQL and the script, so I wouldn't expect a user to figure it out on their own, but it's the query right above the error that tells me: Query 19: SELECT `id`,`title`,`description`,`rating`,`votes`,`validated`,`cat id`,`sumofvotes`,`email`,`time`,`hits`,`numcomments`,`hide`, `ownerid`,`voterips`,`voterids`,`lastedit`,`type`,`notify`,` suspect`,`pendingedit`,`funds`,`suspended`,`alias`,`expire`, `ip`,`inalbum`,`typeorder`,`hitsin`,`hitsinips`,`hitsoutips` ,`lastcomment`,`related`,`inhidden`,`viewers`,`threadviewers `,`hitsintemp`,`hitsouttemp`,`origtype`,`importance`,`parent ids`,`timesdead`,`timesemailed`,`threadclosed`,`threadposter s`,`lastposterid`,`lastpostername`,`ownername`,`deleted`,`de letionreason`,`movedto`,`deletedby`,`timevalidated`,`filefie ld`,`savedby`,`text`,`priority`,`disablehtml`,`disablewsn`,` disableline`,`pollid`,`validatedemail`,`unpaid`,`effectiveti me`,`sugcatid`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`f eedcache`,`feedcachetime`,`sticky`,`downloads`,`posticon`,`r ecipverified`,`pagerank`,`tags`,`xmlsource`,`ordercomments`, `lastpadupdate`,`padfile`,`lastmonthlycheck`,`invisibleto`,` profileurl`,`lastprofileurl`,`timesrenewed`,`timedeleted` FROM wsnkb_links WHERE deleted=0 AND validated=1 AND alias=0 AND inalbum=0 AND inhidden=0 AND hide=0 AND MATCH (title) AGAINST('Testing') and id != 1 LIMIT 0, Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/pikecoun/public_html/databases/mysqli.php on line 20 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 The "LIMIT 0," is improper SQL syntax, since there's supposed to be another number after the comma specifying how many records to grab, and I recognized the rest of the query as being one checking for similar articles. I'll add a check to reset the number to 0 when someone tries to make that setting blank. Odd I couldn't find the error on your site since it logically should've been there even as a guest, but I'll chalk that up to going blind. I do really try to figure these problems out on my own before coming to you since many errors are caused by something we as users do to customize it to suit our sites. It's helpful for me to learn how people misconfigure things so I can anticipate and prevent future users doing the same, as by preventing blanks for the setting here. Sometimes it'll be natural for most people to try doing something trouble-causing that I'd never imagine trying because I already know how it works. And with the lack of inquiries I typically get on KB I worry sometimes that no one is using it, so it's nice to see a copy installed. Edited by Paul on 01/14/08 - 01:46 PM

AutumnWindz
Member

Usergroup: Customer
Joined: Oct 01, 2004
Total Topics: 9
Total Posts: 30

Posted 01/14/08 - 02:34 PM:	#5
Thank you for getting back to me. As with the first site that I use wsnkb on, another site I plan to use wsnkb on will be highly customized, hence the test site that I am using the latest version on. Once I get it working properly and a real website up and running for others in my group to see, there may be many others in my little world that will want to use it with my customizations. It just takes a lot of time to customize to our groups specific needs with custom fields and article types. Once I get the first custom article type working correctly, the rest should be fairly easy. In the meantime I am sure I will be back with many more questions. Barbara

You don't have permission to post.

Please login or register.