Title: SQL errors in log
Last modified: August 30, 2016

---

# SQL errors in log

 *  Resolved [stefhz](https://wordpress.org/support/users/stefhz/)
 * (@stefhz)
 * [10 years, 8 months ago](https://wordpress.org/support/topic/sql-errors-in-log/)
 * Hi – This is the first time I am using this plugin. After activating I went straight
   to the settings, and after setting start and end time and went through all the
   other tabs, I found several SQL error statements in the log:
 * WordPress database error Duplicate key name ‘ix_event’ for query ALTER TABLE 
   wp_ha_user_event ADD KEY ix_event (x_coord, y_coord, event_type, page_width, 
   url, user_env_id) made by activate_plugin, do_action(‘activate_hotspots/hotspots.
   php’), call_user_func_array, ha_activate_plugin, HA_Admin_Controller::activate_plugin,
   dbDelta
 * WordPress database error Duplicate key name ‘ix_user_env’ for query ALTER TABLE
   wp_ha_user_environment ADD KEY ix_user_env (user_id, browser, os, device) made
   by activate_plugin, do_action(‘activate_hotspots/hotspots.php’), call_user_func_array,
   ha_activate_plugin, HA_Admin_Controller::activate_plugin, dbDelta
 * WordPress database error Duplicate key name ‘ix_custom_event’ for query ALTER
   TABLE wp_ha_custom_event ADD KEY ix_custom_event (url, event_type) made by activate_plugin,
   do_action(‘activate_hotspots/hotspots.php’), call_user_func_array, ha_activate_plugin,
   HA_Admin_Controller::activate_plugin, dbDelta
 * The plugin has been recommended big style, but this does not look very trustworthy…
   and I hope I am wrong 🙂 seriously.
 * [https://wordpress.org/plugins/hotspots/](https://wordpress.org/plugins/hotspots/)

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [dpowney](https://wordpress.org/support/users/dpowney/)
 * (@dpowney)
 * [10 years, 8 months ago](https://wordpress.org/support/topic/sql-errors-in-log/#post-6492608)
 * Hi there,
 * This error looks like on plugin activation the database table indexes could not
   be created because they already exist. WordPress always attempts to update database
   tables on plugin activate if using the dbDelta function (See [https://codex.wordpress.org/Creating_Tables_with_Plugins](https://codex.wordpress.org/Creating_Tables_with_Plugins)).
   Were these errors shown in the WordPress admin? Were you able to activate the
   plugin? What logs did you see these errors? These errors are nothing to be concerned
   about; your database and the plugin will work fine.
 * Thanks,
    Daniel
 *  Thread Starter [stefhz](https://wordpress.org/support/users/stefhz/)
 * (@stefhz)
 * [10 years, 8 months ago](https://wordpress.org/support/topic/sql-errors-in-log/#post-6492612)
 * Hi Daniel,
 * Thanks for the quick response … They showed up in the PHP error log, and I am
   using a plugin to show the contents of that log in the Admin dashboard.
 * Yes, the plugin was activated, after seeing those errors however, I deactivated
   it … sounds like I can activate it again.
 * Is there any way to verify the plugin working (and not messing with my db) other
   than waiting for the first run to complete?
 * Thanks
 * Stefan
 *  Plugin Author [dpowney](https://wordpress.org/support/users/dpowney/)
 * (@dpowney)
 * [10 years, 8 months ago](https://wordpress.org/support/topic/sql-errors-in-log/#post-6492614)
 * Hi Stefan,
 * You can use debug mode, try it out yourself and then clear the data once you’re
   happy with the setup.
 * Thanks,
    Daniel

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘SQL errors in log’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/hotspots_f1f1fd.svg)
 * [Hotspots Analytics](https://wordpress.org/plugins/hotspots/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/hotspots/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/hotspots/)
 * [Active Topics](https://wordpress.org/support/plugin/hotspots/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/hotspots/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/hotspots/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [dpowney](https://wordpress.org/support/users/dpowney/)
 * Last activity: [10 years, 8 months ago](https://wordpress.org/support/topic/sql-errors-in-log/#post-6492614)
 * Status: resolved