I believe this is because I'm using vBuleltin 3.5 integration. Shouldn't the field id be userid?
debug output:
Load time so far: 0.14 seconds. Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND isalbum=0 ORDER BY id DESC LIMIT 0,1;
Number of rows is 1 for Resource id #20
Load time so far: 0.16 seconds. Performing query: SELECT name,value FROM wsnlinks_switches WHERE id>0 ;
Number of rows is 58 for Resource id #37
Load time so far: 0.17 seconds. Performing query: SELECT id,type,original,replacement,description,originalclose,replacementclose,sortorder FROM wsnlinks_markup WHERE type='wsncode' ORDER BY sortorder ;
Number of rows is 22 for Resource id #39
Load time so far: 0.17 seconds. Performing query: SELECT original,replacement,description,id,sortorder FROM wsnlinks_markup WHERE type='smilie' ORDER BY sortorder ;
Number of rows is 14 for Resource id #40
Load time so far: 0.18 seconds. Performing query: SELECT id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecats,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcategories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncomments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomments,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canalias,cancopy,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem,canpm,canim,canharddelete,limitpms,limitpmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candeleteownpolls,caneditpolls,caneditownpolls,attachperpost,attachperpm,canviewshouts,caneditshouts,caneditownshouts,candeleteshouts,candeleteownshouts,cansubmitshouts,canpollvote,customtitle,canviewinvisible,namestyle,canpmimportant,canviewmodlog,isleader,cansubmitquotes,validatequotes,candeletequotes,candeleteownquotes,canreport,canusesearch,attachperlink,validateattachments,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,bulkpms,issupermod FROM wsnlinks_membergroups WHERE id>0 ;
Load time so far: 0.18 seconds. Performing query: SELECT userid,usergroupid,username,password,email,styleid,parentemail,homepage,icq,aim,yahoo,usertitle,customtitle,joindate,daysprune,lastvisit,lastactivity,lastpost,posts,timezoneoffset,pmpopup,avatarid,options,birthday,maxposts,startofweek,ipaddress,referrerid,sent,sentdate,award,miserable,pmtotal,pmunread,passworddate,salt,showvbcode,msn,avatarrevision,membergroupids,displaygroupid,reputation,reputationlevelid,languageid,threadedmode,emailstamp,autosubscribe,birthday_search,photos,warning_level,user_favs,user_cats,schools,arcade_ban,times_played,is_arcade_mod,fav_games,user_sort,user_order,user_g_pp,user_s_pp,def_g_cat,game_skin,arcade_mod_privs,warning_bans,warnings,links,reviews,classifieds,canhavejournal,importuserid,profilepicrevision,games_played,time_played,arcade_points,arcade_spent,arcade_won,arcade_high,showbirthday,inferno_warn_level,skype,arcade_pmactive,create_tourney,comments,totalhits,totalhitsin,validated,template,language,lastattempt,allowemail,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,timezone,rating,notifyofpms,acceptpms,cookieduration,banned,location,occupation,bio,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmnotify,modnotes,guestnotes,lastmodnote,newpms,imflag,orderalbums,lastguestnote,notifymethod,showavatars,showsigs,warninglevel,topics,chatcolor FROM user WHERE userid=1 AND validated=1 ;
Load time so far: 0.2 seconds. Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml FROM wsnlinks_categories WHERE validated=1 AND deleted=0 AND hide=0 ;
Number of rows is 17 for Resource id #49
Load time so far: 0.21 seconds. Performing query: SELECT id,title,url,description,rating,votes,validated,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,type,notify,suspect,pendingedit,funds,suspended,alias,expire,ip,inalbum,typeorder,recipurl,hitsin,recipwith,hitsinips,hitsoutips,lastcomment,related,inhidden,viewers,threadviewers,hitsintemp,hitsouttemp,origtype,importance,parentids,timesdead,timesemailed,threadclosed,threadposters,lastposterid,lastpostername,ownername,deleted,deletionreason,movedto,deletedby,timevalidated,filefield,message,sticky,downloads,pollid,posticon,savedby FROM wsnlinks_links WHERE id=1 LIMIT 0,1;
Load time so far: 0.23 seconds. Performing query: SELECT userid,usergroupid,username,password,email,styleid,parentemail,homepage,icq,aim,yahoo,usertitle,customtitle,joindate,daysprune,lastvisit,lastactivity,lastpost,posts,timezoneoffset,pmpopup,avatarid,options,birthday,maxposts,startofweek,ipaddress,referrerid,sent,sentdate,award,miserable,pmtotal,pmunread,passworddate,salt,showvbcode,msn,avatarrevision,membergroupids,displaygroupid,reputation,reputationlevelid,languageid,threadedmode,emailstamp,autosubscribe,birthday_search,photos,warning_level,user_favs,user_cats,schools,arcade_ban,times_played,is_arcade_mod,fav_games,user_sort,user_order,user_g_pp,user_s_pp,def_g_cat,game_skin,arcade_mod_privs,warning_bans,warnings,links,reviews,classifieds,canhavejournal,importuserid,profilepicrevision,games_played,time_played,arcade_points,arcade_spent,arcade_won,arcade_high,showbirthday,inferno_warn_level,skype,arcade_pmactive,create_tourney,comments,totalhits,totalhitsin,validated,template,language,lastattempt,allowemail,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,timezone,rating,notifyofpms,acceptpms,cookieduration,banned,location,occupation,bio,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmnotify,modnotes,guestnotes,lastmodnote,newpms,imflag,orderalbums,lastguestnote,notifymethod,showavatars,showsigs,warninglevel,topics,chatcolor FROM user WHERE id=1 ;
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site9/fst/var/www/html/links/classes/database.php on line 108
Number of rows is for Unknown column 'id' in 'where clause'
Warning: Cannot modify header information - headers already sent by (output started at /home/virtual/site9/fst/var/www/html/links/classes/database.php:276) in /home/virtual/site9/fst/var/www/html/links/commonfuncs.php on line 466
Warning: Cannot modify header information - headers already sent by (output started at /home/virtual/site9/fst/var/www/html/links/classes/database.php:276) in /home/virtual/site9/fst/var/www/html/links/commonfuncs.php on line 470
Load time so far: 0.23 seconds. Performing query: SELECT COUNT(*) FROM wsnlinks_comments WHERE linkid=1 AND validated=1 AND hide=0 AND deleted=1 ;
Unknown column 'id' in 'where clause' Count is 0
Load time so far: 0.23 seconds. Performing query: SELECT time FROM wsnlinks_comments WHERE linkid=1 AND validated=1 AND hide=0 AND deleted=0 ORDER BY time ASC LIMIT 0,1;
Load time so far: 0.23 seconds. Performing query: SELECT COUNT(*) FROM wsnlinks_comments WHERE linkid=1 AND validated=1 AND hide=0 AND deleted=1 AND time<1146707532 ;
Count is 0
Load time so far: 0.23 seconds. Performing query: SELECT id FROM wsnlinks_comments WHERE linkid=1 AND validated=1 AND hide=0 AND deleted=0 LIMIT 0,15;
Number of rows is 1 for Resource id #56
Load time so far: 0.24 seconds. Performing query: SELECT deleted FROM wsnlinks_comments WHERE linkid=1 AND validated=1 AND hide=0 ORDER BY time DESC LIMIT 0,1;
Load time so far: 0.24 seconds. Performing query: SELECT id,linkid,postername,message,time,linkname,validated,ip,ownerid,lastedit,type,approved,votes,hide,typeorder,lasteditby,catid,editreason,preventedit,inhidden,deleted,deletionreason,usernoteon,modnote,filefield,title,deletedby,parentids,disablesmilies,disablesig,icon,disablewsn,disablehtml,originalmessage,flagged FROM wsnlinks_comments WHERE linkid=1 AND validated=1 AND hide=0 ORDER BY time ASC LIMIT 0,15;
Number of rows is 1 for Resource id #58
Load time so far: 0.24 seconds. Performing query: SELECT userid,usergroupid,username,password,email,styleid,parentemail,homepage,icq,aim,yahoo,usertitle,customtitle,joindate,daysprune,lastvisit,lastactivity,lastpost,posts,timezoneoffset,pmpopup,avatarid,options,birthday,maxposts,startofweek,ipaddress,referrerid,sent,sentdate,award,miserable,pmtotal,pmunread,passworddate,salt,showvbcode,msn,avatarrevision,membergroupids,displaygroupid,reputation,reputationlevelid,languageid,threadedmode,emailstamp,autosubscribe,birthday_search,photos,warning_level,user_favs,user_cats,schools,arcade_ban,times_played,is_arcade_mod,fav_games,user_sort,user_order,user_g_pp,user_s_pp,def_g_cat,game_skin,arcade_mod_privs,warning_bans,warnings,links,reviews,classifieds,canhavejournal,importuserid,profilepicrevision,games_played,time_played,arcade_points,arcade_spent,arcade_won,arcade_high,showbirthday,inferno_warn_level,skype,arcade_pmactive,create_tourney,comments,totalhits,totalhitsin,validated,template,language,lastattempt,allowemail,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,timezone,rating,notifyofpms,acceptpms,cookieduration,banned,location,occupation,bio,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmnotify,modnotes,guestnotes,lastmodnote,newpms,imflag,orderalbums,lastguestnote,notifymethod,showavatars,showsigs,warninglevel,topics,chatcolor FROM user WHERE userid=1 ;
Number of rows is 1 for Resource id #61
Load time so far: 0.25 seconds. Performing query: SELECT userid,usergroupid,username,password,email,styleid,parentemail,homepage,icq,aim,yahoo,usertitle,customtitle,joindate,daysprune,lastvisit,lastactivity,lastpost,posts,timezoneoffset,pmpopup,avatarid,options,birthday,maxposts,startofweek,ipaddress,referrerid,sent,sentdate,award,miserable,pmtotal,pmunread,passworddate,salt,showvbcode,msn,avatarrevision,membergroupids,displaygroupid,reputation,reputationlevelid,languageid,threadedmode,emailstamp,autosubscribe,birthday_search,photos,warning_level,user_favs,user_cats,schools,arcade_ban,times_played,is_arcade_mod,fav_games,user_sort,user_order,user_g_pp,user_s_pp,def_g_cat,game_skin,arcade_mod_privs,warning_bans,warnings,links,reviews,classifieds,canhavejournal,importuserid,profilepicrevision,games_played,time_played,arcade_points,arcade_spent,arcade_won,arcade_high,showbirthday,inferno_warn_level,skype,arcade_pmactive,create_tourney,comments,totalhits,totalhitsin,validated,template,language,lastattempt,allowemail,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,timezone,rating,notifyofpms,acceptpms,cookieduration,banned,location,occupation,bio,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmnotify,modnotes,guestnotes,lastmodnote,newpms,imflag,orderalbums,lastguestnote,notifymethod,showavatars,showsigs,warninglevel,topics,chatcolor FROM user WHERE userid=1 ;
Number of rows is 1 for Resource id #62
Load time so far: 0.27 seconds. Performing query: SELECT COUNT(*) FROM wsnlinks_comments WHERE linkid=1 AND deleted=1 ;
Count is 0
Warning: Cannot modify header information - headers already sent by (output started at /home/virtual/site9/fst/var/www/html/links/classes/database.php:276) in /home/virtual/site9/fst/var/www/html/links/end.php on line 142
Load time so far: 0.38 seconds. Performing query: SELECT id,title,url,description,rating,votes,validated,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,type,notify,suspect,pendingedit,funds,suspended,alias,expire,ip,inalbum,typeorder,recipurl,hitsin,recipwith,hitsinips,hitsoutips,lastcomment,related,inhidden,viewers,threadviewers,hitsintemp,hitsouttemp,origtype,importance,parentids,timesdead,timesemailed,threadclosed,threadposters,lastposterid,lastpostername,ownername,deleted,deletionreason,movedto,deletedby,timevalidated,filefield,message,sticky,downloads,pollid,posticon,savedby FROM wsnlinks_links WHERE id=1 LIMIT 0,1;
Load time so far: 0.42 seconds. Performing query: SELECT id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname,lastsearch,nopermission,inchat,name,isrobot,lastchat,groupnamestyle,acceptims,visibility FROM wsnlinks_sessions WHERE time > 1146759863 AND (threadid=1 AND memberid>0) ORDER BY time DESC LIMIT 0,100;
Comments on vBulletin integration mysql error
Member
Usergroup: Customer
Joined: Apr 13, 2006
Total Topics: 5
Total Comments: 16
I believe this is because I'm using vBuleltin 3.5 integration. Shouldn't the field id be userid?
debug output:
Load time so far: 0.14 seconds.
Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND isalbum=0 ORDER BY id DESC LIMIT 0,1;
Number of rows is 1 for Resource id #20
Load time so far: 0.16 seconds.
Performing query: SELECT name,value FROM wsnlinks_switches WHERE id>0 ;
Number of rows is 58 for Resource id #37
Load time so far: 0.17 seconds.
Performing query: SELECT id,type,original,replacement,description,originalclose,replacementclose,sortorder FROM wsnlinks_markup WHERE type='wsncode' ORDER BY sortorder ;
Number of rows is 22 for Resource id #39
Load time so far: 0.17 seconds.
Performing query: SELECT original,replacement,description,id,sortorder FROM wsnlinks_markup WHERE type='smilie' ORDER BY sortorder ;
Number of rows is 14 for Resource id #40
Load time so far: 0.18 seconds.
Performing query: SELECT id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecats,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcategories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncomments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomments,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canalias,cancopy,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem,canpm,canim,canharddelete,limitpms,limitpmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candeleteownpolls,caneditpolls,caneditownpolls,attachperpost,attachperpm,canviewshouts,caneditshouts,caneditownshouts,candeleteshouts,candeleteownshouts,cansubmitshouts,canpollvote,customtitle,canviewinvisible,namestyle,canpmimportant,canviewmodlog,isleader,cansubmitquotes,validatequotes,candeletequotes,candeleteownquotes,canreport,canusesearch,attachperlink,validateattachments,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,bulkpms,issupermod FROM wsnlinks_membergroups WHERE id>0 ;
Load time so far: 0.18 seconds.
Performing query: SELECT userid,usergroupid,username,password,email,styleid,parentemail,homepage,icq,aim,yahoo,usertitle,customtitle,joindate,daysprune,lastvisit,lastactivity,lastpost,posts,timezoneoffset,pmpopup,avatarid,options,birthday,maxposts,startofweek,ipaddress,referrerid,sent,sentdate,award,miserable,pmtotal,pmunread,passworddate,salt,showvbcode,msn,avatarrevision,membergroupids,displaygroupid,reputation,reputationlevelid,languageid,threadedmode,emailstamp,autosubscribe,birthday_search,photos,warning_level,user_favs,user_cats,schools,arcade_ban,times_played,is_arcade_mod,fav_games,user_sort,user_order,user_g_pp,user_s_pp,def_g_cat,game_skin,arcade_mod_privs,warning_bans,warnings,links,reviews,classifieds,canhavejournal,importuserid,profilepicrevision,games_played,time_played,arcade_points,arcade_spent,arcade_won,arcade_high,showbirthday,inferno_warn_level,skype,arcade_pmactive,create_tourney,comments,totalhits,totalhitsin,validated,template,language,lastattempt,allowemail,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,timezone,rating,notifyofpms,acceptpms,cookieduration,banned,location,occupation,bio,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmnotify,modnotes,guestnotes,lastmodnote,newpms,imflag,orderalbums,lastguestnote,notifymethod,showavatars,showsigs,warninglevel,topics,chatcolor FROM user WHERE userid=1 AND validated=1 ;
Load time so far: 0.2 seconds.
Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml FROM wsnlinks_categories WHERE validated=1 AND deleted=0 AND hide=0 ;
Number of rows is 17 for Resource id #49
Load time so far: 0.21 seconds.
Performing query: SELECT id,title,url,description,rating,votes,validated,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,type,notify,suspect,pendingedit,funds,suspended,alias,expire,ip,inalbum,typeorder,recipurl,hitsin,recipwith,hitsinips,hitsoutips,lastcomment,related,inhidden,viewers,threadviewers,hitsintemp,hitsouttemp,origtype,importance,parentids,timesdead,timesemailed,threadclosed,threadposters,lastposterid,lastpostername,ownername,deleted,deletionreason,movedto,deletedby,timevalidated,filefield,message,sticky,downloads,pollid,posticon,savedby FROM wsnlinks_links WHERE id=1 LIMIT 0,1;
Load time so far: 0.23 seconds.
Performing query: SELECT userid,usergroupid,username,password,email,styleid,parentemail,homepage,icq,aim,yahoo,usertitle,customtitle,joindate,daysprune,lastvisit,lastactivity,lastpost,posts,timezoneoffset,pmpopup,avatarid,options,birthday,maxposts,startofweek,ipaddress,referrerid,sent,sentdate,award,miserable,pmtotal,pmunread,passworddate,salt,showvbcode,msn,avatarrevision,membergroupids,displaygroupid,reputation,reputationlevelid,languageid,threadedmode,emailstamp,autosubscribe,birthday_search,photos,warning_level,user_favs,user_cats,schools,arcade_ban,times_played,is_arcade_mod,fav_games,user_sort,user_order,user_g_pp,user_s_pp,def_g_cat,game_skin,arcade_mod_privs,warning_bans,warnings,links,reviews,classifieds,canhavejournal,importuserid,profilepicrevision,games_played,time_played,arcade_points,arcade_spent,arcade_won,arcade_high,showbirthday,inferno_warn_level,skype,arcade_pmactive,create_tourney,comments,totalhits,totalhitsin,validated,template,language,lastattempt,allowemail,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,timezone,rating,notifyofpms,acceptpms,cookieduration,banned,location,occupation,bio,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmnotify,modnotes,guestnotes,lastmodnote,newpms,imflag,orderalbums,lastguestnote,notifymethod,showavatars,showsigs,warninglevel,topics,chatcolor FROM user WHERE id=1 ;
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site9/fst/var/www/html/links/classes/database.php on line 108
Number of rows is for Unknown column 'id' in 'where clause'
Setting cookie with name returnto, value www.dragonslist.com/links/c.../comments.php?id=1&debug=1 and duration 0
Warning: Cannot modify header information - headers already sent by (output started at /home/virtual/site9/fst/var/www/html/links/classes/database.php:276) in /home/virtual/site9/fst/var/www/html/links/commonfuncs.php on line 466
Warning: Cannot modify header information - headers already sent by (output started at /home/virtual/site9/fst/var/www/html/links/classes/database.php:276) in /home/virtual/site9/fst/var/www/html/links/commonfuncs.php on line 470
Load time so far: 0.23 seconds.
Performing query: SELECT COUNT(*) FROM wsnlinks_comments WHERE linkid=1 AND validated=1 AND hide=0 AND deleted=1 ;
Unknown column 'id' in 'where clause'
Count is 0
Load time so far: 0.23 seconds.
Performing query: SELECT time FROM wsnlinks_comments WHERE linkid=1 AND validated=1 AND hide=0 AND deleted=0 ORDER BY time ASC LIMIT 0,1;
Load time so far: 0.23 seconds.
Performing query: SELECT COUNT(*) FROM wsnlinks_comments WHERE linkid=1 AND validated=1 AND hide=0 AND deleted=1 AND time<1146707532 ;
Count is 0
Load time so far: 0.23 seconds.
Performing query: SELECT id FROM wsnlinks_comments WHERE linkid=1 AND validated=1 AND hide=0 AND deleted=0 LIMIT 0,15;
Number of rows is 1 for Resource id #56
Load time so far: 0.24 seconds.
Performing query: SELECT deleted FROM wsnlinks_comments WHERE linkid=1 AND validated=1 AND hide=0 ORDER BY time DESC LIMIT 0,1;
Load time so far: 0.24 seconds.
Performing query: SELECT id,linkid,postername,message,time,linkname,validated,ip,ownerid,lastedit,type,approved,votes,hide,typeorder,lasteditby,catid,editreason,preventedit,inhidden,deleted,deletionreason,usernoteon,modnote,filefield,title,deletedby,parentids,disablesmilies,disablesig,icon,disablewsn,disablehtml,originalmessage,flagged FROM wsnlinks_comments WHERE linkid=1 AND validated=1 AND hide=0 ORDER BY time ASC LIMIT 0,15;
Number of rows is 1 for Resource id #58
Load time so far: 0.24 seconds.
Performing query: SELECT userid,usergroupid,username,password,email,styleid,parentemail,homepage,icq,aim,yahoo,usertitle,customtitle,joindate,daysprune,lastvisit,lastactivity,lastpost,posts,timezoneoffset,pmpopup,avatarid,options,birthday,maxposts,startofweek,ipaddress,referrerid,sent,sentdate,award,miserable,pmtotal,pmunread,passworddate,salt,showvbcode,msn,avatarrevision,membergroupids,displaygroupid,reputation,reputationlevelid,languageid,threadedmode,emailstamp,autosubscribe,birthday_search,photos,warning_level,user_favs,user_cats,schools,arcade_ban,times_played,is_arcade_mod,fav_games,user_sort,user_order,user_g_pp,user_s_pp,def_g_cat,game_skin,arcade_mod_privs,warning_bans,warnings,links,reviews,classifieds,canhavejournal,importuserid,profilepicrevision,games_played,time_played,arcade_points,arcade_spent,arcade_won,arcade_high,showbirthday,inferno_warn_level,skype,arcade_pmactive,create_tourney,comments,totalhits,totalhitsin,validated,template,language,lastattempt,allowemail,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,timezone,rating,notifyofpms,acceptpms,cookieduration,banned,location,occupation,bio,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmnotify,modnotes,guestnotes,lastmodnote,newpms,imflag,orderalbums,lastguestnote,notifymethod,showavatars,showsigs,warninglevel,topics,chatcolor FROM user WHERE userid=1 ;
Number of rows is 1 for Resource id #61
Load time so far: 0.25 seconds.
Performing query: SELECT userid,usergroupid,username,password,email,styleid,parentemail,homepage,icq,aim,yahoo,usertitle,customtitle,joindate,daysprune,lastvisit,lastactivity,lastpost,posts,timezoneoffset,pmpopup,avatarid,options,birthday,maxposts,startofweek,ipaddress,referrerid,sent,sentdate,award,miserable,pmtotal,pmunread,passworddate,salt,showvbcode,msn,avatarrevision,membergroupids,displaygroupid,reputation,reputationlevelid,languageid,threadedmode,emailstamp,autosubscribe,birthday_search,photos,warning_level,user_favs,user_cats,schools,arcade_ban,times_played,is_arcade_mod,fav_games,user_sort,user_order,user_g_pp,user_s_pp,def_g_cat,game_skin,arcade_mod_privs,warning_bans,warnings,links,reviews,classifieds,canhavejournal,importuserid,profilepicrevision,games_played,time_played,arcade_points,arcade_spent,arcade_won,arcade_high,showbirthday,inferno_warn_level,skype,arcade_pmactive,create_tourney,comments,totalhits,totalhitsin,validated,template,language,lastattempt,allowemail,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,timezone,rating,notifyofpms,acceptpms,cookieduration,banned,location,occupation,bio,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmnotify,modnotes,guestnotes,lastmodnote,newpms,imflag,orderalbums,lastguestnote,notifymethod,showavatars,showsigs,warninglevel,topics,chatcolor FROM user WHERE userid=1 ;
Number of rows is 1 for Resource id #62
Load time so far: 0.27 seconds.
Performing query: SELECT COUNT(*) FROM wsnlinks_comments WHERE linkid=1 AND deleted=1 ;
Count is 0
Warning: Cannot modify header information - headers already sent by (output started at /home/virtual/site9/fst/var/www/html/links/classes/database.php:276) in /home/virtual/site9/fst/var/www/html/links/end.php on line 142
Load time so far: 0.38 seconds.
Performing query: SELECT id,title,url,description,rating,votes,validated,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,type,notify,suspect,pendingedit,funds,suspended,alias,expire,ip,inalbum,typeorder,recipurl,hitsin,recipwith,hitsinips,hitsoutips,lastcomment,related,inhidden,viewers,threadviewers,hitsintemp,hitsouttemp,origtype,importance,parentids,timesdead,timesemailed,threadclosed,threadposters,lastposterid,lastpostername,ownername,deleted,deletionreason,movedto,deletedby,timevalidated,filefield,message,sticky,downloads,pollid,posticon,savedby FROM wsnlinks_links WHERE id=1 LIMIT 0,1;
Load time so far: 0.42 seconds.
Performing query: SELECT id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname,lastsearch,nopermission,inchat,name,isrobot,lastchat,groupnamestyle,acceptims,visibility FROM wsnlinks_sessions WHERE time > 1146759863 AND (threadid=1 AND memberid>0) ORDER BY time DESC LIMIT 0,100;
Number of rows is 1 for Resource id #66
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Looks like a bug. Question is, on what page are you seeing this? I can't find that query anywhere.
Member
Usergroup: Customer
Joined: Apr 13, 2006
Total Topics: 5
Total Comments: 16
The page is comments.php
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Change to
Member
Usergroup: Customer
Joined: Apr 13, 2006
Total Topics: 5
Total Comments: 16
That fixed it.
Thank you very much.