AUTH-WEB - Empty business_type causing exception
- Dominant language
- JavaScript
- Stars
- 23
- Forks
- 62
- Avg merge
- 24m
- Merged PRs (30d)
- 1
Description
```
[SQL: UPDATE orgs SET modified=%(modified)s, business_type=%(business_type)s, business_size=%(business_size)s, modified_by_id=%(modified_by_id)s WHERE orgs.id = %(orgs_id)s]
[parameters: {'modified': datetime.datetime(2023, 3, 29, 19, 27, 17, 46787), 'business_type': '', 'business_size': '', 'modified_by_id': 26981, 'orgs_id': 8973}]
(Background on this error at: http://sqlalche.me/e/13/gkpj)
2023-03-29 19:27:35,058 - auth_api - ERROR in app:app.py:1891 - log_exception: Exception on /api/v1/orgs/8973 [PUT]
Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
self.dialect.do_execute(
File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.ForeignKeyViolation: insert or update on table "orgs" violates foreign key constraint "orgs_business_type_fkey"
DETAIL: Key (business_type)=() is not present in table "business_type_codes".
```
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.