WordPress.org

Ready to get started?Download WordPress

Forums

Subscribe To Comments Reloaded
[resolved] Plugin registering error after activation (17 posts)

  1. Perryb2006
    Member
    Posted 3 years 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.

    http://wordpress.org/extend/plugins/subscribe-to-comments-reloaded/

  2. camu
    Member
    Plugin Contributor

    Posted 3 years ago #

    Hi there,

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

    Camu

  3. Perryb2006
    Member
    Posted 3 years ago #

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

  4. camu
    Member
    Plugin Contributor

    Posted 3 years ago #

    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

  5. Perryb2006
    Member
    Posted 3 years ago #

    MySQL version 5.0.92

  6. camu
    Member
    Plugin Contributor

    Posted 3 years ago #

    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

  7. Perryb2006
    Member
    Posted 3 years ago #

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

  8. tizz
    Member
    Posted 3 years ago #

    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.

  9. camu
    Member
    Plugin Contributor

    Posted 3 years ago #

    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

  10. tizz
    Member
    Posted 3 years ago #

    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

  11. camu
    Member
    Plugin Contributor

    Posted 3 years ago #

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

    Camu

  12. tizz
    Member
    Posted 3 years ago #

    I'll try in this way

    Thanks for your kindness

  13. camu
    Member
    Plugin Contributor

    Posted 3 years ago #

    My pleasure! Keep us posted...

    Camu

  14. tizz
    Member
    Posted 3 years ago #

    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?

  15. camu
    Member
    Plugin Contributor

    Posted 3 years ago #

    I guess it's a problem with the theme you're using. Try asking those who developed it :)

    Camu

  16. bptexas
    Member
    Posted 3 years ago #

    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?

  17. camu
    Member
    Plugin Contributor

    Posted 3 years ago #

    Yes may want to wait until 2.0.2 is released. There's a known bug in 2.0.1 when you 'network-activate' it :)

    Camu

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic