Problem when updating to last v14 version

pagliaso · October 31, 2022, 9:57am

Hello,

I have been stucked with this for a couple of weeks now.

I recently moved from Ubuntu v20 and ERPNext V13 to Ubuntu v22 and ERPNext v14.

It was going everything very well, but when I updated to the last version:

**ERPNext:** v14.4.0 (version-14)
**Frappe Framework:** v14.13.0 (version-14)
**WooCommerce Connector:** v1.7.0 (master)

I have a problem that I stop being able to browse my invoices.

I can see the list of invoices, but if I try to open one of them, nothing happens. The browser displays the link to that particular invoice on the url bar, but the view stays on the list of invoices. This happens with all of them.

I can’t see any error meaningful on the console, nor on Error Doctype inside ERPNext.

I see on worker error log, connection errors to Redis, and errors of Cryptography, but everything else seems to be fine. As:

Traceback (most recent call last):
  File "/usr/lib/python3.10/runpy.py", line 196, in _run_module_as_main
    return _run_code(code, main_globals, None,
  File "/usr/lib/python3.10/runpy.py", line 86, in _run_code
    exec(code, run_globals)
  File "/home/erp/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 109, in <module>
    main()
  File "/home/erp/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 18, in main
    click.Group(commands=commands)(prog_name="bench")
  File "/home/erp/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 829, in __call__
    return self.main(*args, **kwargs)
  File "/home/erp/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 782, in main
    rv = self.invoke(ctx)
  File "/home/erp/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 1259, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/home/erp/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 1259, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/home/erp/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 1066, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/home/erp/frappe-bench/env/lib/python3.10/site-packages/click/core.py", line 610, in invoke
    return callback(*args, **kwargs)
  File "/home/erp/frappe-bench/apps/frappe/frappe/commands/scheduler.py", line 189, in start_worker
    start_worker(queue, quiet=quiet, rq_username=rq_username, rq_password=rq_password)
  File "/home/erp/frappe-bench/apps/frappe/frappe/utils/background_jobs.py", line 218, in start_worker
    Worker(queues, name=get_worker_name(queue_name)).work(logging_level=logging_level)
  File "/home/erp/frappe-bench/env/lib/python3.10/site-packages/rq/worker.py", line 637, in work
    self.register_death()
  File "/home/erp/frappe-bench/env/lib/python3.10/site-packages/rq/worker.py", line 337, in register_death
    p.execute()
  File "/home/erp/frappe-bench/env/lib/python3.10/site-packages/redis/client.py", line 4012, in execute
    conn = self.connection_pool.get_connection('MULTI',
  File "/home/erp/frappe-bench/env/lib/python3.10/site-packages/redis/connection.py", line 1192, in get_connection
    connection.connect()
  File "/home/erp/frappe-bench/env/lib/python3.10/site-packages/redis/connection.py", line 563, in connect
    raise ConnectionError(self._error_message(e))
redis.exceptions.ConnectionError: Error 111 connecting to localhost:11000. Connection refused.
ERROR	PropertyValue: Missing token for production Choice(ColorValue, Dimension, URIValue, Value, variable, MSValue, CSSCalc, function): ('HASH', '#0000001a', 1, 3198)
ERROR	PropertyValue: Unknown syntax or no value: 0 3px 6px #0000001a
ERROR	CSSStyleDeclaration: Syntax Error in Property: box-shadow:0 3px 6px #0000001a

On web log error logs there are warnings and errors as:

serWarning: The 'filters_config' hook used to add custom operators is not yet implemented in frappe.db.query engine. Use db_query (frappe.get_list) instead.
and
TypeError: Object of type <class 're.Match'> with value of <re.Match object; span=(8, 12), match='1978'> is not JSON serializable

If I go back to backup before last update, everything goes back to normal.

I forgot to tell that the route to each invoice is like this:

https://erp1.domain.com/app/sales-invoice/2022/082

The code of each invoice is like this 2022/###. Could this be something related to routes?

Many thanks for your help and kind regards from Spain,

nomi-gee · October 31, 2022, 9:59am

try bench migrate --skip-failing

pagliaso · October 31, 2022, 10:06am

Hi @nomi-gee ,

Many thanks for your prompt reply.

Did as you suggested: bench --site erp.domain.com migrate --skip-failing

That produces no error, finishes well, but the problem is still there afterwards.

Many thanks and kind regards,

nomi-gee · October 31, 2022, 10:08am

yes … which branch you are using develop or version-14

pagliaso · October 31, 2022, 10:20am

Thanks.

I would say that I am in production version-14.

**ERPNext:** v14.4.0 (version-14)
**Frappe Framework:** v14.13.0 (version-14)
**WooCommerce Connector:** v1.7.0 (master)

This is what I see in About.

Thanks and kind regards,

Alb

nomi-gee · October 31, 2022, 10:23am

Can you login to server and share output

sudo systemctl status redis-server.service

and

sudo lsof -i :11000

pagliaso · October 31, 2022, 11:01am

Thanks @nomi-gee.

Here are the outputs:

redis-server.service - Advanced key-value store
     Loaded: loaded (/lib/systemd/system/redis-server.service; enabled; vendor >
     Active: active (running) since Sun 2022-10-30 20:15:21 UTC; 14h ago
       Docs: http://redis.io/documentation,
             man:redis-server(1)
   Main PID: 622 (redis-server)
     Status: "Ready to accept connections"
      Tasks: 5 (limit: 9257)
     Memory: 6.5M
        CPU: 1min 42.427s
     CGroup: /system.slice/redis-server.service
             └─622 "/usr/bin/redis-server 127.0.0.1:6379" "" "" "" "" "" "" "" >

Oct 30 20:15:21 ubuntu-4gb-fsn1-1 systemd[1]: Starting Advanced key-value store>
Oct 30 20:15:21 ubuntu-4gb-fsn1-1 systemd[1]: Started Advanced key-value store.

And:


COMMAND   PID        USER   FD   TYPE DEVICE SIZE/OFF NODE NAME
redis-ser 835 erp    6u  IPv4  19002      0t0  TCP localhost:11000 (LISTEN)
redis-ser 835 erp    7u  IPv4  19561      0t0  TCP localhost:11000->localhost:47626 (ESTABLISHED)
redis-ser 835 erp    8u  IPv4  19563      0t0  TCP localhost:11000->localhost:47638 (ESTABLISHED)
redis-ser 835 erp    9u  IPv4  19565      0t0  TCP localhost:11000->localhost:47652 (ESTABLISHED)
redis-ser 835 erp   10u  IPv4  19133      0t0  TCP localhost:11000->localhost:47658 (ESTABLISHED)
redis-ser 835 erp   11u  IPv4  19135      0t0  TCP localhost:11000->localhost:47670 (ESTABLISHED)
redis-ser 835 erp   12u  IPv4  19137      0t0  TCP localhost:11000->localhost:47674 (ESTABLISHED)
redis-ser 835 erp   13u  IPv4 259653      0t0  TCP localhost:11000->localhost:36002 (ESTABLISHED)
redis-ser 835 erp   14u  IPv4 259655      0t0  TCP localhost:11000->localhost:36012 (ESTABLISHED)
redis-ser 835 erp   15u  IPv4 259657      0t0  TCP localhost:11000->localhost:36016 (ESTABLISHED)
python    839 erp    5u  IPv4 258809      0t0  TCP localhost:36002->localhost:11000 (ESTABLISHED)
python    839 erp    6u  IPv4 258814      0t0  TCP localhost:36012->localhost:11000 (ESTABLISHED)
python    839 erp    7u  IPv4 258819      0t0  TCP localhost:36016->localhost:11000 (ESTABLISHED)
python    840 erp    3u  IPv4  19560      0t0  TCP localhost:47626->localhost:11000 (ESTABLISHED)
python    840 erp    4u  IPv4  19571      0t0  TCP localhost:47658->localhost:11000 (ESTABLISHED)
python    849 erp    3u  IPv4  19578      0t0  TCP localhost:47670->localhost:11000 (ESTABLISHED)
python    849 erp    4u  IPv4  19583      0t0  TCP localhost:47674->localhost:11000 (ESTABLISHED)
python    850 erp    3u  IPv4  19127      0t0  TCP localhost:47638->localhost:11000 (ESTABLISHED)
python    850 erp    4u  IPv4  19132      0t0  TCP localhost:47652->localhost:11000 (ESTABLISHED)

Thanks and kind regards,

Alb

nomi-gee · October 31, 2022, 11:10am

All is working fine for you. this might be the issue you are facing. Frappe team will fix it soon I think

github.com/frappe/erpnext

v14.4.0 - Links not opening if Naming Series have SLASH '/'

opened 07:18AM - 31 Oct 22 UTC

closed 03:42PM - 04 Nov 22 UTC

akashdubey22

bug

### Information about bug After updating to v 14.4.0, Links not opening if Nami…ng Series have SLASH '/' LIKE ... ....../app/sales-invoice/22-23/IND/331 before update it was working well & now to access these old records I have to manually type %2F in place of / in naming series. ### Module accounts ### Version Frappe - 14.13.0 ErpNext - 14.4.0 ### Installation method easy-install ### Relevant log output / Stack trace / Full Error Message. _No response_

pagliaso · October 31, 2022, 12:06pm

Hi @nomi-gee,

Many thanks for all your help!!

I had the suspicion that this had to do with the naming series.

I will revert to my backup and wait for a fix.

Many thanks and kind regards from Spain,

Alb

Barath_Prathosh · October 30, 2023, 9:36am

@pagliaso @ankush

Am also facing same issue when updating latest v-14 patches.

issue occur because of frappe.sendmail method.

Solution:

we need to changing the below follow code, it’s work for me.

file location: /sites/assets/frappe/dist/css/email.bundle.FSBE33YW.css

box-shadow:0 3px 6px #0000001a;
change to
box-shadow:0 3px 6px rgba(0, 0, 0, 0.1);