Print Page | Close Window

Registration 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=23976
Printed Date: 06 April 2026 at 11:08pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Registration Error
Posted By: ToJaRo
Subject: Registration Error
Date Posted: 27 July 2007 at 9:59pm
 Users are getting this error when trying to register...
 

Microsoft OLE DB Provider for SQL Server error '80040e14'

Invalid column name 'Newsletter'.

/register.asp, line 718

Ideas?


-------------
ToJaRo
http://www.thesoupbone.com - The SoupBone Community



Replies:
Posted By: ToJaRo
Date Posted: 27 July 2007 at 11:48pm
After further research - I think it is related to the NewsPad intergratioin piece which i have had disabled.... I tried to run the upgrade.htm for 8.0 to 9.0 and that did not help.
 
Any help would be greatly appreciated... 


-------------
ToJaRo
http://www.thesoupbone.com - The SoupBone Community


Posted By: ToJaRo
Date Posted: 28 July 2007 at 3:27pm
Any ideas?  I am stumped.

-------------
ToJaRo
http://www.thesoupbone.com - The SoupBone Community


Posted By: WebWiz-Bruce
Date Posted: 28 July 2007 at 8:27pm
Not sure what version you are using, but this is a new database filed in version 9.0 full.

Do you upgrade your database when in beta or use a beta version? As this may be the reason why the field was not created in the database.


-------------
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: ToJaRo
Date Posted: 28 July 2007 at 11:42pm
I am using the final release of 9.0... i did the upgrade on the live database after the final version was released.  I even reran the upgrade.htm file after redownloading 9.0 and it did not correct it. This DB is hosted and I do not have access to it with Query Manager.. .is there a way I can create the colum with a script in asp?

-------------
ToJaRo
http://www.thesoupbone.com - The SoupBone Community


Posted By: WebWiz-Bruce
Date Posted: 29 July 2007 at 9:54am
You should only run the upgrade tool once, first making a backup. If you get an error you should note it down and retry again from the backup.

It sounds like you do not have a backup, so your oly solution would be to contact your host and ask them to create the field for you in the database it should be:-

tblAuthor -> Newsletter - datatype bit, default value (0)

If your host do not allow you to connect to the database externally they should supply some other tools to mange your database with, such as myLittleAdmin which is an online version of Enterprise Manger we use for our own hosting plans and is very good. However, the software with additional backup part costs over $2000 USD, so if you are using a cheapo webhost they may not supply you an alternative.


-------------
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: ToJaRo
Date Posted: 29 July 2007 at 3:26pm
I have a backup but it's now about a week old now as I did the backup just before I ran my upgrade on on the 23rd.
 
Late last night I did take that backup and create a new DB on my beta server and run the upgrade on it with the same error as above... could there be something wrong with my database?


-------------
ToJaRo
http://www.thesoupbone.com - The SoupBone Community


Posted By: WebWiz-Bruce
Date Posted: 30 July 2007 at 8:17am
Are you getting an error when you run the upgrade?

Line 288 should create the Newsletter field:-

strSQL = strSQL & "[Newsletter] [bit] NOT NULL DEFAULT (1)

If not you will need to create this database field yourself or ask your web host to do it for you.


-------------
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: ToJaRo
Date Posted: 30 July 2007 at 3:00pm

I do not get an error... It says successful.   I am working with my web host to get the field created. 

Thanks for the help... I will let you know how it goes.

-------------
ToJaRo
http://www.thesoupbone.com - The SoupBone Community


Posted By: ToJaRo
Date Posted: 30 July 2007 at 7:51pm
Ok, they claim i can connect via SQL Manager but i have been unsuccessful from 3 seperate servers on different networks... SO... what exactly do i need to tell them to create?  I am not a DBA and am not sure exactly what needs to be added in the DB.

-------------
ToJaRo
http://www.thesoupbone.com - The SoupBone Community


Posted By: WebWiz-Bruce
Date Posted: 31 July 2007 at 8:37am
In tblAuthor create the following:-

[Newsletter] [bit] NOT NULL DEFAULT (1)


-------------
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: ToJaRo
Date Posted: 31 July 2007 at 4:06pm
AHH!!!  I got that fixed and tried to register and this is what I am getting now....
 
 

Provider error '80020005'

Type mismatch.

/register.asp, line 895

I went and looked at the register.asp page and this is the code:
.Fields("Gender") = strGender
 
I think this also was in the upgrade script... Confused


-------------
ToJaRo
http://www.thesoupbone.com - The SoupBone Community


Posted By: WebWiz-Bruce
Date Posted: 31 July 2007 at 6:53pm
It looks like the upgrade tool is not creating any of the new fields, as you don't get an error when year run the update make sure you are running it against the right database

-------------
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: ToJaRo
Date Posted: 31 July 2007 at 6:59pm
I am positive I am running it on the correct DB.. I have even ran the upgrade.htm twice as mentioned earlier.... looks like I will be creating the fields manually... Can you tell me what needs to created for the Gender field?
 
Thanks!


-------------
ToJaRo
http://www.thesoupbone.com - The SoupBone Community


Posted By: ToJaRo
Date Posted: 02 August 2007 at 12:37am
Sorry to bug you again... can you tell me what needs to be added for the Gender field?

-------------
ToJaRo
http://www.thesoupbone.com - The SoupBone Community


Posted By: WebWiz-Bruce
Date Posted: 02 August 2007 at 7:41am
Sounds like you have not actually updtaed your database, the upgrade.htm file won't upgrade your database for you.The page simply lists links to the various upgrade tools.

You then need to select from the list which upgrade tool you require and run one of the upgrade tools entering in your database details. It will then create the fields etc. for you in the database and show you the progress as it goes through updating your database.


-------------
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: ToJaRo
Date Posted: 02 August 2007 at 5:46pm
I have ran the tools twice already on my DB... I even had to have my licenses reactivated because i ran the upgrade twice.... The second time i ran the upgrade it gave me notifications saying that fields were already created but it did not mention Newsletter or Gender.   I have run the tool a 3rd time on my test DB and it does the same thing... can i please know what needs to be inserted for the Gender field?

-------------
ToJaRo
http://www.thesoupbone.com - The SoupBone Community


Posted By: ToJaRo
Date Posted: 03 August 2007 at 2:20pm
This look right?
 
TblAuthor -> Gender - nvarchar (10) NULL


-------------
ToJaRo
http://www.thesoupbone.com - The SoupBone Community


Posted By: WebWiz-Bruce
Date Posted: 03 August 2007 at 3:48pm
yes

-------------
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: ToJaRo
Date Posted: 06 August 2007 at 4:56pm
Now I am getting this after having my host create the above field...
 
Server Error in Forum Application
An error has occurred while reading user data from the database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_getUserData()_get_member_data
File Name:- functions_login.asp

Error details:-
Microsoft OLE DB Provider for SQL Server
Invalid column name 'Username'.
 
What do you think the problem is?  What Shoud the column Username be set to?


-------------
ToJaRo
http://www.thesoupbone.com - The SoupBone Community


Posted By: ToJaRo
Date Posted: 06 August 2007 at 5:02pm
Disregard... they foobarred the script and created a bogus Column... I fixed it... All is working now.

-------------
ToJaRo
http://www.thesoupbone.com - The SoupBone Community



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net