---------------------------
---------------------------
SQLite error
near "Keefe": syntax error
Query: insert into Players( ID, LastName, FirstName, Position1, Position2, isActive, isInjured, TeamFin, TeamSta, GP, GS, MINS, PTS, FGM, FGA, TPM, TPA, FTM, FTA, OREB, DREB, STL, TOS, BLK, AST, FOUL, isAllStar, isNBAChampion) values( '107', 'O'Keefe', 'Pat', '', '', 'True', 'False', 'Glenelg Tigers', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'False', 'False');
---------------------------
OK
---------------------------
koberulz wrote:
- Code: Select all
---------------------------
---------------------------
SQLite error
near "Keefe": syntax error
Query: insert into Players( ID, LastName, FirstName, Position1, Position2, isActive, isInjured, TeamFin, TeamSta, GP, GS, MINS, PTS, FGM, FGA, TPM, TPA, FTM, FTA, OREB, DREB, STL, TOS, BLK, AST, FOUL, isAllStar, isNBAChampion) values( '107', 'O'Keefe', 'Pat', '', '', 'True', 'False', 'Glenelg Tigers', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'False', 'False');
---------------------------
OK
---------------------------
Got that after adding a bunch of players, then trying to save.
Also, when pressing the tab key at the end of the last line on the player creation screen, it adds a new line but highlights the 'OK' button, instead of the 'Last Name' cell of the new line.
EDIT: I only get that error trying 'save all seasons', 'save current season' worked fine.
Another thing: I'm trying to input NBL stats from 1979, which include only FGA, FGM, FTA, FTM, PTS, and FLS. It won't let me do this, insisting I check to make sure all information is entered.
Leftos wrote:The clue is in the player's last name. It has an apostrophe in it that the program doesn't parse correctly, and the database thinks that the last name is just "O" and there's some other weird stuff after it, which causes it to throw an error. It's fixed in the next version that'll be released, and the only way you're going to get that error again is if you use a double-quote in the name.
That's a fail-safe that is currently needed, or else I have to do a lot of different scenario handling which I don't want to go through. Just enter 0 in all other columns.
Leftos wrote:Q: All columns default to zero, so it's not as though any of them are blank. I'd suggest it's either that everyone is listed as playing 0 minutes or none of the 'starter' boxes are checked.
A: I'll need to know what information you're entering so that I can debug and see which fail-safe is firing. Get some screenshots on postimage.org so that I can take a look.
Leftos wrote:P.S. Not to play devil's advocate, but the tool has a big "BETA" in its title, so you shouldn't spend half an hour on a single feature without testing it for a bit to know that it works as you expect.
System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.SortedDictionary`2.get_Item(TKey key)
at NBA_Stats_Tracker.NSTHelper.CalculateAllMetrics(Dictionary`2& playerStats, TeamStats[] teamStats, TeamStats[] oppStats, SortedDictionary`2 TeamOrder, Boolean leagueOv) in C:\Users\Leftos\Documents\Visual Studio 2010\Projects\NBA Stats Tracker\NBA Stats Tracker\StatsTracker.cs:line 60
at NBA_Stats_Tracker.MainWindow.GetPlayersFromDatabase(String file, TeamStats[] _tst, TeamStats[] _tstopp, SortedDictionary`2 _TeamOrder, Int32 curSeason, Int32 maxSeason) in C:\Users\Leftos\Documents\Visual Studio 2010\Projects\NBA Stats Tracker\NBA Stats Tracker\MainWindow.xaml.cs:line 1446
at NBA_Stats_Tracker.MainWindow.LoadSeason(String file, TeamStats[]& _tst, TeamStats[]& _tstopp, Dictionary`2& pst, SortedDictionary`2& _TeamOrder, PlayoffTree& _pt, IList`1& _bshist, Boolean updateCombo, Int32 _curSeason, Boolean doNotLoadBoxScores) in C:\Users\Leftos\Documents\Visual Studio 2010\Projects\NBA Stats Tracker\NBA Stats Tracker\MainWindow.xaml.cs:line 1315
at NBA_Stats_Tracker.boxScoreW.cmbSeasonNum_SelectionChanged(Object sender, SelectionChangedEventArgs e) in C:\Users\Leftos\Documents\Visual Studio 2010\Projects\NBA Stats Tracker\NBA Stats Tracker\boxScoreW.xaml.cs:line 869
at System.Windows.Controls.SelectionChangedEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
at System.Windows.UIElement.RaiseEvent(RoutedEventArgs e)
at System.Windows.Controls.ComboBox.OnSelectionChanged(SelectionChangedEventArgs e)
at System.Windows.Controls.Primitives.Selector.InvokeSelectionChanged(List`1 unselectedItems, List`1 selectedItems)
at System.Windows.Controls.Primitives.Selector.SelectionChanger.End()
at System.Windows.Controls.Primitives.Selector.SelectionChanger.SelectJustThisItem(Object item, Boolean assumeInItemsCollection)
at System.Windows.Controls.Primitives.Selector.OnSelectedItemChanged(DependencyObject d, DependencyPropertyChangedEventArgs e)
at System.Windows.DependencyObject.OnPropertyChanged(DependencyPropertyChangedEventArgs e)
at System.Windows.FrameworkElement.OnPropertyChanged(DependencyPropertyChangedEventArgs e)
at System.Windows.DependencyObject.NotifyPropertyChange(DependencyPropertyChangedEventArgs args)
at System.Windows.DependencyObject.UpdateEffectiveValue(EntryIndex entryIndex, DependencyProperty dp, PropertyMetadata metadata, EffectiveValueEntry oldEntry, EffectiveValueEntry& newEntry, Boolean coerceWithDeferredReference, Boolean coerceWithCurrentValue, OperationType operationType)
at System.Windows.DependencyObject.SetValueCommon(DependencyProperty dp, Object value, PropertyMetadata metadata, Boolean coerceWithDeferredReference, Boolean coerceWithCurrentValue, OperationType operationType, Boolean isInternal)
at System.Windows.DependencyObject.SetValue(DependencyProperty dp, Object value)
at NBA_Stats_Tracker.boxScoreW.PopulateSeasonCombo() in C:\Users\Leftos\Documents\Visual Studio 2010\Projects\NBA Stats Tracker\NBA Stats Tracker\boxScoreW.xaml.cs:line 251
at NBA_Stats_Tracker.boxScoreW.prepareWindow(Mode _curmode) in C:\Users\Leftos\Documents\Visual Studio 2010\Projects\NBA Stats Tracker\NBA Stats Tracker\boxScoreW.xaml.cs:line 146
at NBA_Stats_Tracker.boxScoreW..ctor(Mode _curmode) in C:\Users\Leftos\Documents\Visual Studio 2010\Projects\NBA Stats Tracker\NBA Stats Tracker\boxScoreW.xaml.cs:line 49
at NBA_Stats_Tracker.MainWindow.btnLoadUpdate_Click(Object sender, RoutedEventArgs e) in C:\Users\Leftos\Documents\Visual Studio 2010\Projects\NBA Stats Tracker\NBA Stats Tracker\MainWindow.xaml.cs:line 1460
at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
at System.Windows.UIElement.RaiseEvent(RoutedEventArgs e)
at System.Windows.Controls.Primitives.ButtonBase.OnClick()
at System.Windows.Controls.Button.OnClick()
at System.Windows.Controls.Primitives.ButtonBase.OnMouseLeftButtonUp(MouseButtonEventArgs e)
at System.Windows.UIElement.OnMouseLeftButtonUpThunk(Object sender, MouseButtonEventArgs e)
at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
at System.Windows.UIElement.ReRaiseEventAs(DependencyObject sender, RoutedEventArgs args, RoutedEvent newEvent)
at System.Windows.UIElement.OnMouseUpThunk(Object sender, MouseButtonEventArgs e)
at System.Windows.Input.MouseButtonEventArgs.InvokeEventHandler(Delegate genericHandler, Object genericTarget)
at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
at System.Windows.UIElement.RaiseTrustedEvent(RoutedEventArgs args)
at System.Windows.UIElement.RaiseEvent(RoutedEventArgs args, Boolean trusted)
at System.Windows.Input.InputManager.ProcessStagingArea()
at System.Windows.Input.InputManager.ProcessInput(InputEventArgs input)
at System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport)
at System.Windows.Interop.HwndMouseInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawMouseActions actions, Int32 x, Int32 y, Int32 wheel)
at System.Windows.Interop.HwndMouseInputProvider.FilterMessage(IntPtr hwnd, WindowMessage msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
at System.Windows.Interop.HwndSource.InputFilterMessage(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
at MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o)
at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
at MS.Internal.Threading.ExceptionFilterHelper.TryCatchWhen(Object source, Delegate method, Object args, Int32 numArgs, Delegate catchHandler)
None
What happens to players on deactivated teams? Do I need to inactivate those players, then the team, if I want the players to be accessible?
How do I view previous box scores, for either current or past seasons?
I started a season, created three teams, added two box scores (one v three, two v three), started a new season, deactivated team three, added team C, then went to add a box score and got a crash:
Users browsing this forum: No registered users and 11 guests