Webmastersite.net
Register Log In

sql errors after upgrade

Title sql errors after upgrade
Message Text Paul, I'm suddenly getting an error at the top of all displaylinks pages, after upgrading to 5.1.7
Error occurred at [url=http://www.finsandfur.net/index.ph...playcat&catname=Boats/]http://www.finsandfur.net/index.ph...playcat&catname=Boats/[/url] 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
Rating
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5
0/5 based on 0 votes.
Ownership finsandfur
Views 278 views. Averaging 0 views per day.
Similar Topics
Submission Date Oct 21, 2009 - 7:58 PM