Printable View
Help Please I downloaded Newletter subscribe v207. I was testing my create an account it won't let me create an account I get this message
You must select a country from the Countries pull down menu, It's only one country there United States I select it and I still get the same message.
I am waiting for an answer before I uninstall it.
Well don't look like I'm going to get any help, no surprise to me.
it's a known bug not related to the newsletter subscriptions. Please search the forum I saw it was answered somewhere already. I had this bug when upgraded my store from ZC 1.3.6 to 1.3.7.
Quote:
Originally Posted by weezee
I had already check the forum before I posted, the error was different. this is the error they were getting when they were trying to create an account: 1146 Table 'bea15660_zc1.TABLE_SUBSCRIBERS' doesn't exist
in:
[select count(*) as total from TABLE_SUBSCRIBERS where email_address = '[email protected]' ] I dont't see the answer to that problem either.
I'm having a MAJOR problem, When customer changes his email from account page the newsletter manager confuses old and new address and they end up looking like this [email protected]'[email protected]....
I just might be missing some file but not really likely
Quote:
Originally Posted by sparrish
Please help me to edit the header php file or subscribe template file to fix this problem!!Quote:
Originally Posted by poosk
I'm totally losing my nerves with this thing.. Since I've used my whole day to solve this and I really don't know how to figure it out please help.
1. problem
index.php?main_page=subscribe displays always an error when someone enters the page -> Fix: change the error (from header.php and language file) to display something nonconfusing like enter your email
2.
I can transfer all logged in customers straight to account_newsletters (copied from module/pages/login/header.php) which probably solves something at least makes things easier
3.MAJOR problem
If email is edited from account_edit it creates duplicate entry from email in to the subscription manager and does NOT override the previous email. Same happens whatever is updated from account_edit and subscription manager ends up having entry [email protected]'[email protected]
4.MAJOR problem
All subscriptions made through index.php?main_page=subscribe are TEXT-ONLY even though html would be selected and displayed as default it won't work...
Byte, Ajeh, anyone please help me since I just don't have enough insight how these things work in zen. MANY THANKS
To fix this you need to edit the includes/modules/pages/account_edit/header_php.php file and change the bit that says...Quote:
Originally Posted by poosk
...to...PHP Code:$sql = "UPDATE " . TABLE_SUBSCRIBERS . " SET
email_address = :emailAddress'" . $email_address . "',
email_format = :emailFormat'" . $email_format . "'
WHERE customers_id = :customersID";
It should be somewhere near line 163.PHP Code:$sql = "UPDATE " . TABLE_SUBSCRIBERS . " SET
email_address = :emailAddress,
email_format = :emailFormat
WHERE customers_id = :customersID";
Hope that helps.
Regards,
Christian.
Christian THANK YOU! That did the trick.. and I found a way to change the it to html by default but can I hide the radio buttons (text & html) somehow since they don't work anyhow?
To fix this you need to edit the /includes/templates/YOUR_TEMPLATE/templates/tpl_subscribe_header.php file and change the lines that read...Quote:
Originally Posted by poosk
...to...PHP Code:$content .= '<label class="smallText">' . zen_draw_radio_field('customers_email_format', 'HTML', true) . ENTRY_EMAIL_HTML_DISPLAY . '</label>';
$content .= '<label class="smallText">' . zen_draw_radio_field('customers_email_format', 'TEXT', false) . ENTRY_EMAIL_TEXT_DISPLAY . '</label>';
Should be round lines 22-23.PHP Code:$content .= '<label class="smallText">' . zen_draw_radio_field('email_format', 'HTML', true) . ENTRY_EMAIL_HTML_DISPLAY . '</label>';
$content .= '<label class="smallText">' . zen_draw_radio_field('email_format', 'TEXT', false) . ENTRY_EMAIL_TEXT_DISPLAY . '</label>';
Hope that helps.
Regards,
Christian.