Raised This Month: $32 Target: $400
 8% 

SQLx freezes bad?


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
ARES[ro]
Senior Member
Join Date: Apr 2010
Old 01-06-2011 , 21:43   SQLx freezes bad?
Reply With Quote #1

server freezes after line 51 (the last debug message i see)
Maybe you guys can find the damn error its very well hidden believe me I had a few ppl look at it already. this really wasted so much of my time I might even start over...
Attached Files
File Type: sma Get Plugin or Get Source (forum_registration.sma - 590 views - 4.8 KB)
__________________
okay

Last edited by ARES[ro]; 01-06-2011 at 21:49.
ARES[ro] is offline
Sylwester
Veteran Member
Join Date: Oct 2006
Location: Poland
Old 01-07-2011 , 04:39   Re: SQLx freezes bad?
Reply With Quote #2

It works for me.
Code:
L 01/07/2011 - 10:15:56: -------- Mapchange to de_dust2 --------
[AMXX] Loaded 4 admins from file
L 01/07/2011 - 10:15:56: [forum_registration.amxx] connecting to: 127.0.0.1 root  test
L 01/07/2011 - 10:15:57: [AMXX] Plugin ("forum_registration.amxx") is setting itself as failed.
L 01/07/2011 - 10:15:57: [AMXX] Plugin says: Can't connect to MySQL server on '127.0.0.1' (10061)
L 01/07/2011 - 10:15:57: [AMXX] Run time error 1 (plugin "forum_registration.amxx") - forced exit
Executing AMX Mod X Configuration File
reload
L 01/07/2011 - 10:16:56: -------- Mapchange to de_dust2 --------
[AMXX] Loaded 4 admins from file
L 01/07/2011 - 10:16:57: [forum_registration.amxx] connecting to: 127.0.0.1 root  test
Executing AMX Mod X Configuration File
L 01/07/2011 - 10:17:53: [forum_registration.amxx] load query: SELECT * FROM phpbb_profile_fields_data WHERE pf_steamid='STEAM_0:0:2728585' AND verified='0'
L 01/07/2011 - 10:17:53: [forum_registration.amxx] i got here
L 01/07/2011 - 10:17:53: [forum_registration.amxx] SQL Error: Table 'test.phpbb_profile_fields_data' doesn't exist (1146)
It's my server console output first without mysql and then with mysql running
I added 1 more log_amx in line 32:
PHP Code:
    log_amx("connecting to: %s %s %s %s"HostUserPassDb
The only problem I can see in this part is loading sql host, user, pass and db. If you add this line you will notice that they are updated only after additional mapchange because you didn't add any delay and tried to get them in plugin_init when config files were not executed yet.
__________________
Impossible is Nothing
Sylwester is offline
xPaw
Retired AMX Mod X Moderator
Join Date: Jul 2008
Old 01-07-2011 , 07:16   Re: SQLx freezes bad?
Reply With Quote #3

Side note: Why you open a SQL connection (SqlConnection), you never use it and never close.
__________________
xPaw is offline
ARES[ro]
Senior Member
Join Date: Apr 2010
Old 01-07-2011 , 10:05   Re: SQLx freezes bad?
Reply With Quote #4

KK so it might be a situational problem thanks a lot guys u made me very happy.
although thats the worst case scenario expected :[

Quote:
Originally Posted by xPaw View Post
Side note: Why you open a SQL connection (SqlConnection), you never use it and never close.
It`s SQLx not DBI No connection is kept constantly open.

edit: maybe yours worked as there couldnt be any data returned. So my opinion is that the data my mySQL returns would be somehow hard to read for the SQLx or maybe it gets stuck somewhere. This could very well be a issue in the module itself idk much about it im just saying. But I have to add that I know my queries work i have tested them manually before using them in my plugin. This is a bad position to be in. Idk if some1 can really help here. I will have to start over the plugin and hopefully I can avoid this somehow?
__________________
okay

Last edited by ARES[ro]; 01-07-2011 at 10:16.
ARES[ro] 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 14:59.


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