WordPress.org

Support

Support » Plugins and Hacks » Subscribe To Comments Reloaded » [Resolved] [Plugin: Subscribe To Comments Reloaded] Plugin does not Create Table

[Resolved] [Plugin: Subscribe To Comments Reloaded] Plugin does not Create Table

  • 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

Viewing 15 replies - 1 through 15 (of 17 total)
  • Plugin Contributor Jason Crouse

    @coolmann

    Hi there,

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

    Thanks,
    Camu

    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

    Plugin Contributor Jason Crouse

    @coolmann

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

    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

    Plugin Contributor Jason Crouse

    @coolmann

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

    Camu

    Yep.. This was the first thing I checked 🙁

    Plugin Contributor Jason Crouse

    @coolmann

    Really strange. Are you using 3.1.1?

    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?

    Plugin Contributor Jason Crouse

    @coolmann

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

    Camu

    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

    Plugin Contributor Jason Crouse

    @coolmann

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

    Camu

    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

    Plugin Contributor Jason Crouse

    @coolmann

    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

    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.

    Plugin Contributor Jason Crouse

    @coolmann

    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

Viewing 15 replies - 1 through 15 (of 17 total)
  • The topic ‘[Resolved] [Plugin: Subscribe To Comments Reloaded] Plugin does not Create Table’ is closed to new replies.
Skip to toolbar