Error when adding new location list
- Johan Wagenheim
-
Topic Author
- Offline
- New Member
-
I've created a new location list for Australia, but when I try to add it to OS Property (v. 2.0.
Any ideas why I get this MySQL error with my own location file only?
Please Log in or Create an account to join the conversation.
- Dang Thuc Dam
-
- Offline
- Administrator
-
- Posts: 13435
- Thank you received: 1760
because in the cities names, you have ' character. for example : D'aguilar, it's the reason to make the error in the sql query.
Thanks
Dam
Please Log in or Create an account to join the conversation.
- Johan Wagenheim
-
Topic Author
- Offline
- New Member
-
1. How can I remove the cities I don't need? I have about 5000 cities.
2. How can I publish all the cities I've added?
In both cases, the states and cities lists only display 20 items/page, and it takes a lot of time to go through all the pages and publish or remove cities if I only can do 20 on each page. Are there any easier way to do this?
Thanks for great support
Please Log in or Create an account to join the conversation.
- Dang Thuc Dam
-
- Offline
- Administrator
-
- Posts: 13435
- Thank you received: 1760
The best way is you re-do the location files and remove the cities that you don't need.
And then you can re-import again the location file.
Thanks
Dam
Please Log in or Create an account to join the conversation.
- Acemi
- Offline
- New Member
-
- Posts: 4
- Thank you received: 0
Please Log in or Create an account to join the conversation.
- Dang Thuc Dam
-
- Offline
- Administrator
-
- Posts: 13435
- Thank you received: 1760
This functionality happens when you publish location of one country. You have error with that function?
Thanks
Dam
Please Log in or Create an account to join the conversation.
- Acemi
- Offline
- New Member
-
- Posts: 4
- Thank you received: 0
Please Log in or Create an account to join the conversation.
- Dang Thuc Dam
-
- Offline
- Administrator
-
- Posts: 13435
- Thank you received: 1760
It's strange. Can you please submit ticket and send your site information with super admin acc, ftp acc. I will check the problem for you
Thanks
Dam
Please Log in or Create an account to join the conversation.
- Aydın
- Offline
- Senior Member
-
- Posts: 77
- Thank you received: 4
Kardeş Merhaba, sitenin adresi nedir acaba yaptığın. İhtiyacın olan birşey varsa yardımcı olabilirim.Acemi wrote: my Problem was, i must publish for germany all citizen page for page in Backend. with this query was possible over phpmyadmin all citizen to publish.
Kolaylıklar
Aydın
Please Log in or Create an account to join the conversation.
- Acemi
- Offline
- New Member
-
- Posts: 4
- Thank you received: 0
hazirladigim sayfa henüz online degil. Ülke isimlerinin bulundugu dropdown'da sadece Almanya ve Türkiye kalsin istiyorum. Admin sayfasinda diger ülkeleri databank'dan silmeden deaktive etmenin bir yolu var mi?
Tesekkür ederim,
Devrim.
Please Log in or Create an account to join the conversation.
Support
Documentation
Information
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.