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

[Nathan Watson-H. <na...@wa...>]

ggpauly wrote:
>
> 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
>
>   

You're welcome.

May I ask why you haven't updated to PGV 4.1.* yet?

Before answering, could you let me know why you are tacking GEDCOMS
together and what you are trying to achieve. There may be alternatives,
or possibly a way to do it in newer versions of PGV.

Nath