Web Wiz Forums - v7 register.asp

Print Page | Close Window

v7 register.asp

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=2940
Printed Date: 01 April 2026 at 4:39am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: v7 register.asp

Posted By: Allan_Young
Subject: v7 register.asp
Date 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?

-------------
Everyone has a photographic memory, its just that some are out of film

Replies:

Posted By: WebWiz-Bruce
Date 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.

-------------
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: rio38
Date 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.

Posted By: Allan_Young
Date 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!!!!

-------------
Everyone has a photographic memory, its just that some are out of film

Posted By: rio38
Date 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.