[OPEN-ILS-DEV] ***SPAM*** Re: 1.6 Billing Problem

[Jason Etheridge]

On Thu, Dec 10, 2009 at 5:26 PM, Ryan <ryan484lav at gmail.com> wrote:
>  id |             name              | owner | default_price

Yeah, your problem is no entries above id 100.

This is from an upgrade script in trunk:

INSERT INTO config.billing_type (id, name, owner) SELECT DISTINCT 101,
oils_i18n_gettext(101, 'Misc', 'cbt', 'name'), 1 FROM
config.billing_type_id_seq WHERElast_value < 101;
SELECT SETVAL('config.billing_type_id_seq'::TEXT, 101) FROM
config.billing_type_id_seq WHERE last_value < 101;

Run that in psql and you should be good to go.

-- Jason