Our site www.viart.com site is operated by latest Viart Shop 5 with default Clear design
Topic Information
Vera
Vera
Description
 
1) When you go newsletter's email list and select to delete a few emails the change doesn't reflect on Emails count number.
 
2) There are missing a couple of scripts such as unsubscribe.php which makes it impossible to unsubscribe or calculate correct Statistics.
 
3) The import function doesn't work correctly.
 
Solution
http://www.viart.com/downloads/email_campaigns_update.zip
 
1. Extract into the folders below such files:
 
/admin
admin_export_custom.php
admin_import.php
admin_newsletter_email.php
admin_newsletter_emails.php
admin_subscribe_update.php
 
/blocks
block_order_info.php
 
/includes
newsletter_functions.php
 
/templates/admin
admin_export_custom.html
admin_import.html
admin_newsletter_email.html
admin_newsletter_emails.html
 
root of the shop
email_open.php
subscribe.php
unsubscribe.php
 
2. Run the following script in your browser by entering the URL:
http://www.yoursite.com/admin/admin_subscribe_update.php
 
 
Last modified: 29 Oct 2012 6:20 PM
 
theruck
theruck
what is the expected output of that script?
 
UPDATING...
INSERT INTO va_cms_pages (page_id,module_id,page_order,page_code,page_name) VALUES (83,1,13,'subscribe','SUBSCRIBE_TITLE')
INSERT INTO va_cms_pages (page_id,module_id,page_order,page_code,page_name) VALUES (84,1,14,'unsubscribe','UNSUBSCRIBE_TITLE')
INSERT INTO va_cms_pages_settings (ps_id,page_id,key_code,key_type,key_rule,layout_id,site_id) VALUES (287,83,NULL,NULL,NULL,1,1)
INSERT INTO va_cms_pages_blocks (ps_id,frame_id,block_id,block_key,block_order) VALUES (287,1,118,NULL,1)
INSERT INTO va_cms_pages_blocks (ps_id,frame_id,block_id,block_key,block_order) VALUES (287,3,3,NULL,1)
INSERT INTO va_cms_pages_blocks (ps_id,frame_id,block_id,block_key,block_order) VALUES (287,5,119,NULL,1)
INSERT INTO va_cms_pages_settings (ps_id,page_id,key_code,key_type,key_rule,layout_id,site_id) VALUES (288,84,NULL,NULL,NULL,1,1)
INSERT INTO va_cms_pages_blocks (ps_id,frame_id,block_id,block_key,block_order) VALUES (288,1,118,NULL,1)
INSERT INTO va_cms_pages_blocks (ps_id,frame_id,block_id,block_key,block_order) VALUES (288,3,157,NULL,1)
INSERT INTO va_cms_pages_blocks (ps_id,frame_id,block_id,block_key,block_order) VALUES (288,5,119,NULL,1)
 
Vera
Vera
what is the expected output of that script?
 
UPDATING...
 
The expected outcome is two new pages in CMS - "Subscribe" and "Unsubscribe" with appropriate blocks on them.
 
Vera
Vera
The patch was updated with new updated scripts and templates regarding import/export problems, please download archive again and extract the files in correct folders.
 
Regards,
ViArt Team