Ich habe anhand dieser Anleitung einen neuen Payment-State hinzugefügt:
clarification — „Klärung notwendig“
Aber immer wenn ich zu dem Status wechsle, kommt im Adminpanel eine Fehlermeldung:
An exception occurred while executing '# business-events::state_enter.order_transaction.state.clarification
::search-ids
SELECT `event_action`.`id` FROM `event_action` LEFT JOIN `event_action_rule` `event_action.rules.mapping` ON `event_action`.`id` = `event_action.rules.mapping`.`event_action_id` LEFT JOIN `event_action_sales_channel` `event_action.salesChannels.mapping` ON `event_action`.`id` = `event_action.salesChannels.mapping`.`event_action_id` LEFT JOIN `rule` `event_action.rules` ON `event_action.rules.mapping`.`rule_id` = `event_action.rules`.`id` LEFT JOIN `sales_channel` `event_action.salesChannels` ON `event_action.salesChannels.mapping`.`sales_channel_id` = `event_action.salesChannels`.`id` WHERE (`event_action`.`event_name` = ? AND `event_action`.`active` = ? AND (`event_action.rules`.`id` <=> ? OR `event_action.rules`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (`event_action.salesChannels`.`id` = ? OR `event_action.salesChannels`.`id` <=> ?)) GROUP BY `event_action`.`id`' with params ["state_enter.order_transaction.state.clarification\r\n", true, null, "\x0c\x00\x80\x67\x99\x77\x46\x35\xba\x23\xf7\x50\xfd\x54\x85\xfe", "\x15\x39\x7a\x39\x7d\x5d\x45\xf9\x97\xc7\x38\xdf\xed\xb2\x8a\xd8", "\x56\x44\xd0\xfb\x2a\x27\x4b\xa4\xab\x93\xd7\xcc\x15\x80\xd2\x97", "\x9f\xb9\xc3\xfe\xd7\x62\x47\x02\xba\x2a\x90\x43\x0d\x0f\xa8\xaa", "\xc0\x55\x65\xe9\xa4\xdf\x4b\x7e\xa1\x4b\xa6\x2d\x1b\x69\x95\x79", "\x96\xf2\xbf\x3e\xb0\x8a\x48\xcc\xb2\xa7\xb0\xae\x73\x5e\x2b\x45", "\x88\xb8\xb1\x25\xbc\x6d\x4f\x92\xa4\xb7\x56\xfc\xd4\xc9\xeb\x20", "\x8c\xa3\x31\xa5\xd6\x7f\x40\xcf\x8d\x7a\xed\x84\x60\x91\x25\xfa", "\xec\x8a\x12\x16\xa2\xf0\x4e\xb4\xb9\x87\xe7\xaa\x2f\xb2\x0d\xe1", "\x1b\xe8\x74\x4d\x1d\xa6\x49\x2c\x8d\xc6\x5d\xd9\x3e\x2d\x16\xe2", null]:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '::search-ids
SELECT `event_action`.`id` FROM `event_action` LEFT JOIN `event_...' at line 2
Das Wechseln des Status und das versenden der Mail funktioniert aber.
Kenn jemand das Problem vielleicht? Scheint so als ob da irgendwo noch was fehlt…