Unable to connect to database: Unknown MySQL server host 'localhost:3306' (0)

andjbock · 05-25-2018, 07:15 PM

Does anyone have experience with this error?

I wasn't able to get it fixed with a support ticket.

Everything worked fine with '18, but as soon as I switched over, I get this error now.

TGH-Adfabre · 05-26-2018, 11:46 PM

1) When are you getting this error?
2) Have you rebooted the CPU since the error?
3) I would try the answers in the first answer posted here:
https://stackoverflow.com/questions/...t3306#37135843

Quote:

There can be three issues:
1) Either your server isn't even running. Open your command prompt and enter mysql 2)Let's say it is , can you check if it's connecting on the correct port. Like in the url, you are using 3306,
Try following this post: How do I find out my MySQL URL, host, port and username?
3) Can you check what if there are any credentials to the database you are connecting?
https://netbeans.org/kb/docs/ide/ins...ql-server.html

This is a copy of the answer form the link above.

andjbock · 05-27-2018, 12:29 PM

Thanks. I'll check all those. It has something to do with the conversion from 18 to 19. There were no issues before.

TGH-Adfabre · 05-27-2018, 03:56 PM

Do you still have 18 installed?
Does it load fine and do your 18 leagues load fine?

andjbock · 05-27-2018, 04:53 PM

yes

andjbock · 05-27-2018, 04:56 PM

I can upload files "1 by 1" and it's not an issue either.

Command: tar xzf '/home3/[andjbock's username]/public_html/[andjbock's website]/lgreports/reports.tar.gz' 2>&1:
Successfully unpacked the reports.tar.gz file...

Unable to connect to database: Unknown MySQL server host 'localhost:3306' (0)

Please wait...

tikitiger77 · 05-28-2018, 07:48 AM

Quote:

Originally Posted by andjbock

I can upload files "1 by 1" and it's not an issue either.

Command: tar xzf '/home3/[andjbock's username]/public_html/[andjbock's website]/lgreports/reports.tar.gz' 2>&1:
Successfully unpacked the reports.tar.gz file...

Unable to connect to database: Unknown MySQL server host 'localhost:3306' (0)

Please wait...

Yes, I'm having the exact same problem.

Warning: mysqli::__construct(): (HY000/2005): Unknown MySQL server host 'localhost:3306' (0) in /home/tikitig/public_html/game/lgreports/unpackreports.php on line 64
Unable to connect to database: Unknown MySQL server host 'localhost:3306' (0)

andjbock · 05-29-2018, 08:41 AM

I've been working on it since the game came out, but not able to figure out why.

TGH-Adfabre · 05-29-2018, 10:54 AM

When do you get it? Loading the league file? Exporting, importing?

andjbock · 05-29-2018, 12:15 PM

When trying to unpack the reports online

tikitiger77 · 05-30-2018, 05:42 AM

Quote:

Originally Posted by andjbock

When trying to unpack the reports online

Same with me. I'm paying for a monthly subscription at AllSimBaseball too and am not sure how to contact the site creator.

Marsupilami · 05-30-2018, 05:29 PM

Quote:

Originally Posted by tikitiger77

Same with me. I'm paying for a monthly subscription at AllSimBaseball too and am not sure how to contact the site creator.

i dont know if there are special methods for monthly paying customers, if not you could simply go to the "contact me" page

http://allsimbaseball.com/index.php?...d=36&Itemid=75

ronnieh · 06-13-2018, 10:02 PM

Anyone figure out the issue here? Just converted to 19 and having this exact issue.

andjbock · 06-14-2018, 07:44 AM

No. Sorry. I had 2 support tickets in and it's not something they could assist with since too much of it is tied to factors outside the game.

Andreas Raht · 06-17-2018, 09:02 AM

Sorry guys, there was a bug in the new unpackreports.php script. Please use the attached php file instead.

andjbock · 06-18-2018, 07:43 AM

It didn't work on my first try, but I will create a new DB tonight and try again.

05-25-2018, 07:15 PM	#1
andjbock Hall Of Famer Join Date: Jul 2003 Location: Somerville, MA, USA Bats: Right Throws: Left Posts: 3,621	Unable to connect to database: Unknown MySQL server host 'localhost:3306' (0) Does anyone have experience with this error? I wasn't able to get it fixed with a support ticket. Everything worked fine with '18, but as soon as I switched over, I get this error now.

05-27-2018, 03:56 PM	#4
TGH-Adfabre Hall Of Famer Join Date: Sep 2007 Posts: 2,599	Do you still have 18 installed? Does it load fine and do your 18 leagues load fine? __________________ You mock me, therefore I am My wife

05-29-2018, 10:54 AM	#9
TGH-Adfabre Hall Of Famer Join Date: Sep 2007 Posts: 2,599	When do you get it? Loading the league file? Exporting, importing? __________________ You mock me, therefore I am My wife

05-27-2018, 12:29 PM	#3
andjbock Hall Of Famer Join Date: Jul 2003 Location: Somerville, MA, USA Bats: Right Throws: Left Posts: 3,621	Thanks. I'll check all those. It has something to do with the conversion from 18 to 19. There were no issues before.

05-27-2018, 04:53 PM	#5
andjbock Hall Of Famer Join Date: Jul 2003 Location: Somerville, MA, USA Bats: Right Throws: Left Posts: 3,621	yes

05-27-2018, 04:56 PM	#6
andjbock Hall Of Famer Join Date: Jul 2003 Location: Somerville, MA, USA Bats: Right Throws: Left Posts: 3,621	I can upload files "1 by 1" and it's not an issue either. Command: tar xzf '/home3/[andjbock's username]/public_html/[andjbock's website]/lgreports/reports.tar.gz' 2>&1: Successfully unpacked the reports.tar.gz file... Unable to connect to database: Unknown MySQL server host 'localhost:3306' (0) Please wait...

05-29-2018, 08:41 AM	#8
andjbock Hall Of Famer Join Date: Jul 2003 Location: Somerville, MA, USA Bats: Right Throws: Left Posts: 3,621	I've been working on it since the game came out, but not able to figure out why.

05-29-2018, 12:15 PM	#10
andjbock Hall Of Famer Join Date: Jul 2003 Location: Somerville, MA, USA Bats: Right Throws: Left Posts: 3,621	When trying to unpack the reports online

06-13-2018, 10:02 PM	#13
ronnieh Minors (Rookie Ball) Join Date: Apr 2015 Posts: 44	Anyone figure out the issue here? Just converted to 19 and having this exact issue.

06-14-2018, 07:44 AM	#14
andjbock Hall Of Famer Join Date: Jul 2003 Location: Somerville, MA, USA Bats: Right Throws: Left Posts: 3,621	No. Sorry. I had 2 support tickets in and it's not something they could assist with since too much of it is tied to factors outside the game.

06-18-2018, 07:43 AM	#16
andjbock Hall Of Famer Join Date: Jul 2003 Location: Somerville, MA, USA Bats: Right Throws: Left Posts: 3,621	It didn't work on my first try, but I will create a new DB tonight and try again.