[freeside] Adding a package

[Dale Hege]

> On Tue, May 28, 2002 at 07:33:02PM -0400, Dale Hege wrote:
>>
>> I've been working on the mysql stuff and while working on the
>> "packages with unconfigured services (by package number)" search I
>> found that I am not getting any packages output even though they are
>> there.
>
> MySQL does not support subqueries.  Subqueries are used for the "with
> unconfigured services" search results.  You mentioned you've been
> working on patches for MySQL support;  this is one of the things that
> needs to be patched.
>

Yes, I know. Just putting that in so I don't get the mysql is not
supported answer.
>> I tested this in the webdemo and everything works.
>
> The 1.4.0 webdemo runs on PostgreSQL, which supports subqueries.
>

Thats why I used it as a baseline.

>> So here is my log for the sql server
>> insterting a new package for a customer.
>
> I doubt anything is wrong with the insert.
>

Just wanted to make sure that mysql was getting the proper insersts and
that nothing was missing indicating a problem with mysql before we even
get to searching the db.
-Dale