MySQL error after installation: WSN Support

Quick Links open

New Posts Member List

WSN Support » WSN Forum » MySQL error after installation » MySQL error after installation

MySQL error after installation
supplied argument is not a valid MySQL result reso

Version: WSN Forum Pro 2.0.17
Example URL: www.glassresearch.net/wsnforum

MySQL error after installation

treehstn
Member

Usergroup: Customer
Joined: Nov 17, 2006
Total Topics: 6
Total Posts: 19

Posted 05/15/07 - 10:04 AM:	#1
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`,`paren tnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom `,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`t ype`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`order links`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`vie ws`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdel ay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`, `lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linksher e`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`cou ntposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`, `ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`links perpage`,`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`,`l astPaymentAmount`,`lastPaymentDate`,`accountBalance`,`commen ts`,`time`,`usergroup`,`ip`,`totalhits`,`validated`,`templat e`,`language`,`totalbytes`,`images`,`lastattempt`,`avatarnam e`,`allowemail`,`albumid`,`signature`,`failedattempts`,`allo wuseremail`,`stylesheet`,`funds`,`totalhitsin`,`notifyoflink s`,`lastvisit`,`timezone`,`links`,`rating`,`pmfolders`,`noti fyofpms`,`acceptpms`,`cookieduration`,`banned`,`topics`,`pos ts`,`location`,`homepage`,`occupation`,`bio`,`aim`,`icq`,`ms n`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`buddies`,`ign ored`,`isonline`,`acceptims`,`adminpermissions`,`referrer`,` groupreverttime`,`grouprevertto`,`moderationpm`,`secondarygr oups`,`linksperpage`,`commentsperpage`,`shouts`,`customtitle `,`shoutban`,`topicbans`,`forumbans`,`visibility`,`birthdate `,`lastsession`,`interests`,`posteditor`,`forumaccess`,`pmpo pup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,`lastmodnote` ,`newpms`,`imflag`,`orderalbums`,`lastguestnote`,`autosubscr ibe`,`notifymethod`,`showavatars`,`showsigs`,`warninglevel`, `chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`n ewemail`,`calsub`,`macros`,`autosubscribepost`,`blogrss`,`bl ogcache`,`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`,`l astPaymentAmount`,`lastPaymentDate`,`accountBalance`,`commen ts`,`time`,`usergroup`,`ip`,`totalhits`,`validated`,`templat e`,`language`,`totalbytes`,`images`,`lastattempt`,`avatarnam e`,`allowemail`,`albumid`,`signature`,`failedattempts`,`allo wuseremail`,`stylesheet`,`funds`,`totalhitsin`,`notifyoflink s`,`lastvisit`,`timezone`,`links`,`rating`,`pmfolders`,`noti fyofpms`,`acceptpms`,`cookieduration`,`banned`,`topics`,`pos ts`,`location`,`homepage`,`occupation`,`bio`,`aim`,`icq`,`ms n`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`buddies`,`ign ored`,`isonline`,`acceptims`,`adminpermissions`,`referrer`,` groupreverttime`,`grouprevertto`,`moderationpm`,`secondarygr oups`,`linksperpage`,`commentsperpage`,`shouts`,`customtitle `,`shoutban`,`topicbans`,`forumbans`,`visibility`,`birthdate `,`lastsession`,`interests`,`posteditor`,`forumaccess`,`pmpo pup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,`lastmodnote` ,`newpms`,`imflag`,`orderalbums`,`lastguestnote`,`autosubscr ibe`,`notifymethod`,`showavatars`,`showsigs`,`warninglevel`, `chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`n ewemail`,`calsub`,`macros`,`autosubscribepost`,`blogrss`,`bl ogcache`,`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`,`l astPaymentAmount`,`lastPaymentDate`,`accountBalance`,`commen ts`,`time`,`usergroup`,`ip`,`totalhits`,`validated`,`templat e`,`language`,`totalbytes`,`images`,`lastattempt`,`avatarnam e`,`allowemail`,`albumid`,`signature`,`failedattempts`,`allo wuseremail`,`stylesheet`,`funds`,`totalhitsin`,`notifyoflink s`,`lastvisit`,`timezone`,`links`,`rating`,`pmfolders`,`noti fyofpms`,`acceptpms`,`cookieduration`,`banned`,`topics`,`pos ts`,`location`,`homepage`,`occupation`,`bio`,`aim`,`icq`,`ms n`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`buddies`,`ign ored`,`isonline`,`acceptims`,`adminpermissions`,`referrer`,` groupreverttime`,`grouprevertto`,`moderationpm`,`secondarygr oups`,`linksperpage`,`commentsperpage`,`shouts`,`customtitle `,`shoutban`,`topicbans`,`forumbans`,`visibility`,`birthdate `,`lastsession`,`interests`,`posteditor`,`forumaccess`,`pmpo pup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,`lastmodnote` ,`newpms`,`imflag`,`orderalbums`,`lastguestnote`,`autosubscr ibe`,`notifymethod`,`showavatars`,`showsigs`,`warninglevel`, `chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`n ewemail`,`calsub`,`macros`,`autosubscribepost`,`blogrss`,`bl ogcache`,`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`,`l astPaymentAmount`,`lastPaymentDate`,`accountBalance`,`commen ts`,`time`,`usergroup`,`ip`,`totalhits`,`validated`,`templat e`,`language`,`totalbytes`,`images`,`lastattempt`,`avatarnam e`,`allowemail`,`albumid`,`signature`,`failedattempts`,`allo wuseremail`,`stylesheet`,`funds`,`totalhitsin`,`notifyoflink s`,`lastvisit`,`timezone`,`links`,`rating`,`pmfolders`,`noti fyofpms`,`acceptpms`,`cookieduration`,`banned`,`topics`,`pos ts`,`location`,`homepage`,`occupation`,`bio`,`aim`,`icq`,`ms n`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`buddies`,`ign ored`,`isonline`,`acceptims`,`adminpermissions`,`referrer`,` groupreverttime`,`grouprevertto`,`moderationpm`,`secondarygr oups`,`linksperpage`,`commentsperpage`,`shouts`,`customtitle `,`shoutban`,`topicbans`,`forumbans`,`visibility`,`birthdate `,`lastsession`,`interests`,`posteditor`,`forumaccess`,`pmpo pup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,`lastmodnote` ,`newpms`,`imflag`,`orderalbums`,`lastguestnote`,`autosubscr ibe`,`notifymethod`,`showavatars`,`showsigs`,`warninglevel`, `chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`n ewemail`,`calsub`,`macros`,`autosubscribepost`,`blogrss`,`bl ogcache`,`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`,`accept ims`,`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`,`accept ims`,`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`,`paren tnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom `,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`t ype`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`order links`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`vie ws`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdel ay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`, `lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linksher e`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`cou ntposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`, `ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`links perpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=1 Load time so far: 0.24 seconds. Query 46: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`paren tnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom `,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`t ype`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`order links`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`vie ws`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdel ay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`, `lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linksher e`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`cou ntposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`, `ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`links perpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=2 Load time so far: 0.24 seconds. Query 47: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`paren tnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom `,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`t ype`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`order links`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`vie ws`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdel ay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`, `lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linksher e`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`cou ntposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`, `ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`links perpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=3 Load time so far: 0.24 seconds. Query 48: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`paren tnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom `,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`t ype`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`order links`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`vie ws`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdel ay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`, `lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linksher e`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`cou ntposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`, `ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`links perpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=4 Load time so far: 0.24 seconds. Query 49: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`paren tnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom `,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`t ype`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`order links`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`vie ws`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdel ay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`, `lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linksher e`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`cou ntposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`, `ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`links perpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=5 Load time so far: 0.24 seconds. Query 50: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`paren tnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom `,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`t ype`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`order links`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`vie ws`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdel ay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`, `lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linksher e`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`cou ntposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`, `ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`links perpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=6 Load time so far: 0.24 seconds. Query 51: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`paren tnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom `,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`t ype`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`order links`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`vie ws`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdel ay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`, `lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linksher e`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`cou ntposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`, `ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`links perpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=7 Load time so far: 0.24 seconds. Query 52: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`paren tnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom `,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`t ype`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`order links`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`vie ws`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdel ay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`, `lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linksher e`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`cou ntposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`, `ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`links perpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=8 Load time so far: 0.24 seconds. Query 53: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`paren tnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom `,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`t ype`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`order links`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`vie ws`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdel ay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`, `lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linksher e`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`cou ntposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`, `ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`links perpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=9 Load time so far: 0.25 seconds. Query 54: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`paren tnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom `,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`t ype`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`order links`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`vie ws`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdel ay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`, `lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linksher e`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`cou ntposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`, `ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`links perpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=10 Load time so far: 0.25 seconds. Query 55: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`paren tnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom `,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`t ype`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`order links`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`vie ws`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdel ay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`, `lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linksher e`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`cou ntposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`, `ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`links perpage`,`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`,`accept ims`,`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

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 56
Total Posts: 5853

Posted 05/16/07 - 12:52 PM:	#2
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.
_____________________ "Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

treehstn
Member

Usergroup: Customer
Joined: Nov 17, 2006
Total Topics: 6
Total Posts: 19

Posted 05/16/07 - 01:22 PM:	#3
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.

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 56
Total Posts: 5853

Posted 05/17/07 - 05:03 PM:	#4
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.
_____________________ "Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

You don't have permission to post.

Please login or register.