[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Upgrading 1.3.47 to 1.4.27: No duplicate meta_numbers.

Hi Arne,

This may be easier to deal with if you can drop in on the IRC channel
Either by visiting
https://vector.im/develop/#/room/#ledgersmb:matrix.org

or joining #ledgersmb on the freenode IRC network

If you choose to use the Browser Based client at vector.im please sign
up with your own account rather than using a guest account.
It makes it easier for tracking who we are replying to.

It can take a few hour for someone to respond on IRC but once you have a
dialog going things normally happen fairly quickly.

Erik is normally present for much of his day and most of the evening.
I believe his timezone is GMT+2.

Your issue sounds like an inconsistency in your 1.3 database that the
migration scripts are unable to automatically fix.
Unfortunately this can happen, but in most cases it's easy enough to
resolve, albeit requiring some manual fixes via the migration Interface.

Recently there has been quite a bit of work done on the migration tools,
mainly focused on migrating from SQL Ledger, but the improvements should
also help with issues like this one too.

Regards
David G

On 16/04/16 18:37, Arne Hanssen wrote:
> Hi.  I'm trying to upgrade on my Xubuntu Linux 15.10 system, my second 
> attempt.  This time all goes well until running setup.pl. After logging 
> in and answering Yes to upgrade from 1.3 I get this response:
> -----------------------------------------
> No duplicate meta_numbers
> Make sure all meta numbers are unique.
>
> meta_number        description
> [00000]
> [00000]
>
> [Save and Retry]
> -----------------------------------------
> (The brackets around '00000' is to illustrate that both these are inside 
> a box, 'Save and Retry' is a button).
>
> How can I fix this?  Everything is running on my PC (localhost), but I'm 
> using virtual host 'ledgersmb' (which also is 127.0.0.1) - worked ok in 
> 1.3.47.
>
> Apache2 error log looks like this:
>
> [Sat Apr 16 11:46:19.337846 2016] [cgi:error] [pid 28432] [client 
> 127.0.0.1:42510] AH01215: DBD::Pg::st execute failed: ERROR: function 
> public.setting_get(unknown) does not exist: 
> /mnt/home/www/ledgersmb/login.pl, referer: http://ledgersmb/setup.pl
> [Sat Apr 16 11:46:19.337880 2016] [cgi:error] [pid 28432] [client 
> 127.0.0.1:42510] AH01215: LINE 1: SELECT * FROM 
> "public"."setting_get"('ignore_version'): 
> /mnt/home/www/ledgersmb/login.pl, referer: http://ledgersmb/setup.pl
> [Sat Apr 16 11:46:19.337887 2016] [cgi:error] [pid 28432] [client 
> 127.0.0.1:42510] AH01215:                       ^: 
> /mnt/home/www/ledgersmb/login.pl, referer: http://ledgersmb/setup.pl
> [Sat Apr 16 11:46:19.337908 2016] [cgi:error] [pid 28432] [client 
> 127.0.0.1:42510] AH01215: HINT:  No function matches the given name and 
> argument types. You might need to add explicit type casts. at 
> LedgerSMB.pm line 577.: /mnt/home/www/ledgersmb/login.pl, referer: 
> http://ledgersmb/setup.pl
> [Sat Apr 16 11:46:19.338105 2016] [cgi:error] [pid 28432] [client 
> 127.0.0.1:42510] AH01215: 2016/04/16 11:46:19 - ERROR - 
> LedgerSMB::dberror LedgerSMB.pm (761) -- Logging SQL State 42883, error 
> 7, string ERROR:  function public.setting_get(unknown) does not exist: 
> /mnt/home/www/ledgersmb/login.pl, referer: http://ledgersmb/setup.pl
> [Sat Apr 16 11:46:19.338123 2016] [cgi:error] [pid 28432] [client 
> 127.0.0.1:42510] AH01215: LINE 1: SELECT * FROM 
> "public"."setting_get"('ignore_version'): 
> /mnt/home/www/ledgersmb/login.pl, referer: http://ledgersmb/setup.pl
> [Sat Apr 16 11:46:19.338130 2016] [cgi:error] [pid 28432] [client 
> 127.0.0.1:42510] AH01215:                       ^: 
> /mnt/home/www/ledgersmb/login.pl, referer: http://ledgersmb/setup.pl
> [Sat Apr 16 11:46:19.338147 2016] [cgi:error] [pid 28432] [client 
> 127.0.0.1:42510] AH01215: HINT:  No function matches the given name and 
> argument types. You might need to add explicit type casts.: 
> /mnt/home/www/ledgersmb/login.pl, referer: http://ledgersmb/setup.pl
> [Sat Apr 16 11:46:19.338201 2016] [cgi:error] [pid 28432] [client 
> 127.0.0.1:42510] AH01215: 2016/04/16 11:46:19 - ERROR - 
> LedgerSMB::_error LedgerSMB.pm (639) -- Internal Database Error: 
> /mnt/home/www/ledgersmb/login.pl, referer: http://ledgersmb/setup.pl
> [Sat Apr 16 11:46:19.338218 2016] [cgi:error] [pid 28432] [client 
> 127.0.0.1:42510] AH01215: More information has been reported in the 
> error logs at LedgerSMB.pm line 764.: /mnt/home/www/ledgersmb/login.pl, 
> referer: http://ledgersmb/setup.pl
> [Sat Apr 16 11:46:19.338272 2016] [cgi:error] [pid 28432] [client 
> 127.0.0.1:42510] AH01215: 2016/04/16 11:46:19 - ERROR - 
> LedgerSMB::_error LedgerSMB.pm (640) -- dbversion: 1.4.27, company: 
> postgres: /mnt/home/www/ledgersmb/login.pl, referer: 
> http://ledgersmb/setup.pl
> [Sat Apr 16 11:46:19.338696 2016] [cgi:error] [pid 28432] [client 
> 127.0.0.1:42510] AH01215: 2016/04/16 11:46:19 - ERROR - 
> LedgerSMB::_error LedgerSMB.pm (639) -- exit at LedgerSMB.pm line 653.: 
> /mnt/home/www/ledgersmb/login.pl, referer: http://ledgersmb/setup.pl
> [Sat Apr 16 11:46:19.338772 2016] [cgi:error] [pid 28432] [client 
> 127.0.0.1:42510] AH01215: 2016/04/16 11:46:19 - ERROR - 
> LedgerSMB::_error LedgerSMB.pm (640) -- dbversion: 1.4.27, company: 
> postgres: /mnt/home/www/ledgersmb/login.pl, referer: 
> http://ledgersmb/setup.pl
> [Sat Apr 16 11:46:19.338794 2016] [cgi:error] [pid 28432] [client 
> 127.0.0.1:42510] AH01215: exit at LedgerSMB.pm line 653.: 
> /mnt/home/www/ledgersmb/login.pl, referer: http://ledgersmb/setup.pl
> [Sat Apr 16 11:46:19.338808 2016] [cgi:error] [pid 28432] [client 
> 127.0.0.1:42510] AH01215: Compilation failed in require at 
> /mnt/home/www/ledgersmb/login.pl line 8.: 
> /mnt/home/www/ledgersmb/login.pl, referer: http://ledgersmb/setup.pl
> [Sat Apr 16 11:46:26.924842 2016] [cgi:error] [pid 28434] [client 
> 127.0.0.1:42542] AH01215: LedgerSMB::Upgrade_Tests=HASH(0x9785720) at 
> LedgerSMB/Scripts/setup.pm line 654.: /mnt/home/www/ledgersmb/setup.pl, 
> referer: http://ledgersmb/setup.pl
> [Sat Apr 16 11:46:26.924879 2016] [cgi:error] [pid 28434] [client 
> 127.0.0.1:42542] AH01215: LedgerSMB::Upgrade_Tests=HASH(0x9785720) at 
> LedgerSMB/Scripts/setup.pm line 654.: /mnt/home/www/ledgersmb/setup.pl, 
> referer: http://ledgersmb/setup.pl
> [Sat Apr 16 11:47:09.375897 2016] [cgi:error] [pid 28451] [client 
> 127.0.0.1:42548] AH01215: 1 at LedgerSMB/Scripts/setup.pm line 710.: 
> /mnt/home/www/ledgersmb/setup.pl, referer: http://ledgersmb/setup.pl
> [Sat Apr 16 11:47:09.376878 2016] [cgi:error] [pid 28451] [client 
> 127.0.0.1:42548] AH01215: 2 at LedgerSMB/Scripts/setup.pm line 710.: 
> /mnt/home/www/ledgersmb/setup.pl, referer: http://ledgersmb/setup.pl
> [Sat Apr 16 11:47:09.377143 2016] [cgi:error] [pid 28451] [client 
> 127.0.0.1:42548] AH01215: 3 at LedgerSMB/Scripts/setup.pm line 710.: 
> /mnt/home/www/ledgersmb/setup.pl, referer: http://ledgersmb/setup.pl
> [Sat Apr 16 11:47:09.379524 2016] [cgi:error] [pid 28451] [client 
> 127.0.0.1:42548] AH01215: DBD::Pg::db begin_work failed: Already in a 
> transaction at LedgerSMB/Scripts/setup.pm line 717.: 
> /mnt/home/www/ledgersmb/setup.pl, referer: http://ledgersmb/setup.pl
> [Sat Apr 16 11:47:09.388428 2016] [cgi:error] [pid 28451] [client 
> 127.0.0.1:42548] AH01215: LedgerSMB::Upgrade_Tests=HASH(0xa56fb68) at 
> LedgerSMB/Scripts/setup.pm line 654.: /mnt/home/www/ledgersmb/setup.pl, 
> referer: http://ledgersmb/setup.pl
> [Sat Apr 16 11:47:09.388448 2016] [cgi:error] [pid 28451] [client 
> 127.0.0.1:42548] AH01215: LedgerSMB::Upgrade_Tests=HASH(0xa56fb68) at 
> LedgerSMB/Scripts/setup.pm line 654.: /mnt/home/www/ledgersmb/setup.pl, 
> referer: http://ledgersmb/setup.pl
>



------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users