search

8848digital / erpnext

Free and Open Source Enterprise Resource Planning (ERP)
https://erpnext.com
GNU General Public License v3.0
0 stars 0 forks source link

Purchase Receipt Test Case: test_internal_pr_gl_entries #508

Open chintanshah8848 opened 6 days ago

chintanshah8848 commented 6 days ago

Information about bug

bench --site test run-tests --doctype "Purchase Receipt" --test test_internal_pr_gl_entries 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/chintan/postgres-testing/frappe-bench-postgres/apps/frappe/frappe/utils/bench_helper.py", line 114, in main() File "/home/chintan/postgres-testing/frappe-bench-postgres/apps/frappe/frappe/utils/bench_helper.py", line 20, in main click.Group(commands=commands)(prog_name="bench") File "/home/chintan/postgres-testing/frappe-bench-postgres/env/lib/python3.10/site-packages/click/core.py", line 1157, in call return self.main(args, kwargs) File "/home/chintan/postgres-testing/frappe-bench-postgres/env/lib/python3.10/site-packages/click/core.py", line 1078, in main rv = self.invoke(ctx) File "/home/chintan/postgres-testing/frappe-bench-postgres/env/lib/python3.10/site-packages/click/core.py", line 1688, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/chintan/postgres-testing/frappe-bench-postgres/env/lib/python3.10/site-packages/click/core.py", line 1688, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/chintan/postgres-testing/frappe-bench-postgres/env/lib/python3.10/site-packages/click/core.py", line 1434, in invoke return ctx.invoke(self.callback, ctx.params) File "/home/chintan/postgres-testing/frappe-bench-postgres/env/lib/python3.10/site-packages/click/core.py", line 783, in invoke return __callback(args, kwargs) File "/home/chintan/postgres-testing/frappe-bench-postgres/env/lib/python3.10/site-packages/click/decorators.py", line 33, in new_func return f(get_current_context(), *args, *kwargs) File "/home/chintan/postgres-testing/frappe-bench-postgres/apps/frappe/frappe/commands/init.py", line 29, in _func ret = f(frappe._dict(ctx.obj), args, kwargs) File "/home/chintan/postgres-testing/frappe-bench-postgres/apps/frappe/frappe/commands/utils.py", line 790, in run_tests ret = frappe.test_runner.main( File "/home/chintan/postgres-testing/frappe-bench-postgres/apps/frappe/frappe/test_runner.py", line 88, in main ret = run_tests_for_doctype( File "/home/chintan/postgres-testing/frappe-bench-postgres/apps/frappe/frappe/test_runner.py", line 214, in run_tests_for_doctype return _run_unittest( File "/home/chintan/postgres-testing/frappe-bench-postgres/apps/frappe/frappe/test_runner.py", line 283, in _run_unittest out = runner.run(test_suite) File "/usr/lib/python3.10/unittest/runner.py", line 184, in run test(result) File "/usr/lib/python3.10/unittest/suite.py", line 84, in call return self.run(*args, kwds) File "/usr/lib/python3.10/unittest/suite.py", line 122, in run test(result) File "/usr/lib/python3.10/unittest/case.py", line 650, in call return self.run(*args, *kwds) File "/usr/lib/python3.10/unittest/case.py", line 591, in run self._callTestMethod(testMethod) File "/usr/lib/python3.10/unittest/case.py", line 549, in _callTestMethod method() File "/home/chintan/postgres-testing/frappe-bench-postgres/apps/erpnext/erpnext/stock/doctype/purchase_receipt/test_purchase_receipt.py", line 1754, in test_internal_pr_gl_entries stock_diff = frappe.db.get_value( File "/home/chintan/postgres-testing/frappe-bench-postgres/apps/frappe/frappe/database/database.py", line 512, in get_value result = self.get_values( File "/home/chintan/postgres-testing/frappe-bench-postgres/apps/frappe/frappe/database/database.py", line 616, in get_values out = self._get_values_from_table( File "/home/chintan/postgres-testing/frappe-bench-postgres/apps/frappe/frappe/database/database.py", line 889, in _get_values_from_table return query.run(as_dict=as_dict, debug=debug, update=update, run=run, pluck=pluck) File "/home/chintan/postgres-testing/frappe-bench-postgres/apps/frappe/frappe/query_builder/utils.py", line 87, in execute_query result = frappe.db.sql(query, params, args, kwargs) # nosemgrep File "/home/chintan/postgres-testing/frappe-bench-postgres/apps/frappe/frappe/database/postgres/database.py", line 310, in sql return super().sql(modify_query(query), modify_values(values), *args, **kwargs) File "/home/chintan/postgres-testing/frappe-bench-postgres/apps/frappe/frappe/database/database.py", line 249, in sql traceback.print_stack() 'Error in query:\ncolumn "tabStock Ledger Entry.modified" must appear in the GROUP BY clause or be used in an aggregate function\nLINE 1: ...-PRE-2024-00055\' AND "is_cancelled"= \'0\' ORDER BY "modified"...\n ^\n' E

ERROR: test_internal_pr_gl_entries (erpnext.stock.doctype.purchase_receipt.test_purchase_receipt.TestPurchaseReceipt)

Traceback (most recent call last): File "/home/chintan/postgres-testing/frappe-bench-postgres/apps/erpnext/erpnext/stock/doctype/purchase_receipt/test_purchase_receipt.py", line 1754, in test_internal_pr_gl_entries stock_diff = frappe.db.get_value( File "/home/chintan/postgres-testing/frappe-bench-postgres/apps/frappe/frappe/database/database.py", line 512, in get_value result = self.get_values( File "/home/chintan/postgres-testing/frappe-bench-postgres/apps/frappe/frappe/database/database.py", line 616, in get_values out = self._get_values_from_table( File "/home/chintan/postgres-testing/frappe-bench-postgres/apps/frappe/frappe/database/database.py", line 889, in _get_values_from_table return query.run(as_dict=as_dict, debug=debug, update=update, run=run, pluck=pluck) File "/home/chintan/postgres-testing/frappe-bench-postgres/apps/frappe/frappe/query_builder/utils.py", line 87, in execute_query result = frappe.db.sql(query, params, *args, *kwargs) # nosemgrep File "/home/chintan/postgres-testing/frappe-bench-postgres/apps/frappe/frappe/database/postgres/database.py", line 310, in sql return super().sql(modify_query(query), modify_values(values), args, **kwargs) File "/home/chintan/postgres-testing/frappe-bench-postgres/apps/frappe/frappe/database/database.py", line 227, in sql self._cursor.execute(query, values) psycopg2.errors.GroupingError: column "tabStock Ledger Entry.modified" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...-PRE-2024-00055' AND "is_cancelled"= '0' ORDER BY "modified"... ^

Ran 1 test in 2.875s

FAILED (errors=1)

Module

other

Version

Frappe - v15 Erpnext - v15

Installation method

None

Relevant log output / Stack trace / Full Error Message.

No response

chintanshah8848 commented 2 days ago

https://github.com/8848digital/erpnext/pull/507/