#497 Media DB Errors on Clean Install using Latest CVS

[KosherJava]

ERROR:-5 DB Error: already exists
SQL:CREATE INDEX m_media ON pgv_beta_media (m_media)
[nativecode=1061 ** Duplicate key name 'm_media']

ERROR:-2 DB Error: syntax error
SQL:CREATE TABLE pgv_beta_media_mapping (m_id int(11)
NOT NULL auto_increment, m_media varchar(15) NOT NULL
default '', m_gid varchar(15) NOT NULL default '',
m_order int(11) NOT NULL default '0', m_gedfile int(11)
default NULL, m_gedrec text, PRIMARY KEY (m_id), KEY
m_media (m_media) [nativecode=1064 ** You have an error
in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to
use near '' at line 1]

[KosherJava]

Logged In: YES
user_id=634811

I made changes (not checked in) to functions_db and added a
')' to line that created the media_mapping table. I now get
the following error:
ERROR:-5 DB Error: already exists
SQL:CREATE INDEX m_media ON pgv_beta_media (m_media)
[nativecode=1061 ** Duplicate key name 'm_media']

ERROR:-5 DB Error: already exists
SQL:CREATE INDEX m_media ON pgv_beta_media_mapping (m_media)
[nativecode=1061 ** Duplicate key name 'm_media']

ERROR:-5 DB Error: already exists
SQL:CREATE TABLE pgv_beta_media (m_id int(11) NOT NULL
auto_increment, m_media varchar(15) NOT NULL default '',
m_ext varchar(6) NOT NULL default '', m_titl varchar(255)
default NULL, m_file varchar(255) NOT NULL default '',
m_gedfile int(11) default NULL, m_gedrec text, PRIMARY KEY
(m_id), KEY m_media (m_media)) [nativecode=1050 ** Table
'pgv_beta_media' already exists]

From the functions_db I see that the create statement seems
to appear twice. First in the lines 901-913 and again at
1050-1065. I never really spent time on the file and I am
not sure that this duplication is a problem.

[Roland Dalmulder]

Logged In: YES
user_id=1143947

Dear user,

Can you please test the provided solution and let us know if this
solved your issue? We can then either continue working on your
bug or close it.

Thanks,

The PGV team

[KosherJava]

Logged In: YES
user_id=634811

Roland,
Thanks this is now fixed. Please note that on line 915 of
functions_db there is a missing ) that will cause a syntax
error if called. I do not know if this line is ever called.