cscott5288

I should note that the version I uploaded might not be the version you are using. If they are different versions, you might want to switch to my version. def backup your files before trying anything.

No problem, jf1982.

A while back I went through the whole plugin and sanitized it of any code which was over-taxing on mysql. For instance on the ad places page, if you have too many on one page, it will crash. I’ve uploaded my sanitized version here:
deadcaterpillar.com/simple-ads-manager.zip

Simply overwrite all the files in your plugin’s directory with the files in the zip.

hope that helps you out!

P.S. I should also note that if you have php notices/warnings enabled on your server, you might receive notices and/or warnings for undefined variables… to remedy that, you can turn off php warnings, set those variables to null values, or you could delete any references to said variables.

I can confirm that it is a problem with inefficient queries. If you remove lines 202 to 206 (see code block below) in list.admin.class.php, it will fix the loading issue. There’s a bunch of CPU-intensive mathematical operations being performed on the columns in those lines. The only detriment to deleting them is that you won’t see the hits and total hits columns displayed on the “ad places” page, but you can get those stats from each ad individually (there’s really no need to have them display there).

@patch_hits := (IFNULL((SELECT COUNT(*) FROM $sTable ss WHERE (EXTRACT(YEAR_MONTH FROM NOW()) = EXTRACT(YEAR_MONTH FROM ss.event_time)) AND ss.id = 0 AND ss.pid = sp.id AND ss.event_type = 0), 0)) AS patch_hits,
                      (IFNULL((SELECT COUNT(*) FROM $sTable ss WHERE (EXTRACT(YEAR_MONTH FROM NOW()) = EXTRACT(YEAR_MONTH FROM ss.event_time)) AND ss.id > 0 AND ss.pid = sp.id AND ss.event_type = 0), 0) + IFNULL(@patch_hits, 0)) as total_ad_hits,
                      (IFNULL((SELECT SUM(IF(sa.cpm > 0, IFNULL((SELECT COUNT(*) FROM $sTable ss WHERE (EXTRACT(YEAR_MONTH FROM NOW()) = EXTRACT(YEAR_MONTH FROM ss.event_time)) AND ss.id = sa.id AND ss.pid = sa.pid AND ss.event_type = 0), 0) * sa.cpm / 1000, 0)) FROM $aTable sa WHERE sa.pid = sp.id), 0)) AS e_cpm,
                      (IFNULL((SELECT SUM(IF(sa.cpc > 0, IFNULL((SELECT COUNT(*) FROM $sTable ss WHERE (EXTRACT(YEAR_MONTH FROM NOW()) = EXTRACT(YEAR_MONTH FROM ss.event_time)) AND ss.id = sa.id AND ss.pid = sa.pid AND ss.event_type = 1), 0) * sa.cpc, 0)) FROM $aTable sa WHERE sa.pid = sp.id), 0)) AS e_cpc,
                      (IFNULL((SELECT SUM(IF(sa.ad_schedule AND sa.per_month > 0, DATEDIFF(CURDATE(), sa.ad_start_date) * sa.per_month / 30, 0)) FROM $aTable sa WHERE sa.pid = sp.id), 0)) AS e_month,

it seems the plugin developer is no longer offering support. I hope this post helps someone!

This is definitely a significant problem. If you have more than 10 ads or so, it will temporarily crash the site because of how much memory it uses. Inefficient SQL queries seems to be the culprit. Anyone interested in rewriting the mysql interactions of this plugin?

bcworkz, thanks! I overlooked that part because I was looking for something like a URL parameter instead of a ‘slug’ parameter. But this will work just fine for me. Thanks!

Thanks for the help, OldRiver. This is sort of what I want. But instead of adding a link to the admin bar, I want to add it to the admin menu, the vertical menu on the left-hand side in the wordpress backend. Apologies for not explaining it correctly.

I am having the same problem … searched and searched but could not find a solution.

I am having this same issue …

Resolved: I figured out that the pop over plugin was conflicting with my version of the All in One SEO plugin. I updated the All in One SEO plugin and the pop over worked! So if you are having this issue, try disabling your All in One SEO plugin or updating.

Any help? I’m dying here.

I am having the same problem. A Forbidden and a 403 error when I try to submit a listing. Great plugin by the way (except for that).

Found a solution: https://wpcodesnippets.info/blog/how-to-fix-the-wp-3-1-custom-permalinks-bug.html

Thanks for all the help!

Tried. It still didn’t appear in the FT category archive.

Interestingly no, and not all of the fishshful thinking posts are in Sept. Thanks for the help btw ??