Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - poll submission creating error
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

poll submission creating error

 Post Reply Post Reply
Author
ScotterMonk View Drop Down
Newbie
Newbie


Joined: 01 December 2003
Location: United States
Status: Offline
Points: 8
Post Options Post Options   Thanks (0) Thanks(0)   Quote ScotterMonk Quote  Post ReplyReply Direct Link To This Post Topic: poll submission creating error
    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
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

 

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
Scotter View Drop Down
Newbie
Newbie
Avatar

Joined: 14 November 2002
Location: United States
Status: Offline
Points: 23
Post Options Post Options   Thanks (0) Thanks(0)   Quote Scotter Quote  Post ReplyReply Direct Link To This Post Posted: 05 December 2003 at 10:25am
I did both and one of those did the trick. THANKS!!!!
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.