| Message Text |
I'm also getting mysql errors after upgrading from 4.0.33 to 4.1.62
After going through the manual and learning how to get the debug output it says to post the results here.
It's only showing up on the front page. /index.php
Load time so far: 0.03 seconds.
Query 1: SELECT `name`,`content` FROM wsnlinks_settings WHERE id>0 ORDER BY id ASC
Number of rows is 480
Load time so far: 0.05 seconds.
Query 2: SELECT `name`,`value` FROM wsnlinks_switches WHERE id>0
Number of rows is 93
Load time so far: 0.05 seconds.
Query 3: SELECT `id`,`type`,`original`,`replacement`,`description`,`original close`,`replacementclose`,`sortorder` FROM wsnlinks_markup WHERE type='wsncode' ORDER BY sortorder
Number of rows is 22
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Creating markup with Array as row
Load time so far: 0.06 seconds.
Query 4: 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`,`cancopy`,`candeleteown`,`candeleteall`,`candofulledit `,`candeletecategories`,`candeletecomments`,`candeleteowncat egories`,`candeleteowncomments`,`candeletemembers`,`candelet eownmembers`,`canaliascategories`,`canviewpages`,`caneditvot es`,`numaliases`,`canviewvotes`,`canhideownlinks`,`canhideow ncategories`,`canhideowncomments`,`canhidealllinks`,`canhide allcategories`,`canhideallcomments`,`canratecomments`,`bytes permem`,`canpm`,`canim`,`canharddelete`,`limitpms`,`limitpms daily`,`canviewdeleted`,`cansubmitpolls`,`candeletepolls`,`c andeleteownpolls`,`caneditpolls`,`caneditownpolls`,`attachpe rpost`,`attachperpm`,`canviewshouts`,`caneditshouts`,`canedi townshouts`,`candeleteshouts`,`candeleteownshouts`,`cansubmi tshouts`,`canpollvote`,`customtitle`,`canviewinvisible`,`nam estyle`,`canpmimportant`,`canviewmodlog`,`isleader`,`cansubm itquotes`,`validatequotes`,`candeletequotes`,`candeleteownqu otes`,`canreport`,`canusesearch`,`attachperlink`,`validateat tachments`,`caneditownquotes`,`caneditallquotes`,`canviewcha t`,`caneditownevents`,`caneditallevents`,`candeleteownevents `,`candeleteevents`,`cansubmitevents`,`validateevents`,`bulk pms`,`issupermod`,`numinv`,`allowugspec`,`validateemails`,`v alidatesponsorlinks`,`cansubmittags`,`candeletetags`,`cansub mitfeeds`,`validatefeeds`,`validatefeeditems`,`numaliasestot `,`shoutsperday`,`validatetrader`,`renewdays`,`renewtimes`,` canviewownfulltrc`,`canviewallfulltrc` FROM wsnlinks_membergroups WHERE id>0
Load time so far: 0.07 seconds.
Query 5: 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`,`newemail`,`calsub`,`macros`,`gue stnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost `,`blogrss`,`positivepct`,`notifytrader` FROM wsnlinks_members WHERE id='3' AND validated=1
Load time so far: 0.08 seconds.
Query 6: SELECT `original`,`replacement`,`description`,`id`,`sortorder` FROM wsnlinks_markup WHERE type='smilie' ORDER BY sortorder
Number of rows is 14
Load time so far: 0.08 seconds.
Query 7: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM wsnlinks_email WHERE timesent=0 AND inprogress=0 ORDER BY id ASC LIMIT 0,10
Number of rows is 0
Load time so far: 0.08 seconds.
Query 8: UPDATE wsnlinks_email SET inprogress='0' WHERE
Load time so far: 0.08 seconds.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Query 9: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`wi dth`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads `,`validated`,`ownerip`,`catid`,`importurl` FROM wsnlinks_attachments WHERE importurl != '' ORDER BY id ASC LIMIT 0,1
Number of rows is 0
Load time so far: 0.08 seconds.
Query 10: SELECT `id`,`frequency`,`filename`,`nextrun` FROM wsnlinks_crons WHERE nextrun < 1218954569 ORDER BY id ASC LIMIT 0,1
Number of rows is 0
Load time so far: 0.09 seconds.
Query 11: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=0 AND deleted=0 AND hide=0 AND isalbum=0 AND validated=1
Count is 2
Load time so far: 0.09 seconds.
Query 12: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`paren tnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom `,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`t ype`,`permissions`,`subscribers`,`subscriber`,`mixtypes`,`is album`,`orderlinks`,`totalcomments`,`ulsearchmax`,`ulsearchq uery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath `,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,` reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposter id`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastt hreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomme nts`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,` wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaul tnoaccess`,`lastthreadurl`,`lastposturl` FROM wsnlinks_categories WHERE parent=0 AND validated=1 AND hide=0 AND isalbum=0 AND deleted=0 ORDER BY catcols ASC,name ASC LIMIT 0,40
Number of rows is 2
Creating category with Array as row
Creating category with Array as row
Setting cookie with name returnto, value http://www.finsandfur.net/index.php?debug=1 and expiration time 0
Warning: Cannot modify header information - headers already sent by (output started at /home/finsnet/public_html/classes/database.php:249) in /home/finsnet/public_html/includes/commonfuncs.php on line 746
Warning: Cannot modify header information - headers already sent by (output started at /home/finsnet/public_html/classes/database.php:249) in /home/finsnet/public_html/includes/commonfuncs.php on line 750
Warning: Cannot modify header information - headers already sent by (output started at /home/finsnet/public_html/classes/database.php:249) in /home/finsnet/public_html/end.php on line 71
Load time so far: 0.13 seconds.
Query 13: SELECT COUNT(id) FROM wsnlinks_sessions WHERE memberid>0
Count is 1
Load time so far: 0.13 seconds.
Query 14: SELECT COUNT(id) FROM wsnlinks_sessions WHERE memberid=0 AND isrobot=0
Count is 1
Load time so far: 0.13 seconds.
Query 15: SELECT COUNT(id) FROM wsnlinks_sessions WHERE memberid=0 AND isrobot=1
Count is 1
Load time so far: 0.14 seconds.
Query 16: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime` ,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,` inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`accept ims`,`visibility`,`profileurl` FROM wsnlinks_sessions WHERE time > 1218953969 AND (memberid>0) ORDER BY time DESC LIMIT 0,100
Number of rows is 1
Creating online with Array as row
Query 17: SELECT DISTINCT FROM wsnlinks_tags WHERE 1=1 GROUP BY name ORDER BY uses DESC LIMIT 0,10
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/finsnet/public_html/databases/mysql.php on line 27
Number of rows is You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM wsnlinks_tags WHERE 1=1 GROUP BY name ORDER BY uses DESC LIMIT 0,10' at line 1
Load time so far: 0.14 seconds.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM wsnlinks_tags WHERE 1=1 GROUP BY name ORDER BY uses DESC LIMIT 0,10' at line 1
Query 18: SELECT `` FROM wsnlinks_quotes WHERE validated=1 ORDER BY rand() ASC LIMIT 0,1
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/finsnet/public_html/databases/mysql.php on line 27
Number of rows is Table 'finsnet_spheric1.wsnlinks_quotes' doesn't exist
Load time so far: 0.14 seconds.
Table 'finsnet_spheric1.wsnlinks_quotes' doesn't exist
Query 19: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime` ,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,` inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`accept ims`,`visibility`,`profileurl` FROM wsnlinks_sessions WHERE time > 1218953969 AND (inchat=1 AND memberid>0) ORDER BY time DESC LIMIT 0,100
Number of rows is 0
Load time so far: 0.23 seconds.
Query 20: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime` ,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,` inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`accept ims`,`visibility`,`profileurl` FROM wsnlinks_sessions WHERE memberid=3
Number of rows is 1
Creating online with Array as row
Load time so far: 0.23 seconds.
Query 21: UPDATE wsnlinks_sessions SET starttime='1218944374', time='1218954569', location='http://www.finsandfur.net/index.php?debug=1', catid='0', threadid='', areaname='Main', nopermission='0', inchat='0', ip='75.100.208.171' WHERE id=312560 |
