| Message Text |
Hi Paul,
Just did a fresh on install on a system running:
PHP Version: 5.2.1
Zend Engine Version: 2.2.0
Loaded PHP Extensions: xmlwriter
libxml dom xmlreader xml tokenizer session pcre SimpleXML SPL PDO sockets SQLite standard Reflection posix pdo_sqlite mysqli mysql mcrypt mbstring json iconv hash gd ftp filter exif date curl ctype calendar bcmath zlib apache
Server Type: Apache/1.3.37 (Unix) PHP/5.2.1 mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a
---------------------
Everything looked ok, but when I tried to register a test member, the welcome email never came. The emails can be seen in the Admin Panel Email Log, but the email never went out.
So I turned on the debug and saw that an almost every page, there is some kind of problem, related to the mysql.php (see below). It either cannot modify the header, or cannot fetch something.
Any ideas?
Thanks
David T.
----------------------------
ERROR MESSAGE TOWARDS THE BOTTOM. This came up when I clicked on the Register link on the standard templates after a fresh install (that completed without errors).
Query 2: SHOW COLUMNS FROM wsnlinks_links
Getting field list for table wsnlinks_links: id,title,url,description,rating,votes,validated,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,type,notify,suspect,pendingedit,funds,suspended,alias,expire,ip,inalbum,typeorder,recipurl,hitsin,recipwith,hitsinips,hitsoutips,lastcomment,related,inhidden,viewers,threadviewers,hitsintemp,hitsouttemp,origtype,importance,parentids,timesdead,timesemailed,threadclosed,threadposters,lastposterid,lastpostername,ownername,deleted,deletionreason,movedto,deletedby,timevalidated,filefield,message,sticky,downloads,pollid,posticon,savedby,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime,tagline,keywords
Load time so far: 0.07 seconds.
Query 3: SHOW COLUMNS FROM wsnlinks_categories
Getting field list for table wsnlinks_categories: id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml,linksperpage,wysihtml,numonline
Load time so far: 0.07 seconds.
Query 4: 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
Load time so far: 0.07 seconds.
Query 5: SHOW COLUMNS FROM wsnlinks_membergroups
Getting field list for table wsnlinks_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,cancopy,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,attachperlink,validateattachments,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,bulkpms,issupermod,numinv,allowugspec,validateemails,validatesponsorlinks
Load time so far: 0.07 seconds.
Query 6: SHOW COLUMNS FROM wsnlinks_sessions
Getting field list for table wsnlinks_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.07 seconds.
Load time so far: 0.14 seconds.
Query 7: SELECT `id` FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND isalbum=0 ORDER BY id DESC LIMIT 0,1
Number of rows is 0
Load time so far: 0.14 seconds.
Query 8: UPDATE wsnlinks_settings SET content='0' WHERE name='highestcatindex'
Load time so far: 0.14 seconds.
Query 9: SELECT `name`,`value` FROM wsnlinks_switches WHERE id>0
Number of rows is 72
Query 10: SHOW COLUMNS FROM wsnlinks_email
Getting field list for table wsnlinks_email: id,to,subject,message,headers,timesent,ip,replacement,mime
Load time so far: 0.14 seconds.
Query 11: SHOW COLUMNS FROM wsnlinks_ratings
Getting field list for table wsnlinks_ratings: id,votevalue,time,memberid,ip,custom,linkid,type
Load time so far: 0.14 seconds.
Query 12: SHOW COLUMNS FROM wsnlinks_markup
Getting field list for table wsnlinks_markup: id,type,original,replacement,description,originalclose,replacementclose,sortorder
Load time so far: 0.14 seconds.
Query 13: SHOW COLUMNS FROM wsnlinks_modlog
Getting field list for table wsnlinks_modlog: id,topicid,postid,type,nature,reason,moderatorid,source,destination,time,catid,memberid
Load time so far: 0.14 seconds.
Query 14: SHOW COLUMNS FROM wsnlinks_crons
Getting field list for table wsnlinks_crons: id,frequency,nextrun,filename,native
Load time so far: 0.15 seconds.
Query 15: SHOW COLUMNS FROM wsnlinks_calendar
Getting field list for table wsnlinks_calendar: id,ownerid,title,description,joined,starttime,endtime,date,reminded,validated,time
Load time so far: 0.15 seconds.
Query 16: SHOW COLUMNS FROM wsnlinks_helpcategory
Getting field list for table wsnlinks_helpcategory: id,name,numsubjects,priority
Load time so far: 0.15 seconds.
Query 17: SHOW COLUMNS FROM wsnlinks_helpitem
Getting field list for table wsnlinks_helpitem: id,subject,helptext,priority,category
Load time so far: 0.15 seconds.
Query 18: SHOW COLUMNS FROM wsnlinks_im
Getting field list for table wsnlinks_im: id,toid,fromid,message,time,isread,timeread,deleted
Load time so far: 0.15 seconds.
Query 19: SHOW COLUMNS FROM wsnlinks_searches
Getting field list for table wsnlinks_searches: id,value,memberid,catid,time
Load time so far: 0.15 seconds.
Query 20: SHOW COLUMNS FROM wsnlinks_pm
Getting field list for table wsnlinks_pm: id,toid,fromid,timeread,message,subject,time,icon,folderid,deleted,flag,filefield,important,replyto,replied,sentdeleted,wysihtml,cc
Load time so far: 0.15 seconds.
Load time so far: 0.15 seconds.
Query 21: SELECT `id`,`type`,`original`,`replacement`,`description`,`originalclose`,`replacementclose`,`sortorder` FROM wsnlinks_markup WHERE type='wsncode' ORDER BY sortorder
Number of rows is 23
Query 22: SHOW COLUMNS FROM wsnlinks_attachments
Getting field list for table wsnlinks_attachments: id,type,objectid,filename,filetitle,filesize,width,height,memberid,time,deleted,field,downloads,validated,ownerip,catid
Load time so far: 0.16 seconds.
Query 23: 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,links,comments,English
Load time so far: 0.16 seconds.
Query 24: 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,links,comments,English
Load time so far: 0.17 seconds.
Load time so far: 0.17 seconds.
Query 25: 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`,`cancopy`,`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`,`attachperlink`,`validateattachments`,`caneditownquotes`,`caneditallquotes`,`canviewchat`,`caneditownevents`,`caneditallevents`,`candeleteownevents`,`candeleteevents`,`cansubmitevents`,`validateevents`,`bulkpms`,`issupermod`,`numinv`,`allowugspec`,`validateemails`,`validatesponsorlinks` FROM wsnlinks_membergroups WHERE id>0
Load time so far: 0.17 seconds.
Query 26: SELECT `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`,`links`,`comments`,`English` FROM wsnforum_members WHERE id=2 AND validated=1
Load time so far: 0.18 seconds.
Query 27: SELECT `original`,`replacement`,`description`,`id`,`sortorder` FROM wsnlinks_markup WHERE type='smilie' ORDER BY sortorder
Number of rows is 14
Query 28: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnforum_members WRITE
Load time so far: 0.18 seconds.
Query 29: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM wsnlinks_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,50
Number of rows is 0
Query 30: UNLOCK TABLES
Load time so far: 0.21 seconds.
Query 31: SELECT `id`,`title` FROM wsnlinks_membergroups WHERE id>1 ORDER BY id ASC
Number of rows is 3
Warning: Cannot modify header information - headers already sent by (output started at /home/filmcred/public_html/databases/mysqli.php:14) in /home/filmcred/public_html/end.php on line 146
Load time so far: 0.49 seconds.
Query 32: 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='89.132.104.226' AND memberid=0
Number of rows is 1
Load time so far: 0.49 seconds.
Query 33: UPDATE wsnforum_sessions SET id='5', memberid='0', location='http://www.filmcredit.net/register.php', time='1182531871', ip='89.132.104.226', browser='Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727)', starttime='1182530496', catid='', threadid='', areaname='Registration', lastsearch='0', nopermission='0', inchat='0', name='', isrobot='0', lastchat='0', groupnamestyle='', acceptims='', visibility='' WHERE id=5
----------------------------- |
