<?xml version="1.0" encoding="utf-8"?>
<?xml-stylesheet type="text/css" href="https://www.webmastersite.net/forums/templates/bootstrap/rss.css" ?>
<rss version="2.0"
 xmlns:content="http://purl.org/rss/1.0/modules/content/"
 xmlns:media="http://search.yahoo.com/mrss/"
 xmlns:atom="http://www.w3.org/2005/Atom"
 xmlns:georss="http://www.georss.org/georss"> 
<channel>
<title>WebmasterSite.net</title>
<link>https://www.webmastersite.net/forums</link>
<description></description>
<language>en-us</language>
<atom:link href="https://www.webmastersite.net/forums/rssfeed.php?thecondition=ownerid%3D1389" rel="self" type="application/rss+xml" />

<item>
<title>mysql  errors long after the upgrade</title>
<description>I upgraded September 3 and it went smoothly. I was able to add categories and links.</description>
<link>https://www.webmastersite.net/forums/threads/mysql-errors-long-after-the-upgrade-5586.html</link>
<pubDate>Tue, 20 Sep 2005 05:24:22 GMT</pubDate>
<guid>https://www.webmastersite.net/forums/thread/5586/</guid>
<content:encoded><![CDATA[I upgraded September 3 and it went smoothly. I was able to add categories and links. Today I receive the following errors.I didn 't add any new thing ...just categories or links.


Warning: mysql_list_fields(): Unable to save MySQL query result in /home/protag/public_html/resources/classes/database.php on line 1

Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/protag/public_html/resources/classes/database.php on line 1

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/protag/public_html/resources/classes/database.php on line 1
----------------
debug mode:
Load time so far: 0.13 seconds.
Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 ORDER BY id DESC LIMIT 0,1;


Warning: Cannot modify header information - headers already sent by (output started at /home/protag/public_html/resources/classes/database.php:1) in /home/protag/public_html/resources/prestart.php on line 1

Warning: mysql_list_fields(): Unable to save MySQL query result in /home/protag/public_html/resources/classes/database.php on line 1

Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/protag/public_html/resources/classes/database.php on line 1

Getting field list for table wsnlinks_sessions

Load time so far: 0.13 seconds.
Performing query: SELECT name,value FROM wsnlinks_switches WHERE id&#62;0 ;

Number of rows is 23 for Resource id #30

Load time so far: 0.13 seconds.
Performing query: SELECT id,type,original,replacement,description,originalclose,replacementclose,sortorder FROM wsnlinks_markup WHERE type='wsncode' ORDER BY sortorder ;

Number of rows is 4 for Resource id #32

Load time so far: 0.13 seconds.
Performing query: SELECT original,replacement,description,id,sortorder FROM wsnlinks_markup WHERE type='smilie' ORDER BY sortorder ;

Number of rows is 13 for Resource id #33

Load time so far: 0.14 seconds.
Performing query: SELECT COUNT(*) FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND isalbum=0 ;

Load time so far: 0.14 seconds.
Performing query: UPDATE wsnlinks_settings SET content='64' WHERE name='totalsubcats';

Load time so far: 0.14 seconds.
Performing 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,cancopy,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem FROM wsnlinks_membergroups WHERE id&#62;0 ;

Load time so far: 0.14 seconds.
Performing 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 FROM wsnlinks_members WHERE id=224 AND validated=1 ;

Load time so far: 0.15 seconds.
Performing query: SELECT 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 FROM wsnlinks_categories WHERE validated=1 AND hide=0 ;

Number of rows is 64 for Resource id #39

Load time so far: 0.16 seconds.
Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE;

Load time so far: 0.16 seconds.
nPerforming query: SELECT id,`to`,subject,message,headers,replacement,mime FROM wsnlinks_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10;

Can't open file: 'wsnlinks_email.MYI'. (errno: 145)

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/protag/public_html/resources/classes/database.php on line 1

Number of rows is for Can't open file: 'wsnlinks_email.MYI'. (errno: 145)

Load time so far: 0.16 seconds.
Performing query: UNLOCK TABLES;

Can't open file: 'wsnlinks_email.MYI'. (errno: 145)

Load time so far: 0.2 seconds.
Performing query: SELECT 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 FROM wsnlinks_categories WHERE parent=0 AND validated=1 AND hide=0 AND isalbum=0 ORDER BY name ASC LIMIT 0,300;

Number of rows is 12 for Resource id #42

Load time so far: 0.21 seconds.
Performing query: SELECT id FROM wsnlinks_categories WHERE parent=0 AND validated=1 AND hide=0 ;

Number of rows is 12 for Resource id #43

Warning: Cannot modify header information - headers already sent by (output started at /home/protag/public_html/resources/classes/database.php:1) in /home/protag/public_html/resources/commonfuncs.php on line 1

Warning: Cannot modify header information - headers already sent by (output started at /home/protag/public_html/resources/classes/database.php:1) in /home/protag/public_html/resources/end.php on line 1

Load time so far: 0.55 seconds.
Performing query: SELECT COUNT(*) FROM wsnlinks_links WHERE validated=1 AND hide=0 AND inhidden=0 AND alias=0 AND inalbum=0 ;

Load time so far: 0.58 seconds.
Performing query: SELECT id,title,url,description,rating,votes,validated,recipurl,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,hitsin,voterips,voterids,lastedit,type,filename,filetitle,notify,suspect,downloads,pendingedit,funds,suspended,alias,expire,ip,inalbum,typeorder,recipwith,hitsinips,hitsoutips,lastcomment,related,inhidden,viewers,threadviewers,hitsintemp,hitsouttemp,origtype,importance,parentids,timesdead,timesemailed,threadclosed,threadposters,price,longdescription,xwidth,yheight FROM wsnlinks_links WHERE validated=1 AND hide=0 AND inhidden=0 AND alias=0 AND inalbum=0 ORDER BY rating DESC LIMIT 0,15;

Number of rows is 15 for Resource id #46

Load time so far: 0.63 seconds.
Performing query: SELECT id,title,url,description,rating,votes,validated,recipurl,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,hitsin,voterips,voterids,lastedit,type,filename,filetitle,notify,suspect,downloads,pendingedit,funds,suspended,alias,expire,ip,inalbum,typeorder,recipwith,hitsinips,hitsoutips,lastcomment,related,inhidden,viewers,threadviewers,hitsintemp,hitsouttemp,origtype,importance,parentids,timesdead,timesemailed,threadclosed,threadposters,price,longdescription,xwidth,yheight FROM wsnlinks_links WHERE id=1588 ;

Load time so far: 0.64 seconds.
Performing query: SELECT 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 FROM wsnlinks_categories WHERE id=1588 ;

Load time so far: 0.65 seconds.
Performing query: SELECT 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 FROM wsnlinks_categories WHERE id=1588 ;

Load time so far: 0.66 seconds.
Performing query: SELECT 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 FROM wsnlinks_categories WHERE id=1588 ;

Load time so far: 0.67 seconds.
Performing query: SELECT 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 FROM wsnlinks_categories WHERE id=1588 ;

Load time so far: 0.68 seconds.
Performing query: SELECT 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 FROM wsnlinks_categories WHERE id=1588 ;

Load time so far: 0.68 seconds.
Performing query: SELECT COUNT(*) FROM wsnlinks_links WHERE validated=1 AND hide=0 AND inhidden=0 AND alias=0 AND inalbum=0 ;

Load time so far: 0.71 seconds.
Performing query: SELECT id,title,url,description,rating,votes,validated,recipurl,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,hitsin,voterips,voterids,lastedit,type,filename,filetitle,notify,suspect,downloads,pendingedit,funds,suspended,alias,expire,ip,inalbum,typeorder,recipwith,hitsinips,hitsoutips,lastcomment,related,inhidden,viewers,threadviewers,hitsintemp,hitsouttemp,origtype,importance,parentids,timesdead,timesemailed,threadclosed,threadposters,price,longdescription,xwidth,yheight FROM wsnlinks_links WHERE validated=1 AND hide=0 AND inhidden=0 AND alias=0 AND inalbum=0 ORDER BY id DESC LIMIT 0,15;

Number of rows is 15 for Resource id #54

Load time so far: 0.71 seconds.
Performing query: SELECT 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 FROM wsnlinks_categories WHERE id=1588 ;

Load time so far: 0.72 seconds.
Performing query: SELECT 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 FROM wsnlinks_categories WHERE id=1588 ;

Load time so far: 0.73 seconds.
Performing query: SELECT 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 FROM wsnlinks_categories WHERE id=1588 ;

Load time so far: 0.73 seconds.
Performing query: SELECT 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 FROM wsnlinks_categories WHERE id=1588 ;

Load time so far: 0.74 seconds.
Performing query: SELECT 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 FROM wsnlinks_categories WHERE id=1588 ;]]></content:encoded>
<comments>https://www.webmastersite.net/forums/threads/mysql-errors-long-after-the-upgrade-5586.html</comments>   
</item>

</channel>
</rss>