Raised This Month: $ Target: $400
 0% 

Run Time Error 10


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
ProIcons
Senior Member
Join Date: Jan 2009
Location: Greece - Salonica
Old 07-26-2009 , 06:27   Run Time Error 10
Reply With Quote #1

PHP Code:
new players[32], pnumtempid;
    
get_players(playerspnum);
    for( new 
ii<pnumi++ )
    {
       
tempid players[i];
       new 
Player[32]
       
get_user_name(tempid,Player,31)
       
query SQL_PrepareQuery(con2"SELECT * FROM players WHERE username='%s'",Player)
       
SQL_Execute(query)
       
SQL_NextRow(query)
       new 
kills SQL_ReadResult(query3)
       new 
deaths SQL_ReadResult(query4)
       
set_hudmessage(255170420.10.000.199999.00.00.0534)
       
show_hudmessage(tempid"Kills: %s ^n   Deaths: %s",kills,deaths)
    } 
Quote:
L 07/26/2009 - 13:27:09: [MySQL] No result set in this query!
L 07/26/2009 - 13:27:09: [AMXX] Run time error 10 (plugin "gather.amxx") (native "SQL_NextRow") - debug not enabled!
__________________
function rb return $regsubex($$1-,/(.)/g,$+($chr(2) $+ $chr(3),$r(2,15),$chr(2),\1))
ProIcons is offline
dorin2oo7
Senior Member
Join Date: Jun 2008
Location: Sibiu, Romania
Old 07-26-2009 , 06:36   Re: Run Time Error 10
Reply With Quote #2

first enable debug by adding debug word after the plugin name in plugins.ini then post the error !
__________________
dorin2oo7 is offline
ProIcons
Senior Member
Join Date: Jan 2009
Location: Greece - Salonica
Old 07-26-2009 , 07:26   Re: Run Time Error 10
Reply With Quote #3

Quote:
L 07/26/2009 - 14:26:28: [AMXX] Displaying debug trace (plugin "gather.amxx")
L 07/26/2009 - 14:26:28: [AMXX] Run time error 10: native error (native "SQL_NextRow")
L 07/26/2009 - 14:26:28: [AMXX] [0] Gather.sma::show_msg (line 841)
L 07/26/2009 - 14:26:29: [MySQL] No result set in this query!
__________________
function rb return $regsubex($$1-,/(.)/g,$+($chr(2) $+ $chr(3),$r(2,15),$chr(2),\1))
ProIcons is offline
dorin2oo7
Senior Member
Join Date: Jun 2008
Location: Sibiu, Romania
Old 07-28-2009 , 09:45   Re: Run Time Error 10
Reply With Quote #4

can you post gather.sma to check the error line !!!?
__________________
dorin2oo7 is offline
MrOpposite
Junior Member
Join Date: Jul 2009
Location: Sverige FTW
Old 07-28-2009 , 09:50   Re: Run Time Error 10
Reply With Quote #5

PHP Code:
new players[32], pnumtempid;
    
get_players(playerspnum);
    for( new 
ii<pnumi++ )
    {
       
tempid players[i];
       new 
Player[32]
       
get_user_name(tempid,Player,31)
       
query SQL_PrepareQuery(con2"SELECT * FROM players WHERE username='%s'",Player)
       
SQL_Execute(query)
       
SQL_NextRow(query//THIS IS THE ROW
       
new kills SQL_ReadResult(query3)
       new 
deaths SQL_ReadResult(query4)
       
set_hudmessage(255170420.10.000.199999.00.00.0534)
       
show_hudmessage(tempid"Kills: %s ^n   Deaths: %s",kills,deaths)
    } 
That is based of the error message...

EDIT:
We still need much more of the source though
__________________
^^,
MrOpposite is offline
dorin2oo7
Senior Member
Join Date: Jun 2008
Location: Sibiu, Romania
Old 07-29-2009 , 09:21   Re: Run Time Error 10
Reply With Quote #6

Quote:
Originally Posted by MrOpposite View Post
PHP Code:
new players[32], pnumtempid;
    
get_players(playerspnum);
    for( new 
ii<pnumi++ )
    {
       
tempid players[i];
       new 
Player[32]
       
get_user_name(tempid,Player,31)
       
query SQL_PrepareQuery(con2"SELECT * FROM players WHERE username='%s'",Player)
       
SQL_Execute(query)
       
SQL_NextRow(query//THIS IS THE ROW
       
new kills SQL_ReadResult(query3)
       new 
deaths SQL_ReadResult(query4)
       
set_hudmessage(255170420.10.000.199999.00.00.0534)
       
show_hudmessage(tempid"Kills: %s ^n   Deaths: %s",kills,deaths)
    } 
That is based of the error message...

EDIT:
We still need much more of the source though
as you se in your error L 07/26/2009 - 14:26:28: [AMXX] [0] Gather.sma::show_msg (line 841) i need all *.sma to find line 841 that contains the error. As you posted above is not that much lines !!!
__________________
dorin2oo7 is offline
Bugsy
AMX Mod X Moderator
Join Date: Feb 2005
Location: NJ, USA
Old 07-29-2009 , 09:45   Re: Run Time Error 10
Reply With Quote #7

PHP Code:
show_hudmessage(tempid"Kills: %s ^n   Deaths: %s",kills,deaths
Not the cause of this error but you should be using %d for integers, %s is for strings.
__________________
Bugsy is offline
Reply



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 18:24.


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