MC1171611
Forum Replies Created
-
Posts
-
Paolo,
Now that I tried to merge them, I can’t seem to locations for the countries. What’s the procedure for merging two countries?
Awesome, thanks. I’ve been sitting on that for awhile, not sure what would happen.
I use the Redirection plugin, I just have to add the regex to make it all work. Thanks for the response, Kor.
Does UsersWP add any important functionality to GeoDirectory itself? I’m trying to determine if it’s something I’m going to want for my site.
I still have to go through the process of migrating to WP Invoicing…
How do new projects get added? I’m working on translating Whoop! into Spanish.
Yes Stoifan I understand using ACF isn’t a good idea.
With that thinking I was going to create another geodirectory custom post type and try to offload some of the data there.
Just not sure about the best way to link the 2 post types, and then the function to pull in the data fields from the new GD custom post type into the existing GD custom post type.
Thanks for your help.
Thanks for the help, we are making progress.
I’ve updated a lot of the fields to text and it seems to have fixed the error.
For a long term solution I was thinking that instead of offloading some of the fields to ACF we could create another supporting custom post type and store the data there.
Let’s say Custom Post Type “Things” and then pull in that data to the detail pages, it wouldn’t be searchable which is ok.
If we had a field in the supporting custom post type that was (main custom post type name or post id) and (goedir_things_custom_field) was the data we want to pull into our main custom post type. What would a query look like that might pull that into the detail page for the other custom post type?
if (isset($post->geodir_things_custom_field)
This works but pulls in the current $post ,We would need to pull in the data linked from the other supporting custom post type.
Ideas?
Thanks for your help Stiofan.
This reply has been marked as private.The reason we were looking to use ACF was to try to offload some of the fields to it because of the maximum row size. It looks like by using a couple of the previously mentioned techniques we may be able decrease the row size preventing the error.
Hi Stiofan,
Let me know what you think of this. I think I found a possible solutions. We can limit the character limit for a lot of the fields and maybe combine a few of the fields where possible.
http://stackoverflow.com/questions/2009694/is-there-an-advantage-to-varchar500-over-varchar8000https://wpgeodirectory.com/support/topic/suddenly-unable-to-sort-custom-fields/We have over 50 custom fields. It’s even causing problems now when we try to update a post. But specifically we are running into more problems and getting the error when we try to Broadcast the post fields to one of our subsites. We have almost 100 columns on that restaurant custom post type.
This is triggering the error.
WordPress database error Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs for query ALTER TABLEwp_7_geodir_gd_restaurant_detailADD
postVARCHAR( 255 ) NOT NULL /*
Many of the fields only require less than 10 characters, so I think reducing the overhead might be possible.
Let me know please. Thanks for your help.
We have a significant number of custom fields that are necessary to display all of the data our client requires, and the massive database table is causing all sorts of problems, basically breaking the site. We *have to* have the various data available, but right now GD custom fields isn’t working and you don’t provide compatibility with ACF, so I’m apparently out of options.
GD simply won’t do what we need it to do. The custom fields table in the database is far too big, and it’s breaking critical functions of our setup. What can be done to make it work?
Sure enough, that did it. I may have to forego using a SEO plugin, then. Yoast completely hosed my site. Oh well, now to find a Sitemap plugin. 🙁
Thanks, paolo. You guys have great customer service.
I want to use the /location/ pages as SEO-optimized landing pages.
For most of my site’s visitors, they are not searching for a place near their current location. That’s why I have the location switcher turned off; it’s not very useful for the way my site’s visitors will be searching.
I’m still not able to change the page Title. I added titles for every State:
KJV Baptist Churches in Alaska | KJV Churches
But they’re not showing up. I’ve tweaked the All-in-one SEO settings (Yoast’s sitemap feature was crashing my site so I switched) and Divi’s settings, but nothing is working. It’s showing:
Churches | KJV Churches
I’ve tweaked and tested every setting I can think of, but to no avail.
