[freeside-users] 1.9.3 released

[Ryan Ghering]

Ivan, were testing out 1.9.3 on a test server, using a copy of our live db.

when we upgrade which is from 1.9.1 btw we get.

DROP INDEX pkg_svc1
CREATE UNIQUE INDEX pkg_svc1 ON pkg_svc ( pkgpart, svcpart )
DBD::Pg::db do failed: ERROR:  could not create unique index
DETAIL:  Table contains duplicated values. at
/usr/local/bin/freeside-upgrade line 94.
Error: ERROR:  could not create unique index
DETAIL:  Table contains duplicated values.
 executing: CREATE UNIQUE INDEX pkg_svc1 ON pkg_svc ( pkgpart, svcpart ) at
/usr/local/bin/freeside-upgrade line 94.

After looking at pkg_svc only the pkgsvcnum field is unique, it looks as if
the script is trying to create a unique index using
pkgpart and svcpart which from my db are not unique..

Any ideas?

Thanks
Ryan

On Wed, Apr 21, 2010 at 12:59 AM, Ivan Kohler <ivan at freeside.biz> wrote:

> I'm pleased to announce the release of Freeside version 1.9.3.
>
> Download: http://www.freeside.biz/freeside/freeside-1.9.3.tar.gz
> MD5sum <http://www.freeside.biz/freeside/freeside-1.9.3.tar.gz%0AMD5sum>:
> 12227a5a52ea472b9cc569a0faa88841
> SHA1sum: 1b5b91cda07a22832b37cd95007a112348145b7b
>
> Changelog:
> http://www.freeside.biz/mediawiki/index.php/Freeside:1.9.3:Changelog
>
> Upgrading:
>
> http://www.freeside.biz/mediawiki/index.php/Freeside:1.9.3:Documentation:Upgrading
>
> VMware appliance (402mb):
> - Bittorrent (preferred):
>  http://www.freeside.biz/freeside/Freeside-Appliance-1.9.3.zip.torrent
> - Direct download:
>  http://www.freeside.biz/freeside/Freeside-Appliance-1.9.3.zip
>
> Happy April 20th!
>
> --
> _ivan
> _______________________________________________
> freeside-users mailing list
> freeside-users at freeside.biz
> http://420.am/cgi-bin/mailman/listinfo/freeside-users
>



-- 
Ryan Ghering
Network Operations - Plains.Net
Office: 970-848-0475 - Cell: 970-630-1879
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://420.am/pipermail/freeside-users/attachments/20100423/29ad0273/attachment.htm>