Server Update - Budgets

OK, so this one’s a big one. In theory, all the budgets + stable balances should be operating based on the new database now. This involved a ton of changes, so hopefully they all work ok. :crossed_fingers:

2 Likes

I am trying to enter races but i am being told i cant afford entry fee, but i know i can. But my budget is now showing as $0

Should be fixed.

I tried shipping a horse and got an error saying I can’t afford the shipping cost.

1 Like

I’ve got the same.

I am also unable to ship horses. This is how my shipping page appears. I don’t even see the option to ship.

Race entries and shipping should be fixed.

1 Like

I just went onto my Stable Budget page and tried to view all shipping transactions for October 15th. It came back with the message “No transactions met your search requirements”, even though I know that I had shipped some horses on that date.

When I clicked on “Return to Budget Search Page”, I got the message "404 File Not Found ".

Further to this, I noticed that if I leave the “Keywords seperated by a space” box blank, it seems to show all transactions okay, however, if I put anything in that box, I get the message
“No transactions met your search requirements”.

As far as the "404 File Not Found " message when I click on “Return to Budget Search Page”, it seems to come up regardless of whether I had filled in the “Keywords seperated by a space” box or not.

BTW - Not to be nitpicky or anything, it should be “separated” , not “seperated”. I realize that this is extremely minor compared to the other things you’re working on, however, it’s probably the easiest “fix” you’d have to make.

1 Like

I’m a shocker for spelling and grammar, my brain says it but rarely types the correct thing. :flushed_face:

Fixed.

Also fixed. And no worries, I am a pedant as well. :grin:

The "404 File Not Found " message and the “Separated” issues have been fixed, however, the viewing transactions is still not working properly.

I tried to view all transactions from October 23rd to 24th without entering anything in the “Keywords separated by a space” box and got the message “No transactions met your search requirements”.

I tried again, putting “Shipped” in the Keyword box and got the same message.

I expanded the date range to be from October 22nd to 24th and was able to see all transactions on those dates for October 23rd, but none for October 22nd or the 24th. I didn’t have any transactions on the 24th so didn’t expect to see any, but, as the 22nd was a race day and I had a number of horses earning purse money, I should have seen them.

I changed the date range to be from October 21st to 24th and was able to see all transactions for October 22nd and 23rd, but none for the 21st or 24th.

I changed the date range to be from October 1st to 24th and was able to see all transactions for October 22nd and 23rd, but none for the 1st or 24th.

It seems to be adding 1 to the lower date and showing transactions from that date.

As I haven’t had any transactions on the 24th, I don’t know if the reason it’s not showing anything is because of that or, whether if I had had some transactions today, would it show them or not. I guess that tomorrow will be the acid test (unless none of my runners bring home any checks, God forbid!!!)

Hopefully this information will help you to identify the bug quickly.

Shanthi - Just reminding you of this bug. It still seems to be active. As somebody reported (I think it was Cricket Hill), I’m not able to see any of the horses that I sold in the November Sale.

Fixed.

Unfortunately not quite.

I tried searching for any transactions from November 1 through November 3, putting “sold” in the “Keywords separated by a space:” and it showed No transactions, however, if I put in “Sold”, it showed most, but not all, of the horses I sold in the Auction. The same thing with “Ship” or “ship” (no transactions) and “Shipped” (horses shipped in that period). Previously, it didn’t matter whether you put “Ship”, “ship” or “Shipped”, or “sold” or “Sold”, it would show all transactions with those words or parts of them, and didn’t matter about upper case, lower case, or a mix of the two.

In addition, the budget totals don’t add up. Below is a sample of some recent transactions in our budget (previous line’s balance, Line 0:- was $155,862,849):-
Line 1:- |October 30, 2025 |Shipped Energy Shields from Belmont to Aqueduct |$25 |$155,866,124| I can’t figure out how it came up with this balance
|—|—|—|—|
Line 2:- |October 30, 2025 |Entry Fee: 2029-11-01, Race 5 - Big Lad |$1,750 |$155,866,149| I can’t figure out how it came up with this balance
Line 3:- |October 30, 2025 |Entry Fee: 2029-11-01, Race 48 - Streak of Sand |$37,500 |$155,828,649| Seems to be okay
Line 4:- |October 30, 2025 |Shipped Rebel Fortress from Calder to Starfish Stables |$800 |$155,865,349| Seems to have subtracted $800 from Line 2 instead of Line 3
Line 5:- |October 30, 2025 |Shipped Story’s Sponsor from Woodbine to Starfish Stables |$450 |$155,865,699| Seems to have subtracted $450 from Line 2 instead of Line 4
Line 6:- |October 31, 2025 |Shipped Wannabe Singer from Starfish Stables to Belmont |$600 |$155,864,549| I can’t figure out how it came up with this balance
Line 7:- |October 31, 2025 |Shipped As You Sleep from Belmont to Starfish Stables |$1,000 |$155,865,149| Seems to have subtracted $1,000 from Line 2 instead of Line 6
Line 8:- |October 31, 2025 |Shipped Lucky Flight from Starfish Stables to Calder |$1,000 |$155,864,149| Seems to be okay
Line 9:- |October 31, 2025 |Shipped Move Over from Starfish Stables to Woodbine |$450 |$155,864,699| Seems to have subtracted $450 from Line 7 instead of Line 8
Line 10:- |November 1, 2025 |Race Winnings: 2029-11-01, Race 20 - Fool to be Sassy (3rd) |$5,500 |$155,870,049| Seems to have added $5,500 to Line 6 instead of Line 9
Line 11:- |November 1, 2025 |Jockey Fee: 2029-11-01, Race 47 - Kevin Berry riding Thunderous |$1,575 |$155,862,974| I can’t figure out how it came up with this balance
Line 12:- |November 1, 2025 |Race Winnings: 2029-11-01, Race 47 - Thunderous (4th) |$10,500 |$155,875,049 | Seems to have added $10,500 to Line 8 instead of Line 11

There doesn’t seem to be any consistency with how it is working. Sometimes it adds when it should subtract, other times it adds to or subtracts from an older transaction balance, sometimes it adds the previous line’s amount back before subtracting the current line’s amount (or vice versa), and, occasionally it does it correctly. I’ve tried to indicate how I think it is working out each lines balance but wouldn’t swear to it, especially as it doesn’t seem to follow any pattern.
I don’t know if this is because of the way the system is sorting transactions. My budget is big enough that it doesn’t make too much of a difference, but, for somebody who is just starting out and may not have established a large enough budget, it could make a huge difference.

I think it’s how it’s sorting. But honestly, I don’t particularly care. The final total (what shows on your stable overview page) should be accurate, it’s just how it’s displaying that’s causing it to appear wonky.

When I migrate this page over to the new system (hopefully soon), these issues should be resolved.

1 Like

Actually, I may have fixed the sorting, now that the database has been updated.

This is also fixed.

OK, I think all the budget issues are fixed. :crossed_fingers:

I sorted out the sorting issue by fixing the budget transactions that had identical timestamps (so it would sort by a random order in that case). Then I went through and re-calculated all the budget entries, so that all the math works out.

Then I updated all the stables to reflect that math. So now everyone should have the same amount of money as before (a few stables lost money when I did this math, so I added a fake transaction to get you back to where you were), most of you should have more money than before.

Your money shown on your stable page should match what’s in your stable budget, unless you are actively boarding horses, in which case it will be $100 less for every horse’s day you have currently boarded but-not-yet-paid-for.

Hopefully this makes sense. TL,DR is that yay, more money for everyone! :grin:

2 Likes

Thank you!