Query 27: SELECT `id` FROM wsnlinks_members WHERE validated=1 AND inactive=0
Number of rows is 305
Load time so far: 0.18 seconds.
Query 28: SELECT `id`,`name`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`email`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`topics`,`posts`,`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`,`chatcolor`,`links`,`comments`,`totalhitsin`,`telephone`,`surname`,`company`,`breeds`,`litters`,`health`,`clubs`,`affix`,`country`,`newsletter`,`licenced`,`autosubscribepost`,`breeder`,`isbreeder`,`traderrating`,`invitessent`,`validatedemail`,`newemail`,`calsub`,`macros`,`firstname` FROM wsnlinks_members WHERE validated=1 AND inactive=0 ORDER BY name desc LIMIT 0,80
Number of rows is 80
Load time so far: 1.06 seconds.
Query 29: 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`,`photoattach`,`photocredit`,`linksperpage`,`wysihtml`,`numonline`,`keywords`,`profile`,`profilehelp` FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND deleted=0 AND (parent='0') AND alias=0 ORDER BY n ASC LIMIT 0,150
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/thedogsc/public_html/databases/mysql.php on line 19
Number of rows is Unknown column 'n' in 'order clause'
Load time so far: 1.7 seconds.
Unknown column 'n' in 'order clause'
Query 30: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility` FROM wsnlinks_sessions WHERE memberid=1
Number of rows is 1
Load time so far: 1.7 seconds.
Query 31: UPDATE wsnlinks_sessions SET id='68255', memberid='1', location='http://www.thedogscene.co.uk/memberlist.php?field=name&ascdesc=desc&perpage=80', time='1181466512', ip='85.92.185.57', browser='Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)', starttime='1181466493', catid='', threadid='', areaname='Member List', lastsearch='0', nopermission='0', inchat='0', name='webmaster', isrobot='0', lastchat='0', groupnamestyle='admincolor', acceptims='none', visibility='everyone' WHERE id=68255
0/5
1
2
3
4
5
This thread is closed, so you cannot post a reply.
Comments on Membership List Sort error
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
If I sort the members list I get
It does sort it correctly, but for the first page only - go onto page 2 and it reverts to default order.
Debug...
Load time so far: 0.16 seconds.
Query 23: SELECT `original`,`replacement`,`description`,`id`,`sortorder` FROM wsnlinks_markup WHERE type='smilie' ORDER BY sortorder
Number of rows is 14
Query 24: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE
Load time so far: 0.16 seconds.
Query 25: 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
Query 26: UNLOCK TABLES
Setting cookie with name returnto, value www.thedogscene.co.uk/membe...me&ascdesc=desc&perpage=80 and duration 900
Load time so far: 0.17 seconds.
Query 27: SELECT `id` FROM wsnlinks_members WHERE validated=1 AND inactive=0
Number of rows is 305
Load time so far: 0.18 seconds.
Query 28: SELECT `id`,`name`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`email`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`topics`,`posts`,`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`,`chatcolor`,`links`,`comments`,`totalhitsin`,`telephone`,`surname`,`company`,`breeds`,`litters`,`health`,`clubs`,`affix`,`country`,`newsletter`,`licenced`,`autosubscribepost`,`breeder`,`isbreeder`,`traderrating`,`invitessent`,`validatedemail`,`newemail`,`calsub`,`macros`,`firstname` FROM wsnlinks_members WHERE validated=1 AND inactive=0 ORDER BY name desc LIMIT 0,80
Number of rows is 80
Load time so far: 1.06 seconds.
Query 29: 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`,`photoattach`,`photocredit`,`linksperpage`,`wysihtml`,`numonline`,`keywords`,`profile`,`profilehelp` FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND deleted=0 AND (parent='0') AND alias=0 ORDER BY n ASC LIMIT 0,150
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/thedogsc/public_html/databases/mysql.php on line 19
Number of rows is Unknown column 'n' in 'order clause'
Load time so far: 1.7 seconds.
Unknown column 'n' in 'order clause'
Query 30: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility` FROM wsnlinks_sessions WHERE memberid=1
Number of rows is 1
Load time so far: 1.7 seconds.
Query 31: UPDATE wsnlinks_sessions SET id='68255', memberid='1', location='http://www.thedogscene.co.uk/memberlist.php?field=name&ascdesc=desc&perpage=80', time='1181466512', ip='85.92.185.57', browser='Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)', starttime='1181466493', catid='', threadid='', areaname='Member List', lastsearch='0', nopermission='0', inchat='0', name='webmaster', isrobot='0', lastchat='0', groupnamestyle='admincolor', acceptims='none', visibility='everyone' WHERE id=68255