Webmastersite.net
Register Log In

Database error - member login

Title Database error - member login
Description Possible problem with member registration
Message Text I recently installed WSN 3.20 for the first time (not an upgrade). At first things were going OK, and I was setting options, creating categories etc. Then I tried setting up a new user with the status of Member. The registation process went fine, but a database error appeared subsequently on all pages (details below). I'm not sure if it is directly connected to the fact that a new user was created immediately beforehand. Also, the link to the Moderator Control Panel appears at the bottom of the page when the ordinary member logs in. I would have thought this should only appear for a user with the status of moderator. I checked settings to make sure that there was nothing to instantly upgrade an ordinary member to moderator. I am not sure if the database error/ moderator control panel issues are linked at this stage. Here is the bug report for the database error, taken from the index.php page:
Load time so far: 0.32 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 FROM wsnlinks_categories WHERE validated=1 AND deleted=0 AND hide=0 ;

Number of rows is 13 for Resource id #45

Load time so far: 0.35 seconds.
Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE;

Load time so far: 0.36 seconds.
Performing query: SELECT id,`to`,subject,message,headers,replacement,mime FROM wsnlinks_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10;

Number of rows is 0 for Resource id #46

Load time so far: 0.36 seconds.
Performing query: UNLOCK TABLES;

Load time so far: 0.37 seconds.
Performing query: SELECT id,name,links,comments,time,usergroup,password,ip,totalhits,totalhitsin,email,validated,template,language,lastattempt,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned,location,homepage,occupation,bio,aim,icq,msn,yahoo,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,customtitle,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe,notifymethod,showavatars,showsigs,warninglevel FROM wsnlinks_members WHERE validated = 1 AND usergroup = 2 AND time < 1122739680 AND posts > 1 ;


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in ..\..\..\..\..\classes\database.php on line 108

Number of rows is for Unknown column 'posts' in 'where clause'

Load time so far: 0.37 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 FROM wsnlinks_categories WHERE parent=0 AND validated=1 AND hide=0 AND isalbum=0 AND deleted=0 ORDER BY name ASC LIMIT 0,300;

Unknown column 'posts' in 'where clause'

Number of rows is 10 for Resource id #49

Load time so far: 0.39 seconds.
Performing query: SELECT id FROM wsnlinks_categories WHERE parent=0 AND validated=1 AND hide=0 AND deleted=0 ;

Number of rows is 10 for Resource id #50

Setting cookie with name returnto, value ..//.../.../index.php and duration 1122826980

Load time so far: 0.56 seconds.
Performing query: SELECT COUNT(id) FROM wsnlinks_sessions WHERE memberid>0 ;

Count is 1

Load time so far: 0.56 seconds.
Performing query: SELECT COUNT(id) FROM wsnlinks_sessions WHERE memberid=0 ;

Count is 0

Load time so far: 0.61 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 FROM wsnlinks_links WHERE validated=1 AND hide=0 AND deleted=0 AND inhidden=0 AND alias=0 AND inalbum=0 ORDER BY id DESC LIMIT 0,15;

Number of rows is 0 for Resource id #54

Load time so far: 0.61 seconds.
Performing query: SELECT id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname,lastsearch,nopermission FROM wsnlinks_sessions WHERE time > 1122825180 AND (memberid>0) ORDER BY time DESC LIMIT 0,100;

Number of rows is 0 for Resource id #55
A point which may be of importance is that I am running on Windows2003 and IIS. The error message says "Number of rows is for Unknown column 'posts' in 'where clause'" - I presume this is a reference to posts by members, but I am not using this feature. Therefore, the number of posts by a member cannot be > 1. I will try turning the posting feature back on to see if it makes a difference. If there is anything else I should provide to assist resolving the issue, I'll do it as quickly as possible. Thanks in advance, Donal
Rating
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5
0/5 based on 0 votes.
Ownership TearingHairOut
Views 1,010 views. Averaging 0 views per day.
Similar Topics
Submission Date Jul 31, 2005 - 11:17 AM