[BUG] Project Created without Specifying Funding Source

[dan-tang-ssd]

A sentry error email alert received on 2024-11-22 10:07 PM.

It is about a missing value for column funding_sources.source when creating a new project (id 1584).

---

Sentry error:

https://stats4sd-53.sentry.io/issues/6083676067/?referrer=alert_email&alert_type=email&alert_timestamp=1732313237018&alert_rule_id=15326462&notification_uuid=c921904c-a2c1-4c71-968d-6fdcea375939&environment=production

[dave-mills]

@dan-tang-ssd - I'm confused - your issue summary doesn't seem to match the issue you linked to. I don't see anything about funding_sources.source being missing.

The linked error says:

SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'name' at row 1 (Connection: mysql, SQL: insert into projects...

[dan-tang-ssd]

@dan-tang-ssd - I'm confused - your issue summary doesn't seem to match the issue you linked to. I don't see anything about funding_sources.source being missing.

The linked error says:

SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'name' at row 1 (Connection: mysql, SQL: insert into projects...

Yes.... The actual details can only be viewed in the Sentry alert email now.

I copied the link from the alert email and paste it in browser, it shows the irrelevant error you mentioned... (not sure how does Sentry handle these error links....)

I considered to add a screen shot or attach the email here. I decided not to do that because this may expose project details to public...

For actual details, you may refer to the sentry error email alert received on 2024-11-22 10:07 PM.

[dave-mills]

Ahh, gotcha. It's actually both errors at different times, but Sentry grouped them together, I guess because they're both Illuminate\Database\QueryException errors. The Sentry link was directing to the most recent one, which is the "data too long for column 'name'" error:

[dave-mills]

(Not super helpful from Sentry, as is actually 2 separate bugs!)