calculator.py error: `File "<unknown>", line 0` with MariaDB and FreshRSS #3883

unclemusclez · 2024-10-04T12:39:49Z

unclemusclez
Oct 4, 2024

My settings.xml

    query_str:
      'SELECT `freshrss_unclemusclez_entry`.`title`, `freshrss_unclemusclez_entry`.`author`, `freshrss_unclemusclez_entry`.`content_bin`, `freshrss_unclemusclez_entry`.`date`, `freshrss_unclemusclez_entry`.`link`
      FROM `freshrss_unclemusclez_entry`
      WHERE `freshrss_unclemusclez_entry`.`title` LIKE %(query)s
      OR `freshrss_unclemusclez_entry`.`author` LIKE %(query)s
      OR CONVERT(CAST(`freshrss_unclemusclez_entry`.`content_bin` AS BINARY) USING utf8) LIKE %(query)s
      OR FROM_UNIXTIME(`freshrss_unclemusclez_entry`.`date`) LIKE %(query)s'

if i search with a query it will not work, but if i just use the !rss option with a blank query, the database does populate.

2024-10-04 12:29:59,815 WARNING:searx.engines.rss: ErrorContext('searx/engines/mariadb_server.py', 88, 'cur.execute(query_to_run, query_params)', 'mariadb.InterfaceError', None, ()) False
2024-10-04 12:29:59,816 ERROR:searx.engines.rss: engine rss : exception : Server has gone away
Traceback (most recent call last):
  File "/usr/local/searxng/src/searx/search/processors/offline.py", line 19, in search
    search_results = self._search_basic(query, params)
                     ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/searxng/src/searx/search/processors/offline.py", line 15, in _search_basic
    return self.engine.search(query, params)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/searxng/src/searx/engines/mariadb_server.py", line 88, in search
    cur.execute(query_to_run, query_params)
  File "/usr/local/searxng/.venv/lib/python3.12/site-packages/mariadb/cursors.py", line 310, in execute
    self._execute_text(self._transformed_statement)
mariadb.InterfaceError: Server has gone away
2024-10-04 12:30:03,085 WARNING:searx.engines.rss: ErrorContext('searx/engines/mariadb_server.py', 88, 'cur.execute(query_to_run, query_params)', 'mariadb.InterfaceError', None, ()) False
2024-10-04 12:30:03,086 ERROR:searx.engines.rss: engine rss : exception : Server has gone away
Traceback (most recent call last):
  File "/usr/local/searxng/src/searx/search/processors/offline.py", line 19, in search
    search_results = self._search_basic(query, params)
                     ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/searxng/src/searx/search/processors/offline.py", line 15, in _search_basic
    return self.engine.search(query, params)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/searxng/src/searx/engines/mariadb_server.py", line 88, in search
    cur.execute(query_to_run, query_params)
  File "/usr/local/searxng/.venv/lib/python3.12/site-packages/mariadb/cursors.py", line 310, in execute
    self._execute_text(self._transformed_statement)
mariadb.InterfaceError: Server has gone away
2024-10-04 12:30:09,907 WARNING:searx.engines.rss: ErrorContext('searx/engines/mariadb_server.py', 88, 'cur.execute(query_to_run, query_params)', 'mariadb.InterfaceError', None, ()) False
2024-10-04 12:30:09,907 ERROR:searx.engines.rss: engine rss : exception : Server has gone away
Traceback (most recent call last):
  File "/usr/local/searxng/src/searx/search/processors/offline.py", line 19, in search
    search_results = self._search_basic(query, params)
                     ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/searxng/src/searx/search/processors/offline.py", line 15, in _search_basic
    return self.engine.search(query, params)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/searxng/src/searx/engines/mariadb_server.py", line 88, in search
    cur.execute(query_to_run, query_params)
  File "/usr/local/searxng/.venv/lib/python3.12/site-packages/mariadb/cursors.py", line 310, in execute
    self._execute_text(self._transformed_statement)
mariadb.InterfaceError: Server has gone away
Process Process-2:
Traceback (most recent call last):
  File "/usr/lib/python3.12/multiprocessing/process.py", line 314, in _bootstrap
    self.run()
  File "/usr/lib/python3.12/multiprocessing/process.py", line 108, in run
    self._target(*self._args, **self._kwargs)
  File "/usr/local/searxng/src/searx/plugins/calculator.py", line 62, in handler
    q.put(func(*args, **kwargs))
          ^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/searxng/src/searx/plugins/calculator.py", line 42, in _eval_expr
    return _eval(ast.parse(expr, mode='eval').body)
                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3.12/ast.py", line 52, in parse
    return compile(source, filename, mode, flags,
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "<unknown>", line 0

SyntaxError: invalid syntax

i am also curious about getting the mediumblob binary to display correctly, along the datetime from unix epoch. Perhaps tags and images can be pulled as well. It seems freshrss might be able to serve as engine in itself. I'm just not that familiar with mysql, nor searxng so i'm just poking around for now looking for help/feedback.

thanks again for the MariaDB update. this rocks.

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

calculator.py error: `File "<unknown>", line 0` with MariaDB and FreshRSS #3883

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{editor}}'s edit

{{editor}}'s edit

Uh oh!

Replies: 0 comments

Select a reply

Uh oh!

calculator.py error: File "<unknown>", line 0 with MariaDB and FreshRSS #3883

Uh oh!

Uh oh!

unclemusclez Oct 4, 2024

Replies: 0 comments

calculator.py error: `File "<unknown>", line 0` with MariaDB and FreshRSS #3883

unclemusclez
Oct 4, 2024