show 0000-00-00 00:00:00 in wp_sbb_visitorslog DB

  • Resolved dle001

    (@dle001)


    2 years, 11 months ago

    Hi

    I faced the problem about date in DB.

    In wp_sbb_visitorslog table, it show date 0000-00-00 00:00:00 every users.

    Could you fix it ?
    Thank you

    ss.

    View post on imgur.com

    my hosting spec
    – cPanel – 11.100.0.12
    – LiteSpeed – 7.9
    – PHP – 7.3.33
    – MySQL – 7.4.27
    – phpMyAdmin – 4.9.7

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Bill Minozzi

    (@sminozzi)

    Hi,

    Try to upgrade your PHP to 7.4 and disable Litespeed.

    If doesn’t work, try to copy the content of this screen:

    Dashboard => Stop Bad Bots => Dashboard => Debug Info

    to our support Page:
    https://BillMInozzi.com/support

    Take a look at our troubleshooting page:
    https://siterightaway.net/troubleshooting/

    Cheers,
    Bill

    Thread Starter dle001

    (@dle001)

    Thank you

    Plugin Author Bill Minozzi

    (@sminozzi)

    Hi,

    This should be the structure of that table (sbb_visitorslog):

    id mediumint(9) NOT NULL,
    ip varchar(30) NOT NULL,
    date timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    cookie varchar(1) NOT NULL,
    response varchar(5) NOT NULL,
    bot varchar(1) NOT NULL

    On the field named date, (number 3):

    type should be timestamp

    default should be current_timestamp

    extra, should be ON UPDATE CURRENT_TIMESTAMP()

    Then, each time this table is updated or added a new row, mysql will add the current time there. Otherwise, your mysql has an error.

    Please, use PHP MYADMIN to inspect that table structure. (Talk with your hosting if necessary) Then, let me know.

    Cheers,

    Bill

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘show 0000-00-00 00:00:00 in wp_sbb_visitorslog DB’ is closed to new replies.