Support » Plugin: DB Toolkit » Timestamps – DB Toolkit 0.3.2.026

  • Resolved broganm

    (@broganm)


    Hi, I have a table with various fields describing businesses – name, address etc. Two of the fields are date fields. One I want to be the date the the entry was first entered. I’ve used Date & Time for this and it seems to work OK. The other field I want to be the date & time the entry was last modified. I’ve used Auto Timestamp for this but zeroes are written to the database (0000-00-00 00:00:00) where the date and time should be.

    Two questions:

    1. Does Auto Timestamp work? It looks to me like it doesn’t. If not doed anyone know of a fix.

    2. Is this the correct way to achieve what I need i.e. date & time entry last modified?

    http://wordpress.org/extend/plugins/db-toolkit/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Hi,

    I am also having problems after updating to 0.3.2.026
    In my form the date picker isnt working anymore.

    hope to see a fix soon.

    just found a fix on the internet.
    with thanks to John Morris
    check out this link
    http://jtmorris.net/2013/02/fix-for-db-toolkit-datepicker-not-working/

    Thread Starter broganm

    (@broganm)

    Thanks rhellem. That seems to have fixed the Auto Timestamp as well. However, all the date/timestamp field types seem to be one time write. In other words the date/timestamp is added when the record is first entered but not updated when the record is edited. Default to Today doesn’t seem to work either. It seems that the only way I can get a date/time updated when the record is edited is to use the date picker and select today’s date manually.

    Any one else come up against this problem or a fix?

    Thread Starter broganm

    (@broganm)

    Finally figured out Auto timestamp. You need to make sure the field type is set to TIMESTAMP in the database. This enables the field to auto increment.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Timestamps – DB Toolkit 0.3.2.026’ is closed to new replies.