Unable to find Location URLs

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Author

Posts
September 27, 2014 at 5:42 am #16719

frantletle
Full Member

Post count: 91

Okay, what about the URLs appending a “-1” to them. Perhaps the locations were deleted and recreated, but either way, I cannot figure out how to edit the url

September 28, 2014 at 7:21 am #16755

Guust
Moderator

Post count: 29970

Have a look here:
https://wpgeodirectory.com/support/topic/appending-a-1-to-state-in-url/#post-8959

This problem has been solved in the current version.
Let me know if you need a hand with it.

October 3, 2014 at 10:43 pm #17417

frantletle
Full Member

Post count: 91

Considering wp-geo added a “-1” to a few of the cities, how can I fix that?

I can edit them in the database if its as simple as editing that one field in the database, but not sure if this is how its done

October 3, 2014 at 11:20 pm #17421

Guust
Moderator

Post count: 29970

You can search for the slug in the database, and replace all slug-1 with slug.
Make sure to replace slug with slug-1 if you have them as tags or just delete these tags first.

You should find slug-1 in the location table and the listings table.

Backup and keep track of what you’re doing if in doubt. At least you can then revert.

October 4, 2014 at 2:52 am #17426

frantletle
Full Member

Post count: 91

Well, the problem I just noticed is that every time a new city is added (when a new location is created and a city did not exist before), it always adds a -1 to the end of the url.

Can you help me figure out why?

October 4, 2014 at 3:47 am #17428

Guust
Moderator

Post count: 29970

That normally only happens if that slug is already taken, by a tag, or a post or a category …
I’ll need your phpMyAdmin details too or control panel.

WP Login provided earlier is not valid anymore?

October 4, 2014 at 6:21 am #17437

frantletle
Full Member

Post count: 91

This reply has been marked as private.

October 4, 2014 at 10:24 am #17446

Guust
Moderator

Post count: 29970

The reason why every time a new city is added, it adds a -1 to the end of the url, is because you have every possible place in your state already in the Terms table of the database.
Did you import a list of locations somehow?
I think you can just empty that table, but I’d like Paolo’s opinion on that to make sure that is safe.

October 5, 2014 at 7:11 am #17506

frantletle
Full Member

Post count: 91

Thats odd because I dont even have many of the listed cities in my file that I plan to upload.

I did use the “dummy” import data within Geodirectory, but not sure why that would have created 500 cities.

Is it safe to delete from Terms table?

October 5, 2014 at 7:09 pm #17550

Paolo
Site Admin

Post count: 31206

Login credentials are no longer working.

If we are talking about 500 tags, I’d delete them from the backend.

In screen option select show 100 of them and you will only have to delete 5 pages.

It would be definitely safer and not much longer than doing it in the DB.

Let us know,
Author

Posts