QueryException in Connection.php line 647:SQLSTATE[HY000]: General error: 2053

I am new to all of this and have been asked to debug a new problem with an application that has not been modified since December 2017. After poking around a bit I realized the Laravel software was several releases behind and I upgraded PHP and Laravel to the current releases. The problem remains the same.

at Connection->runQueryCallback('Call DeleteContestStations(:ContestId);', array('ContestId' => '88'), object(Closure)) in Connection.php line 607

at Connection->run('Call DeleteContestStations(:ContestId);', array('ContestId' => '88'), object(Closure)) in Connection.php line 326

The previous developer is unavailable for medical reasons and I am hoping this is something approachable to someone who has watched the first ten introductory Laravel videos and knows little about this level of code so far.

I am not able to read the referenced stored procedure as it is denying access to the root account on the hosting service. Security on the SP is set to DEFINER and the definer is the person who is unavailable.

Thank you in advance for your help.

I selected Laravel as the channel because Redis is not one of the choices, and both Laravel and Redis are in the path to the Connection.php file.

munazzil

7 years ago

Level 13

Use like this instead of DB::select();

    DB::update();

Please or to participate in this conversation.