BOSI Error

[kq76]

After importing the last export of the last season and then clicking on the start new season import link, I get the following error:

Error inserting batting information(You have an error in your SQL syntax near '' at line 1)
Please report the following query --
insert into bosi_BAT_GAME_HISTORY(PLAYER_ID, LEAGUE_ID, TEAM_ID, SPOT, SEASON, AB, R, H, RBI, HR, K, BB, D, T, POG) VALUES

I've started new seasons before and not had this problem. I know very little about SQL. This league is on the OLS. Anybody have an idea about what might be wrong? Thanks.

EDIT: I was going to post this in BOSI's forum, but it looks pretty desolate there now.

[DaveHorn]

There is no data to insert in that query. Although if you typed exactly what you did than your problem my of been user error.

You need rollover your league file and import the NEW season before you click Start New Season.

[kq76]

Originally Posted by DaveHorn

There is no data to insert in that query.

Which means don't worry about it, or..?

Originally Posted by DaveHorn

Although if you typed exactly what you did than your problem my of been user error. You need rollover your league file and import the NEW season before you click Start New Season.

Sorry. After I imported last year's CSVs I uploaded the new year's CSVs and then I clicked the start new season button. I followed (or at least I tried to): http://www.bosicentral.com/help_newseason.html.

[DaveHorn]

Originally Posted by kq76

Which means don't worry about it, or..?

No it likely means something went wrong.

What the code is doing here is getting all the data out of the bat_game table and archiving them in a player and team format into bat_game_history table. It appears you might have something funky in your bat_game table. Not sure what would of caused it. It appears that you either have bad data or no data in your bat_game table? You sure you didn't hit the Start New Season twice?

Is your league date correct in BOSI, did it switch to the new season. If so, maybe you just hit it twice and you are fine.

I'm not sure what fail safe mechanisms are built in case Start New Season fails. Are you familiar with phpmyadmin or a similar tool so you could look at the bag_game table and verify its data?

[kq76]

Originally Posted by DaveHorn

You sure you didn't hit the Start New Season twice?

I may have. I don't remember exactly as I'm doing a bunch of things at once and it was a couple hours ago.

Originally Posted by DaveHorn

Is your league date correct in BOSI, did it switch to the new season. If so, maybe you just hit it twice and you are fine.

No, it still has last year's date.

Originally Posted by DaveHorn

I'm not sure what fail safe mechanisms are built in case Start New Season fails. Are you familiar with phpmyadmin or a similar tool so you could look at the bag_game table and verify its data?

I am a bit familiar with phpmyadmin and I opened it, but all I see are my phpbb tables which is probably because the league's BOSI is on the OLS's server. I guess the only person who could fix it from here is Andreas?

Even if this doesn't get fixed, thanks.

[DaveHorn]

Bummer, my next suggestion was to see if you wanted me to take a peak at the DB for you.

Yeah, I'm not sure how the OLS works. You don't have access to the BOSI database? How about the code? Another possibility is that it moved the data into the history tables correctly, but something else went wrong, so now when you try you are getting an error before you can get to the part the went wrong the first time.

[kq76]

Originally Posted by DaveHorn

Bummer, my next suggestion was to see if you wanted me to take a peak at the DB for you.

Yeah, I'm not sure how the OLS works. You don't have access to the BOSI database? How about the code? Another possibility is that it moved the data into the history tables correctly, but something else went wrong, so now when you try you are getting an error before you can get to the part the went wrong the first time.

I'd give you access if I could, but other than BOSI's admin import page which I believe most BOSI admins use, I don't think I can access it if it is on the OLS. Maybe someone on the OLS knows better though.