Raised This Month: $ Target: $400
 0% 

[MYSQL] No more results in handle *


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
v3x
Veteran Member
Join Date: Oct 2004
Location: US
Old 02-28-2006 , 08:11   [MYSQL] No more results in handle *
Reply With Quote #1

I'm getting these errors in the logs:
Code:
L 02/28/2006 - 07:00:09: [MYSQL] No more results in handle 5
L 02/28/2006 - 07:00:09: [AMXX] Displaying debug trace (plugin "freegun2.amxx")
L 02/28/2006 - 07:00:09: [AMXX] Run time error 10: native error (native "dbi_result")
L 02/28/2006 - 07:00:09: [AMXX]    [0] freegun2.sma::get_user_hours (line 433)
L 02/28/2006 - 07:00:09: [AMXX]    [1] freegun2.sma::CheckSpawn (line 365)
L 02/28/2006 - 07:00:16: [MYSQL] No more results in handle 0
L 02/28/2006 - 07:00:16: [AMXX] Displaying debug trace (plugin "freegun2.amxx")
L 02/28/2006 - 07:00:16: [AMXX] Run time error 10: native error (native "dbi_result")
L 02/28/2006 - 07:00:16: [AMXX]    [0] freegun2.sma::get_user_hours (line 433)
L 02/28/2006 - 07:00:16: [AMXX]    [1] freegun2.sma::CheckSpawn (line 365)
L 02/28/2006 - 07:00:17: [MYSQL] No more results in handle 1
L 02/28/2006 - 07:00:17: [AMXX] Displaying debug trace (plugin "freegun2.amxx")
L 02/28/2006 - 07:00:17: [AMXX] Run time error 10: native error (native "dbi_result")
L 02/28/2006 - 07:00:17: [AMXX]    [0] freegun2.sma::get_user_hours (line 433)
L 02/28/2006 - 07:00:17: [AMXX]    [1] freegun2.sma::CheckSpawn (line 365)
L 02/28/2006 - 07:00:21: [MYSQL] No more results in handle 2
L 02/28/2006 - 07:00:21: [AMXX] Displaying debug trace (plugin "freegun2.amxx")
L 02/28/2006 - 07:00:21: [AMXX] Run time error 10: native error (native "dbi_result")
L 02/28/2006 - 07:00:21: [AMXX]    [0] freegun2.sma::get_user_hours (line 433)
L 02/28/2006 - 07:00:21: [AMXX]    [1] freegun2.sma::CheckSpawn (line 365)
and here's the function "get_user_hours":
Code:
public get_user_hours(id) {   new szAuthID[33];   get_user_authid(id , szAuthID , 32);   result = dbi_query(dbc , "SELECT * FROM `%s` WHERE `authid` = '%s'" , TABLE_USERS , szAuthID);   if(result == RESULT_NONE) {     new szUserName[33] , szAuthID[33];     get_user_name(id , szUserName , 32);     get_user_authid(id , szAuthID , 32);     dbi_query(dbc , "INSERT INTO `%s` (authid , name , time ) VALUES ('%s' , '%s' , '0')" , TABLE_USERS , szAuthID , szUserName);     return 0;   }     new tmp;   dbi_result(result , "time" , tmp); // line 365   dbi_free_result(result);   tmp /= 60;   tmp /= 60;   if(tmp <= 0)     return 0;   return tmp; }
Help would be appreciated seeming how `nobody` is on IRC at the moment. Thanks.
__________________
What am I doing these days? Well, I run my own Rust server. It's heavily modded. If you'd like to join, the ip is 167.114.101.67:28116

I also created a website called Rust Tools. It will calculate and tell you the raw amounts of resources needed to craft items.
v3x is offline
PM
hello, i am pm
Join Date: Jan 2004
Location: Canalization
Old 02-28-2006 , 08:32  
Reply With Quote #2

hello; i am pm

I've just read this other post with FakeNatives and whatnot and BAIL said you need dbi_nextrow or something there so you might want to check that out.




pm


edit: be sure to check out the example here
edit2: which I don't like because it doesn't handle errors properly
__________________
hello, i am pm
PM is offline
v3x
Veteran Member
Join Date: Oct 2004
Location: US
Old 02-28-2006 , 09:02  
Reply With Quote #3

Oh why thank you PM

Maybe someone else could provide a better example?
__________________
What am I doing these days? Well, I run my own Rust server. It's heavily modded. If you'd like to join, the ip is 167.114.101.67:28116

I also created a website called Rust Tools. It will calculate and tell you the raw amounts of resources needed to craft items.
v3x is offline
Sandurr
Senior Member
Join Date: Aug 2005
Old 02-28-2006 , 10:47  
Reply With Quote #4

isn't it
Code:
tmp = dbi_field(result , "time");

instead of
Code:
dbi_result(result , "time" , tmp); // line 365
Sandurr is offline
Freecode
Never Fall Asleep
Join Date: Jan 2004
Old 02-28-2006 , 15:55  
Reply With Quote #5

Edit this
Code:
if(result == RESULT_NONE) {
to this
Code:
if(result == RESULT_NONE || !dbi_nextrow(result) ) {
Freecode is offline
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

Forum Jump


All times are GMT -4. The time now is 20:28.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode