Mysql Error: WSN Support

Quick Links open

New Posts Member List

WSN Support » WSN Forum » Mysql Error » Mysql Error

Mysql Error
Fresh Install

Version: 2.0.14
Example URL: http://www.durhamlinks.com/forums/privatemessaging.php

Mysql Error

larryjam
Member

Usergroup: Customer
Joined: Sep 25, 2003
Location: Canada
Total Topics: 16
Total Posts: 44

Posted 04/18/07 - 08:09 PM:	#1
After having problems with mysql error in 2.0.23, I have done fresh install with 2.0.14. Installation went fine, I enabled seo mod-rewrite, went fine. I then intregrated with wsnlinks through admin panel, and it went fine. My member list at wsnforum now contains my wsnlinks members. Everything looks fine except msql error at www.mysite.com/forums/privatemessaging.php , this is the only place I notice the error appear, I see another intregration switch in the admin panel under "Customizations / Intregration Generator" It says "Please select the members table of the script you're trying to integrate with from the list of tables in your database", there is a wsnlinks_pm option there, Do I need to select this? I selected wsnlinks_pm and clicked next but the next step got complicated and I thought I better ask first, could I just leave all selections as the defalut "not applicable" Do I need to do this for each table? I will paste debug file from from: www.mysite.com/forums/privatemessaging.php?debug=1 _________________________ Load time so far: 0.04 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,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.06 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.06 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.06 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='1' WHERE name='highestcatindex' Load time so far: 0.11 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.11 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.11 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.11 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.11 seconds. Query: SHOW COLUMNS FROM wsnforum_crons Getting field list for table wsnforum_crons: id,frequency,nextrun,filename,native Load time so far: 0.11 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.12 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.12 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.12 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.12 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.12 seconds. Load time so far: 0.12 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.12 seconds. Query: SHOW COLUMNS FROM wsnlinks_members Getting field list for table wsnlinks_members: id,name,links,comments,time,usergroup,password,ip,totalhits, totalhitsin,email,validated,template,language,lastattempt,al lowemail,signature,avatarname,stylesheet,allowuseremail,albu mid,failedattempts,totalbytes,funds,notifyoflinks,lastvisit, timezone,rating,pmfolders,notifyofpms,acceptpms,cookiedurati on,banned,location,homepage,occupation,bio,aim,icq,msn,yahoo ,inactive,timeonline,totalpms,buddies,ignored,isonline,accep tims,adminpermissions,referrer,groupreverttime,grouprevertto ,moderationpm,secondarygroups,linksperpage,commentsperpage,s houts,customtitle,shoutban,topicbans,forumbans,visibility,bi rthdate,lastsession,interests,posteditor,forumaccess,pmpopup ,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag ,orderalbums,lastguestnote,autosubscribe,notifymethod,showav atars,showsigs,warninglevel,topics,posts,chatcolor,traderrat ing,invitessent,validatedemail,calsub,macros,autosubscribepo st,newemail,blogrss,blogcache,watched Load time so far: 0.13 seconds. Query: SHOW COLUMNS FROM wsnlinks_members Getting field list for table wsnlinks_members: id,name,links,comments,time,usergroup,password,ip,totalhits, totalhitsin,email,validated,template,language,lastattempt,al lowemail,signature,avatarname,stylesheet,allowuseremail,albu mid,failedattempts,totalbytes,funds,notifyoflinks,lastvisit, timezone,rating,pmfolders,notifyofpms,acceptpms,cookiedurati on,banned,location,homepage,occupation,bio,aim,icq,msn,yahoo ,inactive,timeonline,totalpms,buddies,ignored,isonline,accep tims,adminpermissions,referrer,groupreverttime,grouprevertto ,moderationpm,secondarygroups,linksperpage,commentsperpage,s houts,customtitle,shoutban,topicbans,forumbans,visibility,bi rthdate,lastsession,interests,posteditor,forumaccess,pmpopup ,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag ,orderalbums,lastguestnote,autosubscribe,notifymethod,showav atars,showsigs,warninglevel,topics,posts,chatcolor,traderrat ing,invitessent,validatedemail,calsub,macros,autosubscribepo st,newemail,blogrss,blogcache,watched Load time so far: 0.13 seconds. Load time so far: 0.13 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>0 Load time so far: 0.13 seconds. Query: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password` ,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`templat e`,`language`,`lastattempt`,`allowemail`,`signature`,`avatar name`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempt s`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezon e`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookiedur ation`,`banned`,`location`,`homepage`,`occupation`,`bio`,`ai m`,`icq`,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`b uddies`,`ignored`,`isonline`,`acceptims`,`adminpermissions`, `referrer`,`groupreverttime`,`grouprevertto`,`moderationpm`, `secondarygroups`,`linksperpage`,`commentsperpage`,`shouts`, `customtitle`,`shoutban`,`topicbans`,`forumbans`,`visibility `,`birthdate`,`lastsession`,`interests`,`posteditor`,`foruma ccess`,`pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,` lastmodnote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote` ,`autosubscribe`,`notifymethod`,`showavatars`,`showsigs`,`wa rninglevel`,`topics`,`posts`,`chatcolor`,`traderrating`,`inv itessent`,`validatedemail`,`calsub`,`macros`,`autosubscribep ost`,`newemail`,`blogrss`,`blogcache`,`watched` FROM wsnlinks_members WHERE id=1 AND validated=1 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 Query: LOCK TABLES wsnforum_email WRITE, wsnforum_links WRITE, wsnforum_categories WRITE, wsnlinks_members WRITE Load time so far: 0.14 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 COUNT(*) FROM wsnlinks_pm WHERE (folderid='' OR folderid='0') AND toid=1 AND deleted=0 AND time > 0 Count is 0 Load time so far: 0.15 seconds. Query: SELECT `id`,`toid`,`fromid`,`timeread`,`message`,`subject`,`time`,` icon`,`folderid`,`deleted`,`flag`,`filefield`,`important`,`r eplyto`,`replied`,`sentdeleted`,`cc`,`wysihtml` FROM wsnlinks_pm WHERE (folderid='' OR folderid='0') AND toid=1 AND deleted=0 AND time > 0 ORDER BY time DESC LIMIT 0,25 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 Number of rows is Unknown column 'cc' in 'field list' 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 147 Load time so far: 0.2 seconds. Unknown column 'cc' in 'field list' 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 Load time so far: 0.27 seconds. Query: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime` ,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,` inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`accept ims`,`visibility` FROM wsnlinks_sessions WHERE memberid=1 Number of rows is 1 Load time so far: 0.27 seconds. Query: UPDATE wsnlinks_sessions SET id='319', memberid='1', location='http://www.durhamlinks.com/forums/privatemessaging.php?debug=1', time='1176949265', ip='74.119.42.57', browser='Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322)', starttime='1176948816', catid='', threadid='', areaname='Private Messaging', lastsearch='0', nopermission='0', inchat='0', name='admin', isrobot='0', lastchat='0', groupnamestyle='admincolor', acceptims='none', visibility='everyone' WHERE id=319
_____________________ Larry Durham Links Directory

Paul
Administrator

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

Posted 04/18/07 - 09:23 PM:	#2
Looks like WSN Links is somehow missing the cc field for PMs that WSN Forum has. I'll add it for 4.0.26. Edited by Paul on 04/18/07 - 09:32 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, founder of Red Hat

You don't have permission to post.

Please login or register.