Title: PHP Warning Error Log Last modified: November 25, 2016 --- # PHP Warning Error Log * Resolved [Dennis](https://wordpress.org/support/users/dennis1001/) * (@dennis1001) * [9 years, 6 months ago](https://wordpress.org/support/topic/php-warning-error-log/) * 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](https://wordpress.org/support/users/en0x/) * (@en0x) * [9 years, 6 months ago](https://wordpress.org/support/topic/php-warning-error-log/#post-8480428) * 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. * Thread Starter [Dennis](https://wordpress.org/support/users/dennis1001/) * (@dennis1001) * [9 years, 6 months ago](https://wordpress.org/support/topic/php-warning-error-log/#post-8480591) * 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](https://wordpress.org/support/users/en0x/) * (@en0x) * [9 years, 6 months ago](https://wordpress.org/support/topic/php-warning-error-log/#post-8480754) * Ah okay, there is one file i hardcoded wp_ as prefix in. I’ll make an quick update. * Plugin Author [en0x](https://wordpress.org/support/users/en0x/) * (@en0x) * [9 years, 6 months ago](https://wordpress.org/support/topic/php-warning-error-log/#post-8480811) * So the plugin is updated, can you please check if it works now? 🙂 * Thread Starter [Dennis](https://wordpress.org/support/users/dennis1001/) * (@dennis1001) * [9 years, 6 months ago](https://wordpress.org/support/topic/php-warning-error-log/#post-8480878) * 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](https://wordpress.org/support/users/en0x/) * (@en0x) * [9 years, 6 months ago](https://wordpress.org/support/topic/php-warning-error-log/#post-8480934) * 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? * Thread Starter [Dennis](https://wordpress.org/support/users/dennis1001/) * (@dennis1001) * [9 years, 6 months ago](https://wordpress.org/support/topic/php-warning-error-log/#post-8481391) * 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](https://wordpress.org/support/users/en0x/) * (@en0x) * [9 years, 5 months ago](https://wordpress.org/support/topic/php-warning-error-log/#post-8486431) * Did it work? Viewing 8 replies - 1 through 8 (of 8 total) The topic ‘PHP Warning Error Log’ is closed to new replies. * ![](https://ps.w.org/simple-support-ticket-system/assets/icon-256x256.png?rev =1244163) * [Support Ticket System](https://wordpress.org/plugins/simple-support-ticket-system/) * [Frequently Asked Questions](https://wordpress.org/plugins/simple-support-ticket-system/#faq) * [Support Threads](https://wordpress.org/support/plugin/simple-support-ticket-system/) * [Active Topics](https://wordpress.org/support/plugin/simple-support-ticket-system/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/simple-support-ticket-system/unresolved/) * [Reviews](https://wordpress.org/support/plugin/simple-support-ticket-system/reviews/) * 8 replies * 2 participants * Last reply from: [en0x](https://wordpress.org/support/users/en0x/) * Last activity: [9 years, 5 months ago](https://wordpress.org/support/topic/php-warning-error-log/#post-8486431) * Status: resolved