Hey
1: You have to go on oc-admin > listing ? Manage Listings, and edit the old items location :


This will fix the old announces from the old theme.

sorry i already done that but have more than 2k listings it is not possible to edit every listing is there any other solution please tell me... if user selected country then also need to show all listings,,,, if user selected city then need show only city rellated ads..  i need solution for only short period of time after some days i will use default script of zara

How to add default country to all listing ?

@Ghany
You can create SQL query and update all your existing listings (replace empty country fields with default country code).
There is no other reliable solution.

bro can u send me some pics about how to add msql query? else i will send you login details can u please help me/?

@Ghany
I do not have any, check MySQL documentation:
http://www.w3schools.com/php/php_mysql_update.asp

its ok bro, with out knowing anything i dont touch msql i will take help any others.. thank for your help bro

if you try to edit item-post take care to edit good. Because you can create a lot of hidden errors.

@mixradu
i not edited, i dnt touch msql database, i am not atleast beginer...
but i have small doubt when i selected country in select location my site was fast, if i not selected any location then my site was slow, why like this? i hope you understand what i am trying to say?

@Ghany
Do you have latest theme version?

i have 1.0.8 version, i don't know present which one is latest version

@Ghany
1.1.15 is latest, but even on 1.0.8 were issues with locations fixed.
Send me URL where is loading fast and URL where is loading slow.

http://domain.com/searcher
http://domain.com/searcher/cookie-action-side,done/country,IN/region,781499

Find the differ.... is there any issue?

@Ghany
Did not get difference....

ok, but having little difference when connecting to server......

I know that this is a very old question, but I had the same issue and I resolve the SQL problem, I add the country code to all of my listings.

well...
first open myphpadmin

Click on the table oc_t_item_location.

Open the SQL where we put the codes

and add:

UPDATE `oc_t_item_location` SET `fk_c_country_code`='SV';

This is for my country El Salvador

After that you need to add the country name:

UPDATE `oc_t_item_location` SET `s_country`='El Salvador';

Just change the country, and thats it...