Re: [Phpgedview-talk] GEDCOM Import DB Error

[Randal T. R. <ra...@pr...>]

On Tue, September 2, 2008 11:54 pm, waldo kitty wrote:
> Randal T. Rioux wrote:
>> I get this error when importing a ~33MB .ged file:
>>
>> ERROR:-2 DB Error: syntax error SQL:CREATE TABLE pgv_nextid (ni_id INT
>> UNSIGNED NOT NULL, ni_type VARCHAR(30) NOT NULL, ni_gedfile INT NOT
>> NULL, PRIMARY KEY(ni_type, ni_gedfile)) [nativecode=ERROR: syntax error
>> at or near "UNSIGNED" at character 36]
>>
>> Any ideas? I'm using PostgreSQL.
>
> what version? is the above sql query valid for that version?

Good question - PGV v4.1.5 and PostgreSQL 8.2.9 (Solaris 10 - SPARC). I'll
look over the SQL statement later to check validity.

> i ask because i just recently upgraded to the latest v4.1.5 and many
> queries were failing with my mysql v3.23.58 didn't recognise (or
> otherwise like) the queries as written... so i quickly altered my
> settings to point to a newer mysql and everything is now working, albeit
> slowly which is causing me to look at several options to move the
> database to a faster server... considering that i host my sites on
> numerous servers, here in my physical location, the easiest appears to me
> to set the new server as a slave to the (secondary) existing server to
> move/copy everything over and then to swap the settings and set the 3rd
> server up as a primary for this one task/database :?

As I've mentioned on the list before, I too have struggled with the speed
issues. Maybe I'll send in some patches at some point :-)

> oh how i wish things were really (a lot more) optimized with this
> application (ie: the googlemap stuff could really use at least one index
> that covers the entire range of locations instead of one index for each
> level :? ) :? :? ;) ;) ;)

Ditto!

Thanks,
Randy