JohnyBlaze

no, just OWNER ads does not have an email and I can not continue to add ads

1/ Search Ads
2/ Search for Ads containing this word or phrase: and wrote keyword
3/ Press “Start search”
4/ I chose one ad and press to enter.
5/ Press “Backspace” in keyboard
6/ ERR_CACHE_MISS

tested on the servers of different companies. Expensive servers, without limitation.

WP – latest
PHP tested – from 5.2 to 5.5

I don’t have limit in my hosting and I previous proved the problem is not hosting but query….

problem occurs on several servers.

in my site

https://i1266.photobucket.com/albums/jj525/piokrz/error_zpse2724a14.png

Ok meanwhile .. can I ask for improving the plugin? or indication of where the file in which to make a change?

this is wrong:

SELECT count(*) FROM itt_awpcp_ads WHERE disabled = 0 AND itt_awpcp_ads.ad_id IN ( SELECT ad_id FROM itt_awpcp_ad_regions WHERE state LIKE ‘%Wielkopolskie%’ ) AND payment_status != ‘Unpaid’ AND verified = 1 AND disabled = 0

Query like this:

SELECT * FROM itt_awpcp_ads ads
inner join itt_awpcp_ad_regions regions
ON ads.ad_id=regions.ad_id
WHERE ads.disabled = 0
AND regions.state LIKE ‘%Wielkopolskie%’
AND ads.payment_status != ‘Unpaid’
AND ads.verified = 1
AND ads.disabled = 0

and the problem disappears

This is answer from shared hosting:

“parameter is exceeded the maximum script execution time, which results in an error. I suggest you verify the database queries and execution oh optimization to solve the problem.”

When I made import from another mysql database, has not been completed a few cells, it can have an impact? (once in a while the lack of city, state, etc.).

1. Yes
2. 3.3.2
3. 4.0.1–pl_PL
4. no
5. just state

ok, I made the same mistake ?? thank you!