Webmastersite.net
Register Log In

database.php on line 256
on clean install

Comments on database.php on line 256

sertan6
Experienced

Usergroup: Customer
Joined: Feb 22, 2004

Total Topics: 47
Total Comments: 88
sertan6
Posted Aug 27, 2006 - 12:53 PM:

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.
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Aug 28, 2006 - 9:15 AM:

Go to yourinstallpath/admin/index...ndex.php?show=main&debug=1 to get the debug output.
sertan6
Experienced

Usergroup: Customer
Joined: Feb 22, 2004

Total Topics: 47
Total Comments: 88
sertan6
Posted Aug 28, 2006 - 1:28 PM:

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
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Aug 31, 2006 - 1:35 PM:

Fixed for 3.4.3.
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



This thread is closed, so you cannot post a reply.