leggn at denison
May 16, 2011, 1:02 PM
Post #2 of 3
Re: Remove expire date via bric_soap or database
[In reply to]
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.
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
> 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.
> Chris Schults
> Web Developer
> PCC Natural Markets
> 206-547-1222 x104
> chris.schults [at] pccsea