VBScript runtime error '800a01a8' only on weeks 2,6, 13, 16

[chunting]

Hi;

I've been a user of the ASP Football pool for years, and have never had any issues... This year I did have to switch to a new server (windows server 2008, 64 bit). The pool seems to be working fine, however if I click through all of the weeks on the weekyEntry.asp page, I get the following VBScript runtime error - but only on weeks 2, 6, 13 and 16 (all other weeks seem fine).

Microsoft VBScript runtime error '800a01a8'

Object required: ''

/football/support/weeklyEntry.asp, line 873

the grid still displays after the error, but everything at the bottom of the screen (submit, links to other weeks, etc) is gone.

Has anyone else encountered this?

[philwojo]

Is this a fresh download of the V4.0 pool from 2014? Or did you copy and upload files from a past year?

I haven't seen this in either regard though.

Also, are you seeing this logged in as Admin or as a specific user?

I just tried it on my site logged in as Admin, but going to those weeks as my username and didn't have that error at all on any of those weeks.

Also, have you look at what like 873 is in that file?

Phil

[chunting]

Thanks for the response. I downloaded the 2014 pool... I had copied from a previous year originally, only because there were certain cosmetic changes I had made that I wanted to maintain (added instructions to the account creation page, for example.).

I didn't see anything unusual in the code - esp that would only affect certain weeks. here's the code, starting with line 871 (if games(i).isLocked then) is line 873):

Code: Select all

				'Add at most one column to show either the quick picks
				'checkbox or the game lock status.
				if games(i).isLocked then %>
					<td align="center"><img src="graphics/locked.png" alt="Locked" /></td>
<%				elseif ENABLE_QUICK_PICKS then %>
					<td align="center"><input type="checkbox" name="keep-<% = (i + 1) %>" value="true" /></td>
<%				elseif anyLocked then %>
					<td>&nbsp;</td>
<%				end if

Thinking too that it was something in the older files- I refreshed all files from the 2014 download except the includes/config.asp, and /userSignUp.asp, and still get the error. in fact, if I extract the full pool folder from the zip file and browse to it without changing a single thing - I still get the error.

This is when I log in as myself - a new user. if I log in as admin and try to administer a users' picks, I get the same error, but on line 881:

Microsoft VBScript runtime error '800a01a8'

Object required: ''

/football/AspFootballPool_4.0/pool/weeklyEntry.asp, line 881

[philwojo]

Hmm, I don't have any idea at this point, does seem strange.

Maybe someone else will have some suggestions.

Phil

[chunting]

Turns out it was a problem in the database. I just re-downloaded today, extracted the full application and ran it without making any changes - and still get the error. If l look at the Schedule table - I see issues on those weeks. When I first posted the error, it was from a download done a few weeks prior - so both recent downloads contained the errors.

Week 2: Games 30 and 31 the time field is blank, and the visitorID is "16:" and "20:" and the team listed as Home is actually the visitor.

Week 6: Game 91 has a VisitorID of "20:", and a HomeID of SF; it should be SF as the visitor, STL as the home team.

Week 13: Games 177 and 178 have "ET" as the VisitorID, and CHI / PHI as the HomeID. it should be CHI and PHI as visitors, DET and DAL as home teams.

Week 16: Games 226 and 227 have "ET" as the VisitorID, and SD / PHI as the HomeID. it should be SD and PHI as visitors, SF and WAS as home teams.

I corrected the entries in the schedules table, and I can now get to all 17 weeks with no runtime errors.


Thanks for your time in trying to help - I do appreciate it!

[philwojo]

Thanks for following up with the fix. I will send a PM/Email to Mike and let him know about this thread so he can look at it and make corrections.

Phil

[mlhall]

There was a corrupted version of the Shedule table in the original download, the current download has a corrected version.
If you already have users set up, you can open your database in Access, delete the Schedule table and import the fixed one from the database in the current download.

[bobl499]

Thanks for this very useful info!! Worked like a charm!

[lurkmaster1]

ugh..I just noticed this error for week 2. I dont have access. Is this neccessary for the fix?

[philwojo]

Umm, yes I think so, at least that is how it appears from Mike's post.

If you want you can send me your database file and I can do it for you, just make sure to make a backup copy of it as well.

Phil

[lurkmaster1]

That'd be awesome! Let me see if I have your email

[philwojo]

You can PM me on here, or click on my username and it should give you the option to email it. I am pretty sure you can put an attachment in the PM as well.

Phil

[lurkmaster1]

PM sent, but that extension isnt allowed to be attached in a PM.

[krisbethea]

Thanks!!
All running now with no errors!

[dusty]

Ok so I have two similar issues
1. Week 2 games shows Denver and San Fran having bye weeks. There are no bye games in week 2. and when looking at the week 2 schedule it looks like it is missing several games

2. I get this error message on week 2 when logged in as admin
Microsoft VBScript runtime error '800a01a8'
Object required: ''
/pool/weeklyEntry.asp, line 855

I will try updating the schedule table to see if that works

[nananaja003]

I get the following VBScript runtime error - but
บาคาร่ามือถือ