If your backup from 2/2 allows posting, you check the account_checkpoint
table for differences, and also the defaults table.
Did you do any upgrades or close books?
On Thu, Feb 25, 2016 at 11:31 PM, Hilton Day <hilton....@gmail.com> wrote:
> I checked my backups - and my previous copy of the database dated 2/2
> allows posting, so having done a diff of the SQL files using pg_dump, I'm
> just going to revert and post the various transactions again since then.
>
> Still not clear what I did to cause book closure, but at least a way
> forwards that isn't too painful has emerged.. I was contemplating removing
> some of the account checkpoint records as an experiment, but spending hours
> fiddling versus an hour re-posting transactions makes no sense.
>
> Thanks all for input!
>
> Hilton.
>
>
>
>
> On Wed, Feb 24, 2016 at 11:31 AM, Hilton Day <hilton....@gmail.com> wrote:
>
>> Hi Chris, thanks.
>>
>>
>> Do you have a save button?
>>>
>>>
>> Yes, but it doesn't proceed the workflow to enable "Post as Saved" as I'm
>> used to seeing.
>>
>> Hitting Save results in a request to the web server, and it populates the
>> Due Date field, but no Post buttons appear.
>>
>>
>>>
>>> If that s missing then the problem may be with books being
>>> inappropriately closed. I can help you with that, but let's check first.
>>>
>>>
>>
>> After this comment of yours, I checked and I can't post anything -
>> AP/AR/GL etc. so it appears my books have indeed somehow become closed.
>>
>> I've checked the Audit Control (no date set), and Year End (closed on
>> 30-06-2014), and tried re-opening the books as of 01-07-2014 in my test
>> environment, but no change in behaviour.
>>
>> Any guidance on how I can re-open the books much appreciated.
>>
>>
>> Regards,
>>
>> Hilton.
>>
>> On Sat, Feb 20, 2016 at 9:19 PM, Chris Travers <chris.trav...@gmail.com>
>> wrote:
>>
>>>
>>>
>>> On Sat, Feb 20, 2016 at 10:21 AM, Hilton Day <hilton....@gmail.com>
>>> wrote:
>>>
>>>> Many thanks Erik for the speedy response.
>>>>
>>>> Upgrade completed to 1.4, and then subsequently to 1.4.24, and I can
>>>> open the accounts, so upgrade is considered successful.
>>>>
>>>> However, here's a question for the brains-trust of ledgersmb experts on
>>>> this list :)
>>>>
>>>> I still can't post an AR invoice - I don't get a Post button. This is
>>>> the issue which caused me to decide to upgrade from 1.3 to 1.4.
>>>>
>>>> The buttons I have are: Update, Save, Schedule, and Save Template, and
>>>> I'm unable to get a Post/Post as Saved/Post as Shown button to appear. I'm
>>>> also unable to see any saved drafts, so it seems they're not being created
>>>> either.
>>>>
>>>> This isn't just for my latest client, but also for clients I've
>>>> previously posted invoices for back in Dec. 2014..
>>>>
>>>
>>> Hi
>>>
>>> The missing post button should be replaced by a save button, and then
>>> you can post after saving.
>>>
>>> If that s missing then the problem may be with books being
>>> inappropriately closed. I can help you with that, but let's check first.
>>>
>>> Do you have a save button?
>>>
>>>>
>>>> To satisfy myself that it wasn't an issue with my
>>>> host/webserver/postgres configuration or old scripts on my usual
>>>> installation, I downloaded the Virtualbox image from sourceforge and
>>>> upgraded that to 1.4.24 separately, and even with a completely separate
>>>> config, the same issue occurs, so its something in my sqlledger config
>>>> inside the database.
>>>>
>>>> Have also checked my yearend - its still closed as of 30-06-14 (I
>>>> haven't filed last tax year ending 30-06-2015 yet) so books are definitely
>>>> open.
>>>>
>>>> The issue is consistent between my current 1.3.46 install (and also
>>>> 1.3.44 - tried downgrading slightly), and 1.4.24.
>>>>
>>>> Any ideas what might be causing this? I'm flummoxed!
>>>>
>>>> Thanksin advance,
>>>>
>>>> Hilton.
>>>>
>>>>
>>>>
>>>> On Fri, Feb 19, 2016 at 9:09 AM, Erik Huelsmann <ehu...@gmail.com>
>>>> wrote:
>>>>
>>>>> Hi Hilton,
>>>>>
>>>>> On Thu, Feb 18, 2016 at 8:33 PM, Hilton Day <hilton....@gmail.com>
>>>>> wrote:
>>>>>
>>>>>> I'm trying to upgrade my old 1.3.46 database (started life as 1.1
>>>>>> from memory - back at end of 2006), and have worked my way through a few
>>>>>> issues so far, like a few duplicate meta numbers, and missing GIFI
>>>>>> accounts.
>>>>>>
>>>>>
>>>>> Ok. Then you have the hardest part behind you :-)
>>>>>
>>>>>
>>>>>> Now the upgrade is bombing out with this message:
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> *Error!Upgrade failed;logs can be found in
>>>>>> /tmp/ledgersmb/dblog_2016-02-18T191531_2606_stdout and
>>>>>> /tmp/ledgersmb/dblog_2016-02-18T191531_2606_stderr at
>>>>>> LedgerSMB/Scripts/setup.pm <http://setup.pm> line 1002.dbversion: 1.4.24,
>>>>>> company: *
>>>>>> Looking in the error log (full version of both the stdout and stderr
>>>>>> files attached), the problems look to me like:
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> *psql:sql/modules/Fixes.sql:164: ERROR: duplicate key value violates
>>>>>> unique constraint "menu_node_pkey"DETAIL: Key (id)=(90) already
>>>>>> exists.psql:sql/modules/Fixes.sql:216: ERROR: duplicate key value
>>>>>> violates
>>>>>> unique constraint "menu_node_pkey"DETAIL: Key (id)=(129) already
>>>>>> exists.*
>>>>>>
>>>>>
>>>>> Errors from Fixes.sql are expected, so these two aren't a problem.
>>>>>
>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> *psql:/tmp/ledgersmb/upgrade.sql:549: ERROR: column
>>>>>> "recurring_interval" is of type interval but expression is of type
>>>>>> textLINE
>>>>>> 4: repeat || ' ' || unit as recurring_interval
>>>>>> ^HINT: You will need to rewrite or cast the expression.*
>>>>>>
>>>>>
>>>>> This is your problem. Fortunately, it's probably easy to work around.
>>>>> Try changing
>>>>>
>>>>> """
>>>>> repeat || ' ' || unit
>>>>> """
>>>>>
>>>>> to
>>>>> """
>>>>> (repeat || ' ' || unit)::interval
>>>>> """
>>>>>
>>>>> That should allow you to get past the current problem. I hope it's the
>>>>> last one on your route to 1.4! Anyway, I'll change this script for 1.4.26
>>>>> (We just released .25 today, but this problem isn't fixed in it).
>>>>>
>>>>>
>>>>>> The reason I'm trying ot upgrade is having recently picked up my
>>>>>> business again I'm doing consulting work, and have discovered that I
>>>>>> can't
>>>>>> post an AR invoice any more in my current 1.3.46 - so I figured I'd
>>>>>> upgrade
>>>>>> to 1.4.24 before getting into why (last invoices I posted were a year or
>>>>>> so
>>>>>> ago).
>>>>>>
>>>>>
>>>>> That's weird. I'm using companies in both 1.3.46 and 1.4.22, but
>>>>> haven't heard about this problem before. Let me know if the upgrade fixed
>>>>> things!
>>>>>
>>>>>
>>>>>> Any help appreciated figuring out this upgrade for now.. I want to
>>>>>> get my database moved up to 1.4 successfully before I worry about the
>>>>>> functional issue.
>>>>>>
>>>>>>
>>>>> The advice above should allow you to continue onto the next upgrade
>>>>> steps.
>>>>>
>>>>> Regards,
>>>>>
>>>>>
>>>>> --
>>>>> Bye,
>>>>>
>>>>> Erik.
>>>>>
>>>>> http://efficito.com -- Hosted accounting and ERP.
>>>>> Robust and Flexible. No vendor lock-in.
>>>>>
>>>>>
>>>>> ------------------------------------------------------------------------------
>>>>> Site24x7 APM Insight: Get Deep Visibility into Application Performance
>>>>> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
>>>>> Monitor end-to-end web transactions and take corrective actions now
>>>>> Troubleshoot faster and improve end-user experience. Signup Now!
>>>>> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
>>>>> _______________________________________________
>>>>> Ledger-smb-users mailing list
>>>>> Ledger-smb-users@lists.sourceforge.net
>>>>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>>>>>
>>>>>
>>>>
>>>>
>>>> ------------------------------------------------------------------------------
>>>> Site24x7 APM Insight: Get Deep Visibility into Application Performance
>>>> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
>>>> Monitor end-to-end web transactions and take corrective actions now
>>>> Troubleshoot faster and improve end-user experience. Signup Now!
>>>> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
>>>> _______________________________________________
>>>> Ledger-smb-users mailing list
>>>> Ledger-smb-users@lists.sourceforge.net
>>>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>>>>
>>>>
>>>
>>>
>>> --
>>> Best Wishes,
>>> Chris Travers
>>>
>>> Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
>>> lock-in.
>>> http://www.efficito.com/learn_more
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Site24x7 APM Insight: Get Deep Visibility into Application Performance
>>> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
>>> Monitor end-to-end web transactions and take corrective actions now
>>> Troubleshoot faster and improve end-user experience. Signup Now!
>>> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
>>> _______________________________________________
>>> Ledger-smb-users mailing list
>>> Ledger-smb-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>>>
>>>
>>
>
>
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
> _______________________________________________
> Ledger-smb-users mailing list
> Ledger-smb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
