When attempting to upload a document into one of my collections, I’m receiving a ValidationError from mongoengine. What’s happening as far as I can tell is that either mongoengine or PyMongo is attempting to store the entire first entry in my document as the ObjectId, and as such is throwing the error:
mongoengine.errors.ValidationError: "SON([('competition', 'Ligi Kuu Tanzania Bara'), ('year', '2023/24'), ('round', 1), ('date', '2023-08-08'), ('teams_id', [ObjectId('64d52c9f4cdabb9dfc3b4a59'), ObjectId('64d52c9f4cdabb9dfc3b4a5c')]), ('venue', 'Bukhungu Stadium'), ('match_url', 'https://www.youtube.com')])" is not a valid ObjectId, it must be a 12-byte input or a 24-character hex string
The teams_id key is a ListField of ReferenceFields to another document defined in mongoengine, and I have used this setup in another document with no issue. I will provide the full stack trace below and can provide any more information as requested, I’m not sure what is most helpful to provide at this stage. Full stack trace:
Traceback (most recent call last):
File "/Users/brycesczekan/PycharmProjects/ea-eye-api/venv/lib/python3.9/site-packages/mongoengine/base/fields.py", line 528, in to_mongo
return ObjectId(str(value))
File "/Users/brycesczekan/PycharmProjects/ea-eye-api/venv/lib/python3.9/site-packages/bson/objectid.py", line 102, in __init__
self.__validate(oid)
File "/Users/brycesczekan/PycharmProjects/ea-eye-api/venv/lib/python3.9/site-packages/bson/objectid.py", line 201, in __validate
_raise_invalid_id(oid)
File "/Users/brycesczekan/PycharmProjects/ea-eye-api/venv/lib/python3.9/site-packages/bson/objectid.py", line 34, in _raise_invalid_id
raise InvalidId(
bson.errors.InvalidId: "SON([('competition', 'Ligi Kuu Tanzania Bara'), ('year', '2023/24'), ('round', 1), ('date', '2023-08-08'), ('teams_id', [ObjectId('64d52c9f4cdabb9dfc3b4a59'), ObjectId('64d52c9f4cdabb9dfc3b4a5c')]), ('venue', 'Bukhungu Stadium'), ('match_url', 'https://www.youtube.com')])" is not a valid ObjectId, it must be a 12-byte input or a 24-character hex string
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/Users/brycesczekan/PycharmProjects/ea-eye-api/app.py", line 285, in upload_fixture_data
rounds_data.append(new_round.to_mongo())
File "/Users/brycesczekan/PycharmProjects/ea-eye-api/venv/lib/python3.9/site-packages/mongoengine/document.py", line 112, in to_mongo
data = super().to_mongo(*args, **kwargs)
File "/Users/brycesczekan/PycharmProjects/ea-eye-api/venv/lib/python3.9/site-packages/mongoengine/base/document.py", line 367, in to_mongo
value = field.to_mongo(value, **ex_vars)
File "/Users/brycesczekan/PycharmProjects/ea-eye-api/venv/lib/python3.9/site-packages/mongoengine/base/fields.py", line 434, in to_mongo
value_dict = {
File "/Users/brycesczekan/PycharmProjects/ea-eye-api/venv/lib/python3.9/site-packages/mongoengine/base/fields.py", line 435, in <dictcomp>
key: self.field._to_mongo_safe_call(item, use_db_field, fields)
File "/Users/brycesczekan/PycharmProjects/ea-eye-api/venv/lib/python3.9/site-packages/mongoengine/base/fields.py", line 191, in _to_mongo_safe_call
return self.to_mongo(value, **ex_vars)
File "/Users/brycesczekan/PycharmProjects/ea-eye-api/venv/lib/python3.9/site-packages/mongoengine/fields.py", line 1230, in to_mongo
id_ = id_field.to_mongo(id_)
File "/Users/brycesczekan/PycharmProjects/ea-eye-api/venv/lib/python3.9/site-packages/mongoengine/base/fields.py", line 530, in to_mongo
self.error(str(e))
File "/Users/brycesczekan/PycharmProjects/ea-eye-api/venv/lib/python3.9/site-packages/mongoengine/base/fields.py", line 171, in error
raise ValidationError(message, errors=errors, field_name=field_name)
mongoengine.errors.ValidationError: "SON([('competition', 'Ligi Kuu Tanzania Bara'), ('year', '2023/24'), ('round', 1), ('date', '2023-08-08'), ('teams_id', [ObjectId('64d52c9f4cdabb9dfc3b4a59'), ObjectId('64d52c9f4cdabb9dfc3b4a5c')]), ('venue', 'Bukhungu Stadium'), ('match_url', 'https://www.youtube.com')])" is not a valid ObjectId, it must be a 12-byte input or a 24-character hex string