Error_Logging

[doris_day]

What is that error all about when it appears in the BetRef column ? I've had it a few times today.

[GaryRussell]

I don't know yet I'm afraid. It's not something I ever expected to see. Is this the first time you've seen this error?
It would help if you could send the file named BA_Diagnostic.txt from the "c:\temp\Betting Assistant Logs" folder to admin@gruss-software.co.uk next time it happens.

[doris_day]

Yes, never seen it before. No mention of it in the Diagnostic file but if it happens tomorrow I'll send it to you. Its something to do with a new routine I'm running.

[GaryRussell]

Yes, never seen it before. No mention of it in the Diagnostic file but if it happens tomorrow I'll send it to you. Its something to do with a new routine I'm running.

Does this involve possibly changing the bet ref column while it still may contain PENDING? Just guessing at the moment.

[GaryRussell]

Another user reported this and they were using LAYR and BACKR.
Does the new routine involve these triggers?

[doris_day]

No, the trigger is very simple indeed, "BACK-SP". Its the Odds and Stake cells that are complicated as they refer to another workbook using VLOOKUP. Most of the bets go through OK but then I get this Error for some of them. Odd. No doubt there'll be a simple answer. I'll take a closer look tomorrow.

[Shaun]

Gary, i changed my Trigger and no longer get that but if you want i can send you the original file with what causes this to happen, i sent you another file yesterday with a different issue.

[GaryRussell]

Gary, i changed my Trigger and no longer get that but if you want i can send you the original file with what causes this to happen, i sent you another file yesterday with a different issue.

Yes please, that would be very helpful. I will send you a reply regarding the other spreadsheet shortly.

[doris_day]

JUST HAPPENED AGAIN IN THE LAST RACE (15:00) BUT NOTHING RELEVANT IN THE LOG FILE.

THE FULL ERROR THOUGH IS ERROR_LOGGING_REF

Sorry about the caps. Was stuck on...

[GaryRussell]

JUST HAPPENED AGAIN IN THE LAST RACE (15:00) BUT NOTHING RELEVANT IN THE LOG FILE.

THE FULL ERROR THOUGH IS ERROR_LOGGING_REF

Sorry about the caps. Was stuck on...

I will have to add more to the log file then. I will send you an update when it's ready. I haven't been able to replicate it so my best chance is to capture it in the log file.

[GaryRussell]

Was the bet actually placed?

[Shaun]

I had a look for the sheet but looks like i may have changed the code, i am pretty sure i know what truugered it so will try to reproduce it.

I have found a solution to my problem i think, but would still be interested why the LAYR trigger was not working for me

[GaryRussell]

I had a look for the sheet but looks like i may have changed the code, i am pretty sure i know what truugered it so will try to reproduce it.

I have found a solution to my problem i think, but would still be interested why the LAYR trigger was not working for me

Have you received my reply to your email this morning?

[GaryRussell]

Can you also tell me if these bets were below minimum stake?

[Shaun]

Yes just got your reply thanks, i am in the process of changeing e-mail, atleast now i know it won't change partial bets, that was sending me nuts because in all other areas it was working.

I will have a look at your sheet and follow your info, thanks for the help.

yes those stakes were below min, but i think when it was tested by the sheets intended user he was using well above min and still got the error.