WebmasterSite.net

sql errors after upgrade

Version: 5.1.7
URL: http://www.finsandfur.net

PrintPrint


sql errors after upgrade
finsandfur
Experienced

Usergroup: Customer
Joined: Apr 18, 2006

Total Topics: 27
Total Posts: 94
quote post #1
Posted 10/21/09 - 4:58 PM:

Paul, I'm suddenly getting an error at the top of all displaylinks pages, after upgrading to 5.1.7



Error occurred at http://www.finsandfur.net/index.ph...playcat&catname=Boats/ on 2009-10-22 00:42:51. Error text: Error #2: 'mysql_num_rows(): supplied argument is not a valid MySQL result resource' in /home/finsnet/public_html/databases/mysql.php on line 70. 


Last SQL error: 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



Debug info:


`invisibleto`,`profileurl`,`lastprofileurl`,`timesrenewed`,`timedeleted`,`sponsorend`,`address`,`city`,`state`,`country`,`latitude`,`longitude`,`zip`,`phone`,`summary`,`active`,`sponsorendtime`,`price` FROM wsnlinks_links WHERE catid=24 AND hide=0 AND validated=1 AND effectivetime < 1256172171 AND type = 'sponsor' ORDER BY title ASC,title ASC LIMIT 0,4


Load time so far: 0.21 seconds.




Number of rows is 0


Query 18: 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`,`pagerank`,`logoattach`,`validatedemail`,`unpaid`,`recipverified`,`effectivetime`,`sugcatid`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`feedcache`,`feedcachetime`,`tags`,`xmlsource`,`ordercomments`,`lastpadupdate`,`padfile`,`lastmonthlycheck`,`invisibleto`,`profileurl`,`lastprofileurl`,`timesrenewed`,`timedeleted`,`sponsorend`,`address`,`city`,`state`,`country`,`latitude`,`longitude`,`zip`,`phone`,`summary`,`active`,`sponsorendtime`,`price` FROM wsnlinks_links WHERE catid=24 AND hide=0 AND deleted=0 AND validated=1 AND effectivetime < 1256172171 AND type != 'sponsor' ORDER BY typeorder ASC,title ASC,title ASC LIMIT 0,


Load time so far: 0.21 seconds.



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



Step 1 of backtrace:


File: /home/finsnet/public_html/databases/mysql.php


Line: 70


Function: mysql_num_rows


Arguments:




Step 2 of backtrace:


File: /home/finsnet/public_html/classes/database.php


Line: 159


Function: numrows


Arguments:


Class: db




Step 3 of backtrace:


File: /home/finsnet/public_html/includes/displaycat.php


Line: 312


Function: numrows


Arguments:


Class: database




Step 4 of backtrace:


File: /home/finsnet/public_html/index.php


Line: 174


Function: require_once


Arguments: /home/finsnet/public_html/includes/displaycat.php


Edited by finsandfur on 10/21/09 - 5:01 PM
babrees
Expert
Avatar

Usergroup: Customer
Joined: Aug 19, 2005
Location: England

Total Topics: 392
Total Posts: 1287
quote post #2
Posted 10/21/09 - 9:03 PM:

Yep. I'm getting this too. I clicked on report error but not sure if it went as it just sent me to a 404 page

I'm not getting this on a NEW site I have just made with v.5.1.7

Edited by babrees on 10/21/09 - 9:10 PM
Paul
developer
Avatar

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

Total Topics: 65
Total Posts: 7614
quote post #3
Posted 10/23/09 - 12:13 AM:

Bug with sites where type mixing is off. Fixed in 5.1.9.
finsandfur
Experienced

Usergroup: Customer
Joined: Apr 18, 2006

Total Topics: 27
Total Posts: 94
quote post #4
Posted 10/23/09 - 2:51 AM:

Thank you sir.
 
Search thread for
Download thread as


Sorry, you don't have permission to post. Log in, or register if you haven't yet.