Re: projects lost after importing 1.2.21 backups in 1.3.23

On Fri, Dec 7, 2012 at 12:18 AM, ario <..hidden..> wrote:

Before I follow your suggestion below, don't you want to read and
comment to my previous follow-up mail with the error messages?

Also in one database in 1.2.21 I counted the projects (41) and entered
the number 42 in the field 'System|Defaults|Job/Project Number', should
I put that back to 11 before I carry out your suggested action?

I may have missed the previous email, going back to check but for now, this should be safe. It will either produce errors or it will import your projects from the stored 1.2.x data. No need to change the defaults yet,

Best Wishes,

Chris Travers

thanks,

ario

On Fri, 2012-12-07 at 00:04 -0800, Chris Travers wrote:
>
>
> On Thu, Dec 6, 2012 at 11:43 PM, ario <..hidden..>
> 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 ..hidden.. 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
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users