Hi - I've been trying to implement Skippy's subscribe plugin, here: http://blog.well-of-dreams.com/subscribe.php but it just doesn't display correctly! I am using a template in /floral not /default and I can only assume it doesn't like that. Any ideas? Skippy has disabled quesiton-asking on this one...
Subscribe plugin messed up! (14 posts)
-
wellofdreams
Posted 4 years ago # -
Viper007Bond
Posted 4 years ago #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_optionstable. Then look for the rows whereoption_nameistemplateandstylesheet. Both should have an option value offloral. -
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 theget_sidebar()template tag. This is mentioned several times in the comments on the original post. -
Posted 4 years ago #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_usersI 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_optionswas to use the prefix value as defined in yourwp-config.phpplus the literal word "options". In your case, as listed above, your prefix iswp_, so your options table iswp_options.Look for the options named
templateandstylesheet. Both should have an option value offloral.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? -
Posted 4 years ago #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="http://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
mainid instead ofpage, and to remove theheaderdiv. -
Posted 4 years ago #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.
-
Posted 4 years ago #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).
-
Posted 4 years ago #Yeah, I've been cuting and pasting 2-3 lines from my post into my excerpt box, but it doesn't get sent.
-
colai
Posted 3 years ago #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 ('name@emailaddress.com', '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.
Topic Closed
This topic has been closed to new replies.
