Nukemods Forum  
» Log in
User Name:

Password:

Not a member yet?
Register Now!
» Online Users: 52
4 members and 48 guests
bea9qgchcomberc, peardir46, ral6qkeighqenpa, whyjjinternetvi
Most users ever online was 611, 03-21-2008 at 10:10 PM.
» .::.
» .:.

Go Back   Nukemods Forum > NM Staff > Purged Topics

Reply
 
LinkBack Thread Tools Display Modes
Still getting this error
Old
  (#1 (permalink))
Junior Member
 
Status: Offline
Posts: 65
Join Date: Dec 2002
Location: Tulsa OK U.S.A
Still getting this error - 03-31-2003, 06:07 PM

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/somewhat/public_html/includes/sql_layer.php on line 253


I have gone through and disable and re-enables all modules and blocks, and nothing has gotten rid of this error, it is starting to piss me off, i may just delete the whole site and run a new fresh install 6.5


I am saving the world while you sleep
  Send a message via Yahoo to christian Send a message via AIM to christian Send a message via MSN to christian  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old
  (#2 (permalink))
Senior Member
 
Status: Offline
Posts: 2,905
Join Date: Sep 2002
03-31-2003, 07:56 PM

hey christian, can you turn on debugging? It will help you diagnose that error a little more.

Here's how

Open includes/sql_layer.php go to line 300(approximately) and change:
code:
Code:
case "MySQL": 
$row = mysql_fetch_row($res); 
return $row; 
break;;
to

Code:
case "MySQL": 
if ($row = mysql_fetch_row($res)) { 
return $row; 
} else { 
print (mysql_error()); 
} 
break;;
mikem
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old
  (#3 (permalink))
ads
Junior Member
 
Status: Offline
Posts: 87
Join Date: Mar 2003
Location: Mayagüez, Puerto Rico
03-31-2003, 09:18 PM

have you made any changes to the database receantly? Does this happen when you do something specific in your site?
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
8(
Old
  (#4 (permalink))
Junior Member
 
Status: Offline
Posts: 65
Join Date: Dec 2002
Location: Tulsa OK U.S.A
8( - 04-02-2003, 11:02 AM

ok, i have replaced that line, and nothing has changed, how do i know what the troubleshooting has found out???


www.somewhatlucky.com


I am saving the world while you sleep
  Send a message via Yahoo to christian Send a message via AIM to christian Send a message via MSN to christian  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old
  (#5 (permalink))
Moderator
 
Status: Offline
Posts: 338
Join Date: Jan 2003
04-02-2003, 11:21 AM

If you are running nuke 6.5 something is not right with your sql_layer.php file as line 253 is
case "ODBC":

this should not have any effect on your site if you use MySQL
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old
  (#6 (permalink))
Senior Member
 
Status: Offline
Posts: 2,905
Join Date: Sep 2002
04-02-2003, 11:36 AM

Quote:
Originally Posted by chatserv
If you are running nuke 6.5 something is not right with your sql_layer.php file as line 253 is
case "ODBC":

this should not have any effect on your site if you use MySQL
nah he's still running 6.0 with Toms' port.

mikem
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old
  (#7 (permalink))
Moderator
 
Status: Offline
Posts: 338
Join Date: Jan 2003
04-02-2003, 11:51 AM

Ok, then, he should change lines 252-255 in sql_layer.php from:
Code:
    case "MySQL":
        $rows=mysql_num_rows($res);
        return $rows;
    break;;
to:
Code:
    case "MySQL":
        if ($rows=mysql_num_rows($res)) {
        return $rows;
        } else {
        print (mysql_error());
        }
        break;;
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old
  (#8 (permalink))
Senior Member
 
Status: Offline
Posts: 2,905
Join Date: Sep 2002
04-02-2003, 11:53 AM

lol..ok..get out of the barn chatserv...he already did that too..look 3 or 4 posts up...You need some coffee.... 8O

mikem
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old
  (#9 (permalink))
Moderator
 
Status: Offline
Posts: 338
Join Date: Jan 2003
04-02-2003, 12:03 PM

Quote:
Originally Posted by mikem
lol..ok..get out of the barn chatserv...he already did that too..look 3 or 4 posts up...You need some coffee.... 8O

mikem
I don't like coffee so i'll do pepsi instead and maybe share some with you, what i may need are new glasses as i thought the code in the other post was meant for lines 300-303 and not for the ones i mentioned 8O

Now regarding the barn, i am out, i am getting a laptop so i can share with my sheep in the open. :twisted:
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old
  (#10 (permalink))
Senior Member
 
Status: Offline
Posts: 2,905
Join Date: Sep 2002
04-02-2003, 12:59 PM

Ahh I see..maybe I need to glasses. Yours was for numrows...

mikem
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error SQL Error : 1064 theme iCGstation XelAleX Nuke 7.x - Themes 0 03-21-2005 05:17 PM
error: phpBB critical error elb0m Purged Topics 15 01-24-2003 02:41 PM




vBulletin Skin developed by: vBStyles.com


LinkBacks Enabled by vBSEO 3.3.0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31