Chris, that command you want me to carry out, is that a one-liner? Or should it 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.projects p; <== ? JOIN lsmb12.customers c ON p.customer_id = c.id; ? Sorry if it's a silly or even stupid question, but my psql-knowledge is around the zero level. thanks, 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; > > > Let me know if this corrects your issue or if you get other issues. > > > 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 ------------------------------------------------------------------------------ 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
