Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /opt/content/medweb/links.www2.medweb.nl/HTML/classes/database.php on line 59
Usergroup: Member
Joined: Dec 03, 2004
Total Topics: 2
Total Posts: 3
Posted 12/03/04 - 01:43 AM:
#1
Hi, I am getting an error on the details page for a link. When debugging it seems an SQL query is performed without using an ID... at least that is what I see in the debug report just before the mentioned error.
Furthermore setting the debug level to "supress all errors" causes the script to show an error about not being able to access the database at all.
Performing query: SELECT id FROM medweblinks_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 /opt/content/medweb/links.www2.medweb.nl/HTML/classes/databa se.php:168) in /opt/content/medweb/links.www2.medweb.nl/HTML/prestart.php on line 109
Performing query: SELECT name,value FROM medweblinks_switches WHERE id>0 ;
Number of rows is 23 for Resource id #31
Performing query: SELECT id,type,original,replacement,description,originalclose,repla cementclose,sor torder FROM medweblinks_markup WHERE type='wsncode' ORDER BY sortorder ;
Number of rows is 4 for Resource id #34
Performing query: SELECT original,replacement,description,id,sortorder FROM medweblinks_markup WHERE type='smilie' ORDER BY sortorder ;
Number of rows is 14 for Resource id #35
Performing query: SELECT id FROM medweblinks_categories WHERE validated=1 AND hide=0 ;
Performing query: SELECT id,name,links,comments,time,usergroup,password,ip,totalhits, totalhitsin,ema il,validated,template,language,lastattempt,allowemail,signat ure,avatarname, stylesheet,allowuseremail,albumid,failedattempts,totalbytes, funds,notifyofl inks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptp ms,cookiedurati on,banned FROM medweblinks_members WHERE id=1 AND validated=1 ;
Performing query: SELECT id,`to`,subject,message,headers,replacement,mime FROM medweblinks_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10;
Number of rows is 0 for Resource id #41
Performing query: SELECT id,title,url,description,rating,votes,validated,catid,sumofv otes,email,time ,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,ty pe,filename,fil etitle,notify,suspect,downloads,pendingedit,funds,suspended, alias,expire,ip ,inalbum,typeorder,recipurl,hitsin,recipwith,hitsinips,hitso utips,lastcomme nt,related,inhidden,viewers,threadviewers,hitsintemp,hitsout temp,origtype,i mportance,parentids,timesdead,timesemailed,threadclosed,thre adposters FROM medweblinks_links WHERE id=1231 ;
Performing query: SELECT id FROM medweblinks_links WHERE id=1231 ;
Performing query: SELECT id,title,url,description,rating,votes,validated,catid,sumofv otes,email,time ,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,ty pe,filename,fil etitle,notify,suspect,downloads,pendingedit,funds,suspended, alias,expire,ip ,inalbum,typeorder,recipurl,hitsin,recipwith,hitsinips,hitso utips,lastcomme nt,related,inhidden,viewers,threadviewers,hitsintemp,hitsout temp,origtype,i mportance,parentids,timesdead,timesemailed,threadclosed,thre adposters FROM medweblinks_links WHERE id=1231 ;
Performing query: SELECT id FROM medweblinks_links WHERE catid=11 AND validated=1 AND hide=0 ORDER BY time DESC ;
Number of rows is 6 for Resource id #45
Performing query: SELECT id,title,url,description,rating,votes,validated,catid,sumofv otes,email,time ,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,ty pe,filename,fil etitle,notify,suspect,downloads,pendingedit,funds,suspended, alias,expire,ip ,inalbum,typeorder,recipurl,hitsin,recipwith,hitsinips,hitso utips,lastcomme nt,related,inhidden,viewers,threadviewers,hitsintemp,hitsout temp,origtype,i mportance,parentids,timesdead,timesemailed,threadclosed,thre adposters FROM medweblinks_links WHERE id= ;
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /opt/content/medweb/links.www2.medweb.nl/HTML/classes/databa se.php on line 59
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 '' at line 1
Performing query: SELECT id,name,parent,validated,description,time,parentnames,parent ids,numlinks,hi de,lastlinktime,custom,lastedit,moderators,headerinfo,relate d,numsub,type,p ermissions,subscribers,subscriber,mixtypes,isalbum,orderlink s,totalcomments ,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkc ols,dmozpath,sp onsorlinks,views,customwrap FROM medweblinks_categories WHERE id=11 ;
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
Warning: Cannot modify header information - headers already sent by (output started at /opt/content/medweb/links.www2.medweb.nl/HTML/classes/databa se.php:168) in /opt/content/medweb/links.www2.medweb.nl/HTML/end.php on line 29
Performing query: DELETE FROM medweblinks_sessions WHERE time 0 ;
Number of rows is 1 for Resource id #50
Performing query: SELECT id FROM medweblinks_sessions WHERE memberid=0 ;
Number of rows is 0 for Resource id #51
Performing query: SELECT id FROM medweblinks_pm WHERE timeread=0 AND time > 0 AND deleted=0 AND toid=1 ;
Number of rows is 0 for Resource id #52
Performing query: SELECT id FROM medweblinks_pm WHERE deleted=0 AND time > 0 AND toid=1 ;
Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 5703
Posted 12/06/04 - 10:29 AM:
#2
It seems to be some sort of issue of the id numbers not registering there for any of your links, but I can't reproduce it in 3.13. I don't remember such an issue from 3.12 but you might try upgrading.
Print
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /opt/content/medweb/links.www2.medweb.nl/HTML/classes/database.php on line 59