Usergroup: Member
Joined: Oct 16, 2004
Total Topics: 2
Total Posts: 4
Posted 10/20/04 - 06:04 PM:
#1
Filename: index.php Error: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/occlicks/public_html/classes/database.php on line 72 Occurred: After I upgraded to 3.12. Website: http://www.occlicks.com
Debug Code:
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 links_categories WHERE validated=1 AND hide=0 ;
Number of rows is 399 for Resource id #39
Performing query: SELECT id,`to`,subject,message,headers,replacement,mime FROM links_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10;
Number of rows is 0 for Resource id #40
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 links_categories WHERE parent=0 AND validated=1 AND hide=0 AND isalbum=0 ORDER BY name ASC LIMIT 0,100;
Number of rows is 12 for Resource id #43
Performing query: SELECT id FROM links_categories WHERE parent=0 AND validated=1 AND hide=0 ;
Number of rows is 12 for Resource id #44
Performing query: UPDATE links_sessions SET starttime='0' WHERE time < 15;
Performing query: UPDATE links_sessions SET time='0' WHERE time < 15;
Performing query: SELECT starttime FROM links_sessions WHERE memberid=1 ;
Number of rows is 1 for Resource id #46
Performing query: UPDATE links_sessions SET time='1098319713', location='http://www.occlicks.com/index.php', catid='', threadid='', areaname='Directory, Local Links, Business Guide, Yellow Pages' WHERE memberid=1;
Performing query: SELECT id FROM WHERE validated=1 ;
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/occlicks/public_html/classes/database.php on line 72
Number of rows is 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 'WHERE validated=1' at line 1
Performing query: SELECT FROM WHERE validated=1 ORDER BY DESC LIMIT 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 'WHERE validated=1' at line 1
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/occlicks/public_html/classes/database.php on line 72
Number of rows is 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 'FROM WHERE validated=1 ORDER BY DESC LIMIT 0,' at line 1
Performing query: SELECT FROM WHERE validated=1 ORDER BY DESC LIMIT 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 'FROM WHERE validated=1 ORDER BY DESC LIMIT 0,' at line 1
Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 5703
Posted 10/22/04 - 01:33 AM:
#2
You're missing a table name, probably the links table, probalby from sending some sort of interfering value to the page. Does this page have toplists of links on it?
Where exactly is this output on your site? I can't find any pages that show warnings.
Print
MYSQL Error: database.php on line 72