Re: [Phpgedview-talk] Can't add new people -solved

[ggpauly <ge...@ri...>]

Nathan Watson-Haigh wrote:
> 
> Hi George,
> 
> Could you let us know what version of PGV you are running, what database
> backend you are using and what version e.g. MySQL v4.1
> 
> Is this a real problem or something you have been testing?
> 
> The reason I ask, it that I don't find it likely that you have
> 2147483647 individuals or families in your tree - correct me if i'm
> wrong! For the convenience of other people/developers reading this
> thread, this sounds like the limit of the "int" numeric datatype in
> MySQL has been reached. The "int" datatype has a limit of integers from
> -2147483647 to 2147483647. If this is indeed the case, the database
> should use an unsigned int which will allow integers from 0 t|o 294967295
> (a doubling of possible positive integers) unless there is likely to be
> some use for negative integers? Or use an unsigned bigint (0 to
> ||18446744073709551615 possible positive integers) |
> |
> I'm not familiar enough with the database setup to comment on exact
> reasons or even possible solutions - hopefully someone else can also
> chip in.
> 
> Nath
> 
> MySQL datatype storage limits and ranges:
> http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html
> 
> 

Thanks Nath!

I changed the type of field ni_id, table pgv_nextid from int to bigint and
the problem was solved.
(MySQL 5.0.16, PGV 4.0.2)

I got myself into this fine mess on account of problems I've had tacking
GEDCOMs together.  Inevitably there are IDs that clash, causing PGV to see
double and hallucinate.  I thought I'd solve this by editing the GEDCOMs and
pre-pending numeric strings to the ids.  This evidently persuaded PGV to
exceed the int datatype limit on the table mentioned above as you described.  
And now I can go beyond that silly 2.15 billion people limit.

What's the best way to stitch GEDCOMS together?   I've been using a text
editor to do search-and-replace to bulk edit IDs, then using GRAMPS to
combine the GEDCOMs.

Thanks a >2.15 billion, 

George

-- 
View this message in context: http://www.nabble.com/Can%27t-add-new-people-tf4931613.html#a14118674
Sent from the phpgedview-talk mailing list archive at Nabble.com.