Support » Plugin: Hotspots Analytics » SQL errors in log

  • Resolved stefhz

    (@stefhz)


    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/

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

    (@dpowney)

    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). 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

    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

    (@dpowney)

    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.