SQL Dump Problem

marky32082 · 08-02-2006, 12:57 PM

Anyone else have a problem with the Teams file from the SQL dump? It seems like the colors fields are missing a parentheses and as a result I keep getting errors when I try to use one of the available importers for Access.

marky32082 · 08-04-2006, 10:58 PM

Nobody else is having this problem?

Comedian2004 · 08-05-2006, 12:34 AM

I have not looked at the field colors, but I will soon.

marky32082 · 08-06-2006, 05:21 PM

It's not that I want to see the color fields, it's that when I try to load those the teams file, the color fields screw up the loading process.

ddonley_98 · 08-22-2006, 01:46 PM

I just saw this same issue yesterday.

I'm running a completely patched version.

I was unable to get the data to import into access until I fixed the teams.access.sql file. The teams.access.sql file would not import because the background_color_id and the text_color_id are not delimited correctly.

Example.

insert into [teams] VALUES (2, "Boston", "BOS", "Red Sox", "Boston_Red Sox.png", "images/Boston_Red Sox.png", 0, 11, 100, 0, 206, 0, 1, 0, 0, 0, 0, "#000000, "#DD0101, 0, "");<o

></o

>

Zubes · 08-25-2006, 11:15 AM

i had the same problem too...its been repotred to the bug forum, and i think they took care of it, so hopefully in the next patch it will be fixed.

Comedian2004 · 08-25-2006, 09:49 PM

The latest beta patch shows the CSV dump like so...

0;"#F37A03;"#FFFFFF;0;"BAL"

Still not right. I will TT it.

Comedian2004 · 08-25-2006, 09:54 PM

Actually, been fixed in the SQL dump:

0, 0, "#F37A03", "#FFFFFF", 0, "BAL");

Really does not matter in the CSV dump, as the import will still work.

08-02-2006, 12:57 PM	#1
marky32082 Minors (Triple A) Join Date: Jun 2004 Location: Chicago Posts: 283	SQL Dump Problem Anyone else have a problem with the Teams file from the SQL dump? It seems like the colors fields are missing a parentheses and as a result I keep getting errors when I try to use one of the available importers for Access. __________________ These pretzels are making me thirsty!

08-04-2006, 10:58 PM	#2
marky32082 Minors (Triple A) Join Date: Jun 2004 Location: Chicago Posts: 283	Nobody else is having this problem? __________________ These pretzels are making me thirsty!

08-05-2006, 12:34 AM	#3
Comedian2004 Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. Posts: 7,085	I have not looked at the field colors, but I will soon. __________________ Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]

08-06-2006, 05:21 PM	#4
marky32082 Minors (Triple A) Join Date: Jun 2004 Location: Chicago Posts: 283	It's not that I want to see the color fields, it's that when I try to load those the teams file, the color fields screw up the loading process. __________________ These pretzels are making me thirsty!

08-22-2006, 01:46 PM	#5
ddonley_98 Bat Boy Join Date: Jun 2006 Posts: 3	I just saw this same issue yesterday. I'm running a completely patched version. I was unable to get the data to import into access until I fixed the teams.access.sql file. The teams.access.sql file would not import because the background_color_id and the text_color_id are not delimited correctly. Example. insert into [teams] VALUES (2, "Boston", "BOS", "Red Sox", "Boston_Red Sox.png", "images/Boston_Red Sox.png", 0, 11, 100, 0, 206, 0, 1, 0, 0, 0, 0, "#000000, "#DD0101, 0, "");<o></o>

08-25-2006, 11:15 AM	#6
Zubes Major Leagues Join Date: Sep 2005 Location: Chicago, IL Posts: 361	i had the same problem too...its been repotred to the bug forum, and i think they took care of it, so hopefully in the next patch it will be fixed. __________________ Phil Zuber Beyond the Ivy - Commish, Twins GM Stars and Stripes Baseball League - Cubs GM Bricks and Ivy - Orioles GM Sim Coalition - co-founder

08-25-2006, 09:49 PM	#7
Comedian2004 Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. Posts: 7,085	The latest beta patch shows the CSV dump like so... 0;"#F37A03;"#FFFFFF;0;"BAL" Still not right. I will TT it. __________________ Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]

08-25-2006, 09:54 PM	#8
Comedian2004 Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. Posts: 7,085	Actually, been fixed in the SQL dump: 0, 0, "#F37A03", "#FFFFFF", 0, "BAL"); Really does not matter in the CSV dump, as the import will still work. __________________ Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]