Installation Error: WSN Support

Quick Links open

New Posts Member List

WSN Support » WSN Forum » Installation Error » Installation Error

Installation Error

Version: 2.0.13 (Free Version)
Example URL: www.durhamlinks.com/forums/index.php

Installation Error

larryjam
Member

Usergroup: Customer
Joined: Sep 25, 2003
Location: Canada
Total Topics: 15
Total Posts: 41

Posted 04/14/07 - 12:40 PM:	#1
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: error.txt (118 KB, 26 downloads) _____________________ Larry Durham Links Directory

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 5796

Posted 04/16/07 - 04:55 PM:	#2
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): http://www.wsnforum.com/wsnmanual/articles/mysql-... Edited by Paul on 04/16/07 - 04:58 PM
_____________________ "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, founcer of Red Hat

larryjam
Member

Usergroup: Customer
Joined: Sep 25, 2003
Location: Canada
Total Topics: 15
Total Posts: 41

Posted 04/16/07 - 09:07 PM:	#3
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&#62;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,lasted it,type,notify,pendingedit,alias,expire,ip,inalbum,typeorder ,hitsoutips,lastcomment,related,inhidden,viewers,threadviewe rs,hitsouttemp,origtype,importance,parentids,timesemailed,me ssage,lastposterid,lastpostername,sticky,threadclosed,ownern ame,threadposters,deleted,downloads,funds,deletionreason,mov edto,pollid,deletedby,posticon,timevalidated,savedby,email,s uspect,suspended,hitsin,hitsinips,hitsintemp,filefield,valid atedemail,unpaid,effectivetime,wysihtml,movedid,unrevised,fe edurl,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,parent ids,numlinks,hide,lastlinktime,custom,lastedit,moderators,he aderinfo,related,numsub,type,permissions,subscribers,mixtype s,isalbum,orderlinks,totalcomments,alias,catcols,sponsorlink s,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,pr iority,levelsdeep,lastposterid,lastpostername,lastcommenttim e,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,un validatedcomments,actaslink,countposts,subcatshtml,opwords,s ubscriber,ulsearchmax,ulsearchquery,ulsearchadult,linkcols,d mozpath,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,avatarna me,stylesheet,allowuseremail,albumid,failedattempts,totalbyt es,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,n otifyofpms,acceptpms,cookieduration,banned,topics,posts,loca tion,homepage,occupation,bio,aim,icq,msn,yahoo,inactive,time online,totalpms,buddies,ignored,isonline,acceptims,adminperm issions,referrer,groupreverttime,grouprevertto,moderationpm, secondarygroups,linksperpage,commentsperpage,shouts,customti tle,shoutban,topicbans,forumbans,visibility,birthdate,lastse ssion,interests,posteditor,forumaccess,pmpopup,pmnotify,modn otes,guestnotes,salt,lastmodnote,newpms,imflag,orderalbums,l astguestnote,autosubscribe,notifymethod,showavatars,showsigs ,warninglevel,chatcolor,autosubscribepost,validatedemail,tot alhitsin,traderrating,invitessent,newemail,calsub,macros,blo grss,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,canem ail,validatecats,validatecomments,validatelinks,validateedit s,cansubmitlinks,cansubmitcategories,cansubmitcomments,caned itownlinks,caneditowncategories,caneditowncomments,caneditow nprofile,caneditalllinks,caneditallcategories,caneditallcomm ents,caneditallprofiles,candownloadfiles,canupload,canviewip ,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canal ias,candeleteown,candeleteall,candofulledit,candeletecategor ies,candeletecomments,candeleteowncategories,candeleteowncom ments,candeletemembers,candeleteownmembers,canaliascategorie s,canviewpages,caneditvotes,numaliases,canviewvotes,canhideo wnlinks,canhideowncategories,canhideowncomments,canhideallli nks,canhideallcategories,canhideallcomments,canratecomments, bytespermem,canpm,canim,canharddelete,limitpms,limitpmsdaily ,canviewdeleted,cansubmitpolls,candeletepolls,candeleteownpo lls,caneditpolls,caneditownpolls,attachperpost,attachperpm,c anviewshouts,caneditshouts,caneditownshouts,candeleteshouts, candeleteownshouts,cansubmitshouts,canpollvote,customtitle,c anviewinvisible,namestyle,canpmimportant,canviewmodlog,islea der,cansubmitquotes,validatequotes,candeletequotes,candelete ownquotes,canreport,canusesearch,validateattachments,canedit ownquotes,caneditallquotes,canviewchat,caneditownevents,cane ditallevents,candeleteownevents,candeleteevents,cansubmiteve nts,validateevents,bulkpms,issupermod,cansuggestban,shoutspe rday,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,threadi d,areaname,lastsearch,nopermission,inchat,name,isrobot,lastc hat,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&#62;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,repla cementclose,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,dest ination,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,r eminded,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,owne rid,lastedit,type,approved,votes,hide,typeorder,lasteditby,c atid,editreason,preventedit,inhidden,deleted,deletionreason, usernoteon,modnote,filefield,title,deletedby,parentids,disab lesmilies,disablesig,icon,originalmessage,disablehtml,disabl ewsn,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,d eleted,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`,`original close`,`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,me mberid,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`,`valid atelinks`,`validateedits`,`cansubmitlinks`,`cansubmitcategor ies`,`cansubmitcomments`,`caneditownlinks`,`caneditowncatego ries`,`caneditowncomments`,`caneditownprofile`,`caneditallli nks`,`caneditallcategories`,`caneditallcomments`,`caneditall profiles`,`candownloadfiles`,`canupload`,`canviewip`,`limitl inks`,`canemailmembers`,`canusehtml`,`limitlinksdaily`,`cana lias`,`candeleteown`,`candeleteall`,`candofulledit`,`candele tecategories`,`candeletecomments`,`candeleteowncategories`,` candeleteowncomments`,`candeletemembers`,`candeleteownmember s`,`canaliascategories`,`canviewpages`,`caneditvotes`,`numal iases`,`canviewvotes`,`canhideownlinks`,`canhideowncategorie s`,`canhideowncomments`,`canhidealllinks`,`canhideallcategor ies`,`canhideallcomments`,`canratecomments`,`bytespermem`,`c anpm`,`canim`,`canharddelete`,`limitpms`,`limitpmsdaily`,`ca nviewdeleted`,`cansubmitpolls`,`candeletepolls`,`candeleteow npolls`,`caneditpolls`,`caneditownpolls`,`attachperpost`,`at tachperpm`,`canviewshouts`,`caneditshouts`,`caneditownshouts `,`candeleteshouts`,`candeleteownshouts`,`cansubmitshouts`,` canpollvote`,`customtitle`,`canviewinvisible`,`namestyle`,`c anpmimportant`,`canviewmodlog`,`isleader`,`cansubmitquotes`, `validatequotes`,`candeletequotes`,`candeleteownquotes`,`can report`,`canusesearch`,`validateattachments`,`caneditownquot es`,`caneditallquotes`,`canviewchat`,`caneditownevents`,`can editallevents`,`candeleteownevents`,`candeleteevents`,`cansu bmitevents`,`validateevents`,`bulkpms`,`issupermod`,`cansugg estban`,`shoutsperday`,`cancopy`,`attachperlink`,`numinv`,`a llowugspec`,`validateemails`,`validatesponsorlinks` FROM wsnforum_membergroups WHERE id&#62;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`,`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 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 &#60; 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`,`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=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 &#60; 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 &#60; 1176782699 Count is 0 Setting cookie with name returnto, value index.php?action=displaycat&amp;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`,`accept ims`,`visibility` FROM wsnforum_sessions WHERE time &#62; 1176781800 AND (catid=1 AND memberid&#62;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`,`accept ims`,`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&amp;catid=1&amp;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 Edited by larryjam on 04/16/07 - 09:15 PM
_____________________ Larry Durham Links Directory

larryjam
Member

Usergroup: Customer
Joined: Sep 25, 2003
Location: Canada
Total Topics: 15
Total Posts: 41

Posted 04/17/07 - 07:13 PM:	#4
larryjam wrote: 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 "http://www.webmastersite.net/forums/" pages. The error is not there on "comment.php", "register.php", "search.php" etc, only index.php.
_____________________ Larry Durham Links Directory

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 5796

Posted 04/17/07 - 08:55 PM:	#5
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. Edited by Paul on 04/17/07 - 08:58 PM
_____________________ "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, founcer of Red Hat

You don't have permission to post.

Please login or register.