This is the PageBuilder plugin you are using? http://ww.wp.xz.cn/plugins/siteorigin-panels/ The link for the screenshot is broken.
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.
https://www.dropbox.com/s/9afr18jbketpzh9/screenshot.jpg
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
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;
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;
}
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();
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?
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'
Results
Array
(
)
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?
Something clearly went wrong because I just realized you also should have an address2 field in your db.
First download this file http://downloads.wp.xz.cn/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?
