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: General / Current Version (Old)
 Microsoft JET Database Engine error '80040e57'
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

blackinwhite
Average Member

Turkey
657 Posts

Posted - 15 March 2001 :  09:00:47  Show Profile
I get this error when I try to reply a topic.

Microsoft JET Database Engine error '80040e57' 

The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.

/forum/inc_top.asp, line 327


what doest it mean, and how can I solve it ?

Thank you
ismailk


HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 15 March 2001 :  16:11:30  Show Profile  Visit HuwR's Homepage
If you have the active users mod installed, you need to increase the size of the M_BROWSE field in FORUM_ONLINE

Go to Top of Page

blackinwhite
Average Member

Turkey
657 Posts

Posted - 15 March 2001 :  17:03:58  Show Profile
quote:

If you have the active users mod installed, you need to increase the size of the M_BROWSE field in FORUM_ONLINE


Yes, I am using Active users mod, but exactly what files are those two?



Edited by - blackinwhite on 15 March 2001 17:23:30
Go to Top of Page

blackinwhite
Average Member

Turkey
657 Posts

Posted - 16 March 2001 :  04:31:15  Show Profile
this is really important. I can't use my forum software, what should I do? Please someone help me?

Go to Top of Page

davemaxwell
Access 2000 Support Moderator

USA
3020 Posts

Posted - 16 March 2001 :  06:55:16  Show Profile  Visit davemaxwell's Homepage  Send davemaxwell an AOL message  Send davemaxwell an ICQ Message  Send davemaxwell a Yahoo! Message
quote:

quote:

If you have the active users mod installed, you need to increase the size of the M_BROWSE field in FORUM_ONLINE


Yes, I am using Active users mod, but exactly what files are those two?



He is talking about the M_BROWSE field in the FORUM_ONLINE table in the database. The size of the database MUST be increased...

Dave Maxwell
--------------
Proud to be a "World Class" Knucklehead
Go to Top of Page

blackinwhite
Average Member

Turkey
657 Posts

Posted - 16 March 2001 :  17:13:33  Show Profile
It worked fine, thank you very much davemaxwell

Go to Top of Page

Martha2Mary
Junior Member

New Zealand
250 Posts

Posted - 25 March 2001 :  21:29:27  Show Profile  Visit Martha2Mary's Homepage  Send Martha2Mary an AOL message  Send Martha2Mary an ICQ Message  Send Martha2Mary a Yahoo! Message
Hi,

I am having the same problem, also using the Active Users mod, but how on earth do I increase the size of the m_browse field in the forum_online table in the database? I have never edited or even attempted to open my database, and cannot find software which would enable me to do so. Please, could someone give me step-by-step instructions to apply this fix? Also, elsewhere it is mentioned that this problem can also be fixed by changing something to 'memo' rather than the above - which fix is the better of the two?

TIA!


*If the world didn't suck, we'd all fall off! *
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 25 March 2001 :  21:51:00  Show Profile
in the active_users_setup.asp file that came with the active users MOD:

change this line:


strSql = strSql & "M_BROWSE varchar (250) ) "


to this:


strSql = strSql & "M_BROWSE memo ) "


then just rerun the active_users_setup.asp file from the address bar of your browser.
Go to Top of Page

Martha2Mary
Junior Member

New Zealand
250 Posts

Posted - 25 March 2001 :  22:51:13  Show Profile  Visit Martha2Mary's Homepage  Send Martha2Mary an AOL message  Send Martha2Mary an ICQ Message  Send Martha2Mary a Yahoo! Message
Many thanks, Richard - all is working perfectly now

*If the world didn't suck, we'd all fall off! *
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 25 March 2001 :  22:52:34  Show Profile
you're welcome
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.3 seconds. Powered By: Snitz Forums 2000 Version 3.4.07