Raised This Month: $51 Target: $400
 12% 

Help storing


Post New Thread Reply   
 
Thread Tools Display Modes
Bugsy
AMX Mod X Moderator
Join Date: Feb 2005
Location: NJ, USA
Old 07-28-2015 , 07:26   Re: Help storing
Reply With Quote #21

You are using the wrong code, this is the latest:

https://forums.alliedmods.net/showpo...4&postcount=18
__________________
Bugsy is offline
Loupu.
Member
Join Date: Jul 2013
Old 07-28-2015 , 15:54   Re: Help storing
Reply With Quote #22

L 07/28/2015 - 181:57: [AMXX] Plugin says: Query failed.
L 07/28/2015 - 181:57: [AMXX] Displaying debug trace (plugin "ace.amxx")
L 07/28/2015 - 181:57: [AMXX] Run time error 1: forced exit
L 07/28/2015 - 181:57: [AMXX] [0] c0x7qd31.sma.p::SelectHandle (line 132)
line 123: return set_fail_state( "Query failed." );
i connected to my database g_SQLTuple = SQL_MakeDbTuple( "myhost" , "myuser" , "mypass" , "mydb" );
and tryed plugin how it was , i mean without host etc , but doesnt worked too... same error that query failed..
Loupu. is offline
Bugsy
AMX Mod X Moderator
Join Date: Feb 2005
Location: NJ, USA
Old 07-28-2015 , 17:13   Re: Help storing
Reply With Quote #23

Does the database file exist? HLServer\cstrike\addons\amxmodx\data\sqlite3\ Aces.sq3

I'm not sure that it's an actual connection problem, appears to be an issue with a query. At what point does this happen (map-change/start, player connect, player disconnect, /aces command)? I just tested it myself and could not get it to throw an error.

PHP Code:
if( FailState == TQUERY_CONNECT_FAILED )
    return 
set_fail_state("Could not connect to SQL database." );
else if( 
FailState == TQUERY_QUERY_FAILED )
    return 
set_fail_state"Query failed." );  <----Query issue 
__________________

Last edited by Bugsy; 07-28-2015 at 17:35.
Bugsy is offline
Loupu.
Member
Join Date: Jul 2013
Old 07-28-2015 , 18:34   Re: Help storing
Reply With Quote #24

yeap the database exists, and i think it gets a problem when i type /ace
Loupu. is offline
Bugsy
AMX Mod X Moderator
Join Date: Feb 2005
Location: NJ, USA
Old 07-28-2015 , 19:09   Re: Help storing
Reply With Quote #25

Can you upload your database file so I can take a look and test it on my machine? Mask the steam-id's for privacy. If you dont have anything to do this with, I highly recommend DB Browser for SQLite
__________________
Bugsy is offline
Loupu.
Member
Join Date: Jul 2013
Old 07-29-2015 , 02:51   Re: Help storing
Reply With Quote #26

here is it
Attached Files
File Type: zip Aces.zip (78.6 KB, 21 views)
Loupu. 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 11:44.


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