[freeside] part_pkg_pkey for quick charge

[Kristian Hoffmann]

Try running bin/fix-sequences in the freeside source tree.  If you're
using Pg, freeside uses Pg's sequences (not counter files) to keep track
of the next primary key values.

-Kristian

On Mon, 7 Feb 2005, Peter Kolbe wrote:

> freeside-1.5.0pre6
> Apache::ASP
> Server version: Apache/1.3.31 (Unix)
> Server built:   Jan 12 2005 09:59:31
>
> RHL9
> This is perl, v5.8.5 built for i686-linux
> psql (PostgreSQL) 7.3.2
> DBI-1.47
> DBD-Pg-1.32
>
> When adding Quick Charge I get :
>
> ERROR: Cannot insert a duplicate key into unique index part_pkg_pkey
>
> I deleted all out of part_pkg and then it created an entry with a pkgpart 25
>
> My packages end at about 86, so I need to increment counter:
> (I tried 2 Locations, and lots of variations on file name, no success)
>
> ls /usr/local/etc/freeside/counters.DBI:Pg:host=localhost;dbname=freeside
> part_pkg_pkey
> part_pkg.pkey
> part_pkg.pkgnum
> part_pkg.pkgpart
>
> ls /usr/local/etc/freeside/counters.DBI:Pg:dbname=freeside
> part_pkg_pkey
> part_pkg.pkey
> part_pkg.pkgnum
> part_pkg.pkgpart
>
>
> each counterfile has the ffg in it :
> COUNTER-1.0
> 100
>
>
> But still no success.
>
> Please help
> Peter
>
> --------------------------------------------------------------------------
> The information transmitted is intended only for the person to whom it is
> addressed and may contain confidential and/or privileged material.
>
> Although SCDS / Venturenet scans incoming and outgoing emails and email
> attachments for viruses we cannot guarantee a communication to be free of
> all viruses nor accept any responsibility for viruses.
>
> Although SCDS / Venturenet monitors incoming and outgoing emails for
> inappropriate content, we cannot be held responsible for the views or
> expressions of the author.
>
> The views expressed may not necessarily be those of SCDS / Venturenet and
> as such, cannot be held responsible for any loss or injury resulting from
> the contents of a message.
> --------------------------------------------------------------------------
>
>
>
>