Subscribe plugin messed up!

Viewing 13 replies - 1 through 13 (of 13 total)

  • Change your theme to something else and then back in your admin area.

    If that doesn’t work, go into your database and open up the prefix_options table. Then look for the rows where option_name is template and stylesheet. Both should have an option value of floral.

    I have closed comments on the old subscribe2 thread. 250+ comments is too many, and no one reads the comments that are there.

    Subscribe2 now has its own category, in which new announcements are made. The new posts are open for commenting.

    I won’t help with CSS and theme related issues, though. There are simply too many themes, each doing too many different things, for me to reasonably troubleshoot them. I’m not a CSS expert, so the time it takes me to diagnose and resolve theme issues is more than I can spare.

    Generally speaking, most problems usually amount to an unclosed <div>, or a duplicate <div> of some sort. In your case, it’s most likely just the placement of the get_sidebar() template tag. This is mentioned several times in the comments on the original post.

    Thread Starter wellofdreams

    (@wellofdreams)

    wow, um……

    there isn’t a ‘pefix options’ table in my database, just:
    wp_categories
    wp_comments
    wp_linkcategories
    wp_links
    wp_miniblog
    wp_options
    wp_post2cat
    wp_postmeta
    wp_posts
    wp_subscribe2
    wp_users

    I dont think it’s a missin </div> because not only is it messed up but entirely the wrong sidebar is showing.

    What Viper007Bond meant when he said prefix_options was to use the prefix value as defined in your wp-config.php plus the literal word “options”. In your case, as listed above, your prefix is wp_, so your options table is wp_options.

    Look for the options named template and stylesheet. Both should have an option value of floral.

    If you activate a new theme, from the Presentation menu in your admin area, does subscribe.php behave properly?

    If you edit subscribe.php and change the location of the get_sidebar() call (as described here), does subscribe.php work properly?

    Thread Starter wellofdreams

    (@wellofdreams)

    oh, duh me…

    ok, I can’t see a template or stylesheet option in my ‘options’ section; it just has things like option_id and blog_id and option_width etc.

    Yes, it works correctly with the default theme.

    no, that doesn’t fix it ??

    (I’d be happy if I could just stick the box and button on my main page like a regular form, and just use the subscribe plugin to power it; is that possible/easier?)

    wellofdreams: if you look at the comments on the original subscribe2 post, you’ll see that I’ve explained there at least twice how to place the HTML form elements in your sidebar.

    The issue is, though, that the form needs to POST somewhere, and the submitted data needs to be processed. This is the function of subscribe.php. So even if you place the HTML form in your sidebar, you’re still going to need subscribe.php to handle the submitted data.

    It would be extremely helpful if you could be more precise when reporting back here. Saying “no, that doesn’t fix it” doesn’t tell me much. I assume you’re responding to me request to adjust the location of get_sidebar(), but that’s not entirely clear. Precision is important when reporting problems, or the steps you’ve taken to resolve a problem.

    Looking further at the floral theme, it’s clear that this is a CSS issue.

    Compare these lines from your main index:
    <body>
    <div id="main">
    <div id="posts">
    <h2>September 19, 2005</h2>

    with these lines from the output of subscribe.php:
    <body>
    <div id="page">
    <div id="header">
    <div id="headerimg">
    <h1><a href="https://blog.well-of-dreams.com">Well of Thoughts</a></h1>
    <div class="description"></div>
    </div>
    </div>
    <hr />
    <div id="content" class="narrowcolumn"><div class="post"><p>By subscribing to this service you will be notified every time a new post is added.</p>

    Feel free to adjust subscribe.php to use the main id instead of page, and to remove the header div.

    Thread Starter wellofdreams

    (@wellofdreams)

    hey, there’s no need to get ratty with me – I’m trying my best, but this is all greek to me. I apologise for having missed one of two-hundred and something comments; I’ve found it now, and it works perfectly – thankyou.

    Please understand that I’m not trying to be snotty, or superior. I’m trying to help you help me, so that together we can fix the problem.

    I know what a pain it is to read through 250+ comments, which is precisely why I closed them on that post, and made new posts for subsequent releases.

    I know how frustrating it can be to try to work through a system you don’t fully understand.

    I’m glad you were able to fix the problem.

    Thread Starter wellofdreams

    (@wellofdreams)

    Sorry I snapped, I was getting a teensy bit frustrated with the php…!

    It’s all working hunky-dory now, except that it isn’t sending out the excerpts. It is definately set up to send excerpts in the control panel, and I read through the comments and saw someone else had had the same problem, but there was no reply with a fix…

    Any ideas, anyone? It’s not vital or anything, but it would be nice to be able to send the excerpt… ??

    The plugin currently uses what WordPress considers to be an excerpt, which is what you manually write in the top field of the Advanced post screen.

    subscribe2 does not automatically generate exceprts for you.

    The next version of subscribe2 will also check whether you have a <–more–> tag inside your post. If you do, it will send the bit before that tag, rather than the whole post (assuming you’ve selected “excerpt”. If you select the whole post, it will correctly deliver the whole post).

    Thread Starter wellofdreams

    (@wellofdreams)

    Yeah, I’ve been cuting and pasting 2-3 lines from my post into my excerpt box, but it doesn’t get sent.

    Hi, I couldn’t find a newer thread for the subscribe2 plugin from Skippy, so I just post my problems in this quite old thing here and hope that someone can help me:

    When I fill in subscribe addresses in WP under “manage – subscribers” by myself it worked, but I got the following error message:

    WordPress database error: [Unknown column ‘date’ in ‘field list’]
    SELECT email, date FROM wp_subscribe2
    ()

    I made a test and posted a new blog entry. It was sending emails to the subscribers, so it worked although I have under each subscriber this error message (only in the manage-subscribers area).

    Then I erased two of the email addresses and wanted to subscribe them again, but after clicking the subscribe button it now gives me the following error message (above the field):
    WordPress database error:
    [Unknown column ‘date’ in ‘field list’]
    INSERT INTO wp_subscribe2 (email, active, date) VALUES (‘[email protected]’, ‘1’, NOW())

    It strangely says “Adress(es) subscribed!” but above I have the mentioned error message…hmm..

    I tried it with other (new) email addresses that haven’t been subscribed before, but always the same error message and the new email addresses are not in the “all subscribers” list.

    Any ideas?

    I hope I didn’t explain it too complicated (I’m not English).
    I use WP 2.0.2. with a modified benevolence theme.

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘Subscribe plugin messed up!’ is closed to new replies.