WordPress.org

Ready to get started?Download WordPress

Forums

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

  1. Sevallis
    Member
    Posted 2 months 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 2 months 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 2 months ago #

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

  4. Sevallis
    Member
    Posted 2 months 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 2 months 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 2 months 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 2 months 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 2 months 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 2 months 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 2 months 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 1 month ago #

    I got this text:

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

    Posted 1 month 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 1 month 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 1 month 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 :)

  15. Sevallis
    Member
    Posted 2 weeks ago #

    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.

  16. Sevallis
    Member
    Posted 2 weeks ago #

    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?

  17. Tijmen Smit
    Member
    Plugin Author

    Posted 2 weeks ago #

    You should look at this table in the db http://codex.wordpress.org/Database_Description#Table:_wp_options

    The default name is wp_options, but it can also be called whatever_options. Open that table and look for the wpsl_version field and then change the value.

    You can uninstall the plugin, but then you will have to enter the data again.

    Or you can just manually rename the street field to address in the wpsl_stores field, that is the easy fix.

Reply

You must log in to post.

About this Plugin

About this Topic

Tags

No tags yet.