JohnyBlaze
Forum Replies Created
-
Forum: Plugins
In reply to: [AWP Classifieds] Mail requiredno, just OWNER ads does not have an email and I can not continue to add ads
Forum: Plugins
In reply to: [AWP Classifieds] ERR_CACHE_MISS1/ 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_MISStested on the servers of different companies. Expensive servers, without limitation.
WP – latest
PHP tested – from 5.2 to 5.5Forum: Plugins
In reply to: [AWP Classifieds] ERR_CACHE_MISSI don’t have limit in my hosting and I previous proved the problem is not hosting but query….
problem occurs on several servers.
Forum: Plugins
In reply to: [AWP Classifieds] ERR_CACHE_MISSForum: Plugins
In reply to: [AWP Classifieds] too slow search "State"Ok meanwhile .. can I ask for improving the plugin? or indication of where the file in which to make a change?
Forum: Plugins
In reply to: [AWP Classifieds] too slow search "State"this is wrong:
SELECT count(*) FROM itt_awpcp_ads WHERE disabled = 0 AND itt_awpcp_ads.
ad_idIN ( SELECT ad_id FROM itt_awpcp_ad_regions WHERE state LIKE ‘%Wielkopolskie%’ ) AND payment_status != ‘Unpaid’ AND verified = 1 AND disabled = 0Query 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 = 0and the problem disappears
Forum: Plugins
In reply to: [AWP Classifieds] too slow search "State"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.).
Forum: Plugins
In reply to: [AWP Classifieds] too slow search "State"1. Yes
2. 3.3.2
3. 4.0.1–pl_PL
4. no
5. just stateok, I made the same mistake 🙂 thank you!
