[freeside-users] 1.9.3 released

[Ghaith ALKAYYEM]

Hello Ryan,

 

I think this might be a problem in the database, sometimes when you copy the
Postgres db you get some duplicated entries due to problem in the hard disks
or maybe other factors.

I recommend you to create an ordinary index without the uniqueness
constraint and search for these duplicated entries and fix them.

 

Regards.

 

 

From: freeside-users-bounces at freeside.biz
[mailto:freeside-users-bounces at freeside.biz] On Behalf Of Ryan Ghering
Sent: Friday, April 23, 2010 11:50 PM
To: Freeside users mailing list
Subject: Re: [freeside-users] 1.9.3 released

 

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
<http://www.freeside.biz/freeside/freeside-1.9.3.tar.gz%0AMD5sum> 
MD5sum: 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:Upg
rading

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/20100424/eb3f5b73/attachment.htm>