I have just installed Forum into a database with WSNGallery running. I'm getting the following error message when browsing to the forum home page.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u4/treehstn/glassresearch.net/html/wsnforum/databases/mysql.php on line 19
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u4/treehstn/glassresearch.net/html/wsnforum/databases/mysql.php on line 19
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u4/treehstn/glassresearch.net/html/wsnforum/databases/mysql.php on line 19
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u4/treehstn/glassresearch.net/html/wsnforum/databases/mysql.php on line 19
Here is the debug information.
Load time so far: 0.05 seconds.
Query 28: SELECT `original`,`replacement`,`description`,`id`,`sortorder` FROM wsnforum_markup WHERE type='smilie' ORDER BY sortorder
Query 30: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM wsnforum_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10
Number of rows is 0
Query 31: UNLOCK TABLES
Load time so far: 0.06 seconds.
Query 32: SELECT `id`,`frequency`,`filename`,`nextrun` FROM wsnforum_crons WHERE nextrun < 1179248277 ORDER BY id ASC LIMIT 0,1
Number of rows is 0
Load time so far: 0.06 seconds.
Query 33: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`linksperpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE parent=0 AND validated=1 AND hide=0 AND isalbum=0 AND deleted=0 ORDER BY priority ASC,name ASC LIMIT 0,300
Query 34: SELECT `userid`,`username`,`password`,`email`,`subscriptionType`,`lastPaymentAmount`,`lastPaymentDate`,`accountBalance`,`comments`,`time`,`usergroup`,`ip`,`totalhits`,`validated`,`template`,`language`,`totalbytes`,`images`,`lastattempt`,`avatarname`,`allowemail`,`albumid`,`signature`,`failedattempts`,`allowuseremail`,`stylesheet`,`funds`,`totalhitsin`,`notifyoflinks`,`lastvisit`,`timezone`,`links`,`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`,`traderrating`,`invitessent`,`validatedemail`,`newemail`,`calsub`,`macros`,`autosubscribepost`,`blogrss`,`blogcache`,`watched` FROM users WHERE birthdate LIKE '%05-15%' AND validated=1 ORDER BY id ASC
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u4/treehstn/glassresearch.net/html/wsnforum/databases/mysql.php on line 19
Number of rows is Unknown column 'id' in 'order clause'
Load time so far: 0.16 seconds.
Unknown column 'id' in 'order clause'
Query 35: SELECT `userid`,`username`,`password`,`email`,`subscriptionType`,`lastPaymentAmount`,`lastPaymentDate`,`accountBalance`,`comments`,`time`,`usergroup`,`ip`,`totalhits`,`validated`,`template`,`language`,`totalbytes`,`images`,`lastattempt`,`avatarname`,`allowemail`,`albumid`,`signature`,`failedattempts`,`allowuseremail`,`stylesheet`,`funds`,`totalhitsin`,`notifyoflinks`,`lastvisit`,`timezone`,`links`,`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`,`traderrating`,`invitessent`,`validatedemail`,`newemail`,`calsub`,`macros`,`autosubscribepost`,`blogrss`,`blogcache`,`watched` FROM users WHERE birthdate LIKE '%05-15%' AND validated=1 ORDER BY id ASC
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u4/treehstn/glassresearch.net/html/wsnforum/databases/mysql.php on line 19
Number of rows is Unknown column 'id' in 'order clause'
Load time so far: 0.16 seconds.
Unknown column 'id' in 'order clause'
Query 36: SELECT `userid`,`username`,`password`,`email`,`subscriptionType`,`lastPaymentAmount`,`lastPaymentDate`,`accountBalance`,`comments`,`time`,`usergroup`,`ip`,`totalhits`,`validated`,`template`,`language`,`totalbytes`,`images`,`lastattempt`,`avatarname`,`allowemail`,`albumid`,`signature`,`failedattempts`,`allowuseremail`,`stylesheet`,`funds`,`totalhitsin`,`notifyoflinks`,`lastvisit`,`timezone`,`links`,`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`,`traderrating`,`invitessent`,`validatedemail`,`newemail`,`calsub`,`macros`,`autosubscribepost`,`blogrss`,`blogcache`,`watched` FROM users WHERE birthdate LIKE '%05-14%' AND validated=1 ORDER BY id ASC
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u4/treehstn/glassresearch.net/html/wsnforum/databases/mysql.php on line 19
Number of rows is Unknown column 'id' in 'order clause'
Load time so far: 0.16 seconds.
Unknown column 'id' in 'order clause'
Query 37: SELECT `userid`,`username`,`password`,`email`,`subscriptionType`,`lastPaymentAmount`,`lastPaymentDate`,`accountBalance`,`comments`,`time`,`usergroup`,`ip`,`totalhits`,`validated`,`template`,`language`,`totalbytes`,`images`,`lastattempt`,`avatarname`,`allowemail`,`albumid`,`signature`,`failedattempts`,`allowuseremail`,`stylesheet`,`funds`,`totalhitsin`,`notifyoflinks`,`lastvisit`,`timezone`,`links`,`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`,`traderrating`,`invitessent`,`validatedemail`,`newemail`,`calsub`,`macros`,`autosubscribepost`,`blogrss`,`blogcache`,`watched` FROM users WHERE birthdate LIKE '%05-16%' AND validated=1 ORDER BY id ASC
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u4/treehstn/glassresearch.net/html/wsnforum/databases/mysql.php on line 19
Number of rows is Unknown column 'id' in 'order clause'
Load time so far: 0.16 seconds.
Unknown column 'id' in 'order clause'
Query 38: UPDATE wsnforum_settings SET content='[DAY:05-15][DAY:05-14][DAY:05-16]' WHERE name='birthdaycache'
Load time so far: 0.17 seconds.
Query 39: SELECT COUNT(*) FROM wsnforum_sessions WHERE memberid>0
Count is 1
Load time so far: 0.17 seconds.
Query 40: SELECT COUNT(*) FROM wsnforum_sessions WHERE memberid=0 AND isrobot=0
Count is 0
Load time so far: 0.17 seconds.
Query 41: SELECT COUNT(*) FROM wsnforum_sessions WHERE memberid=0 AND isrobot=1
Count is 0
Load time so far: 0.23 seconds.
Query 42: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility` FROM wsnforum_sessions WHERE time > 1179247377 AND (memberid>0) ORDER BY time DESC LIMIT 0,100
Number of rows is 1
Load time so far: 0.23 seconds.
Query 43: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility` FROM wsnforum_sessions WHERE time > 1179247377 AND (inchat=1) ORDER BY time DESC LIMIT 0,100
Number of rows is 0
Load time so far: 0.24 seconds.
Query 44: SELECT `id` FROM wsnforum_quotes WHERE 1=1 ORDER BY rand() ASC LIMIT 0,1
Number of rows is 0
Load time so far: 0.24 seconds.
Query 45: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`linksperpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=1
Load time so far: 0.24 seconds.
Query 46: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`linksperpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=2
Load time so far: 0.24 seconds.
Query 47: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`linksperpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=3
Load time so far: 0.24 seconds.
Query 48: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`linksperpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=4
Load time so far: 0.24 seconds.
Query 49: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`linksperpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=5
Load time so far: 0.24 seconds.
Query 50: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`linksperpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=6
Load time so far: 0.24 seconds.
Query 51: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`linksperpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=7
Load time so far: 0.24 seconds.
Query 52: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`linksperpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=8
Load time so far: 0.24 seconds.
Query 53: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`linksperpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=9
Load time so far: 0.25 seconds.
Query 54: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`linksperpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=10
Load time so far: 0.25 seconds.
Query 55: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`linksperpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=11
Load time so far: 0.61 seconds.
Query 56: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility` FROM wsnforum_sessions WHERE memberid=3
Number of rows is 1
Load time so far: 0.61 seconds.
Query 57: UPDATE wsnforum_sessions SET id='10', memberid='3', location='http://www.glassresearch.net/wsnforum/index.php', time='1179248278', ip='67.183.225.229', browser='Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; Media Center PC 4.0; InfoPath.1; .NET CLR 2.0.50727)', starttime='1179245965', catid='0', threadid='', areaname='WSN Forum', lastsearch='0', nopermission='0', inchat='0', name='glasschalice', isrobot='0', lastchat='0', groupnamestyle='admincolor', acceptims='', visibility='' WHERE id=10
It says you're using an integrated members table which doesn't have an id field, so you can't order by id. Pick a new members order at Admin -> Settings -> General.
Comments on MySQL error after installation
Member
Usergroup: Customer
Joined: Nov 17, 2006
Total Topics: 5
Total Comments: 16
I have just installed Forum into a database with WSNGallery running. I'm getting the following error message when browsing to the forum home page.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u4/treehstn/glassresearch.net/html/wsnforum/databases/mysql.php on line 19
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u4/treehstn/glassresearch.net/html/wsnforum/databases/mysql.php on line 19
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u4/treehstn/glassresearch.net/html/wsnforum/databases/mysql.php on line 19
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u4/treehstn/glassresearch.net/html/wsnforum/databases/mysql.php on line 19
Here is the debug information.
Load time so far: 0.05 seconds.
Query 28: SELECT `original`,`replacement`,`description`,`id`,`sortorder` FROM wsnforum_markup WHERE type='smilie' ORDER BY sortorder
Number of rows is 14
Query 29: LOCK TABLES wsnforum_email WRITE, wsnforum_links WRITE, wsnforum_categories WRITE, users WRITE
Load time so far: 0.05 seconds.
Query 30: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM wsnforum_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10
Number of rows is 0
Query 31: UNLOCK TABLES
Load time so far: 0.06 seconds.
Query 32: SELECT `id`,`frequency`,`filename`,`nextrun` FROM wsnforum_crons WHERE nextrun < 1179248277 ORDER BY id ASC LIMIT 0,1
Number of rows is 0
Load time so far: 0.06 seconds.
Query 33: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`linksperpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE parent=0 AND validated=1 AND hide=0 AND isalbum=0 AND deleted=0 ORDER BY priority ASC,name ASC LIMIT 0,300
Number of rows is 11
Setting cookie with name returnto, value http://www.glassresearch.net/wsnforum/index.php and duration 1179249177
Load time so far: 0.16 seconds.
Query 34: SELECT `userid`,`username`,`password`,`email`,`subscriptionType`,`lastPaymentAmount`,`lastPaymentDate`,`accountBalance`,`comments`,`time`,`usergroup`,`ip`,`totalhits`,`validated`,`template`,`language`,`totalbytes`,`images`,`lastattempt`,`avatarname`,`allowemail`,`albumid`,`signature`,`failedattempts`,`allowuseremail`,`stylesheet`,`funds`,`totalhitsin`,`notifyoflinks`,`lastvisit`,`timezone`,`links`,`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`,`traderrating`,`invitessent`,`validatedemail`,`newemail`,`calsub`,`macros`,`autosubscribepost`,`blogrss`,`blogcache`,`watched` FROM users WHERE birthdate LIKE '%05-15%' AND validated=1 ORDER BY id ASC
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u4/treehstn/glassresearch.net/html/wsnforum/databases/mysql.php on line 19
Number of rows is Unknown column 'id' in 'order clause'
Load time so far: 0.16 seconds.
Unknown column 'id' in 'order clause'
Query 35: SELECT `userid`,`username`,`password`,`email`,`subscriptionType`,`lastPaymentAmount`,`lastPaymentDate`,`accountBalance`,`comments`,`time`,`usergroup`,`ip`,`totalhits`,`validated`,`template`,`language`,`totalbytes`,`images`,`lastattempt`,`avatarname`,`allowemail`,`albumid`,`signature`,`failedattempts`,`allowuseremail`,`stylesheet`,`funds`,`totalhitsin`,`notifyoflinks`,`lastvisit`,`timezone`,`links`,`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`,`traderrating`,`invitessent`,`validatedemail`,`newemail`,`calsub`,`macros`,`autosubscribepost`,`blogrss`,`blogcache`,`watched` FROM users WHERE birthdate LIKE '%05-15%' AND validated=1 ORDER BY id ASC
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u4/treehstn/glassresearch.net/html/wsnforum/databases/mysql.php on line 19
Number of rows is Unknown column 'id' in 'order clause'
Load time so far: 0.16 seconds.
Unknown column 'id' in 'order clause'
Query 36: SELECT `userid`,`username`,`password`,`email`,`subscriptionType`,`lastPaymentAmount`,`lastPaymentDate`,`accountBalance`,`comments`,`time`,`usergroup`,`ip`,`totalhits`,`validated`,`template`,`language`,`totalbytes`,`images`,`lastattempt`,`avatarname`,`allowemail`,`albumid`,`signature`,`failedattempts`,`allowuseremail`,`stylesheet`,`funds`,`totalhitsin`,`notifyoflinks`,`lastvisit`,`timezone`,`links`,`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`,`traderrating`,`invitessent`,`validatedemail`,`newemail`,`calsub`,`macros`,`autosubscribepost`,`blogrss`,`blogcache`,`watched` FROM users WHERE birthdate LIKE '%05-14%' AND validated=1 ORDER BY id ASC
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u4/treehstn/glassresearch.net/html/wsnforum/databases/mysql.php on line 19
Number of rows is Unknown column 'id' in 'order clause'
Load time so far: 0.16 seconds.
Unknown column 'id' in 'order clause'
Query 37: SELECT `userid`,`username`,`password`,`email`,`subscriptionType`,`lastPaymentAmount`,`lastPaymentDate`,`accountBalance`,`comments`,`time`,`usergroup`,`ip`,`totalhits`,`validated`,`template`,`language`,`totalbytes`,`images`,`lastattempt`,`avatarname`,`allowemail`,`albumid`,`signature`,`failedattempts`,`allowuseremail`,`stylesheet`,`funds`,`totalhitsin`,`notifyoflinks`,`lastvisit`,`timezone`,`links`,`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`,`traderrating`,`invitessent`,`validatedemail`,`newemail`,`calsub`,`macros`,`autosubscribepost`,`blogrss`,`blogcache`,`watched` FROM users WHERE birthdate LIKE '%05-16%' AND validated=1 ORDER BY id ASC
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/u4/treehstn/glassresearch.net/html/wsnforum/databases/mysql.php on line 19
Number of rows is Unknown column 'id' in 'order clause'
Load time so far: 0.16 seconds.
Unknown column 'id' in 'order clause'
Query 38: UPDATE wsnforum_settings SET content='[DAY:05-15][DAY:05-14][DAY:05-16]' WHERE name='birthdaycache'
Load time so far: 0.17 seconds.
Query 39: SELECT COUNT(*) FROM wsnforum_sessions WHERE memberid>0
Count is 1
Load time so far: 0.17 seconds.
Query 40: SELECT COUNT(*) FROM wsnforum_sessions WHERE memberid=0 AND isrobot=0
Count is 0
Load time so far: 0.17 seconds.
Query 41: SELECT COUNT(*) FROM wsnforum_sessions WHERE memberid=0 AND isrobot=1
Count is 0
Load time so far: 0.23 seconds.
Query 42: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility` FROM wsnforum_sessions WHERE time > 1179247377 AND (memberid>0) ORDER BY time DESC LIMIT 0,100
Number of rows is 1
Load time so far: 0.23 seconds.
Query 43: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility` FROM wsnforum_sessions WHERE time > 1179247377 AND (inchat=1) ORDER BY time DESC LIMIT 0,100
Number of rows is 0
Load time so far: 0.24 seconds.
Query 44: SELECT `id` FROM wsnforum_quotes WHERE 1=1 ORDER BY rand() ASC LIMIT 0,1
Number of rows is 0
Load time so far: 0.24 seconds.
Query 45: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`linksperpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=1
Load time so far: 0.24 seconds.
Query 46: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`linksperpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=2
Load time so far: 0.24 seconds.
Query 47: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`linksperpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=3
Load time so far: 0.24 seconds.
Query 48: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`linksperpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=4
Load time so far: 0.24 seconds.
Query 49: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`linksperpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=5
Load time so far: 0.24 seconds.
Query 50: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`linksperpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=6
Load time so far: 0.24 seconds.
Query 51: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`linksperpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=7
Load time so far: 0.24 seconds.
Query 52: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`linksperpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=8
Load time so far: 0.24 seconds.
Query 53: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`linksperpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=9
Load time so far: 0.25 seconds.
Query 54: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`linksperpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=10
Load time so far: 0.25 seconds.
Query 55: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`linksperpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=11
Load time so far: 0.61 seconds.
Query 56: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility` FROM wsnforum_sessions WHERE memberid=3
Number of rows is 1
Load time so far: 0.61 seconds.
Query 57: UPDATE wsnforum_sessions SET id='10', memberid='3', location='http://www.glassresearch.net/wsnforum/index.php', time='1179248278', ip='67.183.225.229', browser='Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; Media Center PC 4.0; InfoPath.1; .NET CLR 2.0.50727)', starttime='1179245965', catid='0', threadid='', areaname='WSN Forum', lastsearch='0', nopermission='0', inchat='0', name='glasschalice', isrobot='0', lastchat='0', groupnamestyle='admincolor', acceptims='', visibility='' WHERE id=10
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
It says you're using an integrated members table which doesn't have an id field, so you can't order by id. Pick a new members order at Admin -> Settings -> General.
Member
Usergroup: Customer
Joined: Nov 17, 2006
Total Topics: 5
Total Comments: 16
Does that mean that I might not have run the integration for the user table correctly? My user table does have a user id field.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
It doesn't have a field named id. You need to go to Admin -> Settings -> General and make a selection, or just submit the page as it is.