Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Registration Error
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Registration Error
 Post Reply Post Reply Page  123>
Author
  Topic Search Topic Search  Topic Options Topic Options
ToJaRo View Drop Down
Groupie
Groupie
Avatar

Joined: 20 April 2005
Location: United States
Status: Offline
Points: 158 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ToJaRo Quote  Post ReplyReply Direct Link To This Post Topic: Registration Error
    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
The SoupBone Community
Back to Top
ToJaRo View Drop Down
Groupie
Groupie
Avatar

Joined: 20 April 2005
Location: United States
Status: Offline
Points: 158 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ToJaRo Quote  Post ReplyReply Direct Link To This Post 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
The SoupBone Community
Back to Top
ToJaRo View Drop Down
Groupie
Groupie
Avatar

Joined: 20 April 2005
Location: United States
Status: Offline
Points: 158 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ToJaRo Quote  Post ReplyReply Direct Link To This Post Posted: 28 July 2007 at 3:27pm
Any ideas?  I am stumped.
ToJaRo
The SoupBone Community
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: 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
ToJaRo View Drop Down
Groupie
Groupie
Avatar

Joined: 20 April 2005
Location: United States
Status: Offline
Points: 158 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ToJaRo Quote  Post ReplyReply Direct Link To This Post 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?

Edited by ToJaRo - 28 July 2007 at 11:43pm
ToJaRo
The SoupBone Community
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: 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.


Edited by -boRg- - 29 July 2007 at 9:56am
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
ToJaRo View Drop Down
Groupie
Groupie
Avatar

Joined: 20 April 2005
Location: United States
Status: Offline
Points: 158 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ToJaRo Quote  Post ReplyReply Direct Link To This Post 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
The SoupBone Community
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: 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
 Post Reply Post Reply Page  123>

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.