WordPress.org

Ready to get started?Download WordPress

Forums

WP Store Locator
[resolved] Current Stores Section emptied itself (14 posts)

  1. Sevallis
    Member
    Posted 3 weeks ago #

    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:

    https://wordpress.org/plugins/wp-store-locator/

  2. Tijmen Smit
    Member
    Plugin Author

    Posted 3 weeks ago #

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

  3. Tijmen Smit
    Member
    Plugin Author

    Posted 3 weeks ago #

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

  4. Sevallis
    Member
    Posted 3 weeks ago #

    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.

    https://www.dropbox.com/s/9afr18jbketpzh9/screenshot.jpg

  5. Sevallis
    Member
    Posted 3 weeks ago #

    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:
    https://www.dropbox.com/s/713fyt4kw64ccpf/pagebuilderbuttons.jpg
    https://www.dropbox.com/s/svlgn9k59bb11ps/pagebuilderbuttons2.jpg
    They just get sort of squished.

    Here is the map working even though the plugin editor isn't showing entries:
    https://www.dropbox.com/s/uxie8tujhzoykko/storemapworking.jpg

    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:
    https://www.dropbox.com/s/9pgkbifbt4mogk6/wpslstoresdatabase.jpg

    From the wp_store_locator database:
    https://www.dropbox.com/s/3dr5xdt2r7s37za/wpstorelocatordatabase.jpg

  6. Tijmen Smit
    Member
    Plugin Author

    Posted 3 weeks ago #

    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?

  7. Sevallis
    Member
    Posted 3 weeks ago #

    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 :P

    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;
       position:center;
    }
    
    .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;
    }
  8. Tijmen Smit
    Member
    Plugin Author

    Posted 3 weeks ago #

    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.

    $wpdb->show_errors();
    
    echo 'Error = ' . $wpdb->last_error;
    echo '<br>';
    echo 'Results';
    echo '<pre>';
    print_r( $wpdb->last_result );
    echo '</pre>';
    exit();
  9. Sevallis
    Member
    Posted 3 weeks ago #

    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?

  10. Tijmen Smit
    Member
    Plugin Author

    Posted 3 weeks ago #

    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.

  11. Sevallis
    Member
    Posted 3 weeks ago #

    I got this text:

    Error = Unknown column 'address' in 'field list'
    Results
    Array
    (
    )
  12. Tijmen Smit
    Member
    Plugin Author

    Posted 2 weeks ago #

    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.

  13. Sevallis
    Member
    Posted 2 weeks ago #

    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?

  14. Tijmen Smit
    Member
    Plugin Author

    Posted 2 weeks ago #

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

Reply

You must log in to post.

About this Plugin

About this Topic

Tags

No tags yet.