Gruss Forum • View topic

by **doris_day** » Tue Sep 14, 2010 8:38 pm

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

by **GaryRussell** » Tue Sep 14, 2010 9:03 pm

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.

by **doris_day** » Tue Sep 14, 2010 9:14 pm

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.

by **GaryRussell** » Tue Sep 14, 2010 9:22 pm

doris_day wrote: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.

by **GaryRussell** » Tue Sep 14, 2010 9:31 pm

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

by **doris_day** » Tue Sep 14, 2010 9:57 pm

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.

by **Shaun** » Wed Sep 15, 2010 12:51 am

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.

by **GaryRussell** » Wed Sep 15, 2010 7:46 am

Shaun wrote: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.

by **doris_day** » Wed Sep 15, 2010 3:07 pm

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...

by **GaryRussell** » Wed Sep 15, 2010 3:12 pm

doris_day wrote: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.

by **GaryRussell** » Wed Sep 15, 2010 3:12 pm

Was the bet actually placed?

by **Shaun** » Wed Sep 15, 2010 3:25 pm

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

by **GaryRussell** » Wed Sep 15, 2010 3:29 pm

Shaun wrote: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?

by **GaryRussell** » Wed Sep 15, 2010 3:55 pm

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

by **Shaun** » Wed Sep 15, 2010 4:18 pm

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.

Error_Logging

Error_Logging

Who is online

Sports betting software from Gruss Software