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, "");>>

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 (permalink)
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 (permalink)
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 (permalink)
Comedian2004 Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. Posts: 6,396	I have not looked at the field colors, but I will soon. __________________ Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!

08-06-2006, 05:21 PM	#4 (permalink)
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-25-2006, 11:15 AM	#6 (permalink)
Zubes Major Leagues Join Date: Sep 2005 Location: Chicago, IL Posts: 328	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

08-22-2006, 01:46 PM	#5 (permalink)
ddonley_98 Bat Boy Join Date: Jun 2006 Posts: 2	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, "");>>

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

08-25-2006, 09:54 PM	#8 (permalink)
Comedian2004 Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. Posts: 6,396	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. __________________ Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode