<?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%3D1083" rel="self" type="application/rss+xml" />

<item>
<title>mod_rewrite  categoryname.html</title>
<description><![CDATA[Perhaps I&#039;ve missed something really obvious thats been covered before but I can&#039;t find it in the forum anywhere.

I&#039;m now using the mod-rewrite feature and I see the category name links output as links/category_name

Is there a way to add the .html extension to make it output as
/links/category_name.html?   and page 2 as /links/category_name/2.html  ?


or any rewritten links related link for that matter...

Thanks!!!]]></description>
<link>https://www.webmastersite.net/forums/threads/mod_rewrite-categorynamehtml-5583.html</link>
<pubDate>Mon, 19 Sep 2005 11:44:37 GMT</pubDate>
<guid>https://www.webmastersite.net/forums/thread/5583/</guid>
<content:encoded><![CDATA[Perhaps I've missed something really obvious thats been covered before but I can't find it in the forum anywhere.

I'm now using the mod-rewrite feature and I see the category name links output as links/category_name

Is there a way to add the .html extension to make it output as
/links/category_name.html?   and page 2 as /links/category_name/2.html  ?


or any rewritten links related link for that matter...

Thanks!!!]]></content:encoded>
<comments>https://www.webmastersite.net/forums/threads/mod_rewrite-categorynamehtml-5583.html</comments>   
</item>

<item>
<title>MySql error debug info</title>
<description><![CDATA[Upgrading from 2.56B to full 3.2.6 and getting sql error message

Load time so far: 0.08 seconds.
Performing query: SELECT name,content FROM wsnlinks_settings WHERE id0 ORDER BY id ASC ;


Load time so far: 0.12 seconds.
Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND isalbum=0 ORDER BY id DESC LIMIT 0,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


Number of rows is 52 for Resource id #35

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


Number of rows is 22 for Resource id #38

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


Number of rows is 14 for Resource id #39

Load time so far: 0.19 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,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 FROM wsnlinks_membergroups WHERE id


Load time so far: 0.19 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,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 FROM wsnlinks_members WHERE id=1 AND validated=1 ;


Load time so far: 0.22 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,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts FROM wsnlinks_categories WHERE validated=1 AND deleted=0 AND hide=0 ;


Number of rows is 22 for Resource id #47

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


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

Table &#039;theblade_links.wsnlinks_email&#039; doesn&#039;t exist

Number of rows is for Table &#039;theblade_links.wsnlinks_email&#039; doesn&#039;t exist

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

Table &#039;theblade_links.wsnlinks_email&#039; doesn&#039;t exist

Administrative account verified... starting upgrade.


Warning: mysql_list_fields(): Unable to save MySQL query result in /home/theblade/public_html/links2/classes/database.php on line 30

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

Getting field list for table wsnlinks_sessions 

Load time so far: 0.24 seconds.
Performing query: ALTER TABLE wsnlinks_email ADD id int default &#039;0&#039; NOT NULL auto_increment;


Load time so far: 0.24 seconds.
Performing query: ALTER TABLE wsnlinks_email ADD subject text NOT NULL;

Table &#039;theblade_links.wsnlinks_email&#039; doesn&#039;t exist

Load time so far: 0.24 seconds.
Performing query: ALTER TABLE wsnlinks_email ADD message text NOT NULL;

Table &#039;theblade_links.wsnlinks_email&#039; doesn&#039;t exist

Load time so far: 0.24 seconds.
Performing query: ALTER TABLE wsnlinks_email ADD headers text NOT NULL;

Table &#039;theblade_links.wsnlinks_email&#039; doesn&#039;t exist

Load time so far: 0.24 seconds.
Performing query: ALTER TABLE wsnlinks_email ADD timesent int default &#039;0&#039; NOT NULL;

Table &#039;theblade_links.wsnlinks_email&#039; doesn&#039;t exist

Load time so far: 0.24 seconds.
Performing query: ALTER TABLE wsnlinks_email ADD ip text NOT NULL;

Table &#039;theblade_links.wsnlinks_email&#039; doesn&#039;t exist

Load time so far: 0.24 seconds.
Performing query: ALTER TABLE wsnlinks_email ADD replacement text NOT NULL;

Table &#039;theblade_links.wsnlinks_email&#039; doesn&#039;t exist

Load time so far: 0.24 seconds.
Performing query: ALTER TABLE wsnlinks_email ADD mime int default &#039;0&#039; NOT NULL;

Table &#039;theblade_links.wsnlinks_email&#039; doesn&#039;t exist

Load time so far: 0.25 seconds.
Performing query: ALTER TABLE wsnlinks_links CHANGE rating rating float default &#039;0&#039;;

Table &#039;theblade_links.wsnlinks_email&#039; doesn&#039;t exist

Load time so far: 0.33 seconds.
Performing query: ALTER TABLE wsnlinks_links CHANGE lastedit lastedit int default &#039;0&#039;;


Load time so far: 0.54 seconds.
Performing query: ALTER TABLE wsnlinks_links CHANGE time time int default &#039;0&#039;;


Load time so far: 0.71 seconds.
Performing query: ALTER TABLE wsnlinks_members CHANGE failedattempts failedattempts tinyint(4) default &#039;0&#039;;


Load time so far: 0.81 seconds.
Performing query: ALTER TABLE wsnlinks_members CHANGE time time int default &#039;0&#039;;


Load time so far: 0.85 seconds.
Performing query: UPDATE wsnlinks_members SET time=&#039;0&#039; WHERE time=&#039;TIME}&#039;;


Load time so far: 0.85 seconds.
Performing query: ALTER TABLE wsnlinks_membergroups CHANGE canemailmembers canemailmembers tinyint(1) default &#039;0&#039;;


Load time so far: 0.92 seconds.
Performing query: ALTER TABLE wsnlinks_membergroups CHANGE canusehtml canusehtml tinyint(1) default &#039;0&#039;;


Load time so far: 0.96 seconds.
Performing query: ALTER TABLE wsnlinks_links CHANGE funds funds FLOAT DEFAULT &#039;0&#039; NOT NULL;


Load time so far: 1.04 seconds.
Performing query: ALTER TABLE wsnlinks_ratings CHANGE `id` `id` INT( 11 ) DEFAULT &#039;0&#039; NOT NULL AUTO_INCREMENT;


Load time so far: 1.17 seconds.
Performing query: ALTER TABLE wsnlinks_pm CHANGE `folderid` `folderid` TEXT NOT NULL;


Load time so far: 1.18 seconds.
Performing query: ALTER TABLE wsnlinks_links ADD FULLTEXT `titleindex` (`title`);


Load time so far: 1.19 seconds.
Performing query: SELECT name FROM wsnlinks_switches WHERE id


Number of rows is 52 for Resource id #70

Load time so far: 1.19 seconds.
Performing query: UPDATE wsnlinks_members SET notifyoflinks=&#039;no&#039; WHERE notifyoflinks = &#039;&#039;;


Load time so far: 1.19 seconds.
Performing query: UPDATE wsnlinks_links SET lastedit=&#039;0&#039; WHERE lastedit=&#039;time&#039;;


Load time so far: 1.2 seconds.
Performing query: DELETE FROM wsnlinks_settings WHERE name=&#039;sitemap&#039;;


Load time so far: 1.2 seconds.
Performing query: UPDATE wsnlinks_categories SET permissions=&#039;&#039; WHERE permissions NOT LIKE &#039;%[GROUP]%&#039;;


Load time so far: 1.21 seconds.
Performing query: UPDATE wsnlinks_links SET hitsinips=&#039;&#039; WHERE hitsinips NOT LIKE &#039;%[,]%&#039;;


Load time so far: 1.22 seconds.
Performing query: UPDATE wsnlinks_links SET hitsoutips=&#039;&#039; WHERE hitsoutips NOT LIKE &#039;%[,]%&#039;;


Load time so far: 1.23 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,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts FROM wsnlinks_categories WHERE moderators != &#039;&#039; ;


Number of rows is 4 for Resource id #71

Load time so far: 1.23 seconds.
Performing query: SELECT id FROM wsnlinks_members WHERE name = &#039;||||||&#039; ;


Load time so far: 1.24 seconds.
Performing query: UPDATE wsnlinks_categories SET moderators=&#039;||||||&#039; WHERE id=33;


Load time so far: 1.24 seconds.
Performing query: SELECT id FROM wsnlinks_members WHERE name = &#039;||||||&#039; ;


Load time so far: 1.24 seconds.
Performing query: UPDATE wsnlinks_categories SET moderators=&#039;||||||&#039; WHERE id=34;


Load time so far: 1.24 seconds.
Performing query: SELECT id FROM wsnlinks_members WHERE name = &#039;||||||&#039; ;


Load time so far: 1.24 seconds.
Performing query: UPDATE wsnlinks_categories SET moderators=&#039;||||||&#039; WHERE id=36;


Load time so far: 1.25 seconds.
Performing query: SELECT id FROM wsnlinks_members WHERE name = &#039;||||||&#039; ;


Load time so far: 1.25 seconds.
Performing query: UPDATE wsnlinks_categories SET moderators=&#039;||||||&#039; WHERE id=37;


Load time so far: 1.25 seconds.
Performing query: UPDATE wsnlinks_categories SET type=&#039;regular&#039; WHERE type=&#039;&#039;;


Load time so far: 1.25 seconds.
Performing query: UPDATE wsnlinks_comments SET type=&#039;regular&#039; WHERE type=&#039;&#039;;


Load time so far: 1.25 seconds.
Performing query: UPDATE wsnlinks_members SET allowuseremail=&#039;yes&#039; WHERE allowuseremail=&#039;&#039;;


Load time so far: 1.25 seconds.
Performing query: UPDATE wsnlinks_members SET allowemail=&#039;yes&#039; WHERE allowemail=&#039;&#039;;


Load time so far: 1.25 seconds.
Performing query: SELECT stylesheet FROM wsnlinks_members WHERE usergroup=3 ;


Load time so far: 1.25 seconds.
Performing query: SELECT name,content FROM wsnlinks_settings WHERE id0 ORDER BY id ASC ;



Adding email fields: id subject message headers timesent ip replacement mime 
Done adding fields.

r
No new settings need to be added.

No new switches need to be added.

Appending new language from englishonly.lng to your current languages: 


Added these items to default: 


Done appending languages.

Attempting to CHMOD new templates for you...

Updating stylesheets...




If you have any attachments, they haven&#039;t been converted to the new format yet. Click to begin conversion.
]]></description>
<link>https://www.webmastersite.net/forums/threads/mysql-error-debug-info-5572.html</link>
<pubDate>Sat, 17 Sep 2005 17:02:13 GMT</pubDate>
<guid>https://www.webmastersite.net/forums/thread/5572/</guid>
<content:encoded><![CDATA[Upgrading from 2.56B to full 3.2.6 and getting sql error message

Load time so far: 0.08 seconds.
Performing query: SELECT name,content FROM wsnlinks_settings WHERE id&#62;0 ORDER BY id ASC ;


Load time so far: 0.12 seconds.
Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND isalbum=0 ORDER BY id DESC LIMIT 0,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 52 for Resource id #35

Load time so far: 0.14 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 22 for Resource id #38

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


Number of rows is 14 for Resource id #39

Load time so far: 0.19 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,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 FROM wsnlinks_membergroups WHERE id&#62;0 ;


Load time so far: 0.19 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,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 FROM wsnlinks_members WHERE id=1 AND validated=1 ;


Load time so far: 0.22 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,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts FROM wsnlinks_categories WHERE validated=1 AND deleted=0 AND hide=0 ;


Number of rows is 22 for Resource id #47

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


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

Table 'theblade_links.wsnlinks_email' doesn't exist

Number of rows is for Table 'theblade_links.wsnlinks_email' doesn't exist

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

Table 'theblade_links.wsnlinks_email' doesn't exist

Administrative account verified... starting upgrade.


Warning: mysql_list_fields(): Unable to save MySQL query result in /home/theblade/public_html/links2/classes/database.php on line 30

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

Getting field list for table wsnlinks_sessions 

Load time so far: 0.24 seconds.
Performing query: ALTER TABLE wsnlinks_email ADD id int default '0' NOT NULL auto_increment;


Load time so far: 0.24 seconds.
Performing query: ALTER TABLE wsnlinks_email ADD subject text NOT NULL;

Table 'theblade_links.wsnlinks_email' doesn't exist

Load time so far: 0.24 seconds.
Performing query: ALTER TABLE wsnlinks_email ADD message text NOT NULL;

Table 'theblade_links.wsnlinks_email' doesn't exist

Load time so far: 0.24 seconds.
Performing query: ALTER TABLE wsnlinks_email ADD headers text NOT NULL;

Table 'theblade_links.wsnlinks_email' doesn't exist

Load time so far: 0.24 seconds.
Performing query: ALTER TABLE wsnlinks_email ADD timesent int default '0' NOT NULL;

Table 'theblade_links.wsnlinks_email' doesn't exist

Load time so far: 0.24 seconds.
Performing query: ALTER TABLE wsnlinks_email ADD ip text NOT NULL;

Table 'theblade_links.wsnlinks_email' doesn't exist

Load time so far: 0.24 seconds.
Performing query: ALTER TABLE wsnlinks_email ADD replacement text NOT NULL;

Table 'theblade_links.wsnlinks_email' doesn't exist

Load time so far: 0.24 seconds.
Performing query: ALTER TABLE wsnlinks_email ADD mime int default '0' NOT NULL;

Table 'theblade_links.wsnlinks_email' doesn't exist

Load time so far: 0.25 seconds.
Performing query: ALTER TABLE wsnlinks_links CHANGE rating rating float default '0';

Table 'theblade_links.wsnlinks_email' doesn't exist

Load time so far: 0.33 seconds.
Performing query: ALTER TABLE wsnlinks_links CHANGE lastedit lastedit int default '0';


Load time so far: 0.54 seconds.
Performing query: ALTER TABLE wsnlinks_links CHANGE time time int default '0';


Load time so far: 0.71 seconds.
Performing query: ALTER TABLE wsnlinks_members CHANGE failedattempts failedattempts tinyint(4) default '0';


Load time so far: 0.81 seconds.
Performing query: ALTER TABLE wsnlinks_members CHANGE time time int default '0';


Load time so far: 0.85 seconds.
Performing query: UPDATE wsnlinks_members SET time='0' WHERE time='&#123;TIME}';


Load time so far: 0.85 seconds.
Performing query: ALTER TABLE wsnlinks_membergroups CHANGE canemailmembers canemailmembers tinyint(1) default '0';


Load time so far: 0.92 seconds.
Performing query: ALTER TABLE wsnlinks_membergroups CHANGE canusehtml canusehtml tinyint(1) default '0';


Load time so far: 0.96 seconds.
Performing query: ALTER TABLE wsnlinks_links CHANGE funds funds FLOAT DEFAULT '0' NOT NULL;


Load time so far: 1.04 seconds.
Performing query: ALTER TABLE wsnlinks_ratings CHANGE `id` `id` INT( 11 ) DEFAULT '0' NOT NULL AUTO_INCREMENT;


Load time so far: 1.17 seconds.
Performing query: ALTER TABLE wsnlinks_pm CHANGE `folderid` `folderid` TEXT NOT NULL;


Load time so far: 1.18 seconds.
Performing query: ALTER TABLE wsnlinks_links ADD FULLTEXT `titleindex` (`title`);


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


Number of rows is 52 for Resource id #70

Load time so far: 1.19 seconds.
Performing query: UPDATE wsnlinks_members SET notifyoflinks='no' WHERE notifyoflinks = '';


Load time so far: 1.19 seconds.
Performing query: UPDATE wsnlinks_links SET lastedit='0' WHERE lastedit='time';


Load time so far: 1.2 seconds.
Performing query: DELETE FROM wsnlinks_settings WHERE name='sitemap';


Load time so far: 1.2 seconds.
Performing query: UPDATE wsnlinks_categories SET permissions='' WHERE permissions NOT LIKE '%[GROUP]%';


Load time so far: 1.21 seconds.
Performing query: UPDATE wsnlinks_links SET hitsinips='' WHERE hitsinips NOT LIKE '%[,]%';


Load time so far: 1.22 seconds.
Performing query: UPDATE wsnlinks_links SET hitsoutips='' WHERE hitsoutips NOT LIKE '%[,]%';


Load time so far: 1.23 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,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts FROM wsnlinks_categories WHERE moderators != '' ;


Number of rows is 4 for Resource id #71

Load time so far: 1.23 seconds.
Performing query: SELECT id FROM wsnlinks_members WHERE name = '||||||' ;


Load time so far: 1.24 seconds.
Performing query: UPDATE wsnlinks_categories SET moderators='||||||' WHERE id=33;


Load time so far: 1.24 seconds.
Performing query: SELECT id FROM wsnlinks_members WHERE name = '||||||' ;


Load time so far: 1.24 seconds.
Performing query: UPDATE wsnlinks_categories SET moderators='||||||' WHERE id=34;


Load time so far: 1.24 seconds.
Performing query: SELECT id FROM wsnlinks_members WHERE name = '||||||' ;


Load time so far: 1.24 seconds.
Performing query: UPDATE wsnlinks_categories SET moderators='||||||' WHERE id=36;


Load time so far: 1.25 seconds.
Performing query: SELECT id FROM wsnlinks_members WHERE name = '||||||' ;


Load time so far: 1.25 seconds.
Performing query: UPDATE wsnlinks_categories SET moderators='||||||' WHERE id=37;


Load time so far: 1.25 seconds.
Performing query: UPDATE wsnlinks_categories SET type='regular' WHERE type='';


Load time so far: 1.25 seconds.
Performing query: UPDATE wsnlinks_comments SET type='regular' WHERE type='';


Load time so far: 1.25 seconds.
Performing query: UPDATE wsnlinks_members SET allowuseremail='yes' WHERE allowuseremail='';


Load time so far: 1.25 seconds.
Performing query: UPDATE wsnlinks_members SET allowemail='yes' WHERE allowemail='';


Load time so far: 1.25 seconds.
Performing query: SELECT stylesheet FROM wsnlinks_members WHERE usergroup=3 ;


Load time so far: 1.25 seconds.
Performing query: SELECT name,content FROM wsnlinks_settings WHERE id&#62;0 ORDER BY id ASC ;



Adding email fields: id subject message headers timesent ip replacement mime 
Done adding fields.

r
No new settings need to be added.

No new switches need to be added.

Appending new language from englishonly.lng to your current languages: 


Added these items to default: 


Done appending languages.

Attempting to CHMOD new templates for you...

Updating stylesheets...




If you have any attachments, they haven't been converted to the new format yet. Click to begin conversion.
]]></content:encoded>
<comments>https://www.webmastersite.net/forums/threads/mysql-error-debug-info-5572.html</comments>   
</item>

<item>
<title>My sql error?</title>
<description><![CDATA[I&#039;m getting this error, can someone look at it and tell me the problem? It references albums.tpl. I reloaded albums.tpl and still I get the error.

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

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

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

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

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

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/theblade/public_html/links/classes/database.php on line 1
If you are not the administrator of this site, please report this page to the administrator. If you are the administrator, please pay careful attention: You have a parse error in your template templates/default/albums.tpl (or perhaps in your header or footer) which you need to repair before this page can be displayed correctly. The error is picked up on by php at line 129 of the output. Here are the nearby lines in your template where the problem is likely to be: 
Line #126: 
Line #127: brCATLINKSHERE} links in this category 
Line #128: brbr 
Line #129: 

In case the above output is off, this is what the area looks like during parsing:
Line #126: /tr 
Line #127: /table 
Line #128: div class=&quot;main&quot;?php if (27 == )  ? 
Line #129: centerdiv class=&quot;suggest&quot;a href=&quot;suggest.php?action=addlink&catid=&amp;isalbum=1&quot;Add Link/a/div/center 

[Load this template in your template editor]

The source of your error is probably not on line 129 itself, but most likely a line or two before it. Check your code carefully for syntax mistakes. If you cannot recognize one, copy and paste this output into a thread on the support forum.
Now outputing the page without any conditional or php sections evaluated: 
CATHEADERINFO}]]></description>
<link>https://www.webmastersite.net/forums/threads/my-sql-error-5535.html</link>
<pubDate>Wed, 07 Sep 2005 18:22:53 GMT</pubDate>
<guid>https://www.webmastersite.net/forums/thread/5535/</guid>
<content:encoded><![CDATA[I'm getting this error, can someone look at it and tell me the problem? It references albums.tpl. I reloaded albums.tpl and still I get the error.

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

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

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

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

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

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/theblade/public_html/links/classes/database.php on line 1
If you are not the administrator of this site, please report this page to the administrator. If you are the administrator, please pay careful attention: You have a parse error in your template templates/default/albums.tpl (or perhaps in your header or footer) which you need to repair before this page can be displayed correctly. The error is picked up on by php at line 129 of the output. Here are the nearby lines in your template where the problem is likely to be: 
Line #126: 
Line #127: &#60;br&#62;&#123;CATLINKSHERE} links in this category 
Line #128: &#60;br&#62;&#60;br&#62; 
Line #129: 

In case the above output is off, this is what the area looks like during parsing:
Line #126: &#60;/tr&#62; 
Line #127: &#60;/table&#62; 
Line #128: &#60;div class="main"&#62;&#60;?php if (27 == ) &#123; ?&#62; 
Line #129: &#60;center&#62;&#60;div class="suggest"&#62;&#60;a href="suggest.php?action=addlink&catid=&isalbum=1"&#62;Add Link&#60;/a&#62;&#60;/div&#62;&#60;/center&#62; 

[Load this template in your template editor]

The source of your error is probably not on line 129 itself, but most likely a line or two before it. Check your code carefully for syntax mistakes. If you cannot recognize one, copy and paste this output into a thread on the support forum.
Now outputing the page without any conditional or php sections evaluated: 
&#123;CATHEADERINFO}]]></content:encoded>
<comments>https://www.webmastersite.net/forums/threads/my-sql-error-5535.html</comments>   
</item>

</channel>
</rss>