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

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

ggpauly wrote:
> I get stuck at I2147483647.
>
> In other words, every new person gets this GEDCOM ID.
>
> Familys are also stuck at F2147483647
>
> Any help appreciated,
>
> George
>   

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
|