Filament•2y ago•

13 replies

Unsupported Order By on Update and Delete Queries for Notification Database

I am using the SingleStore database drive and it does not support ORDER BY when using UPDATE or DELETE. It happens when the

Livewire/DatabaseNotifications

Livewire/DatabaseNotifications

functions call

getNotificationsQuery

getNotificationsQuery

, but when updating or deleting a notification the following error is returned:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by

created_at

created_at

desc' at line 1

DELETE FROM

DELETE FROM

notifications

notifications

WHERE

WHERE

notifications.notifiable_type = 'App\Models\USER'

notifications.notifiable_type = 'App\Models\USER'

AND notifications.notifiable_id = 1

AND notifications.notifiable_id = 1

AND notifications.notifiable_id IS NOT NULL

AND notifications.notifiable_id IS NOT NULL

AND JSON_EXTRACT_STRING(data, 'format') = 'filament'

AND JSON_EXTRACT_STRING(data, 'format') = 'filament'

AND id = 'e78e0963-1f8a-4bee-b6ac-c204151226c9'

AND id = 'e78e0963-1f8a-4bee-b6ac-c204151226c9'

ORDER BY

ORDER BY

created_at DESC

created_at DESC

Before creating a bug report or a pull request, I would like to check if there is a simple solution for it or would I have to add reorder() to the

removeNotification

removeNotification

markNotificationAsRead

markNotificationAsRead

markNotificationAsUnread

markNotificationAsUnread

and

clearNotifications

clearNotifications

and

markAllNotificationsAsRead

markAllNotificationsAsRead

functions of

Livewire/DatabaseNotifications

Livewire/DatabaseNotifications

and I would like to know if this is really valid, as it already would resolve this error for any other database that does not have this support.

Unsupported Order By on Update and Delete Queries for Notification Database

I am using the SingleStore database drive and it does not support ORDER BY when using UPDATE or DELETE. It happens when the

Livewire/DatabaseNotifications

Livewire/DatabaseNotifications

functions call

getNotificationsQuery

getNotificationsQuery

created_at

created_at

desc' at line 1

DELETE FROM

DELETE FROM

notifications

notifications

WHERE

WHERE

notifications.notifiable_type = 'App\Models\USER'

notifications.notifiable_type = 'App\Models\USER'

AND notifications.notifiable_id = 1

AND notifications.notifiable_id = 1

AND notifications.notifiable_id IS NOT NULL

AND notifications.notifiable_id IS NOT NULL

AND JSON_EXTRACT_STRING(data, 'format') = 'filament'

AND JSON_EXTRACT_STRING(data, 'format') = 'filament'

AND id = 'e78e0963-1f8a-4bee-b6ac-c204151226c9'

AND id = 'e78e0963-1f8a-4bee-b6ac-c204151226c9'

ORDER BY

ORDER BY

created_at DESC

created_at DESC

Before creating a bug report or a pull request, I would like to check if there is a simple solution for it or would I have to add reorder() to the

removeNotification

removeNotification

markNotificationAsRead

markNotificationAsRead

markNotificationAsUnread

markNotificationAsUnread

and

clearNotifications

clearNotifications

and

markAllNotificationsAsRead

markAllNotificationsAsRead

functions of

Livewire/DatabaseNotifications

Livewire/DatabaseNotifications

and I would like to know if this is really valid, as it already would resolve this error for any other database that does not have this support.

Unsupported Order By on Update and Delete Queries for Notification Database

Similar Threads

Unsupported Order By on Update and Delete Queries for Notification Database

Similar Threads

Similar Threads

Similar Threads