Support » Plugin: Support Ticket System » PHP Warning Error Log

  • Resolved Dennis

    (@dennis1001)


    I like your plugin, light and simple. It is on multisite install but, unfortunately, it is causing issues! I cannot locate in DB the missing tables.

    [BPS Pro htaccess Protected Secure PHP Error Log]
    
    [25-Nov-2016 10:15:06 UTC] WordPress database error Table 'DB.wp_sts_options' doesn't exist for query SELECT ts_value FROM wp_sts_options WHERE ts_option = 'db_version' made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, db_version_update, include_once('/plugins/simple-support-ticket-system/includes/db-update.php')
    
    [25-Nov-2016 10:15:06 UTC] WordPress database error Table 'DB.wp_sts_tickets' doesn't exist for query ALTER TABLE wp_sts_tickets
    		ADD title VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
    		; made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, db_version_update, include_once('/plugins/simple-support-ticket-system/includes/db-update.php')
    
    [25-Nov-2016 10:15:07 UTC] WordPress database error Table 'DB.wp_sts_login' doesn't exist for query ALTER TABLE wp_sts_login
    		ADD mail VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
    		; made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, db_version_update, include_once('/plugins/simple-support-ticket-system/includes/db-update.php')
    
Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author en0x

    (@en0x)

    Looks like there are at least one table missing. Can you check how many tables there are with the prefix “wp_sts_” ?

    Anyway a reinstall should fix this.

    I found four tables

    _sts_answers
    _sts_login
    _sts_options
    _sts_tickets

    Deleted the plugin and DB tables, reinstalled and can still see the four tables but, I do not use wp_ prefix as it has been changed to something else. The error still shows up with wp_.

    Plugin Author en0x

    (@en0x)

    Ah okay, there is one file i hardcoded wp_ as prefix in. I’ll make an quick update.

    Plugin Author en0x

    (@en0x)

    So the plugin is updated, can you please check if it works now? 🙂

    There is still issues but the wp_ is gone from the error log, you have fixed one issue! 🙂

    I only updated, did not delete the plugin or DB tables. Not sure if deleting and reinstall will be of any help!

    [BPS Pro htaccess Protected Secure PHP Error Log]
    
    [25-Nov-2016 13:49:31 UTC] WordPress database error Duplicate column name 'title' for query ALTER TABLE _sts_tickets
    		ADD title VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
    		; made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, db_version_update, include_once('/plugins/simple-support-ticket-system/includes/db-update.php')
    
    [25-Nov-2016 13:49:31 UTC] WordPress database error Duplicate column name 'mail' for query ALTER TABLE _sts_login
    		ADD mail VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
    		; made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, db_version_update, include_once('/plugins/simple-support-ticket-system/includes/db-update.php')
    
    [25-Nov-2016 13:49:31 UTC] WordPress database error Duplicate column name 'datepicker' for query ALTER TABLE _sts_tickets
    		ADD datepicker VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
    		; made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, db_version_update, include_once('/plugins/simple-support-ticket-system/includes/db-update.php')
    
    [25-Nov-2016 13:49:31 UTC] WordPress database error Duplicate entry 'opt_field_1' for key 'PRIMARY' for query INSERT INTO _sts_options (ts_option, ts_value) VALUES 
    		('opt_field_1', 'Optional Field 1 (Change in Settings)'), 
    		('opt_field_2', 'Optional Field 2 (Change in Settings)'), 
    		('opt_field_3', 'Optional Field 3 (Change in Settings)'), 
    		('datepicker', 'Datepicker Field (Change in Settings)') made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, db_version_update, include_once('/plugins/simple-support-ticket-system/includes/db-update.php')
    
    [25-Nov-2016 13:49:31 UTC] WordPress database error Duplicate entry 'problem' for key 'PRIMARY' for query INSERT INTO _sts_options (ts_option, ts_value) VALUES
    		('problem', 'Problem (Change in Settings)'),
    		('check_mail', '0'),
    		('mail_answer', NULL),
    		('mail_take', NULL),
    		('mail_done', NULL) made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, db_version_update, include_once('/plugins/simple-support-ticket-system/includes/db-update.php')
    
    
    Plugin Author en0x

    (@en0x)

    Mhh seems like these tables already exist and deleting all tables and a fresh install should fix it. But it’s strange, that there is not a prefix anymore. Or did you choose an empty prefix at installation?

    The prefix is in place, I removed it from the above code before posting.

    I’ll give it one more try and delete the DB tables and reinstall the plugin and we’ll see what happens.

    Plugin Author en0x

    (@en0x)

    Did it work?

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘PHP Warning Error Log’ is closed to new replies.