 |
|
Web Wiz Web Hosting 30 Day Free TrialWindows Hosting 30 Day Free Trial, with no obligation, on all our Windows Web and Reseller Hosting Packages.For more information see our Windows Hosting 30 Day Free Trial page. |
Provider error '80020005' |
Post Reply 
|
| Author | |
adrock5150 
Newbie 
Joined: 11 July 2006 Location: United States Status: Offline Points: 13 |
 Post Options
 Thanks(0)
 Quote Reply
 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.
Type mismatch. /forum/register.asp, line 888 Does anyone know why this is happening?
thank you, adam |
|
 |
|
|
Demon
Mod Builder Group 
Mod-n-Skin Moderator Joined: 26 July 2003 Status: Offline Points: 300 |
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
|
adrock5150
Newbie
Joined: 11 July 2006 Location: United States Status: Offline Points: 13 |
Post Options
Thanks(0)
Quote Reply
Posted: 22 July 2006 at 7:50pm |
|
line 888 of register.asp is
.Fields("Location") = strLocation |
|
|
|
|
WebWiz-Bruce
Admin Group 
Web Wiz Developer Joined: 03 September 2001 Location: Poole, England Status: Offline Points: 8039 |
Post Options
Thanks(0)
Quote Reply
Posted: 24 July 2006 at 11:18am |
|
Could be a corrupted file, first try reuploading the ASP files again.
|
|
|
|
|
adrock5150
Newbie
Joined: 11 July 2006 Location: United States Status: Offline Points: 13 |
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer Joined: 03 September 2001 Location: Poole, England Status: Offline Points: 8039 |
Post Options
Thanks(0)
Quote Reply
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. |
|
|
|
|
adrock5150
Newbie
Joined: 11 July 2006 Location: United States Status: Offline Points: 13 |
Post Options
Thanks(0)
Quote Reply
Posted: 31 July 2006 at 7:05pm |
|
Hey Borg,
Sorry about that, I'm actually using mySQL. |
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer Joined: 03 September 2001 Location: Poole, England Status: Offline Points: 8039 |
Post Options
Thanks(0)
Quote Reply
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. |
|
|
|
Topic Options|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
