[Plugin: Subscribe To Comments Reloaded] Plugin registering error after activation

  • Resolved Perryb2006

    (@perryb2006)


    13 years, 7 months ago

    Hi,
    For some time now I have been noticing an error that appears in error log file if I use All In One Seo pack and Subscribe to comments reloaded plugin together. Following is the error:

    WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') <= DATE_SUB(NOW(), INTERVAL 2 DAY) AND meta_value LIKE '%C'' at line 3 for query
			DELETE FROM wp_postmeta
			WHERE meta_key LIKE '\_stcr@\_%'
				AND STR_TO_DATE(meta_value) <= DATE_SUB(NOW(), INTERVAL 2 DAY) AND meta_value LIKE '%C' made by do_action_ref_array, call_user_func_array, wp_subscribe_reloaded->subscribe_reloaded_purge

    This error did not appear when I removed this plugin.

    Please take a look at this.

    https://www.ads-software.com/extend/plugins/subscribe-to-comments-reloaded/

Viewing 15 replies - 1 through 15 (of 16 total)

  • Hi there,

    so just to clarify, if you disable AIO SEO, the error doesn’t come up?

    Camu

    Thread Starter Perryb2006

    (@perryb2006)

    Its the other way. When I removed Subscribe to comments reloaded plugin this error did not appear.

    Yes, but I was trying to understand if it’s a conflict with AIO SEO or a bug in my plugin. What version of MySQL are you using?

    Camu

    Thread Starter Perryb2006

    (@perryb2006)

    MySQL version 5.0.92

    Okay cool, I found the bug. I’ll fix it in my next release. It’s not a conflict with AIO SEO.

    Thank you,
    Camu

    Thread Starter Perryb2006

    (@perryb2006)

    Ah. But it did happen when I activated these 2 plugins. Anyway, looking forward to the update ??

    This topic prompted me to write here asking your opinion, for a problem that might be similar (but I can’t see error log).
    Please, before read here, excuse me if this will take some time and if could have nothing to do with you.
    Like I write there, I’ve had big problems with DB, after installing Platinum SEO Pack, just for case in the same day I’ve installed your plugin too.
    I uninstalled PSP, I reactivated AIO and I continued to have different problems, but always on DB. Currently I have no SEO plugin and I have your plugin, so I know it’s not a conflict, but I have a problem of custom field disappearing from DB.
    In those days I had come to suspect that it could be also something related to your plugin, after reading that the plugin use the same custom field’s table, post-meta.
    Do you think that my problem may be the same of this topic?
    Thanks.

    Hi Tizz,

    I see you’re having problems with custom fields, is there a way for to have access to your site so that I can take a look at the problem? My plugin uses custom fields that start with _stcr@_ and contain the email address of the subscriber. As far as I know, there are no other plugins that use the same prefix, but I could definitely be wrong.

    Please let me know what you think,
    Camu

    For the first problem, I haven’t a link ’cause I have canceled PSP, there’s only that example shot in the other topic in PSP support.

    For the second, with no SEO plugin activated (at the moment I use only a theme’s native SEO), problem is that almost every day the feat. image and custom field of this post disappears.
    I have to say that I haven’t had yet STCR subscriptions.

    Thanks

    I would say you should try disable STCR for a couple of days and see if the problem occurs again.

    Camu

    I’ll try in this way

    Thanks for your kindness

    My pleasure! Keep us posted…

    Camu

    Sooner than I thought.
    I disabled STCR, and after a while custom fields on that posts are disappeared.
    The difference is that, this time, feat. image has no disappeared.
    You can see at the same link above, custom fields should be under title and before post.
    Do you know what does it means?

    I guess it’s a problem with the theme you’re using. Try asking those who developed it ??

    Camu

    Hi, I tried installing your plugin on a 3.0 multi-site installation and had problems. I installed through Network Admin and when I went to activate it on the site I wanted to (we only have 3 sites set up) it actually activated it on one of the other sites. In other words, I’m trying to install it on our main site but when I do it ends up activating it on another site.

    Any ideas?

Viewing 15 replies - 1 through 15 (of 16 total)
  • The topic ‘[Plugin: Subscribe To Comments Reloaded] Plugin registering error after activation’ is closed to new replies.