Lisa
Thu Nov 18 18:06:15 CST 2004
This is a multi-part message in MIME format.
------=_NextPart_000_001B_01C4CD99.4BBB1A20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Generally the tp_NextAvailableID is one more than the tp_ItemCount =
value. If you only added one record, I would increment each value by =
one. In theory I'm not sure it matters what the NextAvailableID is as =
long as it doesn't think it's one that's already being used.=20
However, as I said, I would STRONGLY recommend not adding anything =
directly to the database. As you can see from this one problem you're =
having there are repercussions. :-) =20
"David Lozzi" <dlozzi(remove-this)@delphi-ts.com> wrote in message =
news:%23MA18gczEHA.576@TK2MSFTNGP14.phx.gbl...
Interesting, I did add an item manually through SQl. how do deteremine =
what those numbers should be?
--=20
David Lozzi
Web Applications/Network Specialist
Delphi Technology Solutions, Inc.
dlozzi(remove-this)@delphi-ts.com
"Lisa Parris" <lisa@parrisonline.com> wrote in message =
news:OGiiREbzEHA.2636@TK2MSFTNGP11.phx.gbl...
I take back my first reply. I went back and checked through my =
messages from where I had the problem and this was my solution:
In the Lists table in the Database, there are two columns: =
tp_ItemCount and
tp_NextAvailableID. If you added data manually to the database =
(which I
wouldn't recommend) you have to update these two columns for the =
list that
you're adding data to.
Had you manually added any records prior to having this problem?
"Lisa Parris" <lisa@parrisonline.com> wrote in message =
news:uS6tQBbzEHA.2656@TK2MSFTNGP14.phx.gbl...
I had this problem before and it was due to one particular field =
having data that was too long for that field.
"David Lozzi" <dlozzi(remove-this)@delphi-ts.com> wrote in =
message news:u8JKrsYzEHA.4028@TK2MSFTNGP15.phx.gbl...
Hello!
I have a custom list that is rather large, about 40 fields, and =
there are 20 entries so far in this list, and when I try to add another =
entry, i get this error:
The list item could not be added because the length of the =
fields was too long. Please shorten the new entries or remove some =
fields from this list.
THANKS!
--=20
David Lozzi
Web Applications/Network Specialist
Delphi Technology Solutions, Inc.
dlozzi(remove-this)@delphi-ts.com
------=_NextPart_000_001B_01C4CD99.4BBB1A20
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Generally the tp_NextAvailableID is one =
more than=20
the tp_ItemCount value. If you only added one record, I would increment =
each=20
value by one. In theory I'm not sure it matters what the NextAvailableID =
is as=20
long as it doesn't think it's one that's already being used. =
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>However, as I said, I would STRONGLY =
recommend not=20
adding anything directly to the database. As you can see from this one =
problem=20
you're having there are repercussions. :-) </FONT><FONT =
face=3DArial=20
size=3D2></FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"David Lozzi" <dlozzi(remove-this)@delphi-ts.com> wrote in =
message=20
<A=20
=
href=3D"news:%23MA18gczEHA.576@TK2MSFTNGP14.phx.gbl">news:%23MA18gczEHA.5=
76@TK2MSFTNGP14.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Interesting, I did add an item =
manually through=20
SQl. how do deteremine what those numbers should be?</FONT></DIV>
<DIV><BR>-- <BR>David Lozzi<BR>Web Applications/Network =
Specialist<BR>Delphi=20
Technology Solutions, Inc.<BR>dlozzi(remove-this)@delphi-ts.com</DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Lisa Parris" <<A=20
href=3D"mailto:lisa@parrisonline.com">lisa@parrisonline.com</A>> =
wrote in=20
message <A=20
=
href=3D"news:OGiiREbzEHA.2636@TK2MSFTNGP11.phx.gbl">news:OGiiREbzEHA.2636=
@TK2MSFTNGP11.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>I take back my first reply. I went =
back and=20
checked through my messages from where I had the problem and this =
was my=20
solution:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV>In the Lists table in the Database, there are two columns: =
tp_ItemCount=20
and<BR>tp_NextAvailableID. If you added data manually to the =
database (which=20
I<BR>wouldn't recommend) you have to update these two columns for =
the list=20
that<BR>you're adding data to.<BR><BR><FONT face=3DArial =
size=3D2>Had you=20
manually added any records prior to having this =
problem?</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Lisa Parris" <<A=20
=
href=3D"mailto:lisa@parrisonline.com">lisa@parrisonline.com</A>> =
wrote in=20
message <A=20
=
href=3D"news:uS6tQBbzEHA.2656@TK2MSFTNGP14.phx.gbl">news:uS6tQBbzEHA.2656=
@TK2MSFTNGP14.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>I had this problem before and it =
was due to=20
one particular field having data that was too long for that=20
field.</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"David Lozzi" <dlozzi(remove-this)@delphi-ts.com> =
wrote in=20
message <A=20
=
href=3D"news:u8JKrsYzEHA.4028@TK2MSFTNGP15.phx.gbl">news:u8JKrsYzEHA.4028=
@TK2MSFTNGP15.phx.gbl</A>...</DIV>
<DIV>
<DIV><FONT face=3DArial size=3D2>Hello!</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I have a custom list that is =
rather large,=20
about 40 fields, and there are 20 entries so far in this list, =
and when=20
I try to add another entry, i get this error:</FONT></DIV>
<DIV> </DIV>
<DIV><SPAN class=3Dms-descriptiontext><FONT face=3DArial =
size=3D2>The list=20
item could not be added because the length of the fields was too =
long. Please shorten the new entries or remove some fields =
from=20
this list.</FONT></SPAN></DIV>
<DIV><SPAN class=3Dms-descriptiontext><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3Dms-descriptiontext><FONT face=3DArial=20
size=3D2>THANKS!</FONT></SPAN></DIV></DIV><FONT face=3DArial =
size=3D2>
<DIV><BR>-- <BR>David Lozzi<BR>Web Applications/Network=20
Specialist<BR>Delphi Technology Solutions,=20
Inc.<BR>dlozzi(remove-this)@delphi-ts.com</DIV>
<DIV> </DIV>
=
<DIV></FONT> </DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUO=
TE></BODY></HTML>
------=_NextPart_000_001B_01C4CD99.4BBB1A20--
![http://www.sharepointu.com/forums/image/s6.gif"](http://www.sharepointu.com/forums/image/s6.gif"){kind=link}
