Web Wiz Forums - poll submission creating error

Print Page | Close Window

poll submission creating error

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=7863
Printed Date: 06 April 2026 at 3:35pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: poll submission creating error

Posted By: ScotterMonk
Subject: poll submission creating error
Date Posted: 04 December 2003 at 4:30pm

Hi -

I posted before and now that I've recopied your files, I'm getting same problem still. I no longer think this is necessariily a bug that is your problem. It MAY be because of the database upgrade. I'm posting this to look for ideas/clues/ or even if someone else has had the same problem as me. Thanks for your patience with me.

Info: using 7.6 Access 2000 version upgraded from 6.34 using free database upgrade tool from your site. IIS 5 on Win2k Server. And yup I made some mods to old 6.34 database before the upgrade to 7.6 BUT I did not remove any tables or fields or change any data types. Is it possible the free database conversion tool avail on your site used relative instead of absolute (like =rs(1) instead of rs("fieldname")) to get fields and that caused some data to be inaccurately moved?

I had an error occur when I tried to create a poll.
I followed your suggestion and copied over all files in case some of my files were corrupted.

All things work except for creating a poll.

This could mean the problem is with the database. However, when I look at the code in the page that produces the error, it doesn't seem like that would be the problem. BUT if you think it is a database corruption problem, let me know, and I'll work from that direction. I'm just wondering if the problem could have occurred during the database-upgrade and really hoping that is NOT the problem because it could potentially mean tons of work for me.

Here is the order of what happens (maybe clues for you):

When I begin on this page (to create a poll):
http://www.bodychoir.org/forum/poll_create_form.asp?FID=10 - http://www.bodychoir.org/forum/poll_create_form.asp?FID=10
I see the querystring is ?FID=10
Yet in the code on line 223 of poll_create_form.asp I see it wanting "PN" to send on when the form is submitted.

See here:
document.frmAddMessage.action = "post_message.asp?PN=<% = CInt(Request.QueryString("PN")) %>"

I submit and I get following error msg:

Microsoft VBScript runtime error '800a0009'

Subscript out of range: 'UBound'

/forum/post_message.asp, line 540

This is after having redownloaded your 7.6 zip and copied the files over so it is a fresh install. Please help.

Thanks!

Scott

Replies:

Posted By: WebWiz-Bruce
Date Posted: 05 December 2003 at 3:09am

Try compacting and repairing the database.

Also on the forum configuration page in the admin area try changing the number of allowed questions in a poll.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: Scotter
Date Posted: 05 December 2003 at 10:25am

I did both and one of those did the trick. THANKS!!!!