Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Provider error '80020005'
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Provider error '80020005'

 Post Reply Post Reply
Author
adrock5150 View Drop Down
Newbie
Newbie
Avatar

Joined: 11 July 2006
Location: United States
Status: Offline
Points: 13
Post Options Post Options   Thanks (0) Thanks(0)   Quote adrock5150 Quote  Post ReplyReply Direct Link To This Post Topic: Provider error '80020005'
    Posted: 22 July 2006 at 4:24am
Hello,

   I am getting the following error when anyone trys to update their profile.


Provider
error '80020005'

Type mismatch.

/forum/register.asp, line 888


    Does anyone know why this is happening?

 

thank you,

adam

Back to Top
Demon View Drop Down
Mod Builder Group
Mod Builder Group
Avatar
Mod-n-Skin Moderator

Joined: 26 July 2003
Status: Offline
Points: 299
Post Options Post Options   Thanks (0) Thanks(0)   Quote Demon Quote  Post ReplyReply Direct Link To This Post Posted: 22 July 2006 at 4:53am
Moved to regular forum support. The Modifications forum is for only mods/support of mods.

On a side note, try showing what line 888 of register.asp's source is.
So Sayith the Demon.
Back to Top
adrock5150 View Drop Down
Newbie
Newbie
Avatar

Joined: 11 July 2006
Location: United States
Status: Offline
Points: 13
Post Options Post Options   Thanks (0) Thanks(0)   Quote adrock5150 Quote  Post ReplyReply Direct Link To This Post Posted: 22 July 2006 at 7:50pm
line 888 of register.asp is

 .Fields("Location") = strLocation


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: 24 July 2006 at 11:18am
Could be a corrupted file, first try reuploading the ASP files again.
Back to Top
adrock5150 View Drop Down
Newbie
Newbie
Avatar

Joined: 11 July 2006
Location: United States
Status: Offline
Points: 13
Post Options Post Options   Thanks (0) Thanks(0)   Quote adrock5150 Quote  Post ReplyReply Direct Link To This Post Posted: 29 July 2006 at 9:27pm
Hello,

   I am still getting this error whenever someone trys to register or update thier profile. It has to do with the location field (country).

  After using borgs upgrade tool 7.8 to 8.03 everyones profile in my forum has the location field defaulted to 255.  Other country options a present in the pull down. If you click 'update profile' you get the following error regardless of whether you make any changes or not, and if you select a c ountry. Basically there is no way to get past the update profile screen.

Provider error '80020005'

Type mismatch.

/forum/register.asp, line 888


   Line 888 is,

     
.Fields("Location") = strLocation

 
  This is what everyones profile looks like in respect to the location field.




    What can I do to the location field to get this to work properly?  Everything else works fine on the forum, but no one can register.

  thank you,

adam
   
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: 31 July 2006 at 10:57am
It could be a corrupted database so first try downloading the database, open in MS Access, and select 'compact and repair database' from the tools menu.

If this fails, check the Location field in tblAuthor in the database and make sure that the data type for this field is set to Text, and by default it should be set to 60 characters.

By the way these instructions are for Access, so I hope that it is the Access version you are using as you didn't mention the database type.
Back to Top
adrock5150 View Drop Down
Newbie
Newbie
Avatar

Joined: 11 July 2006
Location: United States
Status: Offline
Points: 13
Post Options Post Options   Thanks (0) Thanks(0)   Quote adrock5150 Quote  Post ReplyReply Direct Link To This Post Posted: 31 July 2006 at 7:05pm
Hey Borg,


 Sorry about that, I'm actually using mySQL.
  
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: 31 July 2006 at 7:29pm
It sounds like some conversion has gone wrong somewhere as you must have moved from Access or SQL Server from version 7.x to version 8.x then converted the database to mySQL.

Are you getting the same issue with your version 8.x non mySQL database before you do the conversion to mySQL. this may tell us at what stage the database is getting corrupted.
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.