Re: [Phpgedview-talk] GEDCOM Import DB Error

[waldo k. <wki...@wi...>]

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?

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 :?

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 :? ) :? :? ;) ;) ;)

-- 
NOTE: NEW EMAIL ADDRESS!!

        _\/
       (@@)                      Waldo Kitty, Waldo's Place USA
__ooO_( )_Ooo_____________________ telnet://bbs.wpusa.dynip.com
_|_____|_____|_____|_____|_____|_____ http://www.wpusa.dynip.com
____|_____|_____|_____|_____|_____|____ ftp://ftp.wpusa.dynip.com
_|_Eat_SPAM_to_email_me!_YUM!__|_____ wkitty42 -at- windstream.net


---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 080902-0, 09/02/2008
Tested on: 9/2/08 23:54:17
avast! - copyright (c) 1988-2008 ALWIL Software.
http://www.avast.com