ProgrammingError at /payments/unreconciled/
relation "payments_unreconciledpayment" does not exist
LINE 1: SELECT COUNT(*) AS "__count" FROM "payments_unreconciledpaym...
                                          ^
Request Method:	GET
Request URL:	http://system.optinet.co.ke/payments/unreconciled/
Django Version:	5.0.2
Exception Type:	ProgrammingError
Exception Value:	
relation "payments_unreconciledpayment" does not exist
LINE 1: SELECT COUNT(*) AS "__count" FROM "payments_unreconciledpaym...
                                          ^
Exception Location:	/var/www/html/optinet_system/venv/lib/python3.10/site-packages/django/db/backends/utils.py, line 105, in _execute
Raised during:	payments.views.unreconciled_payments_list
Python Executable:	/var/www/html/optinet_system/venv/bin/python
Python Version:	3.10.12
Python Path:	
['/var/www/html/optinet_system',
 '/var/www/html/optinet_system',
 '/usr/lib/python310.zip',
 '/usr/lib/python3.10',
 '/usr/lib/python3.10/lib-dynload',
 '/var/www/html/optinet_system/venv/lib/python3.10/site-packages']
Server time:	Wed, 13 Aug 2025 00:14:36 +0300
Traceback Switch to copy-and-paste view
/var/www/html/optinet_system/venv/lib/python3.10/site-packages/django/db/backends/utils.py, line 105, in _execute
                return self.cursor.execute(sql, params) …
Local vars
The above exception (relation "payments_unreconciledpayment" does not exist LINE 1: SELECT COUNT(*) AS "__count" FROM "payments_unreconciledpaym... ^ ) was the direct cause of the following exception:
/var/www/html/optinet_system/venv/lib/python3.10/site-packages/django/core/handlers/exception.py, line 55, in inner
                response = get_response(request) …
Local vars
/var/www/html/optinet_system/venv/lib/python3.10/site-packages/django/core/handlers/base.py, line 197, in _get_response
                response = wrapped_callback(request, *callback_args, **callback_kwargs) …
Local vars
/var/www/html/optinet_system/venv/lib/python3.10/site-packages/django/contrib/auth/decorators.py, line 23, in _wrapper_view
                return view_func(request, *args, **kwargs) …
Local vars
/var/www/html/optinet_system/venv/lib/python3.10/site-packages/django/contrib/auth/decorators.py, line 23, in _wrapper_view
                return view_func(request, *args, **kwargs) …
Local vars
/var/www/html/optinet_system/payments/views.py, line 1137, in unreconciled_payments_list
    total_unreconciled = unreconciled_payments.filter(status='pending').count()