The following warnings occurred:
Warning [2] Use of undefined constant SAPI_NAME - assumed 'SAPI_NAME' (this will throw an Error in a future version of PHP) - Line: 3388 - File: inc/functions.php PHP 7.4.33-nmm7 (Linux)
File Line Function
/inc/functions.php 3388 errorHandler->error
/showthread.php 116 build_archive_link
Warning [2] Use of undefined constant IN_ARCHIVE - assumed 'IN_ARCHIVE' (this will throw an Error in a future version of PHP) - Line: 3331 - File: inc/functions.php PHP 7.4.33-nmm7 (Linux)
File Line Function
/inc/functions.php 3331 errorHandler->error
/inc/functions.php 3324 build_forum_breadcrumb
/showthread.php 195 build_forum_breadcrumb
Warning [2] Use of undefined constant IN_ARCHIVE - assumed 'IN_ARCHIVE' (this will throw an Error in a future version of PHP) - Line: 3331 - File: inc/functions.php PHP 7.4.33-nmm7 (Linux)
File Line Function
/inc/functions.php 3331 errorHandler->error
/showthread.php 195 build_forum_breadcrumb






Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Problems with MAIN THREAD
Author Message
Lazarus
Master
**

Posts: 352
Likes Given: 11
Likes Received: 7 in 6 posts
Joined: Jun 2012
Reputation: 1

Hybris Ultima Online

Post: #11
RE: Problems with MySQL
(08-17-2012 01:05 AM)Extreme Wrote:  Rolleyes
Don't worry, where are there to help when someone need help.

You are sure? Because End works like endfor -.-

[Image: 2hy9q0y.png]
08-17-2012 03:48 AM
Visit this user's website Find all posts by this user Like Post Quote this message in a reply
Extreme
Grandmaster Poster
***

Posts: 1,141
Likes Given: 217
Likes Received: 90 in 77 posts
Joined: May 2012
Reputation: 20

SphereCommunity

Post: #12
RE: Problems with MySQL
(08-17-2012 03:48 AM)Lazarus Wrote:  
(08-17-2012 01:05 AM)Extreme Wrote:  Rolleyes
Don't worry, where are there to help when someone need help.

You are sure? Because End works like endfor -.-
I don't think so.
One time I had this same mistake, the sphere crashes like shit...
Maybe now End = Endfor, before not I think.
Did it resolve your problem? Don't? What's happening?

STEPS BEFORE CREATE A THREAD
- Check the revisions log;
- Use the search button and use the keywords of your problem;
- Check the WIKI;
- Create a thread.
08-17-2012 04:50 AM
Find all posts by this user Like Post Quote this message in a reply
Lazarus
Master
**

Posts: 352
Likes Given: 11
Likes Received: 7 in 6 posts
Joined: Jun 2012
Reputation: 1

Hybris Ultima Online

Post: #13
RE: Problems with MySQL
(08-17-2012 04:50 AM)Extreme Wrote:  
(08-17-2012 03:48 AM)Lazarus Wrote:  
(08-17-2012 01:05 AM)Extreme Wrote:  Rolleyes
Don't worry, where are there to help when someone need help.

You are sure? Because End works like endfor -.-
I don't think so.
One time I had this same mistake, the sphere crashes like shit...
Maybe now End = Endfor, before not I think.
Did it resolve your problem? Don't? What's happening?


Nope... And I was changes some codes I'd try with this and nothing:

Code:
[FUNCTION f_query_2]
IF (<ARGN2>==0)
SERV.LOG Cuentas: El siguiente comando fallo al ejecutarse. (<ARGS>)
ELSE
SERV.LOG Cuentas: El proceso finalizo satisfactoriamente
ENDIF



[FUNCTION f_query_1]
IF (<ARGN2>==0)
SERV.LOG Cuentas: El siguiente comando fallo al ejecutarse. (<ARGS>)
ELSE
if (<LOCAL.NUMROWS> > 0)
        for R 0 <eval <LOCAL.NUMROWS>-1>
            serv.account add <LOCAL.<eval <LOCAL.R>>.login> <LOCAL.<eval <LOCAL.R>>.password>
            serv.log Cuentas: #<eval <LOCAL.R>> La cuenta "<LOCAL.<eval <LOCAL.R>>.login>" ha sido creada
            IF (<DB.AEXECUTE f_query_2, UPDATE accounts SET status='1' WHERE login='<LOCAL.<eval <LOCAL.R>>.login>'>)
            SERV.LOG Cuentas: Comando iniciado satisfactoriamente
            ELSE
            SERV.LOG Cuentas: El comando fallo al iniciarse
            ENDIF
        end
    endif
ENDIF


[function f_acc_update]
if !( <DB.connected> )
DB.CONNECT
ENDIF
if (<DB.AQUERY f_query_1, SELECT * FROM accounts WHERE status='0'>)
SERV.LOG Cuentas: Comando iniciado satisfactoriamente
ELSE
SERV.LOG Cuentas: El comando fallo al iniciarse
ENDIF



Mbe... the host no is in the local host and that's the real problem i guess.

I will try to change the operating system [Im using w7] and install mysql here too...
1gb ram 2.0 1 core.

[Image: 2hy9q0y.png]
08-18-2012 02:34 AM
Visit this user's website Find all posts by this user Like Post Quote this message in a reply
Extreme
Grandmaster Poster
***

Posts: 1,141
Likes Given: 217
Likes Received: 90 in 77 posts
Joined: May 2012
Reputation: 20

SphereCommunity

Post: #14
RE: Problems with MySQL
Man your problem is the mysql server stored in other machine.
You need use both in the same machine.
Try it...

STEPS BEFORE CREATE A THREAD
- Check the revisions log;
- Use the search button and use the keywords of your problem;
- Check the WIKI;
- Create a thread.
08-18-2012 09:46 AM
Find all posts by this user Like Post Quote this message in a reply
Lazarus
Master
**

Posts: 352
Likes Given: 11
Likes Received: 7 in 6 posts
Joined: Jun 2012
Reputation: 1

Hybris Ultima Online

Post: #15
RE: Problems with MySQL
(08-18-2012 09:46 AM)Extreme Wrote:  Man your problem is the mysql server stored in other machine.
You need use both in the same machine.
Try it...

Yep yep, I know.

Now I cant, the hosting are DOWN and the server is in private... We are waiting the new hosting and then we'll install the mysql and the sphereserver ^_^

Thanks for all Smile

[Image: 2hy9q0y.png]
08-18-2012 03:09 PM
Visit this user's website Find all posts by this user Like Post Quote this message in a reply
Extreme
Grandmaster Poster
***

Posts: 1,141
Likes Given: 217
Likes Received: 90 in 77 posts
Joined: May 2012
Reputation: 20

SphereCommunity

Post: #16
RE: Problems with MySQL
Let us know later if you setup the mysql and sphereserver in the same machine =D

STEPS BEFORE CREATE A THREAD
- Check the revisions log;
- Use the search button and use the keywords of your problem;
- Check the WIKI;
- Create a thread.
08-18-2012 03:44 PM
Find all posts by this user Like Post Quote this message in a reply
Lazarus
Master
**

Posts: 352
Likes Given: 11
Likes Received: 7 in 6 posts
Joined: Jun 2012
Reputation: 1

Hybris Ultima Online

Post: #17
RE: Problems with MySQL
(08-18-2012 03:44 PM)Extreme Wrote:  Let us know later if you setup the mysql and sphereserver in the same machine =D


Yes I will. Thanks Extreme Smile Im waiting for you in my shard xD

I wanna get your soul Shock haha

[Image: 2hy9q0y.png]
08-18-2012 04:00 PM
Visit this user's website Find all posts by this user Like Post Quote this message in a reply
Extreme
Grandmaster Poster
***

Posts: 1,141
Likes Given: 217
Likes Received: 90 in 77 posts
Joined: May 2012
Reputation: 20

SphereCommunity

Post: #18
RE: Problems with MySQL
I joined but don't see players then I logout :\

STEPS BEFORE CREATE A THREAD
- Check the revisions log;
- Use the search button and use the keywords of your problem;
- Check the WIKI;
- Create a thread.
08-19-2012 02:47 AM
Find all posts by this user Like Post Quote this message in a reply
xwerswoodx
Journeyman
*

Posts: 86
Likes Given: 4
Likes Received: 7 in 4 posts
Joined: Jun 2012
Reputation: 0

UoMMO

Post: #19
RE: Problems with MySQL
you should use endfor, you use end. Change it endfor.
08-19-2012 02:55 AM
Find all posts by this user Like Post Quote this message in a reply
Lazarus
Master
**

Posts: 352
Likes Given: 11
Likes Received: 7 in 6 posts
Joined: Jun 2012
Reputation: 1

Hybris Ultima Online

Post: #20
RE: Problems with MySQL
I'm not using the mysql script, im not connected to a mysql, I have commented ALL of the MYSQL, and my sphere frozens, my computer works fine, but again the error of the main at 1 min or 2 later...

Everytime... The sphere frozes like a 1 min -.-

00:42:WARNING:Forcing thread 'Main' to terminate...
00:42:CRITICAL:'Main' thread hang, restarting...

What can be now?

Thanks...

[CAN BE THE SPHERESERVICE? Im using it...]
Okay, i have closed it and happends again...

This happends in the VPS and in my PC with the playeers ON -.-
:'(

please help!

[Image: 2hy9q0y.png]
(This post was last modified: 08-21-2012 02:10 PM by Lazarus.)
08-21-2012 02:07 PM
Visit this user's website Find all posts by this user Like Post Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 11 Guest(s)