checkseyup.pl:1897

[David Miller]

On 6/5/2003 2:23 AM -0400, Jason Pyeron wrote:

> can anyone explain this to me?
> I tried to do it by hand in mysql but i get a table bugs not found????
>
>
> Thanks
>
>
>
> AddFDef("(to_days(now()) - to_days(bugs.delta_ts))", "Days since bug
>changed", 0);
>
> REPLACE INTO fielddefs (fieldid, name, description, mailhead, sortkey)
> VALUES (NULL, (to_days(now()) - to_days(bugs.delta_ts)), "Days since bug
> changed",0,31);

Although it happens to be SQL, that's just an accident.  It's a string, and
stored exactly as it looks, so make sure you quote it when you insert it :)

 REPLACE INTO fielddefs (fieldid, name, description, mailhead, sortkey)
 VALUES (NULL, '(to_days(now()) - to_days(bugs.delta_ts))', 'Days since bug
 changed',0,31);

-- 
Dave Miller      Project Leader, Bugzilla Bug Tracking System
http://www.justdave.net/             http://www.bugzilla.org/