exactly the same procedure as in my first post, now on clean 3.4.2
debug output: (the error is at the bottom): ----------------------------------------------
Load time so far: 0.2 seconds. Performing query: DELETE FROM wsnlinks_members WHERE validated=0 AND time<1154996082;
Load time so far: 0.2 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 FROM wsnlinks_links WHERE validated=0 AND alias=0 ORDER BY id ASC LIMIT -30,30;
Number of rows is 0 for Resource id #55
Load time so far: 0.2 seconds. Performing query: SELECT COUNT(id) FROM wsnlinks_modlog WHERE memberid>1 and nature='suggested ban' ;
Count is 0
Load time so far: 0.24 seconds. Performing query: SELECT COUNT(id) FROM wsnlinks_links WHERE validated=0 ;
Count is 0
Load time so far: 0.24 seconds. Performing query: SELECT COUNT(id) FROM wsnlinks_links WHERE pendingedit != '' ;
Count is 0
Load time so far: 0.24 seconds. Performing query: SELECT COUNT(id) FROM wsnlinks_categories WHERE validated=0 ;
Count is 0
Load time so far: 0.24 seconds. Performing query: SELECT COUNT(id) FROM wsnlinks_comments WHERE validated=0 ;
Count is 0
Load time so far: 0.24 seconds. Performing query: SELECT COUNT(id) FROM wsnlinks_members WHERE validated=0 ;
Count is 0
Load time so far: 0.24 seconds. Performing query: SELECT id FROM wsnlinks_members WHERE id>0 ;
Number of rows is 1 for Resource id #64
Load time so far: 0.29 seconds. Performing query: SELECT COUNT(id) FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND parent=0 AND deleted=0 ;
Count is 0
Load time so far: 0.29 seconds. Performing query: SELECT COUNT(id) FROM WHERE categoriestable validated=1 AND hide=0 AND isalbum=0 AND deleted=0;
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /var/hsphere/local/home/serkino/fantasy-post.com/links2/classes/database.php on line 256 Count is
Comments on database.php on line 256
Experienced
Usergroup: Customer
Joined: Feb 22, 2004
Total Topics: 47
Total Comments: 88
After a clean install of 3.4.1 (and new database), the directory stats in admin page says:
"Categories: 0 ( 2 counting subcategories)"
if i regenerate everything, and return in admin main page, i get the following message:
"Warning: mysql_result(): supplied argument is not a valid MySQL result resource in d:\phpdev\www\wsnlinks\classes\database.php on line 256"
this happens only in admin main page, not in other admin page or in the directory.
Also, i enabled to show queries at bottom, but it is not working in admin main page.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Go to yourinstallpath/admin/index...ndex.php?show=main&debug=1 to get the debug output.
Experienced
Usergroup: Customer
Joined: Feb 22, 2004
Total Topics: 47
Total Comments: 88
exactly the same procedure as in my first post, now on clean 3.4.2
debug output: (the error is at the bottom):
----------------------------------------------
Load time so far: 0.2 seconds.
Performing query: DELETE FROM wsnlinks_members WHERE validated=0 AND time<1154996082;
Load time so far: 0.2 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 FROM wsnlinks_links WHERE validated=0 AND alias=0 ORDER BY id ASC LIMIT -30,30;
Number of rows is 0 for Resource id #55
Load time so far: 0.2 seconds.
Performing query: SELECT COUNT(id) FROM wsnlinks_modlog WHERE memberid>1 and nature='suggested ban' ;
Count is 0
Load time so far: 0.24 seconds.
Performing query: SELECT COUNT(id) FROM wsnlinks_links WHERE validated=0 ;
Count is 0
Load time so far: 0.24 seconds.
Performing query: SELECT COUNT(id) FROM wsnlinks_links WHERE pendingedit != '' ;
Count is 0
Load time so far: 0.24 seconds.
Performing query: SELECT COUNT(id) FROM wsnlinks_categories WHERE validated=0 ;
Count is 0
Load time so far: 0.24 seconds.
Performing query: SELECT COUNT(id) FROM wsnlinks_comments WHERE validated=0 ;
Count is 0
Load time so far: 0.24 seconds.
Performing query: SELECT COUNT(id) FROM wsnlinks_members WHERE validated=0 ;
Count is 0
Load time so far: 0.24 seconds.
Performing query: SELECT id FROM wsnlinks_members WHERE id>0 ;
Number of rows is 1 for Resource id #64
Load time so far: 0.29 seconds.
Performing query: SELECT COUNT(id) FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND parent=0 AND deleted=0 ;
Count is 0
Load time so far: 0.29 seconds.
Performing query: SELECT COUNT(id) FROM WHERE categoriestable validated=1 AND hide=0 AND isalbum=0 AND deleted=0;
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /var/hsphere/local/home/serkino/fantasy-post.com/links2/classes/database.php on line 256
Count is
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Fixed for 3.4.3.