Forum OpenACS Q&A: Error adding custom field in ecommerce

Collapse
1: Error adding custom field in ecommerce
Posted by Luis Armando Arriola on 10/04/02 01:18 AM
<p>
I am using ecommerce module of OpenACS 3.2.5 with Postres 7.2<br>
I have a problem with Add a custom field<br>
This is the error I got in custom-field-add-3.tcl<br>
<b>Database operation "dml" failed</b>
</p>
If I look at the log file I got the following:
<p>
<p>
</p>

[03/Oct/2002:14:45:54][6172.5126][-conn0-] Error: Ns_PgExec: result
status: 7 message: ERROR:  parser: parse error at or near "("
<br>

[03/Oct/2002:14:45:54][6172.5126][-conn0-] Error: dbinit:
error(localhost::soloaterias,ERROR:  parser: parse error at or near "("
): 'alter table ec_custom_product_field_values add (
    codigo varchar(200)
)'

Collapse
2: Response to Error adding custom field in ecommerce (response to 1)
Posted by Bart Teeuwisse on 10/04/02 01:26 AM
The query in question is an Oracle query. For PostgreSQL use
alter table ec_custom_product_field_values add column ...
instead of
alter table ec_custom_product_field_values add (...)
/Bart