Errors and other issues to solve

  • RonaldS

    (@norus)


    7 years ago

    Here a short dump of debug.log after installing and fisrt setup of your plugin.
    I use PHP7.2.2, WP latest.
    Also get on front-end the message: Settings changes are needed for the time sheet application. Please verify settings. But what is to be set is unclear. Message stays at top in front-end.
    Hope you can fix those issues soon.

    [21-Mar-2018 15:24:26 UTC] PHP Notice: Undefined index: page in /home/deb96951n2/domains/webdomain.nl/public_html/devsite/wp-content/plugins/time-sheets/time-sheets.php on line 397
    [21-Mar-2018 15:24:26 UTC] WordPress database error Specified key was too long; max key length is 3072 bytes for query
    SELECT
    s.id,
    st.status,
    s.domain_name_context_md5 AS ctx ,
    st.value AS translated,
    st.mo_string AS mo_string,
    s.value AS original,
    s.gettext_context
    FROM wp_icl_strings s
    LEFT JOIN wp_icl_string_translations st
    ON s.id=st.string_id
    AND st.language=’en’
    AND s.language!=’en’
    WHERE s.context = ‘default’
    LIMIT 1000 OFFSET 5000 made by activate_plugin, do_action(‘activate_time-sheets/time-sheets.php’), WP_Hook->do_action, WP_Hook->apply_filters, time_sheets_main->activation, time_sheets_setup->create_db_objects, time_sheets_setup->create_tables
    [21-Mar-2018 15:24:27 UTC] PHP Notice: Undefined index: page in /home/deb96951n2/domains/webdomain.nl/public_html/devsite/wp-content/plugins/time-sheets/time-sheets.php on line 397
    [21-Mar-2018 15:24:27 UTC] PHP Notice: Undefined index: day_of_week_timesheet_reminders in /home/deb96951n2/domains/webdomain.nl/public_html/devsite/wp-content/plugins/time-sheets/time-sheets.php on line 406
    [21-Mar-2018 15:24:27 UTC] PHP Notice: Undefined index: show_header_open_invoices in /home/deb96951n2/domains/webdomain.nl/public_html/devsite/wp-content/plugins/time-sheets/time-sheets.php on line 412
    [21-Mar-2018 15:24:27 UTC] PHP Notice: Undefined index: show_header_queues in /home/deb96951n2/domains/webdomain.nl/public_html/devsite/wp-content/plugins/time-sheets/time-sheets.php on line 416
    [21-Mar-2018 15:24:28 UTC] PHP Notice: Trying to get property of non-object in /home/deb96951n2/domains/webdomain.nl/public_html/devsite/wp-content/plugins/time-sheets/time-sheets.php on line 117
    [21-Mar-2018 15:24:28 UTC] PHP Notice: Trying to get property of non-object in /home/deb96951n2/domains/webdomain.nl/public_html/devsite/wp-content/plugins/time-sheets/time-sheets.php on line 117
    [21-Mar-2018 15:24:28 UTC] PHP Notice: Trying to get property of non-object in /home/deb96951n2/domains/webdomain.nl/public_html/devsite/wp-content/plugins/time-sheets/time-sheets.php on line 117
    [21-Mar-2018 15:24:28 UTC] PHP Notice: Trying to get property of non-object in /home/deb96951n2/domains/webdomain.nl/public_html/devsite/wp-content/plugins/time-sheets/time-sheets.php on line 117
    [21-Mar-2018 15:24:28 UTC] PHP Notice: Undefined index: menu_location in /home/deb96951n2/domains/webdomain.nl/public_html/devsite/wp-content/plugins/time-sheets/time-sheets.php on line 119
    [21-Mar-2018 15:24:28 UTC] PHP Notice: Undefined index: users_override_location in /home/deb96951n2/domains/webdomain.nl/public_html/devsite/wp-content/plugins/time-sheets/time-sheets.php on line 125
    [21-Mar-2018 15:24:28 UTC] PHP Notice: Undefined index: page in /home/deb96951n2/domains/webdomain.nl/public_html/devsite/wp-content/plugins/time-sheets/time-sheets.php on line 223
    [21-Mar-2018 15:24:31 UTC] PHP Notice: Undefined index: day_of_week_timesheet_reminders in /home/deb96951n2/domains/webdomain.nl/public_html/devsite/wp-content/plugins/time-sheets/time-sheets.php on line 406

Viewing 1 replies (of 1 total)
  • Plugin Author mrdenny

    (@mrdenny)

    It appears that your MySQL database is rejecting the tables because it doesn’t like the length of the key in some of the tables.

    I checked the table definitions and I didn’t see any indexes that were anything close to 3072 bytes (there was one I saw that was a little over 1000 bytes).

    Do you know what version of MySQL you are running? Can you take a screenshot of the tables that were created? That should tell me which ones are missing and point me to potential issues.

Viewing 1 replies (of 1 total)
  • The topic ‘Errors and other issues to solve’ is closed to new replies.