+- SphereCommunity (https://forum.spherecommunity.net)
+-- Forum: Sphere 0.56d (/Forum-Sphere-0-56d)
+--- Forum: General Help (/Forum-General-Help)
+--- Thread: Problems with MAIN THREAD (/Thread-Problems-with-MAIN-THREAD)
Problems with MAIN THREAD - Lazarus - 08-16-2012 02:52 AM
Code:
22:27:CRITICAL:'Main' thread hang, restarting...
22:30:WARNING:Forcing thread 'Main' to terminate...
22:30:Sphere Version 0.56b-Nightly [WIN32] by www.sphereserver.com, compiled at Jul 2 2012 (00:04:39), internal build #1519
22:30:WARNING: --- WARNING ---I had to erase the mysql because the server get freezed and somethings sends some like this...
What should I do?
A great scripter have tell's me that change the QUERY for AQUERY and something else that i don't remember ^_^
Any ideas?
Thanks!
Lazarus.
RE: Problems with MySQL - Shaklaban - 08-16-2012 03:02 AM
its depended on your sql statements, how many rows you returned from mysql and for what purpose?
RE: Problems with MySQL - Lazarus - 08-16-2012 06:24 AM
(08-16-2012 03:02 AM)Shaklaban Wrote: its depended on your sql statements, how many rows you returned from mysql and for what purpose?
Code:
[function f_acc_update]
if !( <DB.connected> )
DB.CONNECT
ENDIF
DB.QUERY "SELECT * FROM accounts WHERE status='0'"
if (<DB.ROW.NUMROWS> > 0)
for R 0 <eval <DB.ROW.NUMROWS>-1>
serv.account add <DB.ROW.<eval <LOCAL.R>>.login> <DB.ROW.<eval <LOCAL.R>>.password>
DB.EXECUTE "UPDATE accounts SET status='1' WHERE login='<DB.ROW.<eval <LOCAL.R>>.login>'"
serv.log MySQL Debug: #<eval <LOCAL.R>> La cuenta "<DB.ROW.<eval <LOCAL.R>>.login>" ha sido creada
end
endifthat is the script
it's just create accounts by web.
RE: Problems with MySQL - Shaklaban - 08-16-2012 06:26 AM
how many accounts created for one instance? for the hang the main thread, thousands of accounts needs to be created.
also if your mysql server is not in the local network your server can always freeze due to slow connection between two servers.
RE: Problems with MySQL - Lazarus - 08-16-2012 07:17 AM
(08-16-2012 06:26 AM)Shaklaban Wrote: how many accounts created for one instance? for the hang the main thread, thousands of accounts needs to be created.
also if your mysql server is not in the local network your server can always freeze due to slow connection between two servers.
I guess that's the problem...
I have the mysql server in other server..
Any idea?
The script it's OK?
RE: Problems with MySQL - Shaklaban - 08-16-2012 03:28 PM
scripts is ok.
RE: Problems with MySQL - Extreme - 08-16-2012 04:18 PM
[function f_acc_update]
if !( <DB.connected> )
DB.CONNECT
ENDIF
DB.QUERY "SELECT * FROM accounts WHERE status='0'"
if (<DB.ROW.NUMROWS> > 0)
for R 0 <eval <DB.ROW.NUMROWS>-1>
serv.account add <DB.ROW.<eval <LOCAL.R>>.login> <DB.ROW.<eval <LOCAL.R>>.password>
DB.EXECUTE "UPDATE accounts SET status='1' WHERE login='<DB.ROW.<eval <LOCAL.R>>.login>'"
serv.log MySQL Debug: #<eval <LOCAL.R>> La cuenta "<DB.ROW.<eval <LOCAL.R>>.login>" ha sido creada
endfor
endif
RE: Problems with MySQL - Shaklaban - 08-16-2012 11:27 PM
haha epic
RE: Problems with MySQL - Lazarus - 08-16-2012 11:30 PM
(08-16-2012 04:18 PM)Extreme Wrote: [function f_acc_update]
if !( <DB.connected> )
DB.CONNECT
ENDIF
DB.QUERY "SELECT * FROM accounts WHERE status='0'"
if (<DB.ROW.NUMROWS> > 0)
for R 0 <eval <DB.ROW.NUMROWS>-1>
serv.account add <DB.ROW.<eval <LOCAL.R>>.login> <DB.ROW.<eval <LOCAL.R>>.password>
DB.EXECUTE "UPDATE accounts SET status='1' WHERE login='<DB.ROW.<eval <LOCAL.R>>.login>'"
serv.log MySQL Debug: #<eval <LOCAL.R>> La cuenta "<DB.ROW.<eval <LOCAL.R>>.login>" ha sido creada
endfor
endif
that's all the problem! :||||||||
god why
[I don't understand of MySQL, my spherescripting SUCKS very much, but... I have a staff with this, I only post in the forums and ask the problems ^_^]
That can be all?
RE: Problems with MySQL - Extreme - 08-17-2012 01:05 AM
Don't worry, where are there to help when someone need help.