Webmastersite.net
Register Log In

Mysql could change header OR fetch

Comments on Mysql could change header OR fetch

david
Forum Regular

Usergroup: Customer
Joined: Jun 22, 2005

Total Topics: 91
Total Comments: 305
david
Posted Jun 22, 2007 - 10:10 AM:

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
-----------------------------
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Jun 22, 2007 - 11:13 AM:

scripts.webmastersite.net/w...rspan-information-216.html

Make sure you have an administrator email input and don't have spam filtering active, and do have PHP's mail function configured on the server.
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



This thread is closed, so you cannot post a reply.