Array to String Conversion in Listener trying to send Notification

@martin.fdm Well the strange thing is that is actually a query exception. The error comes when it tries to display the actual error. If you have xdebug, then try setting a breakpoint here. If not add a dd($e->getMessage()); temporarily

https://flareapp.io/share/17DyjWZ5#F80

@Sinnbeck Thanks for the reply. I added the dd($e->getMessage()); in the try catch. It just returns "Array to string conversion". Added Xdebug and some breakpoints but, first time using it, I couldn't get it work properly I guess.

@martin.fdm Where did you add it?

It should look like

catch (Exception $e) {
         dd($e->getMessage());
            throw new QueryException(

                $query, $this->prepareBindings($bindings), $e

            );

        }

@Sinnbeck I'm trying both on the service method which calls the event where I have all this situation and in the listener where $users = User::role('supervisor')->get() happens.. Anyhow, $query, $this->prepareBindings($bindings), is marked as undefined. Variables and method.

Edit : If I left it that way and send a request again, keep on displaying the Array to String Conversion Exception.

@martin.fdm Sorry what? Are you adding this inside your own files? My suggestion was to edit this file, just for testing

vendor/laravel/framework/src/Illuminate/Database/Connection.php line 704

@Sinnbeck Oh! Okey, sorry! It returns "Array to String Conversion" only.

@martin.fdm you shouldnt get error page, but rather a dd result page.. I dont assume that it is dd result you are getting?

@Sinnbeck yes. It's a dd message containing that string only

@martin.fdm I assume it is sort of a recursive error then. Try adding some debug data to here

foreach ($segments as $segment) {
           if (!is_string($segment)) {
                     dd($segment);
          }
            $result .= (array_shift($replace) ?? $search).$segment;

        }

https://flareapp.io/share/17DyjWZ5#F84L596

@Sinnbeck with that if statement it goes straight to Array to String Conversion Exception. Removing the ! returns this: ", " Hey, thanks again for your time! Really

@martin.fdm So its solved?

@Sinnbeck No, I just wanted to say thanks for continuing to respond

@Sinnbeck I should have added also that this seemed to be query which returns nothing.

select * from `users` where exists (select * from `roles` inner join `model_has_roles` on `roles`.`id` = `model_has_roles`.`role_id` where `users`.`id` = `model_has_roles`.`model_id` and `model_has_roles`.`model_type` = 'App\Models\User' and `roles`.`id` in (2))

It's the equivalent query to $users = User::role('supervisor')->get()

@martin.fdm can you post the class NuevoFormularioExpedienteNotification ?

@martin.fdm Why do you need to access a specific notification? You have not mentioned this in your question or previous replies.

@Snapey Just for the classic notification dropdown element (in my app, showing only unread notifications) where there's a message referencing issue of notification and a little button to redirect to pertinent page.

For that I've implement a handler which needs some way to get the specific notification in question.

Anyway! I've solved that requirement passing the whole notification instead of id for then searching it inside the handler! Hahah, my bad!

@snapey mmmhm. I sang victory before time.

But I'll need to add a little bit more context .

In that dropdown element I've mentioned, I can use a foreach to handle notifications individually. lets say

foreach ($notifications as $notif)

But as there's no Notification model, when i pass $notif to handler, I'm only getting the notif id.

$notif is DatabaseNotification type

What should I do?

@martin.fdm How are you getting notifications? Not from a model that has the Notifiable trait?

eg $user->notifications()

https://laravel.com/docs/8.x/notifications#accessing-the-notifications