WordPress.org

Ready to get started?Download WordPress

Forums

WordPress Store Locator
[resolved] [Plugin: Google Maps Store Locator for WordPress] Invalid query: Table 'db337960084.wp_store_lo (2 posts)

  1. Mystech
    Member
    Posted 3 years ago #

    After installing, when I attempt to add my first location I get the following error after filling out the Add Location form and hitting the "Add Location" button:

    Invalid query: Table 'db337960084.wp_store_locator' doesn't exist

    I could not find any reference to this error in the documentation, faq, etc. Any ideas?

    http://wordpress.org/extend/plugins/store-locator/

  2. Mystech
    Member
    Posted 3 years ago #

    Table was not created during plugin activation, found the necessary SQL in the file functions.sl.php and created the MySQL table manually.

    CREATE TABLE wp_store_locator (
    sl_id mediumint(8) unsigned NOT NULL auto_increment,
    sl_store varchar(255) NULL,
    sl_address varchar(255) NULL,
    sl_address2 varchar(255) NULL,
    sl_city varchar(255) NULL,
    sl_state varchar(255) NULL,
    sl_zip varchar(255) NULL,
    sl_latitude varchar(255) NULL,
    sl_longitude varchar(255) NULL,
    sl_tags mediumtext NULL,
    sl_description varchar(255) NULL,
    sl_url varchar(255) NULL,
    sl_hours varchar(255) NULL,
    sl_phone varchar(255) NULL,
    sl_image varchar(255) NULL,
    sl_private varchar(1) NULL,
    sl_neat_title varchar(255) NULL,
    PRIMARY KEY (sl_id)
    ) ENGINE=innoDB DEFAULT CHARACTER SET=utf8 DEFAULT COLLATE=utf8_unicode_ci;

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic