# Segment not working **URL:** \ **Category:** Product Support\ **Created:** [February 1, 2021, 11:55am UTC](https://forum.mautic.org/t/segment-not-working/17977 "2021-02-01T11:55:15Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![enricosigurta](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/enricosigurta/32/3676_2.png) [@enricosigurta](https://forum.mautic.org/u/enricosigurta)\ **Post date:** [February 1, 2021, 11:55am UTC](https://forum.mautic.org/t/segment-not-working/17977/1 "2021-02-01T11:55:16Z")
**Your software** My Mautic version is: 3.2.4 My PHP version is: 7.2 My Database type and version is: I don’t know **Your problem** My problem is: I set up a simple segment rule: when a contact has an empty stage, add to segment. However, it’s not working. I already set up the corn (and, from the mails I’m receiving, everything seems fine). What might be the issue? These errors are showing in the log (I don’t know if they are related): [2021-02-01 10:45:38] mautic.WARNING: PHP Warning - mysqli\_stmt::bind\_result(): Server returned unknown type 245. Probably your client library is incompatible with the server version you use! - in file /home/wbintern/public\_html/wnbigroup.com/crm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php - at line 197 {“params”:null,“meta”:"[object] (mysqli\_result: {“current\_field”:null,“field\_count”:null,“lengths”:null,“num\_rows”:null,“type”:null})",“fields”:["[object] (stdClass: {“name”:“is\_published\_0”,“orgname”:“is\_published”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:1,“charsetnr”:63,“flags”:36865,“type”:1,“decimals”:0})","[object] (stdClass: {“name”:“date\_added\_1”,“orgname”:“date\_added”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:19,“charsetnr”:63,“flags”:128,“type”:12,“decimals”:0})","[object] (stdClass: {“name”:“created\_by\_2”,“orgname”:“created\_by”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:11,“charsetnr”:63,“flags”:32768,“type”:3,“decimals”:0})","[object] (stdClass: {“name”:“created\_by\_user\_3”,“orgname”:“created\_by\_user”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:764,“charsetnr”:45,“flags”:0,“type”:253,“decimals”:0})","[object] (stdClass: {“name”:“date\_modified\_4”,“orgname”:“date\_modified”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:19,“charsetnr”:63,“flags”:128,“type”:12,“decimals”:0})","[object] (stdClass: {“name”:“modified\_by\_5”,“orgname”:“modified\_by”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:11,“charsetnr”:63,“flags”:32768,“type”:3,“decimals”:0})","[object] (stdClass: {“name”:“modified\_by\_user\_6”,“orgname”:“modified\_by\_user”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:764,“charsetnr”:45,“flags”:0,“type”:253,“decimals”:0})","[object] (stdClass: {“name”:“checked\_out\_7”,“orgname”:“checked\_out”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:19,“charsetnr”:63,“flags”:128,“type”:12,“decimals”:0})","[object] (stdClass: {“name”:“checked\_out\_by\_8”,“orgname”:“checked\_out\_by”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:11,“charsetnr”:63,“flags”:32768,“type”:3,“decimals”:0})","[object] (stdClass: {“name”:“checked\_out\_by\_user\_9”,“orgname”:“checked\_out\_by\_user”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:764,“charsetnr”:45,“flags”:0,“type”:253,“decimals”:0})","[object] (stdClass: {“name”:“id\_10”,“orgname”:“id”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:10,“charsetnr”:63,“flags”:49699,“type”:3,“decimals”:0})","[object] (stdClass: {“name”:“name\_11”,“orgname”:“name”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:764,“charsetnr”:45,“flags”:4097,“type”:253,“decimals”:0})","[object] (stdClass: {“name”:“description\_12”,“orgname”:“description”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:4294967295,“charsetnr”:45,“flags”:16,“type”:252,“decimals”:0})","[object] (stdClass: {“name”:“subject\_13”,“orgname”:“subject”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:4294967295,“charsetnr”:45,“flags”:16,“type”:252,“decimals”:0})","[object] (stdClass: {“name”:“from\_address\_14”,“orgname”:“from\_address”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:764,“charsetnr”:45,“flags”:0,“type”:253,“decimals”:0})","[object] (stdClass: {“name”:“from\_name\_15”,“orgname”:“from\_name”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:764,“charsetnr”:45,“flags”:0,“type”:253,“decimals”:0})","[object] (stdClass: {“name”:“reply\_to\_address\_16”,“orgname”:“reply\_to\_address”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:764,“charsetnr”:45,“flags”:0,“type”:253,“decimals”:0})","[object] (stdClass: {“name”:“bcc\_address\_17”,“orgname”:“bcc\_address”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:764,“charsetnr”:45,“flags”:0,“type”:253,“decimals”:0})","[object] (stdClass: {“name”:“template\_18”,“orgname”:“template”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:764,“charsetnr”:45,“flags”:0,“type”:253,“decimals”:0})","[object] (stdClass: {“name”:“content\_19”,“orgname”:“content”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:4294967295,“charsetnr”:45,“flags”:16,“type”:252,“decimals”:0})","[object] (stdClass: {“name”:“utm\_tags\_20”,“orgname”:“utm\_tags”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:4294967295,“charsetnr”:45,“flags”:16,“type”:252,“decimals”:0})","[object] (stdClass: {“name”:“plain\_text\_21”,“orgname”:“plain\_text”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:4294967295,“charsetnr”:45,“flags”:16,“type”:252,“decimals”:0})","[object] (stdClass: {“name”:“custom\_html\_22”,“orgname”:“custom\_html”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:4294967295,“charsetnr”:45,“flags”:16,“type”:252,“decimals”:0})","[object] (stdClass: {“name”:“email\_type\_23”,“orgname”:“email\_type”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:4294967295,“charsetnr”:45,“flags”:16,“type”:252,“decimals”:0})","[object] (stdClass: {“name”:“publish\_up\_24”,“orgname”:“publish\_up”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:19,“charsetnr”:63,“flags”:128,“type”:12,“decimals”:0})","[object] (stdClass: {“name”:“publish\_down\_25”,“orgname”:“publish\_down”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:19,“charsetnr”:63,“flags”:128,“type”:12,“decimals”:0})","[object] (stdClass: {“name”:“read\_count\_26”,“orgname”:“read\_count”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:11,“charsetnr”:63,“flags”:36865,“type”:3,“decimals”:0})","[object] (stdClass: {“name”:“sent\_count\_27”,“orgname”:“sent\_count”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:11,“charsetnr”:63,“flags”:36865,“type”:3,“decimals”:0})","[object] (stdClass: {“name”:“variant\_sent\_count\_28”,“orgname”:“variant\_sent\_count”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:11,“charsetnr”:63,“flags”:36865,“type”:3,“decimals”:0})","[object] (stdClass: {“name”:“variant\_read\_count\_29”,“orgname”:“variant\_read\_count”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:11,“charsetnr”:63,“flags”:36865,“type”:3,“decimals”:0})","[object] (stdClass: {“name”:“revision\_30”,“orgname”:“revision”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:11,“charsetnr”:63,“flags”:36865,“type”:3,“decimals”:0})","[object] (stdClass: {“name”:“lang\_31”,“orgname”:“lang”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:764,“charsetnr”:45,“flags”:4097,“type”:253,“decimals”:0})","[object] (stdClass: {“name”:“variant\_settings\_32”,“orgname”:“variant\_settings”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:4294967295,“charsetnr”:45,“flags”:16,“type”:252,“decimals”:0})","[object] (stdClass: {“name”:“variant\_start\_date\_33”,“orgname”:“variant\_start\_date”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:19,“charsetnr”:63,“flags”:128,“type”:12,“decimals”:0})","[object] (stdClass: {“name”:“dynamic\_content\_34”,“orgname”:“dynamic\_content”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:4294967295,“charsetnr”:45,“flags”:16,“type”:252,“decimals”:0})","[object] (stdClass: {“name”:“headers\_35”,“orgname”:“headers”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:4294967295,“charsetnr”:63,“flags”:4241,“type”:245,“decimals”:0})","[object] (stdClass: {“name”:“public\_preview\_36”,“orgname”:“public\_preview”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:1,“charsetnr”:63,“flags”:32768,“type”:1,“decimals”:0})","[object] (stdClass: {“name”:“category\_id\_37”,“orgname”:“category\_id”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:10,“charsetnr”:63,“flags”:49192,“type”:3,“decimals”:0})","[object] (stdClass: {“name”:“translation\_parent\_id\_38”,“orgname”:“translation\_parent\_id”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:10,“charsetnr”:63,“flags”:49192,“type”:3,“decimals”:0})","[object] (stdClass: {“name”:“variant\_parent\_id\_39”,“orgname”:“variant\_parent\_id”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:10,“charsetnr”:63,“flags”:49192,“type”:3,“decimals”:0})","[object] (stdClass: {“name”:“unsubscribeform\_id\_40”,“orgname”:“unsubscribeform\_id”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:10,“charsetnr”:63,“flags”:49192,“type”:3,“decimals”:0})","[object] (stdClass: {“name”:“preference\_center\_id\_41”,“orgname”:“preference\_center\_id”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:10,“charsetnr”:63,“flags”:49192,“type”:3,“decimals”:0})"],“columnNames”:[“is\_published\_0”,“date\_added\_1”,“created\_by\_2”,“created\_by\_user\_3”,“date\_modified\_4”,“modified\_by\_5”,“modified\_by\_user\_6”,“checked\_out\_7”,“checked\_out\_by\_8”,“checked\_out\_by\_user\_9”,“id\_10”,“name\_11”,“description\_12”,“subject\_13”,“from\_address\_14”,“from\_name\_15”,“reply\_to\_address\_16”,“bcc\_address\_17”,“template\_18”,“content\_19”,“utm\_tags\_20”,“plain\_text\_21”,“custom\_html\_22”,“email\_type\_23”,“publish\_up\_24”,“publish\_down\_25”,“read\_count\_26”,“sent\_count\_27”,“variant\_sent\_count\_28”,“variant\_read\_count\_29”,“revision\_30”,“lang\_31”,“variant\_settings\_32”,“variant\_start\_date\_33”,“dynamic\_content\_34”,“headers\_35”,“public\_preview\_36”,“category\_id\_37”,“translation\_parent\_id\_38”,“variant\_parent\_id\_39”,“unsubscribeform\_id\_40”,“preference\_center\_id\_41”],“col”:"[object] (stdClass: {“name”:“preference\_center\_id\_41”,“orgname”:“preference\_center\_id”,“table”:“m0\_”,“orgtable”:“maunu\_emails”,“def”:"",“db”:“wbintern\_maut703”,“catalog”:“def”,“max\_length”:0,“length”:10,“charsetnr”:63,“flags”:49192,“type”:3,“decimals”:0})",“refs”:[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],“value”:null,“key”:41} ---
**Author:** ![EJL](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ejl/32/12155_2.png) [@EJL](https://forum.mautic.org/u/EJL)\ **Post date:** [February 1, 2021, 3:01pm UTC](https://forum.mautic.org/t/segment-not-working/17977/2 "2021-02-01T15:01:57Z")
your/mautic/app/config/local.php ![Screenshot_2021-02-01 local](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/3/3c9ef4bf6db35f1803e7ef81f3480a6629d52f50.png) change line 3 to **'pdo\_mysql’** you may also need to run **doctrine:schema:validate** to see if you have an issue ---
**Author:** ![enricosigurta](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/enricosigurta/32/3676_2.png) [@enricosigurta](https://forum.mautic.org/u/enricosigurta)\ **Post date:** [February 1, 2021, 4:09pm UTC](https://forum.mautic.org/t/segment-not-working/17977/3 "2021-02-01T16:09:05Z")
Thank you @EJL🙂 the logs stopped giving any error after the modification you recommended. However, the segment is still not working. I tried creating a new one, aiming at the contact’s country, but still, it gives no contact (and it should give a few of them) ---
**Author:** ![EJL](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ejl/32/12155_2.png) [@EJL](https://forum.mautic.org/u/EJL)\ **Post date:** [February 1, 2021, 4:12pm UTC](https://forum.mautic.org/t/segment-not-working/17977/4 "2021-02-01T16:12:44Z")
Well thats half the problem solved. Are you running **mautic:segments:update** to effect these changes in segments. You must do so in order to update the segments. ---
**Author:** ![enricosigurta](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/enricosigurta/32/3676_2.png) [@enricosigurta](https://forum.mautic.org/u/enricosigurta)\ **Post date:** [February 1, 2021, 4:21pm UTC](https://forum.mautic.org/t/segment-not-working/17977/5 "2021-02-01T16:21:17Z")
It’s running via Cron every 5 minutes. From the messages CPanel is sending me, it seems that the cron is working just fine. Is there a way to see if there’s an issue? Or a way to run it manually? ---
**Author:** ![EJL](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ejl/32/12155_2.png) [@EJL](https://forum.mautic.org/u/EJL)\ **Post date:** [February 1, 2021, 4:27pm UTC](https://forum.mautic.org/t/segment-not-working/17977/6 "2021-02-01T16:27:00Z")
yes. run the command via ssh. add -vvv to the end to see debug level logging ---
**Author:** ![enricosigurta](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/enricosigurta/32/3676_2.png) [@enricosigurta](https://forum.mautic.org/u/enricosigurta)\ **Post date:** [February 2, 2021, 10:21am UTC](https://forum.mautic.org/t/segment-not-working/17977/7 "2021-02-02T10:21:56Z")
Hi @EJL , thank you very much 🙂 It worked perfectly. What do you recommend now? Do I add the -vvv to the corn job as well, or now it should work normally? Thank you 🙂 ---
**Author:** ![EJL](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ejl/32/12155_2.png) [@EJL](https://forum.mautic.org/u/EJL)\ **Post date:** [February 2, 2021, 3:05pm UTC](https://forum.mautic.org/t/segment-not-working/17977/8 "2021-02-02T15:05:37Z")
I only use -vvv when i’m running commands manually via SSH. If everything is working properly there is no need to add it to your cron jobs.