[Phpgedview-talk] PostgreSQL Setup Problems

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

I get the following errors when trying to configure a new database using
the latest PGV. I'm using PostgreSQL 8.3.7 and created a database named
phpgedview with user pgv (which both seem to work). It just looks like
it is having trouble creating certain tables. It would appear PostgreSQL
is confused by some of the datatypes. Has anyone else experienced the same?

Thanks!
Randy

********************************************************


ERROR:-2 DB Error: syntax error
SQL:CREATE TABLE pgv_individuals ( i_id VARCHAR(20) NOT NULL, i_file
SMALLINT UNSIGNED NOT NULL, i_rin VARCHAR(255) NULL, i_isdead INT
DEFAULT 1 NULL, i_sex CHAR(1) NOT NULL, i_gedcom LONGTEXT NULL, PRIMARY
KEY (i_id, i_file)) [nativecode=ERROR: syntax error at or near
"UNSIGNED" LINE 1: ... VARCHAR(20) NOT NULL, i_file SMALLINT UNSIGNED ... ^]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_indi_id ON pgv_individuals (i_id )
[nativecode=ERROR: relation "pgv_individuals" does not exist]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_indi_file ON pgv_individuals (i_file )
[nativecode=ERROR: relation "pgv_individuals" does not exist]

ERROR:-2 DB Error: syntax error
SQL:CREATE TABLE pgv_families ( f_id VARCHAR(20) NOT NULL, f_file
SMALLINT UNSIGNED NOT NULL, f_husb VARCHAR(20) NULL, f_wife VARCHAR(20)
NULL, f_chil TEXT NULL, f_gedcom LONGTEXT NULL, f_numchil INT NULL,
PRIMARY KEY (f_id, f_file)) [nativecode=ERROR: syntax error at or near
"UNSIGNED" LINE 1: ... VARCHAR(20) NOT NULL, f_file SMALLINT UNSIGNED ... ^]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_fam_id ON pgv_families (f_id ) [nativecode=ERROR:
relation "pgv_families" does not exist]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_fam_file ON pgv_families (f_file)
[nativecode=ERROR: relation "pgv_families" does not exist]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_fam_husb ON pgv_families (f_husb)
[nativecode=ERROR: relation "pgv_families" does not exist]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_fam_wife ON pgv_families (f_wife)
[nativecode=ERROR: relation "pgv_families" does not exist]

ERROR:-2 DB Error: syntax error
SQL:CREATE TABLE pgv_placelinks ( pl_p_id INT NOT NULL, pl_gid
VARCHAR(20) NOT NULL, pl_file SMALLINT UNSIGNED NOT NULL, PRIMARY KEY
(pl_p_id, pl_gid, pl_file)) [nativecode=ERROR: syntax error at or near
"UNSIGNED" LINE 1: ...L, pl_gid VARCHAR(20) NOT NULL, pl_file SMALLINT
UNSIGNED N... ^]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_plindex_place ON pgv_placelinks (pl_p_id)
[nativecode=ERROR: relation "pgv_placelinks" does not exist]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_plindex_gid ON pgv_placelinks (pl_gid )
[nativecode=ERROR: relation "pgv_placelinks" does not exist]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_plindex_file ON pgv_placelinks (pl_file)
[nativecode=ERROR: relation "pgv_placelinks" does not exist]

ERROR:-2 DB Error: syntax error
SQL:CREATE TABLE pgv_dates ( d_day INT NULL, d_month VARCHAR(5) NULL,
d_mon INT NULL, d_year INT NULL, d_datestamp INT NULL, d_julianday1 INT
NULL, d_julianday2 INT NULL, d_fact VARCHAR(15) NULL, d_gid VARCHAR(20)
NULL, d_file SMALLINT UNSIGNED NULL, d_type VARCHAR(13) NULL)
[nativecode=ERROR: syntax error at or near "UNSIGNED" LINE 1: ... d_gid
VARCHAR(20) NULL, d_file SMALLINT UNSIGNED N... ^]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_date_day ON pgv_dates (d_day ) [nativecode=ERROR:
relation "pgv_dates" does not exist]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_date_month ON pgv_dates (d_month )
[nativecode=ERROR: relation "pgv_dates" does not exist]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_date_mon ON pgv_dates (d_mon ) [nativecode=ERROR:
relation "pgv_dates" does not exist]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_date_year ON pgv_dates (d_year ) [nativecode=ERROR:
relation "pgv_dates" does not exist]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_date_datestamp ON pgv_dates (d_datestamp )
[nativecode=ERROR: relation "pgv_dates" does not exist]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_date_julianday1 ON pgv_dates (d_julianday1 )
[nativecode=ERROR: relation "pgv_dates" does not exist]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_date_julianday2 ON pgv_dates (d_julianday2 )
[nativecode=ERROR: relation "pgv_dates" does not exist]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_date_gid ON pgv_dates (d_gid ) [nativecode=ERROR:
relation "pgv_dates" does not exist]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_date_file ON pgv_dates (d_file ) [nativecode=ERROR:
relation "pgv_dates" does not exist]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_date_type ON pgv_dates (d_type ) [nativecode=ERROR:
relation "pgv_dates" does not exist]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_date_fact_gid ON pgv_dates (d_fact, d_gid)
[nativecode=ERROR: relation "pgv_dates" does not exist]

ERROR:-2 DB Error: syntax error
SQL:CREATE TABLE pgv_media ( m_id INT NOT NULL, m_media VARCHAR(20)
NULL, m_ext VARCHAR(6) NULL, m_titl VARCHAR(255) NULL, m_file
VARCHAR(255) NULL, m_gedfile SMALLINT UNSIGNED NULL, m_gedrec LONGTEXT
NULL, PRIMARY KEY (m_id)) [nativecode=ERROR: syntax error at or near
"UNSIGNED" LINE 1: ... VARCHAR(255) NULL, m_gedfile SMALLINT UNSIGNED ... ^]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_m_media ON pgv_media (m_media ) [nativecode=ERROR:
relation "pgv_media" does not exist]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_m_media_file ON pgv_media (m_media, m_gedfile)
[nativecode=ERROR: relation "pgv_media" does not exist]

ERROR:-2 DB Error: syntax error
SQL:CREATE TABLE pgv_remotelinks ( r_gid VARCHAR(20) NOT NULL, r_linkid
VARCHAR(255) NULL, r_file SMALLINT UNSIGNED NOT NULL) [nativecode=ERROR:
syntax error at or near "UNSIGNED" LINE 1: ... r_linkid VARCHAR(255)
NULL, r_file SMALLINT UNSIGNED N... ^]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_r_gid ON pgv_remotelinks (r_gid )
[nativecode=ERROR: relation "pgv_remotelinks" does not exist]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_r_link_id ON pgv_remotelinks (r_linkid)
[nativecode=ERROR: relation "pgv_remotelinks" does not exist]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_r_file ON pgv_remotelinks (r_file )
[nativecode=ERROR: relation "pgv_remotelinks" does not exist]

ERROR:-2 DB Error: syntax error
SQL:CREATE TABLE pgv_media_mapping ( mm_id INT NOT NULL, mm_media
VARCHAR(20) NOT NULL DEFAULT '', mm_gid VARCHAR(20) NOT NULL DEFAULT '',
mm_order INT NOT NULL DEFAULT '0', mm_gedfile SMALLINT UNSIGNED NULL,
mm_gedrec LONGTEXT NULL, PRIMARY KEY (mm_id)) [nativecode=ERROR: syntax
error at or near "UNSIGNED" LINE 1: ... NOT NULL DEFAULT '0', mm_gedfile
SMALLINT UNSIGNED ... ^]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_mm_media_id ON pgv_media_mapping (mm_media,
mm_gedfile) [nativecode=ERROR: relation "pgv_media_mapping" does not exist]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_mm_media_gid ON pgv_media_mapping (mm_gid,
mm_gedfile ) [nativecode=ERROR: relation "pgv_media_mapping" does not exist]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_mm_media_gedfile ON pgv_media_mapping (mm_gedfile )
[nativecode=ERROR: relation "pgv_media_mapping" does not exist]

ERROR:-2 DB Error: syntax error
SQL:CREATE TABLE pgv_nextid ( ni_id INT NOT NULL, ni_type VARCHAR(15)
NOT NULL, ni_gedfile SMALLINT UNSIGNED NOT NULL, PRIMARY KEY (ni_type,
ni_gedfile)) [nativecode=ERROR: syntax error at or near "UNSIGNED" LINE
1: ...ype VARCHAR(15) NOT NULL, ni_gedfile SMALLINT UNSIGNED N... ^]

ERROR:-2 DB Error: syntax error
SQL:CREATE TABLE pgv_other ( o_id VARCHAR(20) NOT NULL, o_file SMALLINT
UNSIGNED NOT NULL, o_type VARCHAR(15) NULL, o_gedcom LONGTEXT NULL,
PRIMARY KEY (o_id, o_file)) [nativecode=ERROR: syntax error at or near
"UNSIGNED" LINE 1: ... VARCHAR(20) NOT NULL, o_file SMALLINT UNSIGNED ... ^]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_other_id ON pgv_other (o_id ) [nativecode=ERROR:
relation "pgv_other" does not exist]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_other_file ON pgv_other (o_file) [nativecode=ERROR:
relation "pgv_other" does not exist]

ERROR:-2 DB Error: syntax error
SQL:CREATE TABLE pgv_sources ( s_id VARCHAR(20) NOT NULL, s_file
SMALLINT UNSIGNED NULL, s_name VARCHAR(255) NULL, s_gedcom LONGTEXT
NULL, s_dbid CHAR(1) NULL, PRIMARY KEY (s_id, s_file))
[nativecode=ERROR: syntax error at or near "UNSIGNED" LINE 1: ...
VARCHAR(20) NOT NULL, s_file SMALLINT UNSIGNED ... ^]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_sour_id ON pgv_sources (s_id ) [nativecode=ERROR:
relation "pgv_sources" does not exist]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_sour_name ON pgv_sources (s_name)
[nativecode=ERROR: relation "pgv_sources" does not exist]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_sour_file ON pgv_sources (s_file)
[nativecode=ERROR: relation "pgv_sources" does not exist]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_sour_dbid ON pgv_sources (s_dbid)
[nativecode=ERROR: relation "pgv_sources" does not exist]

ERROR:-2 DB Error: syntax error
SQL:CREATE TABLE pgv_link ( l_file SMALLINT UNSIGNED NOT NULL, l_from
VARCHAR(20) NOT NULL, l_type VARCHAR(15) NOT NULL, l_to VARCHAR(20) NOT
NULL, PRIMARY KEY (l_from, l_file, l_type, l_to)) [nativecode=ERROR:
syntax error at or near "UNSIGNED" LINE 1: CREATE TABLE pgv_link (
l_file SMALLINT UNSIGNED NOT NULL... ^]

ERROR:-18 DB Error: no such table
SQL:CREATE UNIQUE INDEX pgv_ux1 ON pgv_link (l_to, l_file, l_type,
l_from) [nativecode=ERROR: relation "pgv_link" does not exist]

ERROR:-2 DB Error: syntax error
SQL:CREATE TABLE pgv_name ( n_file SMALLINT UNSIGNED NOT NULL, n_id
VARCHAR(20) NOT NULL, n_num INT NOT NULL, n_type VARCHAR(15) NOT NULL,
n_sort VARCHAR(255) NOT NULL, n_full VARCHAR(255) NOT NULL, n_list
VARCHAR(255) NOT NULL, n_surname VARCHAR(255) NULL, n_surn VARCHAR(255)
NULL, n_givn VARCHAR(255) NULL, n_soundex_givn_std VARCHAR(255) NULL,
n_soundex_surn_std VARCHAR(255) NULL, n_soundex_givn_dm VARCHAR(255)
NULL, n_soundex_surn_dm VARCHAR(255) NULL, PRIMARY KEY (n_id, n_file,
n_num)) [nativecode=ERROR: syntax error at or near "UNSIGNED" LINE 1:
CREATE TABLE pgv_name ( n_file SMALLINT UNSIGNED N... ^]

ERROR:-18 DB Error: no such table
SQL:CREATE INDEX pgv_name_file ON pgv_name (n_file ) [nativecode=ERROR:
relation "pgv_name" does not exist]

Database Tables created successfully