WordPress.org

Ready to get started?Download WordPress

Forums

Subscribe To Comments Reloaded
[resolved] Plugin does not Create Table (18 posts)

  1. yvesbecker
    Member
    Posted 3 years ago #

    Hey Camu,

    I have a strange problem with your plugin and I hope you can help me out. I have debugged far enough to see that it does not call the initializing hook at all when I activate the plugin. I already checked out this forum and the other forum and can't find any report of this bug, so probably it has nothing to do with your plugin anyway. Do you have an idea what else I can check or fix?

    I'm using your plugin with the newest version (1.6) and PHP version 5.2.4-2ubuntu5.14

    Regards

    Yves

  2. camu
    Member
    Plugin Contributor

    Posted 3 years ago #

    Hi there,

    is your a multisite environment? Also, what other plugins are you using?

    Thanks,
    Camu

  3. yvesbecker
    Member
    Posted 3 years ago #

    Hey,

    if with multisite environment you mean multiple blogs for one wordpress installation then no. I'm using Better Tag Cloud, Configurable Tag Cloud, Mail On Update, More Fields, xLanguage (always latest version).

    I already tried to deactivate all the other plugins and only run yours, but no difference :-/

    Yves

  4. camu
    Member
    Plugin Contributor

    Posted 3 years ago #

    Hi Yves, no known conflicts exist between my plugin and the ones you listed. Do you have access to your php log files?

  5. yvesbecker
    Member
    Posted 3 years ago #

    Hi Camu,

    just checked but no entry :-/ Like I said it's like the activation hook (register_activation_hook) that gets ignored.

    I figured out that all the other Plugins' hooks are affected as well (tried to send me a mail in activation process) but I guess it doesn't hurt because they aren't trying to create tables they need or whatnot.

    So the problem has nothing to do with your plugin, but maybe you have some idea what could have triggered this madness?

    Yves

  6. camu
    Member
    Plugin Contributor

    Posted 3 years ago #

    This is weird indeed. Is the mysql user allowed to create new tables in the database?

    Camu

  7. yvesbecker
    Member
    Posted 3 years ago #

    Yep.. This was the first thing I checked :-(

  8. camu
    Member
    Plugin Contributor

    Posted 3 years ago #

    Really strange. Are you using 3.1.1?

  9. yvesbecker
    Member
    Posted 3 years ago #

    Not yet. I'm currently using 3.1. Do you think the Update could help? Also I'm not using the standard wordpress theme. Can we exclude the possibility that a theme can be (in any way) responsible?

  10. camu
    Member
    Plugin Contributor

    Posted 3 years ago #

    No, we can't. Try switching to the default theme and see what happens.

    Camu

  11. yvesbecker
    Member
    Posted 3 years ago #

    Okay Thanks so far for your help, even if its not your problem resp. your plugins cause. I really appreciate it! :) Have to continue tomorrow and will inform you then.

    Yves

  12. camu
    Member
    Plugin Contributor

    Posted 3 years ago #

    Hey, a vote for my plugin would be a nice way to thank me.

    Camu

  13. ScreenfeedFr
    Member
    Posted 3 years ago #

    Hi there.

    I have the same problem: the table wp_subscribe_reloaded is not created. But I think I know why.
    Camu, I ran your sql script in mysql : "CREATE TABLE IF NOT EXISTS..." (subscribe-to-comments-reloaded.php, line 139) and I had an error with the TIMESTAMP line: "dt TIMESTAMP(10) NOT NULL DEFAULT CURRENT_TIMESTAMP".
    The problem is, since MySQL v4.1, we can't use the size with TIMESTAMP anymore (apparently, I'm not an sql expert), so we can't use "TIMESTAMP(10)".
    And my MySQL version is 5.5.9.

    I hope it will help.
    Greg

  14. camu
    Member
    Plugin Contributor

    Posted 3 years ago #

    Interesting, I must admit I didn't know the size had been "deprecated" in newer versions of MySQL. I will definitely address the issue asap.

    Thank you for your feedback,
    Camu

  15. ScreenfeedFr
    Member
    Posted 3 years ago #

    Hi Camu.

    You're welcome ;)
    May be I'm wrong about this. It was on my local server (with MAMP) and I had some troubles with this plugin (no table created, no mails sent...).
    But with my true blog, everything's working fine (MySQL version: 5.0.90).

    Thank you for your plugin, I voted 5 stars of course :)
    Greg

    PS1: the text inputs in the templates need the same "id" attribute than the label "for" attribute.
    PS2: an idea: what about make a shortcode for the url of the link to subscribe without commenting? So we could place this link everywhere in our themes.

  16. camu
    Member
    Plugin Contributor

    Posted 3 years ago #

    Thank you, Greg. I will test the query without the size associated to TIMESTAMP on my environments and see how it works. The official MySQL 5 documentation doesn't mention a size indeed, so I guess it can be safely removed.

    As for your PS1 and PS2, you make very good points! Especially the second one is something that other people have already requested, so I will see if there's a way to implement that.

    Best,
    Camu

  17. ScreenfeedFr
    Member
    Posted 3 years ago #

    Hi again Camu.

    For the shortcode, I think this should help:
    http://pastebin.com/ZTsJDiyZ
    I ran some short tests and it works fine :)

    Another last small thing:
    In user.php and author.php, when clicking on "Select-all" and "Invert selection", we go to the top of the page. Just putting return false; at the end of the javascript code solves the problem.

    Greg

  18. camu
    Member
    Plugin Contributor

    Posted 3 years ago #

    Hi Greg,

    I'm adding the code you proposed to the new version of StCR! Thank you for your feedback. Also, your "PS1" has been fixed now.

    Cheers,
    Camu

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic