Author Topic: BeBot 0.5.0 (SVN) (Read 20643 times)

Dracutza · « **Reply #15 on:** March 29, 2008, 08:34:24 pm »

other than the ini thing, all load issues I've seen seem to be fixed now.

New thing though that I've seen A LOT in 5 as opposed to 4...

Quote

Warning: mysql_connect(): Can't connect to MySQL server on 'localhost' (10048) in P:\bot\Sources\MySQL.php on line 96
MySQL error (# 0) on query: Cannot connect to the database server!

There is no rhyme or reason to this happening. It seems to happen regularly when launching a new bot instance before an old one is 100% done loading, but that is not always the case. Sometimes I can get several bots to launch at "the same time" with no error, and sometimes I get it even when it's the first instance getting loaded.

Eventually it works itself out and everything appears to load fine, but I never saw this happen on 4 in the quantity is does in 5.

Greengadget · « **Reply #16 on:** March 29, 2008, 08:56:59 pm »

Quote from: Temar on March 29, 2008, 09:27:52 pm

delete the 1 in core folder. Its now in main folder

thx, works fine now

Alreadythere · « **Reply #17 on:** March 29, 2008, 09:02:11 pm »

Quote from: Dracutza on March 29, 2008, 08:34:24 pm

Quote
Warning: mysql_connect(): Can't connect to MySQL server on 'localhost' (10048) in P:\bot\Sources\MySQL.php on line 96
MySQL error (# 0) on query: Cannot connect to the database server!

I don't know what the problem with mysql itself it, maybe there is some connection per time limit.

The real reason this may happen is a change in the MySQL layer. The bot now calls mysql_connect() first, reestablishing any connection closed since the last SQL query. If the connection is still open it returns just the already existing connection, so no harm done then. As a result there may be a couple more mysql_connect() calls then before, the 0.4 version doesn't try to reconnect.