fix(audit): allow nullable sponsor in SummitSponsorExtraQuestionType:…

…:getSponsor (#531)

* fix(audit): allow nullable sponsor in SummitSponsorExtraQuestionType::getSponsor

Signed-off-by: romanetar <[email protected]>

* fix: update getSponsor return allowing nulls

Signed-off-by: romanetar <[email protected]>

* chore(unit-tests): fix location venue generator

* chore(unit-test): add regresion test

---------

Signed-off-by: romanetar <[email protected]>
Co-authored-by: smarcet <[email protected]>

fix(sponsor-sync): use SELECT result to detect row existence in addSp…

…onsorPermission, not UPDATE affected-row count (#529)

Signed-off-by: romanetar <[email protected]>

fix(errors): exception processing at JSON endpoints

fix(external-services): argument error (#521)

implode(): Argument #2 ($array) must be of type ?array, string given

fix(external-services): argument error (#521)

implode(): Argument #2 ($array) must be of type ?array, string given

remove sprintf for prefixing scopes (#519)

* chore(scopes): remove sprintf for prefixing scopes
chore(ci): add swagger preview

* chore: PR review

remove sprintf for prefixing scopes (#519)

* chore(scopes): remove sprintf for prefixing scopes
chore(ci): add swagger preview

* chore: PR review

fix(sql): fix default created / last edited default values for m2m ta…

…bles

The junction table SummitEventType_SummitTicketType was created (via CreateTableTrait)
with Created and LastEdited columns that are NOT NULL but have no default value. When
Doctrine's ManyToManyPersister inserts into this table (e.g., when updating allowed_ticket_types
on an event type), it only inserts the FK columns (SummitEventTypeID, SummitTicketTypeID). MySQL
rejects the insert because Created has no value and no default.

fix(emails): improve cache reliability in attendee ticket email jobs

* Replace non-atomic Cache::has()+Cache::put() with Cache::add() for
  duplicate send prevention in both InviteAttendeeTicketEditionMail and
  SummitAttendeeTicketEmail, eliminating a race condition where two queue
  workers could both pass the check and send the same email.

* Replace Cache::forever() with a 1-hour TTL on the SummitAttendeeTicketEmail
  _sent key to prevent unbounded cache growth over time.

* Increase the message passthrough cache TTL from 5 minutes to 1 hour so
  user-written invitation messages survive queue backlog without being
  silently dropped.

fix(repository): SummitEventReposutory has a missing join on filtering