[ic] page generation for the admin area orders

Peter peter at pajamian.dhs.org
Tue Nov 1 20:37:13 EST 2005


On 11/01/2005 05:14 PM, James P. Kinney III wrote:
> Plus I got an error message when I ran a test:
> 
> table transactions: set_slice error as called by Vend::Data: DBD::Pg::st
> execute failed: ERROR: invalid input syntax for type timestamp: "" query
> was:update transactions SET
> currency_locale=?,fname=?,subtotal=?,po_number=?,comments=?,state=?,b_country=?,email=?,campaign=?,b_lname=?,shipping=?,order_number=?,parent=?,salestax=?,b_company=?,archived=?,order_wday=?,username=?,b_fname=?,zip=?,payment_method=?,b_phone=?,order_date=?,b_address1=?,lname=?,b_state=?,address1=?,shipmode=?,phone_day=?,store_id=?,status=?,avs=?,b_city=?,phone_night=?,city=?,fax=?,order_ymd=?,company=?,b_zip=?,country=?,b_address2=?,order_id=?,affiliate=?,deleted=?,total_cost=?,address2=?,nitems=?,update_date=?,handling=?,complete=? WHERE code = 'TEST0004' values were:'','wilma','169','','','MA','','billme at chargealot.com','','','0.00','TEST0004','','0.00','','','2','00003','','10111','credit_card','','20051101 20:07:01','','flintstone','','123 any st','JACKSVAC (Jacks $7.95 rate)','5551234','','pending','','','','bedrock','','20051101','','','US','','','ORDER_DESK','','176.95','','1','','0.00','0'

You have a field of type timestamp, probably update_date that you're 
leaving blank, and a blank value is not a valid timestamp for 
Postgresql.  You need to fill in the update_date for it to work, or 
change the field type to something else such as character varying(26) 
(gives enough space for YYYY-MM-DD HH:MM:SS.mmmmmm).

>>>>Where is the "process" page generated?
>>
>>process isn't a real page.  See 
>><http://www.icdevgroup.org/interchange-doc-5.2.0/icfaq.html#Where%20is%20process.html>
> 
> 
> Thanks. That was what I thought it was. Now to dig into the guts...

Also see <http://www.interchange.rtfm.info/docs/frames/ictemplates_35.html>.

Peter


More information about the interchange-users mailing list