[ic] IC_TEST_CREATE table

[Chad Leigh, Shire.Net LLC]

--==========1437271731==========
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi

In the configuration of a new catalog (using SQL database, in my case =
trying to use FrontBase), it apperas to create a table called =
IC_TEST_CREATE with the columns of the real table it wants to create.  It =
then appears to try and create the real table.  My problem is that the =
IC_TEST_CREATE from the table creation before hand is still in my database =
when it tries to go through the cycle again for the next table.

I have tried using Oracle and Postgres as my "databases" with actually =
being logged into FrontBase, after changing the appropriate table column =
definition files.

What is the actual work going on behind he scenes with this IC_TEST_CREATE =
table?

Here is a sample log
Do you want me to start it as 'interch' now? [y]
Killing Interchange server 54648 with TERM.
Low traffic settings.
Calling UI....
...UI is loaded....
Interchange V4.6.5
Configuring catalog construct...Using PostgreSQL, =
DSN=3Ddbi:FB:dbname=3Dconstruct;host=3Dmyhost.myhost.me.
perl in free(): warning: modified (chunk-) pointer.
table country created: create table country (
code CHAR(3) NOT NULL PRIMARY KEY,
selector CHAR(3) NOT NULL,
shipmodes CHAR(64),
countryname CHAR(32) NOT NULL
)

table country index failed: Semantic error 249. Index already defined.
Exception 363. Transaction rollback.

perl in free(): warning: modified (chunk-) pointer.
perl in free(): warning: modified (chunk-) pointer.
bad table creation statement:
create table gift_certs (
code char(14) NOT NULL PRIMARY KEY,
username CHAR(20) default '' NOT NULL,
order_date varchar(32) NOT NULL,
original_amount float(4) NOT NULL,
redeemed_amount float(4) NOT NULL,
available_amount float(4) NOT NULL,
passcode CHAR(20) NOT NULL,
active CHAR(3),
redeemed CHAR(3),
update_date timestamp
)


Error: Semantic error 085. Table name - IC_TEST_CREATE - exists.
Exception 363. Transaction rollback.

construct config error: No database object for table: gift_certs
.


Thanks
Chad

--==========1437271731==========
Content-Type: application/pgp-signature
Content-Transfer-Encoding: 7bit

-----BEGIN PGP SIGNATURE-----
Version: Mulberry PGP Plugin v2.0
Comment: processed by Mulberry PGP Plugin

iQA/AwUBOvduOZTz5Jfdw0hKEQJMYgCeM2zsyQghow0aqF/cARoAot0NUeIAoP/N
kgaJ+IipgV4CQ1LTQeQHJgRI
=5MhG
-----END PGP SIGNATURE-----

--==========1437271731==========--