Re: Newsletter-Only Subscriptions for v1.3x
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;
Re: Newsletter-Only Subscriptions for v1.3x
the sidebox is not showing in my tools-Layout boxes controller?
Everything is upload correctly, not sure what is going on?
Re: Newsletter-Only Subscriptions for v1.3x
Quote:
Originally Posted by
Chuckl
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.
Re: Newsletter-Only Subscriptions for v1.3x
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.
Re: Newsletter-Only Subscriptions for v1.3x
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:
PHP Code:
require($template->get_template_dir('tpl_subscribe_header',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_subscribe_header.php');
thanks.
Re: Newsletter-Only Subscriptions for v1.3x
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.
1 Attachment(s)
Re: Newsletter-Only Subscriptions for v1.3x
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
Re: Newsletter-Only Subscriptions for v1.3x
Quote:
Originally Posted by
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.
Ok, I did that, but nothing has changed. I have no idea what the heck is wrong here. Hmmm..
Re: Newsletter-Only Subscriptions for v1.3x
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.
Re: Newsletter-Only Subscriptions for v1.3x
ok, I finally figured it on on my own. ugh. what a nightmare.
thanks for the help people.