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)
 Topics starting with non-alphabet characters
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

MarkJH
Senior Member

United Kingdom
1722 Posts

Posted - 06 June 2001 :  19:17:19  Show Profile  Visit MarkJH's Homepage
I've found that if somebody starts a topic with a character that isn't a letter or number, you cannot reply to the topic.

Is this an error with the forum software?

bandlink.net - http://www.bandlink.net/
bandlink music forums - http://www.bandlink.net/forum/

e3stone
Average Member

USA
885 Posts

Posted - 06 June 2001 :  19:38:08  Show Profile  Send e3stone an AOL message
what characters are you trying to enter? I can't seem to duplicate your error.

<-- Eric -->


InsideWaco.com

Edited by - e3stone on 06 June 2001 19:38:50
Go to Top of Page

MarkJH
Senior Member

United Kingdom
1722 Posts

Posted - 07 June 2001 :  11:33:09  Show Profile  Visit MarkJH's Homepage
It's funny. I can't seem to duplicate this error on this forum.

Somebody posted a topic the title starting with a :) or ;). I had to edit it before I could reply to it.

bandlink.net - http://www.bandlink.net/
bandlink music forums - http://www.bandlink.net/forum/
Go to Top of Page

MarkJH
Senior Member

United Kingdom
1722 Posts

Posted - 07 June 2001 :  12:31:13  Show Profile  Visit MarkJH's Homepage
I posted a test topic here - http://www.bandlink.net/forum/topic.asp?TOPIC_ID=328&FORUM_ID=14&CAT_ID=6&Topic_Title=%2E%2E%2E%2E%2E%2E%2E%2E%2E%2E%2E%2E%2E%2E+This+is+a+test%2E%2E%2E%2E%2E%2E%2E%2E%2E%2E%2E%2E%2E%2E%2E%2E%2E%2E%2E%2E%2E&Forum_Title=Tabs

I tried replying and I got this error:

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 284



bandlink.net - http://www.bandlink.net/
bandlink music forums - http://www.bandlink.net/forum/
Go to Top of Page

big9erfan
Average Member

540 Posts

Posted - 07 June 2001 :  12:59:02  Show Profile
Check that line in Inc_Top.asp and I'll be guessing it belongs to some code that updates the FORUM_ONLINE Table that has to deal with the Active Users Mod

Are you looking at your inc_top yet? Ok, now say "OMG, he's right!" LOL, just kidding, I could be wrong, but here goes anyways.

The field that holds the location of the user in the FORUM_ONLINE table is a text field that's like 100 characters long. Either bump that up to 255 or change it to a memo field and you'll be golden.




http://www.ugfl.net/forums
Go to Top of Page

MarkJH
Senior Member

United Kingdom
1722 Posts

Posted - 09 June 2001 :  08:24:21  Show Profile  Visit MarkJH's Homepage
This is line 284:

<body bgColor="<% =strPageBGColor %>" text="<% =strDefaultFontColor %>" link="<% =strLinkColor %>" aLink="<% =strActiveLinkColor %>" vLink="<% =strActiveLinkColor %>">

quote:
The field that holds the location of the user in the FORUM_ONLINE table is a text field that's like 100 characters long. Either bump that up to 255 or change it to a memo field and you'll be golden.


I'll check this out now... thx!

bandlink.net - http://www.bandlink.net/
bandlink music forums - http://www.bandlink.net/forum/
Go to Top of Page

MarkJH
Senior Member

United Kingdom
1722 Posts

Posted - 09 June 2001 :  08:37:12  Show Profile  Visit MarkJH's Homepage
If you mean the MBROWSE field, that is already 250 characters. These are the other fields in that category:

UserID - TEXT - 100 char
UserIP - TEXT - 40 char
DateCreated - TEXT - 100 char
LastDateCreated - TEXT - 100 char
CheckedIn - TEXT - 100 char
LastChecked - TEXT - 100 char

bandlink.net - http://www.bandlink.net/
bandlink music forums - http://www.bandlink.net/forum/
Go to Top of Page

MarkJH
Senior Member

United Kingdom
1722 Posts

Posted - 09 June 2001 :  09:00:03  Show Profile  Visit MarkJH's Homepage
I notice that the test topic title is 120 chars. long. Is this the problematic line then?

So many questions!

bandlink.net - http://www.bandlink.net/
bandlink music forums - http://www.bandlink.net/forum/
Go to Top of Page

MarkJH
Senior Member

United Kingdom
1722 Posts

Posted - 09 June 2001 :  10:20:28  Show Profile  Visit MarkJH's Homepage
I think this may be related.

I posted a thread with the subject:

Favourite album - which and why?

When you open the thread it appears as:

Favourite album ''2D which and why''3F

Is this normal?

bandlink.net - http://www.bandlink.net/
bandlink music forums - http://www.bandlink.net/forum/
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 09 June 2001 :  18:11:42  Show Profile
You need to change the M_BROWSE field from TEXT (250) to a MEMO field. That will fix your problem.
Go to Top of Page

MarkJH
Senior Member

United Kingdom
1722 Posts

Posted - 10 June 2001 :  04:44:13  Show Profile  Visit MarkJH's Homepage
What can I say? Richard, Big9er, you guys are the best!

Thanks, that fixed the problem.

Presumably, this is a common problem? Would it not be better to have this field as a MEMO rather than TEXT when you download the software or will this be 'fixed' in the new version?

bandlink.net - http://www.bandlink.net/
bandlink music forums - http://www.bandlink.net/forum/
Go to Top of Page

big9erfan
Average Member

540 Posts

Posted - 10 June 2001 :  09:53:54  Show Profile
Mark,

The Active Users is a mod that you added to your board ( though I suppose it could be part of the new alpha release, I am unsure ). Mods are not necessairly fully supported through the boards and could cause problems here and there.

Here is an example:
The private messages mod is a great mod that many people install on their forums. A problem arises when you delete a member that has messages to someone else or from someone else ( checking your inbox or outbox you will see this problem if you have a PM to or from them ). This is what I mean by some mods not being fully supported by the forums. They are not something that has been integrated fully into the software yet.

Maybe eventually they will move from being just mods to actual modules fully supported by the forums, but until that point they are just mods.

http://www.ugfl.net/forums
Go to Top of Page

MarkJH
Senior Member

United Kingdom
1722 Posts

Posted - 10 June 2001 :  12:43:43  Show Profile  Visit MarkJH's Homepage
Perhaps the question should be posed to whoever wrote that particular mod then.

bandlink.net - http://www.bandlink.net/
bandlink music forums - http://www.bandlink.net/forum/
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.29 seconds. Powered By: Snitz Forums 2000 Version 3.4.07