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

  New Posts New Posts RSS Feed - v7 register.asp
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

v7 register.asp
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
Allan_Young View Drop Down
Newbie
Newbie


Joined: 18 May 2003
Location: United Kingdom
Status: Offline
Points: 24 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Allan_Young Quote  Post ReplyReply Direct Link To This Post Topic: v7 register.asp
    Posted: 22 May 2003 at 8:19am

After being told that a few new members couldn't register with the forum I thought I'd have a quick look - all was working fine up till a few days ago, and now I get the following error:

Microsoft JET Database Engine error '80040e21'

Field 'tblAuthor.Avatar_title' cannot be a zero-length string.

/nwcld/secstu/forum/register.asp, line 825

(line 825 because of MODs which exist on the page - navigation_buttons etc)

Anyone any ideas?
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: 22 May 2003 at 9:35am

This feature should only be availble to admins.

It looks like the file has been modified and or edited, this is proably what is coursing the problem with the page. Try uploading the original file.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
rio38 View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 04 April 2003
Status: Offline
Points: 19 		Post Options Post Options   Thanks (0) Thanks(0)   Quote rio38 Quote  Post ReplyReply Direct Link To This Post Posted: 22 May 2003 at 12:11pm

You might also want to check the field in the database.  If it is an Access database, you must chenge the "Allow zero length" option of the field to False if it is true.  This should take care of it.

 

The field would be Avatar_title in teh tblAuthor table.
Back to Top
Allan_Young View Drop Down
Newbie
Newbie


Joined: 18 May 2003
Location: United Kingdom
Status: Offline
Points: 24 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Allan_Young Quote  Post ReplyReply Direct Link To This Post Posted: 22 May 2003 at 2:54pm

rio38,

Owe you a beer - worked a treat, and I thought I knew a bit about database's!!!!
Back to Top
rio38 View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 04 April 2003
Status: Offline
Points: 19 		Post Options Post Options   Thanks (0) Thanks(0)   Quote rio38 Quote  Post ReplyReply Direct Link To This Post Posted: 23 May 2003 at 6:47am

Not a problem.  I make that mistake all the time and then realize it after I get that error.  Too much experience with Access DBs I guess.

I also realize I meant to say, set the "Allow Zero Length" flag to true, not false.



Edited by rio38
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.