Support » Plugins and Hacks » WP Store Locator » [Resolved] Current Stores Section emptied itself

[Resolved] Current Stores Section emptied itself

  • Hi,

    I recently ran into a plugin conflict between PageBuilder and your plugin. It seems to cause PageBuilder’s UI buttons to misalign for some reason, and it also seems to cause problems with using PageBuilder’s Embed Image widget item. What happens is that this maps plugin makes the pop up dialog box within the editor pop up underneath rather than above the other dialog box, and therefore stops me from using the widget.

    So I have been deactivating this maps plugin while I edit other things, which works fine. However, I recently ran into a problem wherein my entire list of stores is empty. When I go to the Manage Stores section of the plugin, all of my work is missing and cannot be edited. The page still lists that there are 21 items in the list, and yet the list is empty, and when I browse to the page that I used the wpsl embed on, the dealers load up correctly. I spent a lot of time adding these dealers to the plugin database, is there some way to correct this?

    Here is a screenshot:


Viewing 15 replies - 1 through 15 (of 26 total)
  • Plugin Author Tijmen Smit


    This is the PageBuilder plugin you are using? http://wordpress.org/plugins/siteorigin-panels/ The link for the screenshot is broken.

    Plugin Author Tijmen Smit


    I see the screenshot link works in the other thread you started.

    Huh, that’s strange. I hit the edit button on this post and it made a new thread instead. Sorry about that!

    Yes I am using the latest version of page builder, which you linked to.

    I’ll add the link back in here to consolidate the threads and then delete the other one.


    OK, perhaps I should redact the dialog box bug I had run into previously. I can’t reproduce it now, perhaps I should have reported it when I spotted it months ago, so thats off the table for now. Here are what happens to the PageBuilder buttons though:
    They just get sort of squished.

    Here is the map working even though the plugin editor isn’t showing entries:

    As for the issue with displaying my database of store names, here are a couple of screenshots from the mysql database.
    From the wp_wpsl_stores database:

    From the wp_store_locator database:

    Plugin Author Tijmen Smit


    What happens when you use the paging to go the second page? Still no results?

    The UI buttons of PageBuilder are misaligned without the store locator plugin being active in my installation with wp 3.9. So that shouldn’t have anything todo with my plugin.

    You haven’t customized anything in the code? What other plugins are you using? What is the name of the theme you are using?

    Ah ok, sorry for putting the up issue on your plate then, it was correlation due to when I installed the plugin, and not causation at work 😛

    Page 2 looks identically empty.

    I am using the Vantage theme by SiteOrigin.

    I am using Black Studio’s TinyMCE widget, Matcha Labs Meta Slider, SiteOrigin’s Page Builder, Raygun’s Q and A FAQ and knowledge base for WordPress, and of course WP Store Locator.

    I have customized some CSS but I think I had it active without issue in the past, here it is:

    .specs {
       overflow: hidden;
    .specs .col-1, .specs .col-2 {
       overflow: hidden;
       width: 390px;
    .specs .col-1 {
       float: left;
       margin-left: 5px;
    .specs .col-2 {
       float: right;
       margin-right: 5px;
    .specs .col-1, .specs .col-2 {
       line-height: 30px;
    .specs .col-1 span.label, .specs .col-2 span.label {
       color: #706d66;
       padding: 0 20px;
       width: 140px;
       float: left;
    .specs .col-1 span.value, .specs .col-2 span.value {
       font-weight: bold;
       float: left;
       text-align: left;
       width: 200px;
    .specs .col-1.odd, .specs .col-2.odd, .specs .col-1.odd, .specs .col-2.odd {
       background: transparent url(/wp-content/uploads/2014/03/Medium_Gray_Background.jpeg) repeat top left;
    ul.noindent {
       margin-left: 0px;
       padding-left: 0px;

    Plugin Author Tijmen Smit


    Can you add this to the /admin/class-store-overview.php just after line 330, and then either post it here or email to info at tijmensmit.com. You should probably remove the name of the db if it shows up in the error.

    echo 'Error = ' . $wpdb->last_error;
    echo '<br>';
    echo 'Results';
    echo '<pre>';
    print_r( $wpdb->last_result );
    echo '</pre>';

    I don’t know much about PHP, am I supposed to get an error message from a database from this command? Do I enter it via an editor like DreamWeaver and then post the actual file here to share it with you?

    Plugin Author Tijmen Smit


    Just open the /admin/class-store-overview.php in any editor that shows line number, and then add the code just after line 330. Upload it to the server and reload the store overview page. It should show whether there are sql error and the current date.

    I got this text:

    Error = Unknown column 'address' in 'field list'
    Plugin Author Tijmen Smit


    Something really weird is going on here. What version are you using?

    The field called ‘street’ in your db should be called ‘address’ https://www.dropbox.com/s/9pgkbifbt4mogk6/wpslstoresdatabase.jpg But this should have been changed during the upgrade procedure.

    Have you at some point upgraded to a new version? If so, that probably failed. If you rename the street field in the db to address, and download the most recent version then it should work.

    I am using Version 1.2.21

    I’m a bit wary of changing database table names, I’ve lost access to large amounts of data in the past because of a lack of understanding of databases. How do I replace the current version with the downloaded plugin without losing my database data?

    Plugin Author Tijmen Smit


    Something clearly went wrong because I just realized you also should have an address2 field in your db.

    First download this file http://downloads.wordpress.org/plugin/wp-store-locator.1.2.21.zip and overwrite the existing files on your server.

    After that you should change the wpsl_version value in the wp options table, that should trigger the sql update procedure again. It should now say 1.2.21, change it to 1.2.20.

    Then reload the store locator editor page. If you keep phpMyadmin open while you do this you should see the db field named address instead of street, and an address2 field.

    Do make a db backup first of your wp stores field 🙂

    Ok, sorry for the delay in response.

    I’m confused about this instruction. I backed up then replaced my newer plugin with the older version, but then I have no idea what you mean by “change the wpsl_version value in the wp options table”. I’ve logged into the MySQL wordpress database which contains all of my wpsl_stores entries and also looked in the GUI section of my wordpress administration section and I have no idea what that is or where to find it, or how to change it.

    Can I just delete and reinstall the plugin as a whole, is there a way to properly reinstate all of the store entries that I manually typed in?

Viewing 15 replies - 1 through 15 (of 26 total)
  • The topic ‘[Resolved] Current Stores Section emptied itself’ is closed to new replies.
Skip to toolbar