Mailing List Archive: Remove expire date via bric

Remove expire date via bric_soap or database

May 16, 2011, 12:57 PM

Post #1 of 3 (1566 views)

I need to remove the expire date from hundreds of stories. Any ideas on
how to do this?

I've tried using bric_soap by removing the <expire_date> element
altogether and replacing with <expire_date></expire_date> with no
change.

When updating the story table, I can't seem to insert a blank value as I
get an "invalid input syntax for type timestamp" error.

Thanks,

Chris

--------------------------------

Chris Schults
Web Developer
PCC Natural Markets
206-547-1222 x104
chris.schults@pccsea.com
http://www.pccnaturalmarkets.com

Re: Remove expire date via bric_soap or database [ In reply to ]

leggn at denison

May 16, 2011, 1:02 PM

Post #2 of 3 (1495 views)

Permalink

Hi Chris,

You could write a quick perl script using the Bric API to accomplish
this, or just an update query in the DB directly. The bric_soap issue
sounds like a bug to me.

The timestamp field in the DB won't accept an empty string, but you can
set it to NULL to make it blank.

-Nick

On 5/16/2011 3:57 PM, Schults, Chris wrote:
> I need to remove the expire date from hundreds of stories. Any ideas on
> how to do this?
>
> I've tried using bric_soap by removing the<expire_date> element
> altogether and replacing with<expire_date></expire_date> with no
> change.
>
> When updating the story table, I can't seem to insert a blank value as I
> get an "invalid input syntax for type timestamp" error.
>
> Thanks,
>
> Chris
>
> --------------------------------
>
> Chris Schults
> Web Developer
> PCC Natural Markets
> 206-547-1222 x104
> chris.schults@pccsea.com
> http://www.pccnaturalmarkets.com
>
>

RE: Remove expire date via bric_soap or database [ In reply to ]

chris.schults at pccsea

May 16, 2011, 1:07 PM

Post #3 of 3 (1495 views)

Permalink

> Hi Chris,
>
> You could write a quick perl script using the Bric API to accomplish
> this, or just an update query in the DB directly. The bric_soap issue
> sounds like a bug to me.
>
> The timestamp field in the DB won't accept an empty string, but you
can
> set it to NULL to make it blank.
>
> -Nick

Thanks Nick, going with NULL did the trick.