Search results

  1. C

    --segment_uid for listexport

    Yes, bot not until this week-end unfortunately. Keep you informed.
  2. C

    --segment_uid for listexport

    Hi Twisted First, many thanks to work on this feature. But I've a problem: # php htdocs/apps/console/console.php list-export --uid-list=ot237vpp0w99b --segment_list=tg056vk3vr8c4 PHP Error[2]: include(ConsoleCommand.php): failed to open stream: No such file or directory in file...
  3. C

    --segment_uid for listexport

    Hi, A feature request: to have the possibility to add a '--segment_uid' to the command "console.php listexport --list_uid=<list>" I've a segment of more than 1 millions subscribers, it takes too much time through the web interface. Thanks. Regards, JC
  4. C

    operation in the segment field's value

    Hi, I reply to myself just for those who are interested by this kind of feature. in /apps/common/models/ListSegmentCondition.php line 181 public static function _parseDateValueTag($data, $value, $condition) { $switch_time = array( 'D' => 'day', 'W' =>...
  5. C

    operation in the segment field's value

    Hi, I try to send a mail to subscribers who didn't login to thier interface since 20 days. I can see that we can specify [DATE] in the value of a field in a segment. Is there any way to do something like : LASTVISIT < [DATE] - 20D and then attach this segment to a recurring campaign...
  6. C

    Problem of performance with mailwizz

    mysql> select count(*) from mw_list_field_value; +-----------+ | count(*) | +-----------+ | 164849341 | +-----------+ 1 row in set (1 min 15.85 sec)
  7. C

    Problem of performance with mailwizz

    mysql> SELECT COUNT(*) from `mw_list_field_value` `fieldValues434` WHERE `fieldValues434`.`field_id` = 434 AND (`fieldValues434`.`value` = 0 OR `fieldValues434`.`value` = 3 OR `fieldValues434`.`value` = 4); +----------+ | COUNT(*) | +----------+ | 4734100 | +----------+ 1 row in set, 270...
  8. C

    what about subscribers status for unknown bounce

    Thanks Any way to change this to "nothing to do" ? this is for a specific need.
  9. C

    Problem of performance with mailwizz

    mysql> SELECT COUNT(*) from `mw_list_field_value` `fieldValues434` WHERE `fieldValues434`.`field_id` = 434 AND (CAST(`fieldValues434`.`value` AS UNSIGNED) = 0 OR CAST(`fieldValues434`.`value` AS UNSIGNED) = 3 OR CAST(`fieldValues434`.`value` AS UNSIGNED) = 4); +----------+ | COUNT(*) |...
  10. C

    what about subscribers status for unknown bounce

    Hi, If mailwizz retrieve a bounce for a subscriber but doesn't match any rule in apps/common/vendors/BounceHandler/rules.php, what happens for the subscriber ? Regards, JC
  11. C

    Problem of performance with mailwizz

    mysql> SELECT COUNT(DISTINCT t.subscriber_id) as counter FROM `mw_list_subscriber` `t` LEFT JOIN `mw_list_field_value` `fieldValues434` ON (`fieldValues434`.`subscriber_id`=`t`.`subscriber_id`) WHERE ((t.list_id='15') AND (t.status='confirmed') AND ( (`fieldValues434`.`field_id` = 434 AND...
  12. C

    Bounce not working

    By the way, I noticed that you have the same problem as me with the "@SWIFT_VERSION_NUMBER@". I guess it's a cosmetic bug since spam detection system doesn't care about this header. Regards, JC
  13. C

    Email not going. Status is "Pending-sending"

    Hi, I've the same problem with emails who begin with '_' or '-'. This is not permitted. I thought it was corrected in a recent previous version but if the subscriber is already inserted in the database it's too late :) I just changed the status of those subscribers in the database with an...
  14. C

    Problem of performance with mailwizz

    mysql> explain SELECT COUNT(DISTINCT t.subscriber_id) as counter FROM `mw_list_subscriber` `t` LEFT JOIN `mw_list_field_value` `fieldValues434` ON (`fieldValues434`.`subscriber_id`=`t`.`subscriber_id`) WHERE ((t.list_id='15') AND (t.status='confirmed') AND ( (`fieldValues434`.`field_id` = 434...
  15. C

    Problem of performance with mailwizz

    Hi, Sorry for the delay, I was ill last week. There are no ameliorations, the interface is unusable now :-( Here is the request who took very long time (304 secs): # Time: 160628 15:31:16 # User@Host: mailwizz[mailwizz] @ [127.0.0.1] Id: 157 # Query_time: 304.479513 Lock_time: 0.000230...
  16. C

    Problem of performance with mailwizz

    done ! normally when I change innodb_buffer_pool_size, I chage the innodb_buffer_pool_instances too. Anyway, I let it as it (25). Just let the server running for a while and I will post the result this night. Regards JC
  17. C

    Problem of performance with mailwizz

    Hi, I tried with the percona configuration but the result is worst ! I tried also with innodb_log_file_size 1/4 of innodb_buffer_pool_size wait_timeout = innodb_lock_wait_timeout = 1000 but the query are always very slow... Here is the my.cnf configuration: [mysqld] bind-address...
  18. C

    Problem of performance with mailwizz

    OK, I just change the settings and restart mysqld I let the server running for a while and be back as soon as possible
  19. C

    Problem of performance with mailwizz

    innodb_log_file_size = 50331648 (48M) max_heap_table_size = 536870912 (512M) tmp_table_size = 536870912 (512M) wait_timeout = 1800 innodb_lock_wait_timeout = 50
  20. C

    Problem of performance with mailwizz

    yes, already done ! innodb_file_per_table = 1 innodb_buffer_pool_size = 25GB innodb_buffer_pool_instances = 25 innodb_log_buffer_size = 16M innodb_flush_log_at_trx_commit = 0
Back
Top