Webmastersite.net
Register Log In

Mysql Error

Title Mysql Error
Description Fresh Install
Message Text 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,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.06 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.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,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.06 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='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,replacementclose,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,destination,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,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.12 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.12 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.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`,`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.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,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned,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,topics,posts,chatcolor,traderrating,invitessent,validatedemail,calsub,macros,autosubscribepost,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,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned,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,topics,posts,chatcolor,traderrating,invitessent,validatedemail,calsub,macros,autosubscribepost,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`,`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.13 seconds. Query: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`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`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros`,`autosubscribepost`,`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`,`replyto`,`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`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`alias`,`catcols`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`opwords`,`subscriber`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`linkcols`,`dmozpath`,`linksperpage`,`wysihtml`,`numonline` FROM wsnforum_categories WHERE id=1 Load time so far: 0.27 seconds. Query: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`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
Rating
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5
0/5 based on 0 votes.
Ownership larryjam
Views 546 views. Averaging 0 views per day.
Similar Topics
Submission Date Apr 18, 2007 - 10:09 PM