Now member submits links with name Link1 with value of days is monday. When member goes to category and click to edit picture by Link1, edit page displays for this link.That's all right. Now member select in filter value Monday, all is alright, only links displays, where is days is monday.
Now member click to edit picture by Linkl, but edit page not displays and page displays with noaccess.tpl with this text:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in c:\phpdev\www\3319orig\classes\database.php on line 94
When member remove filter, editing works normal.
This problem is only for members, not for Admin.
When I try change setting in group of members and I check Is an administrator? for this group, no problem with editing of Link1 after using filter.
Load time so far: 0.1 seconds. Performing query: SELECT id FROM tc_categories WHERE validated=1 AND hide=0 AND isalbum=0 ORDER BY id DESC LIMIT 0,1;
Number of rows is 1 for Resource id #21
Load time so far: 0.11 seconds. Performing query: SELECT name,value FROM tc_switches WHERE id>0 ;
Number of rows is 57 for Resource id #38
Load time so far: 0.11 seconds. Performing query: SELECT id,type,original,replacement,description,originalclose,replacementclose,sortorder FROM tc_markup WHERE type='wsncode' ORDER BY sortorder ;
Number of rows is 22 for Resource id #40
Load time so far: 0.12 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,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,bulkpms,issupermod FROM tc_membergroups WHERE id>0 ;
Load time so far: 0.12 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,topics,posts,chatcolor,jmenoprijmeni FROM tc_members WHERE id=9 AND validated=1 ;
Load time so far: 0,13 seconds. Performing query: SELECT 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,days FROM tc_links WHERE id=347 LIMIT 0,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,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml,patrido,konkurezim,reklamatopbanner,reklamarightbanner FROM tc_categories WHERE id=93 ;
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,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml,patrido,konkurezim,reklamatopbanner,reklamarightbanner FROM tc_categories WHERE id=15 ;
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,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml,patrido,konkurezim,reklamatopbanner,reklamarightbanner FROM tc_categories WHERE id=1 ;
Load time so far: 0,16 seconds. Performing query: LOCK TABLES tc_email WRITE, tc_links WRITE, tc_categories WRITE, tc_members WRITE;
Load time so far: 0,16 seconds. Performing query: SELECT id,`to`,subject,message,headers,replacement,mime FROM tc_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10;
Access denied for user 'befe.net'@'127.0.0.1' to database 'befenet1'
Number of rows is 0 for Resource id #52
Load time so far: 0,16 seconds. Performing query: UNLOCK TABLES;
Load time so far: 0,17 seconds. Performing query: SELECT alias FROM tc_links WHERE id=347 ;
Number of rows is 1 for Resource id #57
Load time so far: 0,17 seconds. Performing query: SELECT 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,days FROM tc_links WHERE id= LIMIT 0,1;
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /hosting/www/tachovsko.net/stribro/classes/database.php on line 94
Mysql error while fetching row for :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 'LIMIT 0,1' at line 1
Load time so far: 0,17 seconds. Performing query: SELECT 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,days FROM tc_links WHERE id= LIMIT 0,1;
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 'LIMIT 0,1' at line 1
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /hosting/www/befeleme.net/stribro/classes/database.php on line 94
Mysql error while fetching row for :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 'LIMIT 0,1' at line 1
Load time so far: 0,17 seconds. Performing query: SELECT value FROM tc_switches WHERE name='ims' ;
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 'LIMIT 0,1' at line 1
Warning: Cannot modify header information - headers already sent by (output started at /hosting/www/befeleme.net/stribro/classes/database.php:276) in /hosting/www/befeleme.net/stribro/end.php on line 142
Comments on Edit links after using filter
Experienced
Usergroup: Customer
Joined: Aug 27, 2005
Location: Czech Republic
Total Topics: 48
Total Comments: 82
Hallo Paul,
I have problem with using filter.
I add new custom link field with name: days and I use in template displaylinks.tpl this code:
<form action="index.php?action=displaycat&catid={CATID}&filter=days&linkfilteraction=add"
method="post">
<select name="filtervalue">
<option value="removefilter">all</option>
<option value="monday">Monday</option>
<option value="saturday">Saturday</option>
</select> <input type="submit" value=" OK " class="button">
</form>
Now member submits links with name Link1 with value of days is monday.
When member goes to category and click to edit picture by Link1, edit page displays for this link.That's all right.
Now member select in filter value Monday, all is alright, only links displays, where is days is monday.
Now member click to edit picture by Linkl, but edit page not displays and page displays with noaccess.tpl with this text:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in c:\phpdev\www\3319orig\classes\database.php on line 94
When member remove filter, editing works normal.
This problem is only for members, not for Admin.
When I try change setting in group of members and I check Is an administrator? for this group, no problem with editing of Link1 after using filter.
Thank you.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
I could resolve this a lot quicker if you followed the report procedure to post debug: www.webmastersite.net/forum...report_procedure-4382.html
Experienced
Usergroup: Customer
Joined: Aug 27, 2005
Location: Czech Republic
Total Topics: 48
Total Comments: 82
Here is my debug output:
Load time so far: 0.1 seconds.
Performing query: SELECT id FROM tc_categories WHERE validated=1 AND hide=0 AND isalbum=0 ORDER BY id DESC LIMIT 0,1;
Number of rows is 1 for Resource id #21
Load time so far: 0.11 seconds.
Performing query: SELECT name,value FROM tc_switches WHERE id>0 ;
Number of rows is 57 for Resource id #38
Load time so far: 0.11 seconds.
Performing query: SELECT id,type,original,replacement,description,originalclose,replacementclose,sortorder FROM tc_markup WHERE type='wsncode' ORDER BY sortorder ;
Number of rows is 22 for Resource id #40
Load time so far: 0.12 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,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,bulkpms,issupermod FROM tc_membergroups WHERE id>0 ;
Load time so far: 0.12 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,topics,posts,chatcolor,jmenoprijmeni FROM tc_members WHERE id=9 AND validated=1 ;
Load time so far: 0,13 seconds.
Performing query: SELECT 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,days FROM tc_links WHERE id=347 LIMIT 0,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,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml,patrido,konkurezim,reklamatopbanner,reklamarightbanner FROM tc_categories WHERE id=93 ;
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,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml,patrido,konkurezim,reklamatopbanner,reklamarightbanner FROM tc_categories WHERE id=15 ;
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,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml,patrido,konkurezim,reklamatopbanner,reklamarightbanner FROM tc_categories WHERE id=1 ;
Load time so far: 0,16 seconds.
Performing query: LOCK TABLES tc_email WRITE, tc_links WRITE, tc_categories WRITE, tc_members WRITE;
Load time so far: 0,16 seconds.
Performing query: SELECT id,`to`,subject,message,headers,replacement,mime FROM tc_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10;
Access denied for user 'befe.net'@'127.0.0.1' to database 'befenet1'
Number of rows is 0 for Resource id #52
Load time so far: 0,16 seconds.
Performing query: UNLOCK TABLES;
Load time so far: 0,17 seconds.
Performing query: SELECT alias FROM tc_links WHERE id=347 ;
Number of rows is 1 for Resource id #57
Load time so far: 0,17 seconds.
Performing query: SELECT 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,days FROM tc_links WHERE id= LIMIT 0,1;
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /hosting/www/tachovsko.net/stribro/classes/database.php on line 94
Mysql error while fetching row for :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 'LIMIT 0,1' at line 1
Load time so far: 0,17 seconds.
Performing query: SELECT 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,days FROM tc_links WHERE id= LIMIT 0,1;
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 'LIMIT 0,1' at line 1
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /hosting/www/befeleme.net/stribro/classes/database.php on line 94
Mysql error while fetching row for :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 'LIMIT 0,1' at line 1
Load time so far: 0,17 seconds.
Performing query: SELECT value FROM tc_switches WHERE name='ims' ;
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 'LIMIT 0,1' at line 1
Warning: Cannot modify header information - headers already sent by (output started at /hosting/www/befeleme.net/stribro/classes/database.php:276) in /hosting/www/befeleme.net/stribro/end.php on line 142
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Open start.php, replace with and with