Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS Access
 Can't add new members!!
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

garrigus
New Member

53 Posts

Posted - 11 September 2006 :  19:11:51  Show Profile  Visit garrigus's Homepage
Okay... there was a problem with my forum a few days ago and I needed to change all the e-mail settings for everyone's profile to No to stop a spamming incident. Instead of going through and editing each and every member profile, I shut down the forum, downloaded the database, made the edit in Access, saved the database, and uploaded back to the site.

Everything seemed to be working fine, but now I can't activate any newly registered members and they can't activate via the e-mail link. The following error keeps coming up:

**************************************************************
Microsoft JET Database Engine error '80004005'
Field 'FORUM_MEMBERS.M_LASTPOSTDATE' cannot be a zero-length string.
/digifreq/discuss/register.asp, line 184
**************************************************************

What did I do???

Shouldn't I be able to edit the database manually? Or no?

Thanks for any help!
Scott

Edited by - garrigus on 11 September 2006 19:12:37

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 11 September 2006 :  19:21:31  Show Profile  Send ruirib a Yahoo! Message
You will need to edit the database again and set the Allow Zero Length property for the column to Yes.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

garrigus
New Member

53 Posts

Posted - 11 September 2006 :  19:58:21  Show Profile  Visit garrigus's Homepage
Hi Ruirib,

Ah ha! That did the trick. Actually, I had to go into all non-essential string columns and change them. It worked!

Thanks so much for your quick help!
Scott

Edited by - garrigus on 11 September 2006 19:58:42
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 12 September 2006 :  00:54:05  Show Profile  Send ruirib a Yahoo! Message
You're welcome.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.19 seconds. Powered By: Snitz Forums 2000 Version 3.4.07