[Release] MailWizz - v1.3.6.2

[Vpul Shah]

Yes Update is completed but this last query is I think not fire.

Do you find any solution ?

 

[Shailendra Jha]

Hi, i got the below error while updating from command line
Updating to version 1.3.6.1 failed with: CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1005 Can't create table 'email_.#sql-146f_1a9f3a' (errno: 121)

 

[Shailendra Jha]

hi @twisted1919 i am really struggling with upgrade, please help dear

 

[twisted1919]

Can you explain this a bit more? Do records from the delivery-log move into the archive automatically or is this done manually via the command line?

It's done when you call the command.

I noticed that there is a "archive-campaigns-delivery-logs" and a "archivecampaignsdeliverylogs" - do those do the same?

It's the same thing.

Our current deliverylog consists of 55m records and even after a MySQL optimize it feels sluggish. If I run the archivecampaignsdeliverylogs, does this mean that campaign stats will be retained?

Yup.

You also mentioned that archiving comes with issues - can you explain?

Well, the sql queries might fail with lots of data, for various reasons. See /apps/console/commands/ArchiveCampaignsDeliveryLogsCommand.php for understanding what sql statement is going to be ran.

Hi @twisted1919 how much time it takes to update, after you have suggested me to edit file and then run an update, i did the same and now its almost 5 hours and i am on the update screen of app

It depends, wait for it to finish.

Updating to version 1.3.6.2 failed with: CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation:

Yeah, this happens because ALTER IGNORE has been removed from newer versions of mysql and i didn't know that.
Just empty the sql file, run the upgrade again, it will tell you everything is fine, then put back the sql contents in file.
Next, run these two commands from mysql command line, one, then the other.

DELETE FROM `campaign_bounce_log` WHERE log_id NOT IN (SELECT * FROM (SELECT MAX(n.log_id) FROM `campaign_bounce_log` n GROUP BY n.campaign_id, n.subscriber_id) x);
ALTER TABLE `campaign_bounce_log` ADD UNIQUE KEY `cid_sid` (`campaign_id`, `subscriber_id`);

The above will basically do what the ALTER IGNORE one should have done.
Note that your table names might have a prefix, i.e: mw_campaign_bounce_log instead of campaign_bounce_log

Yes Update is completed but this last query is I think not fire.

Do you find any solution ?

Yup, see above sql statements.

Hi, i got the below error while updating from command line

Did you follow my advive with removing sql statements from the upgrade file one by one ?

 

[Martino Hugo]

[ADD] - #14 - New command to delete old records from various tables

How to use it?

 

[Scott]

[ADD] - #18 - Ability to filter subscribers that did(not) open/click one/all campaigns in given timespan and take an action against them, such as disable

Where can I find this filtering option? My only guess was segments but don't see it there.

 

[twisted1919]

@Martino Hugo - Please see https://forum.mailwizz.com/threads/release-mailwizz-v1-3-6-2.1826/page-2#post-10890

@Scott - See the subscribers list for each email list, it's there.

 

[Shailendra Jha]

Thanks @twisted1919 application upgraded..

 

[twisted1919]

@Shailendra Jha - Phiu :-s

 

[Salman Habib]

I have upgraded to 1.3.6.2 version. I am using Sparkpost API. For some reason, campaign emails are not being sent. When I send a test email it goes fine. Can you please check if there is an issue with send process against API,

 

[twisted1919]

@Salman Habib - I am using SparkPost in the dev as we speak and i don't see any issue with it.
Have you checked your application logs?

 

[frm.mwz]

That is why we have the campaign-archive command, to move the logs in another table, as an archive and clear up the main table

Could this be put into the settings, so it can be automated?
Also, is there a way to save all settings, so that one can easily reload them if need be?
thx

 

[twisted1919]

@frm.mwz - you can add it as a cron job, just like all the other commands. But please note that that command has to be handled with care, as i said it before, there are chances to break things.

Also, is there a way to save all settings, so that one can easily reload them if need be?

General website settings? Not sure how restoring/saving would work, if you have some ideas on the workflow, describe it here and i'll make sure it happens.

 

[Daniel Dunbar]

Hi,

I have a strange issue, unfortunately I was one of the people effected by the recent issues at 123-reg, they "accidentally" deleted my VPS server and were unable to recover my image and as I didn't have a backup I'm starting again from scatch :/

So I'm currently reinstalling the latest mailwizz package (1.3.6.2) on my new server.. everything installed as normal, backend is working and I proceeded to set everything up as it was.. but for some reason the frontend isn't working, I get a 500 HTTP ERROR

The URL redirects as normal to "/customer/guest/index", but the page contents do not load.. but I can access the frontend by impersonating a customer from the backend.. any ideas what could of happened here?

Thanks

 

[wissem]

Hi,
in this add: [ADD] - #15 - Ability to add logo from customization area for backend / customer / frontend
when i click "clear" nothing change

 

[frm.mwz]

@frm.mwz - you can add it as a cron job, just like all the other commands. But please note that that command has to be handled with care, as i said it before, there are chances to break things.


General website settings? Not sure how restoring/saving would work, if you have some ideas on the workflow, describe it here and i'll make sure it happens.

If that cron could break things, perhaps there is a safer procedure to do this, and then that could be in the backend?

Re 'save settings'...probably best to just use a full backup.

 

[twisted1919]

@Daniel Dunbar - Can you try enabling debugging and see what the real issue is?

in this add: [ADD] - #15 - Ability to add logo from customization area for backend / customer / frontend
when i click "clear" nothing change

You need to also save the form. When you click clear, the uploaded image should go away making room for a new one or none at all, but you still have to save the settings.

If that cron could break things, perhaps there is a safer procedure to do this, and then that could be in the backend?

Always command line stuff is safer to run than the one from backend because in backend things might timeout but the command line does not have this limitation.

Re 'save settings'...probably best to just use a full backup.

Then the backup extension is what you need i guess.

 

[Daniel Dunbar]

@Daniel Dunbar - Can you try enabling debugging and see what the real issue is?

I've opened a ticket with the link for you to see the report.. as for the error logs this is all I can see:

[error] File does not exist: /var/www/vhosts/httpdocs/mail/frontend/assets/files/customer

 

[twisted1919]

Yeah, see the support ticket

 

[Shailendra Jha]

Hi @twisted1919 upgrade gone well, but got in new problem
I am able to open backend, but for some reason which i dont know froentend is not opening
Evan i am not able to impersonate customers from backend

This is what there in today application log
---
2016/04/26 03:57:13 [error] [exception.CHttpException.404] exception 'CHttpException' with message 'Unable to resolve the request "SQlite/main.php".' in /var/www/vhosts/emailcampaign.email/httpdocs/apps/common/framework/web/CWebApplication.php:286
Stack trace:
#0 /var/www/vhosts/emailcampaign.email/httpdocs/apps/common/framework/web/CWebApplication.php(141): CWebApplication->runController('SQlite/main.php')
#1 /var/www/vhosts/emailcampaign.email/httpdocs/apps/common/framework/base/CApplication.php(185): CWebApplication->processRequest()
#2 /var/www/vhosts/emailcampaign.email/httpdocs/apps/init.php(224): CApplication->run()
#3 /var/www/vhosts/emailcampaign.email/httpdocs/index.php(18): require_once('/var/www/vhosts...')
#4 {main}
REQUEST_URI=/SQlite/main.php
---
2016/04/26 03:57:13 [error] [exception.CHttpException.404] exception 'CHttpException' with message 'Unable to resolve the request "SQLiteManager/main.php".' in /var/www/vhosts/emailcampaign.email/httpdocs/apps/common/framework/web/CWebApplication.php:286
Stack trace:
#0 /var/www/vhosts/emailcampaign.email/httpdocs/apps/common/framework/web/CWebApplication.php(141): CWebApplication->runController('SQLiteManager/m...')
#1 /var/www/vhosts/emailcampaign.email/httpdocs/apps/common/framework/base/CApplication.php(185): CWebApplication->processRequest()
#2 /var/www/vhosts/emailcampaign.email/httpdocs/apps/init.php(224): CApplication->run()
#3 /var/www/vhosts/emailcampaign.email/httpdocs/index.php(18): require_once('/var/www/vhosts...')
#4 {main}
REQUEST_URI=/SQLiteManager/main.php
---


Please help !!!!!!!!!!!!