0000029: geodata import fails if table already exists - Mantis

Viewing Issue Simple Details [ Jump to Notes ]

[ View Advanced ] [ Issue History ] [ Print ]

ID

Category

Severity

Reproducibility

Date Submitted

Last Update

0000029

[Mapping kit] geodata

minor

have not tried

2008-11-21 09:29

2008-11-30 22:29

Reporter

john

View Status

public

Assigned To

john

Priority

normal

Resolution

fixed

Status

resolved

Product Version

Summary

0000029: geodata import fails if table already exists

Description

Import process should be made more robust, and e.g. check existence of a table name before trying the import.

Additional Information

Tags

No tags attached.

Relationships

Notes
(0000009) john (manager) 2008-11-28 13:13 edited on: 2008-11-28 14:03	Warnings at second import of shapefile: * Table worldcountries already exists. Please choose another name. * warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "column" LINE 1: alter table add column _importtime timestamp without time z... ^ in D:\WWW\drupal-6.x\includes\database.pgsql.inc on line 140. * user warning: query: alter table add column _importtime timestamp without time zone DEFAULT now(), add column _importuid int; update set _importuid = 1; in D:\WWW\drupal-6.x\sites\all\modules\mappingkit\geodata\geodata.module on line 1082. The second node has been created, but does not have its properties set; when it is deleted, the table is not affected.

Issue History
Date Modified	Username	Field	Change
2008-11-21 09:29	john	New Issue
2008-11-21 10:35	john	Assigned To	=> john
2008-11-21 10:35	john	Status	new => assigned
2008-11-21 10:36	john	Target Version	=> 6.x-1.3
2008-11-28 13:13	john	Note Added: 0000009
2008-11-28 14:03	john	Note Edited: 0000009
2008-11-29 23:26	john	Status	assigned => resolved
2008-11-29 23:26	john	Fixed in Version	=> 6.x-1.x-dev
2008-11-29 23:26	john	Resolution	open => fixed
2008-11-30 22:29	john	Fixed in Version	6.x-1.x-dev => 6.x-1.3

Mantis 1.1.4[^]

Copyright © 2000 - 2008 Mantis Group