Re: Upgrade error

["Chris Travers" <..hidden..>]

In your case, can continue operation with your current dataset.

Do as follows:
drop cascade the transactions table.
Copy from the upgrade sql file the portions dealing with the
transactions table (including rules, inserts, etc).  Delete the lines
dealing with inserting from chart, parts, partsgroup, and employee.
Run the queries.  You should be good to go.

These tables are going to eventually be moved out of the universal id
framework and they don;t have shipto's or acc_trans.trans_id's
associated with them, so we shouldn't have any join projection issues.

Best Wishes,
Chris Travers

On 11/12/06, G. Net <..hidden..> wrote:
> > Does the same id occur in any single table, for example, if in the
> > GROUP BY clause of the subquery, if you add table_name to the list of
> > columns, do you still get any output?
>
>
> Output from SQL command: select * from transactions where id IN (select id from transactions
> GROUP BY id, table_name HAVING count(*) > 1); ...
>
>
> No data returned
>
>
>
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users