I am trying to intregate wsnforum with an existing wsnlinks database.
I have wsnlinks version 4.0.25 installed in the root directory of my site. I installed the free version of wsnforum into the "forums" subdirectory, I used the same database that I use for wsnlinks, I used the same ftp info except I add the "forums" directory for the ftp directoy info "/www/mysite.com/forums/
I received the following error after running setup.
"Warning: ftp_chdir() [function.ftp-chdir]: /www/mysite.com/forums/: No such file or directory in /home/www/mysite.com/forums/setup.php"
But it also says sucessful installation.
The script seems to be running except the following error message at the top of the page:
"Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/mysite.com/forums/databases/mysql.php on line 19"
I have double checked the installed info by running setup a second time, same result.
Sounds like your file path to your attachments directory could be incorrect.
except I add the "forums" directory for the ftp directoy info "/www/mysite.com/forums/
Are you sure that's the path from where the FTP account drops you? Actually it can't be since that's not the format there, you have at least two extra slashes compared to what the example pre-filled shows.
Would I be better off installing the forums at forums.mysite.com ?
Here is the Debug Info:
Load time so far: 0.03 seconds.
Query: SELECT `name`,`content` FROM wsnforum_settings WHERE id>0 ORDER BY id ASC
Query: SHOW COLUMNS FROM wsnforum_links
Getting field list for table wsnforum_links: id,title,description,rating,votes,validated,catid,sumofvotes,time,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,type,notify,pendingedit,alias,expire,ip,inalbum,typeorder,hitsoutips,lastcomment,related,inhidden,viewers,threadviewers,hitsouttemp,origtype,importance,parentids,timesemailed,message,lastposterid,lastpostername,sticky,threadclosed,ownername,threadposters,deleted,downloads,funds,deletionreason,movedto,pollid,deletedby,posticon,timevalidated,savedby,email,suspect,suspended,hitsin,hitsinips,hitsintemp,filefield,validatedemail,unpaid,effectivetime,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime
Load time so far: 0.05 seconds.
Query: SHOW COLUMNS FROM wsnforum_categories
Getting field list for table wsnforum_categories: 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
Load time so far: 0.05 seconds.
Query: SHOW COLUMNS FROM wsnforum_members
Getting field list for table wsnforum_members: 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,autosubscribepost,validatedemail,totalhitsin,traderrating,invitessent,newemail,calsub,macros,blogrss,blogcache,watched
Load time so far: 0.05 seconds.
Query: SHOW COLUMNS FROM wsnforum_membergroups
Getting field list for table wsnforum_membergroups: 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,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,validateattachments,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,bulkpms,issupermod,cansuggestban,shoutsperday,cancopy,attachperlink,numinv,allowugspec,validateemails,validatesponsorlinks
Load time so far: 0.06 seconds.
Query: SHOW COLUMNS FROM wsnforum_sessions
Getting field list for table wsnforum_sessions: id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname,lastsearch,nopermission,inchat,name,isrobot,lastchat,groupnamestyle,acceptims,visibility
Load time so far: 0.06 seconds.
Load time so far: 0.11 seconds.
Query: SELECT `id` FROM wsnforum_categories WHERE validated=1 AND hide=0 AND isalbum=0 ORDER BY id DESC LIMIT 0,1
Number of rows is 1
Load time so far: 0.11 seconds.
Query: UPDATE wsnforum_settings SET content=Ƈ' WHERE name='highestcatindex'
Load time so far: 0.12 seconds.
Query: SELECT `name`,`value` FROM wsnforum_switches WHERE id>0
Number of rows is 75
Query: SHOW COLUMNS FROM wsnforum_email
Getting field list for table wsnforum_email: id,to,subject,message,headers,timesent,ip,replacement,mime
Load time so far: 0.12 seconds.
Query: SHOW COLUMNS FROM wsnforum_ratings
Getting field list for table wsnforum_ratings: id,votevalue,time,memberid,ip,custom,linkid,type
Load time so far: 0.12 seconds.
Query: SHOW COLUMNS FROM wsnforum_markup
Getting field list for table wsnforum_markup: id,type,original,replacement,description,originalclose,replacementclose,sortorder
Load time so far: 0.12 seconds.
Query: SHOW COLUMNS FROM wsnforum_modlog
Getting field list for table wsnforum_modlog: id,topicid,postid,type,nature,reason,moderatorid,source,destination,time,catid,memberid
Load time so far: 0.12 seconds.
Query: SHOW COLUMNS FROM wsnforum_crons
Getting field list for table wsnforum_crons: id,frequency,nextrun,filename,native
Load time so far: 0.12 seconds.
Query: SHOW COLUMNS FROM wsnforum_calendar
Getting field list for table wsnforum_calendar: id,ownerid,title,description,joined,starttime,endtime,date,reminded,validated,time
Load time so far: 0.12 seconds.
Query: SHOW COLUMNS FROM wsnforum_helpcategory
Getting field list for table wsnforum_helpcategory: id,name,numsubjects,priority
Load time so far: 0.12 seconds.
Query: SHOW COLUMNS FROM wsnforum_helpitem
Getting field list for table wsnforum_helpitem: id,subject,helptext,priority,category
Load time so far: 0.12 seconds.
Query: SHOW COLUMNS FROM wsnforum_shouts
Getting field list for table wsnforum_shouts: id,ownerid,time,deleted,message,name,ip
Load time so far: 0.12 seconds.
Query: SHOW COLUMNS FROM wsnforum_quotes
Getting field list for table wsnforum_quotes: content,author,id,source,ownerid,ownername,validated
Load time so far: 0.12 seconds.
Query: SHOW COLUMNS FROM wsnforum_im
Getting field list for table wsnforum_im: id,toid,fromid,message,time,isread,timeread,deleted
Load time so far: 0.12 seconds.
Query: SHOW COLUMNS FROM wsnforum_searches
Getting field list for table wsnforum_searches: id,value,memberid,catid,time
Load time so far: 0.13 seconds.
Query: SHOW COLUMNS FROM wsnforum_comments
Getting field list for table wsnforum_comments: 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,originalmessage,disablehtml,disablewsn,flagged,wysihtml,unrevised
Load time so far: 0.13 seconds.
Query: SHOW COLUMNS FROM wsnforum_pm
Getting field list for table wsnforum_pm: id,toid,fromid,timeread,message,subject,time,icon,folderid,deleted,flag,filefield,important,replyto,replied,sentdeleted,cc,wysihtml
Load time so far: 0.13 seconds.
Query: SHOW COLUMNS FROM wsnforum_polls
Getting field list for table wsnforum_polls: id,topicid,catid,question,options,time,endtime,deleted,multi,public,totals
Load time so far: 0.13 seconds.
Query: SHOW COLUMNS FROM wsnforum_pollvotes
Getting field list for table wsnforum_pollvotes: id,pollid,vote,memberid,ip,deleted,membername,time
Load time so far: 0.13 seconds.
Load time so far: 0.13 seconds.
Query: SELECT `id`,`type`,`original`,`replacement`,`description`,`originalclose`,`replacementclose`,`sortorder` FROM wsnforum_markup WHERE type='wsncode' ORDER BY sortorder
Number of rows is 23
Query: SHOW COLUMNS FROM wsnforum_attachments
Getting field list for table wsnforum_attachments: id,type,objectid,filename,filetitle,filesize,width,height,memberid,time,deleted,field,downloads,validated,ownerip,catid
Load time so far: 0.13 seconds.
Load time so far: 0.14 seconds.
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`,`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`,`validateattachments`,`caneditownquotes`,`caneditallquotes`,`canviewchat`,`caneditownevents`,`caneditallevents`,`candeleteownevents`,`candeleteevents`,`cansubmitevents`,`validateevents`,`bulkpms`,`issupermod`,`cansuggestban`,`shoutsperday`,`cancopy`,`attachperlink`,`numinv`,`allowugspec`,`validateemails`,`validatesponsorlinks` FROM wsnforum_membergroups WHERE id>0
Load time so far: 0.14 seconds.
Query: SELECT `original`,`replacement`,`description`,`id`,`sortorder` FROM wsnforum_markup WHERE type='smilie' ORDER BY sortorder
Number of rows is 14
Load time so far: 0.15 seconds.
Query: 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
Query: 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: UNLOCK TABLES
Load time so far: 0.15 seconds.
Query: SELECT `id`,`frequency`,`filename`,`nextrun` FROM wsnforum_crons WHERE nextrun < 1176782699 ORDER BY id ASC LIMIT 0,1
Number of rows is 0
Load time so far: 0.15 seconds.
Query: 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=1 AND validated=1 AND hide=0 AND deleted=0 AND isalbum=0 ORDER BY priority ASC,name ASC LIMIT 0,300
Number of rows is 0
Load time so far: 0.15 seconds.
Query: SELECT COUNT(id) FROM wsnforum_links WHERE catid=1 AND hide=0 AND deleted=0 AND validated=1 AND effectivetime < 1176782699
Count is 0
Load time so far: 0.15 seconds.
Query: SELECT COUNT(id) FROM wsnforum_links WHERE catid=1 AND hide=0 AND deleted=0 AND validated=1 AND effectivetime < 1176782699
Count is 0
Setting cookie with name returnto, value index.php?action=displaycat&catid=1 and duration 1176783600
Warning: Cannot modify header information - headers already sent by (output started at /home/www/durhamlinks.com/forums/classes/database.php:248) in /home/www/durhamlinks.com/forums/commonfuncs.php on line 713
Warning: Cannot modify header information - headers already sent by (output started at /home/www/durhamlinks.com/forums/classes/database.php:248) in /home/www/durhamlinks.com/forums/commonfuncs.php on line 717
Warning: Cannot modify header information - headers already sent by (output started at /home/www/durhamlinks.com/forums/classes/database.php:248) in /home/www/durhamlinks.com/forums/end.php on line 145
Load time so far: 0.22 seconds.
Query: 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 > 1176781800 AND (catid=1 AND memberid>0) ORDER BY time DESC LIMIT 0,100
Number of rows is 0
Load time so far: 0.29 seconds.
Query: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility` FROM wsnforum_sessions WHERE ip=྆.119.42.57' AND memberid=0
Number of rows is 1
Load time so far: 0.29 seconds.
Query: UPDATE wsnforum_sessions SET id=ƈ', memberid=Ɔ', location='http://www.durhamlinks.com/forums/index.php?action=displaycat&catid=1&debug=1', time=?', ip=྆.119.42.57', browser='Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)', starttime=?', catid=Ƈ', threadid='', areaname='Sample Forum', lastsearch=?', nopermission=Ɔ', inchat=Ɔ', name='', isrobot=Ɔ', lastchat=Ɔ', groupnamestyle='', acceptims='', visibility='' WHERE id=2
Also I cannot access the forum at www.mysite.com/forums/ I receive an page from wsnlinks that says "The page does not exist" I can only access the forum at www.mysite.com/forums/index.php
I think I have solved this problem. I added this to .htaccess:
RewriteRule ^forums/?$ forums/index.php
That part works fine now but I still have the error posted above all all "index.php" pages. The error is not there on "comment.php", "register.php", "search.php" etc, only index.php.
Comments on Installation Error
Member
Usergroup: Customer
Joined: Sep 25, 2003
Location: Canada
Total Topics: 22
Total Comments: 48
I am trying to intregate wsnforum with an existing wsnlinks database.
I have wsnlinks version 4.0.25 installed in the root directory of my site. I installed the free version of wsnforum into the "forums" subdirectory, I used the same database that I use for wsnlinks, I used the same ftp info except I add the "forums" directory for the ftp directoy info "/www/mysite.com/forums/
I received the following error after running setup.
"Warning: ftp_chdir() [function.ftp-chdir]: /www/mysite.com/forums/: No such file or directory in /home/www/mysite.com/forums/setup.php"
But it also says sucessful installation.
The script seems to be running except the following error message at the top of the page:
"Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/mysite.com/forums/databases/mysql.php on line 19"
I have double checked the installed info by running setup a second time, same result.
I have attached the debug file.
Attached Files:
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Sounds like your file path to your attachments directory could be incorrect.
except I add the "forums" directory for the ftp directoy info "/www/mysite.com/forums/
Are you sure that's the path from where the FTP account drops you? Actually it can't be since that's not the format there, you have at least two extra slashes compared to what the example pre-filled shows.
You don't seem to have provided the debug for the mysql warning, which is what debug mode is for (it's no use with the ftp message): www.wsnforum.com/wsnmanual/...icles/mysql-errors-66.html
Member
Usergroup: Customer
Joined: Sep 25, 2003
Location: Canada
Total Topics: 22
Total Comments: 48
Ok, I corrected the ftp path and that has gotten rid of the ftp error, but I still have the mysql error.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/durhamlinks.com/forums/databases/mysql.php on line 19
The error shows up when logged in as admin and when logged out. The error occurs when clicking on the sample category.
Also I cannot access the forum at www.mysite.com/forums/ I receive an page from wsnlinks that says "The page does not exist" I can only access the forum at www.mysite.com/forums/index.php
Would I be better off installing the forums at forums.mysite.com ?
Here is the Debug Info:
Load time so far: 0.03 seconds.
Query: SELECT `name`,`content` FROM wsnforum_settings WHERE id>0 ORDER BY id ASC
Query: SHOW COLUMNS FROM wsnforum_links
Getting field list for table wsnforum_links: id,title,description,rating,votes,validated,catid,sumofvotes,time,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,type,notify,pendingedit,alias,expire,ip,inalbum,typeorder,hitsoutips,lastcomment,related,inhidden,viewers,threadviewers,hitsouttemp,origtype,importance,parentids,timesemailed,message,lastposterid,lastpostername,sticky,threadclosed,ownername,threadposters,deleted,downloads,funds,deletionreason,movedto,pollid,deletedby,posticon,timevalidated,savedby,email,suspect,suspended,hitsin,hitsinips,hitsintemp,filefield,validatedemail,unpaid,effectivetime,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime
Load time so far: 0.05 seconds.
Query: SHOW COLUMNS FROM wsnforum_categories
Getting field list for table wsnforum_categories: 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
Load time so far: 0.05 seconds.
Query: SHOW COLUMNS FROM wsnforum_members
Getting field list for table wsnforum_members: 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,autosubscribepost,validatedemail,totalhitsin,traderrating,invitessent,newemail,calsub,macros,blogrss,blogcache,watched
Load time so far: 0.05 seconds.
Query: SHOW COLUMNS FROM wsnforum_membergroups
Getting field list for table wsnforum_membergroups: 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,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,validateattachments,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,bulkpms,issupermod,cansuggestban,shoutsperday,cancopy,attachperlink,numinv,allowugspec,validateemails,validatesponsorlinks
Load time so far: 0.06 seconds.
Query: SHOW COLUMNS FROM wsnforum_sessions
Getting field list for table wsnforum_sessions: id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname,lastsearch,nopermission,inchat,name,isrobot,lastchat,groupnamestyle,acceptims,visibility
Load time so far: 0.06 seconds.
Load time so far: 0.11 seconds.
Query: SELECT `id` FROM wsnforum_categories WHERE validated=1 AND hide=0 AND isalbum=0 ORDER BY id DESC LIMIT 0,1
Number of rows is 1
Load time so far: 0.11 seconds.
Query: UPDATE wsnforum_settings SET content=Ƈ' WHERE name='highestcatindex'
Load time so far: 0.12 seconds.
Query: SELECT `name`,`value` FROM wsnforum_switches WHERE id>0
Number of rows is 75
Query: SHOW COLUMNS FROM wsnforum_email
Getting field list for table wsnforum_email: id,to,subject,message,headers,timesent,ip,replacement,mime
Load time so far: 0.12 seconds.
Query: SHOW COLUMNS FROM wsnforum_ratings
Getting field list for table wsnforum_ratings: id,votevalue,time,memberid,ip,custom,linkid,type
Load time so far: 0.12 seconds.
Query: SHOW COLUMNS FROM wsnforum_markup
Getting field list for table wsnforum_markup: id,type,original,replacement,description,originalclose,replacementclose,sortorder
Load time so far: 0.12 seconds.
Query: SHOW COLUMNS FROM wsnforum_modlog
Getting field list for table wsnforum_modlog: id,topicid,postid,type,nature,reason,moderatorid,source,destination,time,catid,memberid
Load time so far: 0.12 seconds.
Query: SHOW COLUMNS FROM wsnforum_crons
Getting field list for table wsnforum_crons: id,frequency,nextrun,filename,native
Load time so far: 0.12 seconds.
Query: SHOW COLUMNS FROM wsnforum_calendar
Getting field list for table wsnforum_calendar: id,ownerid,title,description,joined,starttime,endtime,date,reminded,validated,time
Load time so far: 0.12 seconds.
Query: SHOW COLUMNS FROM wsnforum_helpcategory
Getting field list for table wsnforum_helpcategory: id,name,numsubjects,priority
Load time so far: 0.12 seconds.
Query: SHOW COLUMNS FROM wsnforum_helpitem
Getting field list for table wsnforum_helpitem: id,subject,helptext,priority,category
Load time so far: 0.12 seconds.
Query: SHOW COLUMNS FROM wsnforum_shouts
Getting field list for table wsnforum_shouts: id,ownerid,time,deleted,message,name,ip
Load time so far: 0.12 seconds.
Query: SHOW COLUMNS FROM wsnforum_quotes
Getting field list for table wsnforum_quotes: content,author,id,source,ownerid,ownername,validated
Load time so far: 0.12 seconds.
Query: SHOW COLUMNS FROM wsnforum_im
Getting field list for table wsnforum_im: id,toid,fromid,message,time,isread,timeread,deleted
Load time so far: 0.12 seconds.
Query: SHOW COLUMNS FROM wsnforum_searches
Getting field list for table wsnforum_searches: id,value,memberid,catid,time
Load time so far: 0.13 seconds.
Query: SHOW COLUMNS FROM wsnforum_comments
Getting field list for table wsnforum_comments: 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,originalmessage,disablehtml,disablewsn,flagged,wysihtml,unrevised
Load time so far: 0.13 seconds.
Query: SHOW COLUMNS FROM wsnforum_pm
Getting field list for table wsnforum_pm: id,toid,fromid,timeread,message,subject,time,icon,folderid,deleted,flag,filefield,important,replyto,replied,sentdeleted,cc,wysihtml
Load time so far: 0.13 seconds.
Query: SHOW COLUMNS FROM wsnforum_polls
Getting field list for table wsnforum_polls: id,topicid,catid,question,options,time,endtime,deleted,multi,public,totals
Load time so far: 0.13 seconds.
Query: SHOW COLUMNS FROM wsnforum_pollvotes
Getting field list for table wsnforum_pollvotes: id,pollid,vote,memberid,ip,deleted,membername,time
Load time so far: 0.13 seconds.
Load time so far: 0.13 seconds.
Query: SELECT `id`,`type`,`original`,`replacement`,`description`,`originalclose`,`replacementclose`,`sortorder` FROM wsnforum_markup WHERE type='wsncode' ORDER BY sortorder
Number of rows is 23
Query: SHOW COLUMNS FROM wsnforum_attachments
Getting field list for table wsnforum_attachments: id,type,objectid,filename,filetitle,filesize,width,height,memberid,time,deleted,field,downloads,validated,ownerip,catid
Load time so far: 0.13 seconds.
Load time so far: 0.14 seconds.
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`,`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`,`validateattachments`,`caneditownquotes`,`caneditallquotes`,`canviewchat`,`caneditownevents`,`caneditallevents`,`candeleteownevents`,`candeleteevents`,`cansubmitevents`,`validateevents`,`bulkpms`,`issupermod`,`cansuggestban`,`shoutsperday`,`cancopy`,`attachperlink`,`numinv`,`allowugspec`,`validateemails`,`validatesponsorlinks` FROM wsnforum_membergroups WHERE id>0
Load time so far: 0.14 seconds.
Query: SELECT `original`,`replacement`,`description`,`id`,`sortorder` FROM wsnforum_markup WHERE type='smilie' ORDER BY sortorder
Number of rows is 14
Load time so far: 0.15 seconds.
Query: 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
Query: LOCK TABLES wsnforum_email WRITE, wsnforum_links WRITE, wsnforum_categories WRITE, wsnforum_members WRITE
Load time so far: 0.15 seconds.
Query: 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: UNLOCK TABLES
Load time so far: 0.15 seconds.
Query: SELECT `id`,`frequency`,`filename`,`nextrun` FROM wsnforum_crons WHERE nextrun < 1176782699 ORDER BY id ASC LIMIT 0,1
Number of rows is 0
Load time so far: 0.15 seconds.
Query: 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=1 AND validated=1 AND hide=0 AND deleted=0 AND isalbum=0 ORDER BY priority ASC,name ASC LIMIT 0,300
Number of rows is 0
Load time so far: 0.15 seconds.
Query: SELECT COUNT(id) FROM wsnforum_links WHERE catid=1 AND hide=0 AND deleted=0 AND validated=1 AND effectivetime < 1176782699
Count is 0
Load time so far: 0.15 seconds.
Query: SELECT COUNT(id) FROM wsnforum_links WHERE catid=1 AND hide=0 AND deleted=0 AND validated=1 AND effectivetime < 1176782699
Count is 0
Setting cookie with name returnto, value index.php?action=displaycat&catid=1 and duration 1176783600
Warning: Cannot modify header information - headers already sent by (output started at /home/www/durhamlinks.com/forums/classes/database.php:248) in /home/www/durhamlinks.com/forums/commonfuncs.php on line 713
Warning: Cannot modify header information - headers already sent by (output started at /home/www/durhamlinks.com/forums/classes/database.php:248) in /home/www/durhamlinks.com/forums/commonfuncs.php on line 717
Warning: Cannot modify header information - headers already sent by (output started at /home/www/durhamlinks.com/forums/classes/database.php:248) in /home/www/durhamlinks.com/forums/end.php on line 145
Load time so far: 0.22 seconds.
Query: 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 > 1176781800 AND (catid=1 AND memberid>0) ORDER BY time DESC LIMIT 0,100
Number of rows is 0
Load time so far: 0.29 seconds.
Query: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility` FROM wsnforum_sessions WHERE ip=྆.119.42.57' AND memberid=0
Number of rows is 1
Load time so far: 0.29 seconds.
Query: UPDATE wsnforum_sessions SET id=ƈ', memberid=Ɔ', location='http://www.durhamlinks.com/forums/index.php?action=displaycat&catid=1&debug=1', time=?', ip=྆.119.42.57', browser='Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)', starttime=?', catid=Ƈ', threadid='', areaname='Sample Forum', lastsearch=?', nopermission=Ɔ', inchat=Ɔ', name='', isrobot=Ɔ', lastchat=Ɔ', groupnamestyle='', acceptims='', visibility='' WHERE id=2
Member
Usergroup: Customer
Joined: Sep 25, 2003
Location: Canada
Total Topics: 22
Total Comments: 48
Also I cannot access the forum at www.mysite.com/forums/ I receive an page from wsnlinks that says "The page does not exist" I can only access the forum at www.mysite.com/forums/index.php
I think I have solved this problem. I added this to .htaccess:
RewriteRule ^forums/?$ forums/index.php
That part works fine now but I still have the error posted above all all "index.php" pages. The error is not there on "comment.php", "register.php", "search.php" etc, only index.php.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
You didn't post a mysql warning above, your debug info has no such message.
I notice you're not using the current version though, and there was an error a few weeks ago.
You should let it write the .htaccess for you. It'll calculate the rewrite base so it works.