Question: Cannot Delete User

Cannot Delete User

whenever i tried to delete user i get error 500 Server error Sorry, server encountered an error, please try again later. SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-p...

A

aimknight

Asked
whenever i tried to delete user i get error 500

Server error
Sorry, server encountered an error, please try again later.

SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared (Connection: mysql, SQL: delete from `users` where `id` = 5)

Go back home
  • MS

    Mian Saleem

    Answered
    Hello,

    Please check the latest log file in the `storage/logs/` folder and share the error details so that I can suggest.

    Thank you
  • A

    aimknight

    Answered
    [2025-10-15 09:21:56] production.ERROR: Call to a member function addMinutes() on null {"userId":1,"exception":"[object] (Error(code: 0): Call to a member function addMinutes() on null at /home2/ilpstrat/public_html/forum.ilpstrategy.org.ng/app/Rules/ThrottleThread.php:26)
    [stacktrace]
    #0 /home2/ilpstrat/public_html/forum.ilpstrategy.org.ng/vendor/laravel/framework/src/Illuminate/Validation/InvokableValidationRule.php(102): App\\Rules\\ThrottleThread->validate()
    #1 /home2/ilpstrat/public_html/forum.ilpstrategy.org.ng/vendor/laravel/framework/src/Illuminate/Validation/Validator.php(902): Illuminate\\Validation\\InvokableValidationRule->passes()
    #2 /home2/ilpstrat/public_html/forum.ilpstrategy.org.ng/vendor/laravel/framework/src/Illuminate/Validation/Validator.php(678): Illuminate\\Validation\\Validator->validateUsingCustomRule()
    #3 /home2/ilpstrat/public_html/forum.ilpstrategy.org.ng/vendor/laravel/framework/src/Illuminate/Validation/Validator.php(481): Illuminate\\Validation\\Validator->validateAttribute()
    #4 /home2/ilpstrat/public_html/forum.ilpstrategy.org.ng/vendor/laravel/framework/src/Illuminate/Validation/Validator.php(516): Illuminate\\Validation\\Validator->passes()
    #5 /home2/ilpstrat/public_html/forum.ilpstrategy.org.ng/vendor/laravel/framework/src/Illuminate/Validation/Validator.php(558): Illuminate\\Validation\\Validator->fails()
    #6 /home2/ilpstrat/public_html/forum.ilpstrategy.org.ng/vendor/livewire/livewire/src/Features/SupportValidation/HandlesValidation.php(266): Illuminate\\Validation\\Validator->validate()
    #7 /home2/ilpstrat/public_html/forum.ilpstrategy.org.ng/vendor/livewire/livewire/src/Features/SupportFormObjects/Form.php(33): Livewire\\Features\\SupportFormObjects\\Form->parentValidate()
    #8 /home2/ilpstrat/public_html/forum.ilpstrategy.org.ng/app/Livewire/Forms/ThreadForm.php(113): Livewire\\Features\\SupportFormObjects\\Form->validate()
  • MS

    Mian Saleem

    Answered
    Hello, are you still having issue after making changes to file as suggested in your other question?
  • A

    aimknight

    Answered
    still having same issue

    Sorry, server encountered an error, please try again later.

    SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared (Connection: mysql, SQL: delete from `users` where `id` = 6)

    error log

    [2025-10-17 07:41:49] production.ERROR: SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared (Connection: mysql, SQL: delete from `users` where `id` = 6) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: HY000): SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared (Connection: mysql, SQL: delete from `users` where `id` = 6) at /home2/ilpstrat/public_html/forum.ilpstrategy.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connection.php:825)
    [stacktrace]
    #0 /home2/ilpstrat/public_html/forum.ilpstrategy.org.ng/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\\Database\\Connection->runQueryCallback()
  • MS

    Mian Saleem

    Answered
    Hello,

    The error is related to MySQL server. Can you please test this again.

    Thank you
  • A

    aimknight

    Answered
    still the same error

    Server error
    Sorry, server encountered an error, please try again later.

    SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared (Connection: mysql, SQL: delete from `users` where `id` = 8)
  • A

    aimknight

    Answered
    im still having this issue
  • MS

    Mian Saleem

    Answered
    Hello,

    Please let me know the installation url with admin login details in private reply.

    Thank you
  • MS

    Mian Saleem

    Answered
    Hello,

    It was due to your database sever. I am not sure either `table_definition_cache` or something else. I have set the `PDO::ATTR_EMULATE_PREPARES` to true and disabled the strict mode. Now it's deleting the user. Please check.

    If you need further information, you can check with your server admin.

    Thank you
  • Login to Reply