Deleting items from the part_pkg and part_svc listings

[Ivan Kohler]

-----BEGIN PGP SIGNED MESSAGE-----

On Thu, 11 Jun 1998, Allen Short wrote:

> Is there a method in Freeside to remove items from the package and
> service tables or must this be done using a client for the SQL database?

Right now you need to use your SQL client.  Be sure and make sure:

When removing services, make sure there are no services with this part (no
matching svcpart in cust_svc) and that they are included in no packages
(no matching svcpart in pkg_svc).  Records in pkg_svc with 0 quantity can
be safely removed.

A When removing packages, make sure there are no packages with this part
(no maching pkgpart in cust_pkg) and also remove any entries matching that
pkgpart in type_pkgs.
 
> Also, when clicking the 'add' button in the 'add services' page, I
> receive an 'Internal Server Error' and this appears in my httpd logs:
> 
> access to /opt/fs-1.0.0/htdocs//edit/process/part_pkg.cgi failed for
> proxy.narrowgate.net, reason: malformed header from script. Bad
> header=HTTP/1.0 302 Moved Temporarily

Check htdocs/docs/cgifix.html

> I'm running Red Hat Linux 5.0 with Apache and mysql, using Netscape
> Communicator for Windows 95 as my browser. Also, this is not a dedicated
> machine -- thus, everything is aliased in Apache to reside under
> /freeside.

Support for this has been added to the development tree but hasn't been
released yet.  I hope to get a release out soon.

> Any help would be appreciated.
> 
> --
> Allen Short
> 

- -- 
Ivan Kohler <ivan at sisd.com> - finger for PGP key
Silicon Interactive Software Design - http://www.sisd.com/
Open source billing and administration for ISPs - http://www.sisd.com/freeside
"But it's alright, to smile back at me" -Blind Melon

-----BEGIN PGP SIGNATURE-----
Version: 2.6.3ia
Charset: noconv

iQCVAwUBNYA6ir7OPBeQJv09AQEaswP+PAHZvgKkbjmFrXxTrCB+ieGE0jbR0AQF
Kdu319MbCCyp3Jaxfqh72P93dqcjo+kguC0eS6Ovn0tLokBSKvrnrYAhbrgO62tC
xjzUWcWDJ51snY6/t0kJf1VUl/i7rCNiuYlnHW2oKu9TK4Law1wB5xHPnmOweQ8o
tKX7X8rnaY8=
=kt5t
-----END PGP SIGNATURE-----