On Fri, Dec 7, 2012 at 1:57 PM, ario <ledger-smb-us...@infopower.nl> wrote:
> On Fri, 2012-12-07 at 18:22 +0000, ario wrote:
> > On Fri, 2012-12-07 at 03:34 -0800, Chris Travers wrote:
> > >
> > >
> > > On Fri, Dec 7, 2012 at 2:07 AM, ario <ledger-smb-us...@infopower.nl>
> > > wrote:
> > > Tried, I'll quote the result:
> > >
> > > <quote>
> > > ERROR: relation "lsmb12.projects" does not exist
> > > LINE 1: ..., parts_id, production, completed, credit_id FROM
> > > lsmb12.pro...
> > > ^
> > > </quote>
> > >
> > > ario
> > >
> > >
> > > On Fri, 2012-12-07 at 00:04 -0800, Chris Travers wrote:
> > > >
> > > >
> > >
> > > > On Thu, Dec 6, 2012 at 11:43 PM, ario
> > > <ledger-smb-us...@infopower.nl>
> > > > wrote:
> > > > Still trying to get things working.
> > > > Re-installed brand new debian 6.0.6 and ledgersmb
> > > 1.3.23.
> > > > Imported the backup of a 1.2.21 database with loads
> > > of
> > > > projects.
> > > > After that, only 2 projects show up.
> > > > Strange number in System|Defaults|Job/Project
> > > Number: 11
> > > > Both databases (within the same cluster) give this
> > > same
> > > > number, although
> > > > both have different number of projects >> 11.
> > > >
> > > > What's going on, and how can I get my projects back
> > > in 1.3.23?
> > > >
> > > >
> > > > Hi;
> > > >
> > > >
> > > > I am trying to track this down. Can you try this for me:
> > > >
> > > >
> > > > INSERT INTO project
> > > > (id, projectnumber, description, startdate,
> > > > enddate, parts_id, production, completed, credit_id)
> > > > SELECT p.id, projectnumber, p.description, p.startdate,
> > > p.enddate,
> > > > parts_id, production, completed, credit_id
> > > > FROM lsmb12.projects p
> > > > JOIN lsmb12.customers c ON p.customer_id = c.id;
> > >
> > >
> > >
> > > Sorry, my bad, should be:
> > >
> > >
> > > INSERT INTO project
> > > (id, projectnumber, description, startdate, enddate, parts_id,
> > > production, completed, credit_id)
> > > SELECT p.id, projectnumber, p.description, p.startdate, p.enddate,
> > > parts_id, production, completed, credit_id
> > > FROM lsmb12.project p
> > > JOIN lsmb12.customers c ON p.customer_id = c.id;
> > >
> > >
> > > In other words, lsmb12.project instead of lsmb12.projects.
> >
> > And lsmb12.customer instead of lsmb12.customer, I realised after the
> > same error appeared (no relationship exists) with respect to
> > 'lsmb12.customers'.
> >
> > But still then, after removing the trailing 's' in both
> > 'lsmb12.projects' and 'lsmb12.customers' it still gave an error:
> >
> > <quote>
> > ERROR: duplicate key value violates unique constraint "project_pkey"
> > DETAIL: Key (id)=(14395) already exists.
> > dbname=#
> > </quote>
>
If you just start at SELECT, how many rows show up? If only two then I
know what to do to both preventing this from happening again and in fixing
it.
Best Wishes,
Chris Travers
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
