i'm doing a test with a two category WSNlinks' site with one forbidden to member (only one link in this one) i have no problem when connecting to the main page as an administrator. when connecting as a member, i get this message : Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/sites/site103/web/sikyak/classes/database.php on line 69
first, as it is a member problem, i choose show queries as executed i get : Warning: Cannot modify header information - headers already sent by (output started at .../classes/database.php:230*) in .../prestart.php on line 115** (* echo "Load time so far: $totaltime seconds. Performing query: $sqllump; ". mysql_error() .""; **which should // fix IE 6 default requirement of privacy policy for cookies) then i (try to) logout (as an admin)
and i get the previous message and some lines after "Warning: Cannot modify header information - headers already sent by (output started at .../classes/database.php:230) in .../commonfuncs.php on line 310*" (309 AND 310 if (strlen($value) > 3000) setcookie($name, " ", 1); else setcookie($name, "$value", $duration); )
and then "Warning: Cannot modify header information - headers already sent by (output started at .../classes/database.php:230) in .../commonfuncs.php on line 310"
Warning: Cannot modify header information - headers already sent by (output started at .../classes/database.php:230) in .../end.php on line 29*" (* // fix possible 500 errors by clariflying content type)
...and the test is finished because i can't logout : i'm deconnected a few seconds and reconnected as the admin (even if i try to connect as a member at this moment)
i can't : i identify as a member i get the page of the only category i can get as a member when i want to go up to the main directory with the link .../index.php i get it AND the message Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /.../classes/database.php on line 69 of course adding &debug=1 to http://.../index.php doesn't work
of course adding &debug=1 to http://.../index.php doesn't work
Huh? How can modifying your browser's url not work? Unless you don't have a query string, in which case of course you need a ? instead of a &. But if you're in a category as you say you are then you must have a query string.
si i did http://.../index.php?debug=1 instead of http://.../index.php?debug=1 (file not found) and i get
... Warning: Cannot modify header information - headers already sent by (output started at /home/sites/site103/web/sikyak/classes/database.php:230) in /home/sites/site103/web/sikyak/prestart.php on line 115 ... Warning: Cannot modify header information - headers already sent by (output started at /home/sites/site103/web/sikyak/classes/database.php:230) in /home/sites/site103/web/sikyak/commonfuncs.php on line 310
Warning: Cannot modify header information - headers already sent by (output started at /home/sites/site103/web/sikyak/classes/database.php:230) in /home/sites/site103/web/sikyak/end.php on line 29 ... Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/sites/site103/web/sikyak/classes/database.php on line 69
Since you went to the trouble of posting the exact lines that header warnings occour on in debug mode (while omiting the actual debug mode info), please read scripts.webmastersite.net/w...nks/wsnmanual/articles/216 in order to avoid doing so again.
You keep omiting all of the information and posting useless stuff. I don't want to see your header information warnings or mysql warnings, I have to see the debug output. That is, obviously, the point of debug mode. I'm guessing you're actually seeing it, but replacing it with ... rather than posting it. Please copy and paste what's actually on your screen.
As you understood, i do not understand very well the way it works : i hope you will excuse me making lose your time ;
you'll find hereunder the whole stuff :
Load time so far: 0.77 seconds. Performing query: SELECT name,content FROM wsnlinks_settings WHERE id>0 ORDER BY id ASC ;
Number of rows is 250 for Resource id #19
Load time so far: 0.93 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 /.../classes/database.php:230) in /.../prestart.php on line 115
Load time so far: 1.21 seconds. Performing query: SELECT name,value FROM wsnlinks_switches WHERE id>0 ;
Number of rows is 23 for Resource id #31
Load time so far: 1.25 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 #34
Load time so far: 1.27 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 #35
Load time so far: 1.28 seconds. Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 ;
Number of rows is 2 for Resource id #36
Load time so far: 1.28 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>0 ;
Load time so far: 1.3 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=2 AND validated=1 ;
Load time so far: 1.43 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 2 for Resource id #41
Load time so far: 1.47 seconds. Performing query: SELECT id,`to`,subject,message,headers,replacement,mime FROM wsnlinks_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10;
Number of rows is 0 for Resource id #42
Load time so far: 1.5 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 2 for Resource id #45
Load time so far: 1.51 seconds. Performing query: SELECT id FROM wsnlinks_categories WHERE parent=0 AND validated=1 AND hide=0 ;
Number of rows is 2 for Resource id #46
Warning: Cannot modify header information - headers already sent by (output started at /.../classes/database.php:230) in /.../commonfuncs.php on line 310
Warning: Cannot modify header information - headers already sent by (output started at /.../classes/database.php:230) in /.../end.php on line 29
Load time so far: 1.72 seconds. Performing query: UPDATE wsnlinks_sessions SET starttime='0' WHERE time < 15;
Load time so far: 1.82 seconds. Performing query: UPDATE wsnlinks_sessions SET time='0' WHERE time < 15;
Load time so far: 1.87 seconds. Performing query: SELECT starttime FROM wsnlinks_sessions WHERE memberid=2 ;
Number of rows is 1 for Resource id #48
Load time so far: 1.9 seconds. Performing query: UPDATE wsnlinks_sessions SET time='1106642198', location='http://.../index.php?debug=1', catid='', threadid='', areaname='Principal' WHERE memberid=2;
Load time so far: 1.91 seconds. Performing query: SELECT id FROM wsnlinks_sessions WHERE memberid>0 ;
Number of rows is 1 for Resource id #49
Load time so far: 1.92 seconds. Performing query: SELECT id FROM wsnlinks_sessions WHERE memberid=0 ;
Number of rows is 0 for Resource id #50
Load time so far: 2.62 seconds. Performing query: SELECT id FROM wsnlinks_pm WHERE timeread=0 AND time > 0 AND deleted=0 AND toid=2 ;
Number of rows is 0 for Resource id #51
Load time so far: 2.63 seconds. Performing query: SELECT id FROM wsnlinks_pm WHERE deleted=0 AND time > 0 AND toid=2 ;
Number of rows is 0 for Resource id #52
Load time so far: 2.69 seconds. Performing query: SELECT id FROM wsnlinks_links WHERE validated=1 AND hide=0 AND inhidden=0 AND alias=0 AND inalbum=0 ;
Number of rows is 1 for Resource id #53
Load time so far: 2.69 seconds. Performing query: SELECT id,title,url,description,rating,votes,validated,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,type,filename,filetitle,notify,suspect,downloads,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 FROM wsnlinks_links WHERE validated=1 AND hide=0 AND inhidden=0 AND alias=0 AND inalbum=0 ORDER BY id DESC LIMIT 0,5;
Number of rows is 1 for Resource id #54
Load time so far: 2.69 seconds. Performing query: SELECT id,title,url,description,rating,votes,validated,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,type,filename,filetitle,notify,suspect,downloads,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 FROM wsnlinks_links WHERE validated=1 AND hide=0 AND inhidden=0 AND alias=0 AND inalbum=0 ORDER BY id DESC LIMIT 1,5;
Load time so far: 2.77 seconds. Performing query: SELECT id,title,url,description,rating,votes,validated,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,type,filename,filetitle,notify,suspect,downloads,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 FROM wsnlinks_links WHERE id= ;
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /.../classes/database.php on line 69
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
Load time so far: 2.78 seconds. Performing query: SELECT id FROM wsnlinks_sessions WHERE 1=1 AND (memberid>0) ;
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
Number of rows is 1 for Resource id #56
Load time so far: 2.79 seconds. Performing query: SELECT id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname FROM wsnlinks_sessions WHERE 1=1 AND (memberid>0) ORDER BY time DESC LIMIT 0,100;
Number of rows is 1 for Resource id #57
Load time so far: 2.79 seconds. Performing query: SELECT id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname FROM wsnlinks_sessions WHERE 1=1 AND (memberid>0) ORDER BY time DESC LIMIT 1,100;
Load time so far: 2.77 seconds. Performing query: SELECT id,title,url,description,rating,votes,validated,catid,sumofvotes,email,time ,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,type,filename,fil etitle,notify,suspect,downloads,pendingedit,funds,suspended,alias,expire,ip ,inalbum,typeorder,recipurl,hitsin,recipwith,hitsinips,hitsoutips,lastcomme nt,related,inhidden,viewers,threadviewers,hitsintemp,hitsouttemp,origtype,i mportance,parentids,timesdead,timesemailed,threadclosed,threadposters FROM wsnlinks_links WHERE id= ;
Based on the location, I'd guess this is something in or related to a toplist. It appears right after what appear to be two different toplists of 5 links, the latter of them being offset to start at the 2nd result for some reason. What toplists do you have?
Actually, since you said you're using 3.13, are you sure your issue isn't the same as https://www.webmastersite.net/forums/thread/4649 (though I don't remember a mysql error there, it's otherwise similar). It's always a good idea to update to the latest version when you get an error.
As it is a test, i'm going to load the 3.14 version (i thought i had the last one); it will be easier ... and i'll try it the same way ... and if the same problem occurs, i'll give you indications about toplists Thank you anyway
corbin wrote: As it is a test, i'm going to load the 3.14 version (i thought i had the last one); it will be easier ... and i'll try it the same way ... and if the same problem occurs, i'll give you indications about toplists Thank you anyway
ps : and i will also try to configurate FIRST vote values (post in basic)
Charles
0/5
1
2
3
4
5
This thread is closed, so you cannot post a reply.
Comments on pb connecting member
Experienced
Usergroup: Customer
Joined: Oct 21, 2003
Total Topics: 21
Total Comments: 53
Hello,
i'm doing a test with a two category WSNlinks' site with one forbidden to member (only one link in this one)
i have no problem when connecting to the main page as an administrator.
when connecting as a member, i get this message :
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/sites/site103/web/sikyak/classes/database.php on line 69
thank you
charles
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Read the pinned procedure thread before posting.
Experienced
Usergroup: Customer
Joined: Oct 21, 2003
Total Topics: 21
Total Comments: 53
ok, ok,
first, as it is a member problem, i choose
show queries as executed
i get :
Warning: Cannot modify header information - headers already sent by (output started at .../classes/database.php:230*) in .../prestart.php on line 115**
(* echo "Load time so far: $totaltime seconds. Performing query: $sqllump; ". mysql_error() ."";
**which should // fix IE 6 default requirement of privacy policy for cookies)
then i (try to) logout (as an admin)
and i get the previous message and some lines after
"Warning: Cannot modify header information - headers already sent by (output started at .../classes/database.php:230) in .../commonfuncs.php on line 310*"
(309 AND 310
if (strlen($value) > 3000) setcookie($name, " ", 1);
else setcookie($name, "$value", $duration); )
and then
"Warning: Cannot modify header information - headers already sent by (output started at .../classes/database.php:230) in .../commonfuncs.php on line 310"
Warning: Cannot modify header information - headers already sent by (output started at .../classes/database.php:230) in .../end.php on line 29*"
(* // fix possible 500 errors by clariflying content type)
...and the test is finished because i can't logout : i'm deconnected a few seconds and reconnected as the admin (even if i try to connect as a member at this moment)
thank you
charles
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Just turn debug mode off, login as a member, go to the page, and add &debug=1 onto the end of the url of the page. Copy and paste the result here.
Experienced
Usergroup: Customer
Joined: Oct 21, 2003
Total Topics: 21
Total Comments: 53
i can't :
i identify as a member
i get the page of the only category i can get as a member
when i want to go up to the main directory with the link .../index.php i get it AND the message
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /.../classes/database.php on line 69
of course adding &debug=1 to http://.../index.php doesn't work
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
of course adding &debug=1 to http://.../index.php doesn't work
Huh? How can modifying your browser's url not work? Unless you don't have a query string, in which case of course you need a ? instead of a &. But if you're in a category as you say you are then you must have a query string.
Experienced
Usergroup: Customer
Joined: Oct 21, 2003
Total Topics: 21
Total Comments: 53
si i did http://.../index.php?debug=1 instead of http://.../index.php?debug=1 (file not found)
and i get
...
Warning: Cannot modify header information - headers already sent by (output started at /home/sites/site103/web/sikyak/classes/database.php:230) in /home/sites/site103/web/sikyak/prestart.php on line 115
...
Warning: Cannot modify header information - headers already sent by (output started at /home/sites/site103/web/sikyak/classes/database.php:230) in /home/sites/site103/web/sikyak/commonfuncs.php on line 310
Warning: Cannot modify header information - headers already sent by (output started at /home/sites/site103/web/sikyak/classes/database.php:230) in /home/sites/site103/web/sikyak/end.php on line 29
...
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/sites/site103/web/sikyak/classes/database.php on line 69
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Since you went to the trouble of posting the exact lines that header warnings occour on in debug mode (while omiting the actual debug mode info), please read scripts.webmastersite.net/w...nks/wsnmanual/articles/216 in order to avoid doing so again.
You keep omiting all of the information and posting useless stuff. I don't want to see your header information warnings or mysql warnings, I have to see the debug output. That is, obviously, the point of debug mode. I'm guessing you're actually seeing it, but replacing it with ... rather than posting it. Please copy and paste what's actually on your screen.
Experienced
Usergroup: Customer
Joined: Oct 21, 2003
Total Topics: 21
Total Comments: 53
As you understood, i do not understand very well the way it works : i hope you will excuse me making lose your time
you'll find hereunder the whole stuff :
Load time so far: 0.77 seconds.
Performing query: SELECT name,content FROM wsnlinks_settings WHERE id>0 ORDER BY id ASC ;
Number of rows is 250 for Resource id #19
Load time so far: 0.93 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 /.../classes/database.php:230) in /.../prestart.php on line 115
Load time so far: 1.21 seconds.
Performing query: SELECT name,value FROM wsnlinks_switches WHERE id>0 ;
Number of rows is 23 for Resource id #31
Load time so far: 1.25 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 #34
Load time so far: 1.27 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 #35
Load time so far: 1.28 seconds.
Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 ;
Number of rows is 2 for Resource id #36
Load time so far: 1.28 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>0 ;
Load time so far: 1.3 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=2 AND validated=1 ;
Load time so far: 1.43 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 2 for Resource id #41
Load time so far: 1.47 seconds.
Performing query: SELECT id,`to`,subject,message,headers,replacement,mime FROM wsnlinks_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10;
Number of rows is 0 for Resource id #42
Load time so far: 1.5 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 2 for Resource id #45
Load time so far: 1.51 seconds.
Performing query: SELECT id FROM wsnlinks_categories WHERE parent=0 AND validated=1 AND hide=0 ;
Number of rows is 2 for Resource id #46
Warning: Cannot modify header information - headers already sent by (output started at /.../classes/database.php:230) in /.../commonfuncs.php on line 310
Warning: Cannot modify header information - headers already sent by (output started at /.../classes/database.php:230) in /.../end.php on line 29
Load time so far: 1.72 seconds.
Performing query: UPDATE wsnlinks_sessions SET starttime='0' WHERE time < 15;
Load time so far: 1.82 seconds.
Performing query: UPDATE wsnlinks_sessions SET time='0' WHERE time < 15;
Load time so far: 1.87 seconds.
Performing query: SELECT starttime FROM wsnlinks_sessions WHERE memberid=2 ;
Number of rows is 1 for Resource id #48
Load time so far: 1.9 seconds.
Performing query: UPDATE wsnlinks_sessions SET time='1106642198', location='http://.../index.php?debug=1', catid='', threadid='', areaname='Principal' WHERE memberid=2;
Load time so far: 1.91 seconds.
Performing query: SELECT id FROM wsnlinks_sessions WHERE memberid>0 ;
Number of rows is 1 for Resource id #49
Load time so far: 1.92 seconds.
Performing query: SELECT id FROM wsnlinks_sessions WHERE memberid=0 ;
Number of rows is 0 for Resource id #50
Load time so far: 2.62 seconds.
Performing query: SELECT id FROM wsnlinks_pm WHERE timeread=0 AND time > 0 AND deleted=0 AND toid=2 ;
Number of rows is 0 for Resource id #51
Load time so far: 2.63 seconds.
Performing query: SELECT id FROM wsnlinks_pm WHERE deleted=0 AND time > 0 AND toid=2 ;
Number of rows is 0 for Resource id #52
Load time so far: 2.69 seconds.
Performing query: SELECT id FROM wsnlinks_links WHERE validated=1 AND hide=0 AND inhidden=0 AND alias=0 AND inalbum=0 ;
Number of rows is 1 for Resource id #53
Load time so far: 2.69 seconds.
Performing query: SELECT id,title,url,description,rating,votes,validated,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,type,filename,filetitle,notify,suspect,downloads,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 FROM wsnlinks_links WHERE validated=1 AND hide=0 AND inhidden=0 AND alias=0 AND inalbum=0 ORDER BY id DESC LIMIT 0,5;
Number of rows is 1 for Resource id #54
Load time so far: 2.69 seconds.
Performing query: SELECT id,title,url,description,rating,votes,validated,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,type,filename,filetitle,notify,suspect,downloads,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 FROM wsnlinks_links WHERE validated=1 AND hide=0 AND inhidden=0 AND alias=0 AND inalbum=0 ORDER BY id DESC LIMIT 1,5;
Load time so far: 2.77 seconds.
Performing query: SELECT id,title,url,description,rating,votes,validated,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,type,filename,filetitle,notify,suspect,downloads,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 FROM wsnlinks_links WHERE id= ;
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /.../classes/database.php on line 69
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
Load time so far: 2.78 seconds.
Performing query: SELECT id FROM wsnlinks_sessions WHERE 1=1 AND (memberid>0) ;
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
Number of rows is 1 for Resource id #56
Load time so far: 2.79 seconds.
Performing query: SELECT id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname FROM wsnlinks_sessions WHERE 1=1 AND (memberid>0) ORDER BY time DESC LIMIT 0,100;
Number of rows is 1 for Resource id #57
Load time so far: 2.79 seconds.
Performing query: SELECT id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname FROM wsnlinks_sessions WHERE 1=1 AND (memberid>0) ORDER BY time DESC LIMIT 1,100;
thank you
charles
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Load time so far: 2.77 seconds.
Performing query: SELECT id,title,url,description,rating,votes,validated,catid,sumofvotes,email,time ,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,type,filename,fil etitle,notify,suspect,downloads,pendingedit,funds,suspended,alias,expire,ip ,inalbum,typeorder,recipurl,hitsin,recipwith,hitsinips,hitsoutips,lastcomme nt,related,inhidden,viewers,threadviewers,hitsintemp,hitsouttemp,origtype,i mportance,parentids,timesdead,timesemailed,threadclosed,threadposters FROM wsnlinks_links WHERE id= ;
Based on the location, I'd guess this is something in or related to a toplist. It appears right after what appear to be two different toplists of 5 links, the latter of them being offset to start at the 2nd result for some reason. What toplists do you have?
Actually, since you said you're using 3.13, are you sure your issue isn't the same as https://www.webmastersite.net/forums/thread/4649 (though I don't remember a mysql error there, it's otherwise similar). It's always a good idea to update to the latest version when you get an error.
Experienced
Usergroup: Customer
Joined: Oct 21, 2003
Total Topics: 21
Total Comments: 53
As it is a test, i'm going to load the 3.14 version (i thought i had the last one);
it will be easier ... and i'll try it the same way ... and if the same problem occurs, i'll give you indications about toplists
Thank you anyway
Experienced
Usergroup: Customer
Joined: Oct 21, 2003
Total Topics: 21
Total Comments: 53
As it is a test, i'm going to load the 3.14 version (i thought i had the last one);
it will be easier ... and i'll try it the same way ... and if the same problem occurs, i'll give you indications about toplists
Thank you anyway
ps : and i will also try to configurate FIRST vote values (post in basic)
Charles