Newsletter-Only Subscriptions for v1.3x

[Chuckl]

Yes, you can edit the table with phpmyadmin or similar, or you can use a table update statement.

e.g. from your earlier example

UPDATE subscribers SET confirmed = '1' WHERE customers_id = '2';

or

UPDATE subscribers SET confirmed = '1' WHERE confirmed = NULL;

[khopek]

the sidebox is not showing in my tools-Layout boxes controller?
Everything is upload correctly, not sure what is going on?

[BradSmith]

BradSmith, in your first post above, you refer to an error in a SQL statement - a 'Replace'. Where is that to be found in the Newsletter Subscribers mod? Replace can be dangerous, Update might be safer.

I don't know the answer to this question... I believe I am getting these errors because the persons who ran this site before me, had installed a Newsletter Mod and it's remnants may be conflicting with this.

I've saved all of our subscribers' emails in case I have to start fresh... I'm so far over my head I have no idea what to do. I've opened up the database, only to realize I had no idea which table I was needing to edit.

Any further help on this will be appreciated - I realize it's probably irritating to have to help a guy along like this, but I'm afraid I'm just clueless.

[Chuckl]

It is the subscribers table you are interested in. In there is a column called 'confirmed'. Most of the entries will be '1', but one at least will be a Null - Empty - Blank. Change it to 1.

[magneteye]

hi, i am having issues with this mod.

I installed, and take a look at my right sidebox: http://www.lightswitchclothing.com/catalog

It's looking for something and not finding it.

Also, if you just click where the button SHOULD BE, i get these errors:

Warning: main(includes/templates/template_default/templates/tpl_subscribe_header.php) [function.main]: failed to open stream: No such file or directory in /home/lightswi/public_html/catalog/includes/modules/lavender/subscribe_header.php on line 20

Warning: main(includes/templates/template_default/templates/tpl_subscribe_header.php) [function.main]: failed to open stream: No such file or directory in /home/lightswi/public_html/catalog/includes/modules/lavender/subscribe_header.php on line 20

Fatal error: main() [function.require]: Failed opening required 'includes/templates/template_default/templates/tpl_subscribe_header.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/lightswi/public_html/catalog/includes/modules/lavender/subscribe_header.php on line 20

Does anyone know whats going on here? Seems to have an issue with the subscribe_header file line 20 which is this:

require($template->get_template_dir('tpl_subscribe_header',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_subscribe_header.php'); 

thanks.

[Chuckl]

The mod has a templates folder called YOUR_TEMPLATE that should be renamed to the name of the template you are using before copying the files onto the server.

You can get rid of the error message by giving it what it wants -

includes/templates/template_default/templates/tpl_subscribe_header.php No such file or directory

Put a copy of tpl_subscribe_header.php from the mod YOUR_TEMPLATE folder into the /includes/templates/template_default/templates folder on the server, or if you prefer not to use the template_default folder, in the templates folder inside the folder of your store template.

[tatiana77]

Hello there,
Any help would be appreciated - Please take a look at the screenshot, for some reason the subscribecontent is not being included in the subscribe container, causing this strange look,

Also, how can I make the color baby blue instead of white in back of the letters?

Maybe this is related to my 1st issue.

Thanks,
Tatiana

[magneteye]

The mod has a templates folder called YOUR_TEMPLATE that should be renamed to the name of the template you are using before copying the files onto the server.

You can get rid of the error message by giving it what it wants -

includes/templates/template_default/templates/tpl_subscribe_header.php No such file or directory

Put a copy of tpl_subscribe_header.php from the mod YOUR_TEMPLATE folder into the /includes/templates/template_default/templates folder on the server, or if you prefer not to use the template_default folder, in the templates folder inside the folder of your store template.

Ok, I did that, but nothing has changed. I have no idea what the heck is wrong here. Hmmm..

[magneteye]

hey, ok i did get rid of the error. but why am I still having the other issue where its saying:

BOX_SUBSCRIBE_DEFAULT_TEXT

HEADER_SUBSCRIBE_BUTTON


I renamed the folders for my template. so, not sure whats up with this.

thanks.

[magneteye]

ok, I finally figured it on on my own. ugh. what a nightmare.

thanks for the help people.