AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   SQLx freezes bad? (https://forums.alliedmods.net/showthread.php?t=147231)

ARES[ro] 01-06-2011 21:43

SQLx freezes bad?
 
1 Attachment(s)
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...

Sylwester 01-07-2011 04:39

Re: SQLx freezes bad?
 
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.

xPaw 01-07-2011 07:16

Re: SQLx freezes bad?
 
Side note: Why you open a SQL connection (SqlConnection), you never use it and never close.

ARES[ro] 01-07-2011 10:05

Re: SQLx freezes bad?
 
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 (Post 1388005)
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?


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

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