Welcome Guest, Not a member yet? Register   Sign In
CodeIgniter Forums CodeIgniter 4 CodeIgniter 4 Support ->onlyDeleted() returns all
->onlyDeleted() returns all
  • Offline includebeer
    CodeIgniter Team
  • Posts: 1,018
    Threads: 18
    Joined: Oct 2014
    Reputation: 40
#4
03-27-2020, 02:25 PM
(This post was last modified: 03-27-2020, 02:27 PM by includebeer.)

(03-25-2020, 03:58 AM)niklas Wrote:
(03-22-2020, 08:08 AM)includebeer Wrote: Can you confirm there are rows with the deleted_at field with a NULL value?  Maybe your previous delete() really deleted all the rows.

Yes i can confirm that the "deleted_at" rows have values so they are soft deleted and other rows have null. Both are returned by ->onlyDeleted().

Maybe there is a problem with mySql field settings. If the datetime field is null there is a "0000-00-00 00:00" in it. I don't know how CodeIgniter checks that field.

If there is a value of “0000-00-00 00:00”, then it is not NULL.
Is the deleted_at column nullable in your MySQL table? Maybe it have a default value of “0000-00-00 00:00”?
Reply


Messages In This Thread
->onlyDeleted() returns all - by niklas - 03-18-2020, 09:09 AM
RE: ->onlyDeleted() returns all - by includebeer - 03-22-2020, 08:08 AM
RE: ->onlyDeleted() returns all - by niklas - 03-25-2020, 03:58 AM
RE: ->onlyDeleted() returns all - by includebeer - 03-27-2020, 02:25 PM
RE: ->onlyDeleted() returns all - by niklas - 03-30-2020, 05:58 AM
RE: ->onlyDeleted() returns all - by includebeer - 03-30-2020, 01:35 PM



Theme © iAndrew 2016 - Forum software by © MyBB