# Text Messages In Mautic
**URL:** https://forum.mautic.org/t/text-messages-in-mautic/20271
**Category:** General Discussion
**Created:** [July 26, 2021, 2:41am UTC](https://forum.mautic.org/t/text-messages-in-mautic/20271 "2021-07-26T02:41:45Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@aquib](https://forum.mautic.org/u/aquib)
#### Post date: [July 26, 2021, 2:41am UTC](https://forum.mautic.org/t/text-messages-in-mautic/20271/1 "2021-07-26T02:41:45Z")
My Mautic Shows This Error Whenever I Clicks On Text Message Section In Mautic.
I Have Already Configured Twilio Plugin With Mautic.
Can Anyone Help Me In This Error.
---
### Author:  [@joeyk](https://forum.mautic.org/u/joeyk)
#### Post date: [July 26, 2021, 10:01am UTC](https://forum.mautic.org/t/text-messages-in-mautic/20271/2 "2021-07-26T10:01:59Z")
Can you plz check Config - System Info - Log
What do you see there?
---
### Author:  [@aquib](https://forum.mautic.org/u/aquib)
#### Post date: [July 26, 2021, 12:02pm UTC](https://forum.mautic.org/t/text-messages-in-mautic/20271/3 "2021-07-26T12:02:10Z")
[2021-07-26 17:31:06] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\TableNotFoundException: “An exception occurred while executing ‘SELECT COUNT(DISTINCT l.id) FROM sms\_message\_list\_xref sml INNER JOIN ma\_lead\_lists ll ON ll.id = sml.leadlist\_id and ll.is\_published = 1 INNER JOIN ma\_lead\_lists\_leads lll ON lll.leadlist\_id = sml.leadlist\_id and lll.manually\_removed = 0 INNER JOIN ma\_leads l ON lll.lead\_id = l.id WHERE (sml.sms\_id = ?) AND (((l.mobile IS NOT NULL) OR (l.mobile \<\> ‘’)) OR ((l.phone IS NOT NULL) OR (l.phone \<\> ‘’))) AND (NOT EXISTS (SELECT null FROM ma\_sms\_message\_stats stat WHERE (stat.lead\_id = l.id) AND (stat.sms\_id = 1))) AND (NOT EXISTS (SELECT null FROM ma\_lead\_donotcontact dnc WHERE (dnc.lead\_id = l.id) AND (dnc.channel = ‘sms’))) AND (NOT EXISTS (SELECT null FROM ma\_message\_queue mq WHERE (mq.lead\_id = l.id) AND (mq.status \<\> ‘sent’) AND (mq.channel = ‘sms’))) ORDER BY lll.lead\_id ASC’ with params [1]: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘bitnami\_mautic.sms\_message\_list\_xref’ doesn’t exist” at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 42 {“exception”:"[object] (Doctrine\DBAL\Exception\TableNotFoundException(code: 0): An exception occurred while executing ‘SELECT COUNT(DISTINCT l.id) FROM sms\_message\_list\_xref sml INNER JOIN ma\_lead\_lists ll ON ll.id = sml.leadlist\_id and ll.is\_published = 1 INNER JOIN ma\_lead\_lists\_leads lll ON lll.leadlist\_id = sml.leadlist\_id and lll.manually\_removed = 0 INNER JOIN ma\_leads l ON lll.lead\_id = l.id WHERE (sml.sms\_id = ?) AND (((l.mobile IS NOT NULL) OR (l.mobile \<\> ‘’)) OR ((l.phone IS NOT NULL) OR (l.phone \<\> ‘’))) AND (NOT EXISTS (SELECT null FROM ma\_sms\_message\_stats stat WHERE (stat.lead\_id = l.id) AND (stat.sms\_id = 1))) AND (NOT EXISTS (SELECT null FROM ma\_lead\_donotcontact dnc WHERE (dnc.lead\_id = l.id) AND (dnc.channel = ‘sms’))) AND (NOT EXISTS (SELECT null FROM ma\_message\_queue mq WHERE (mq.lead\_id = l.id) AND (mq.status \<\> ‘sent’) AND (mq.channel = ‘sms’))) ORDER BY lll.lead\_id ASC’ with params [1]:\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table ‘bitnami\_mautic.sms\_message\_list\_xref’ doesn’t exist at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:42, Doctrine\DBAL\Driver\PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘bitnami\_mautic.sms\_message\_list\_xref’ doesn’t exist at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:123, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘bitnami\_mautic.sms\_message\_list\_xref’ doesn’t exist at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:121)"}
---
### Author:  [@joeyk](https://forum.mautic.org/u/joeyk)
#### Post date: [July 26, 2021, 12:03pm UTC](https://forum.mautic.org/t/text-messages-in-mautic/20271/4 "2021-07-26T12:03:43Z")
Hi,
This is a known bug, its solved here:
> [@Configuration Page & SMS Channel cannot be accessed after SMS segment message created](https://forum.mautic.org/t/configuration-page-sms-channel-cannot-be-accessed-after-sms-segment-message-created/17453/9):
>
> I just want to concur that I had what seems like the exact same situation, using Mautic v3.3.1. Having a wrong host entered into a configuration field completely hung the entire configuration part of Mautic. Thanks to this post from EJL, I realized what it was. I had mistyped my host address for my monitored email. It was never able to connect, which I guess Mautic tries to do each time before it displays the configuration menu. I had to fix the error directly in the app/config/local.php. …
Good luck!
---
### Author:  [@aquib](https://forum.mautic.org/u/aquib)
#### Post date: [July 27, 2021, 2:09am UTC](https://forum.mautic.org/t/text-messages-in-mautic/20271/5 "2021-07-27T02:09:30Z")
Really Sorry But I’m Not Able To Understand What To Do To Solve This Issue …
---
### Author:  [@joeyk](https://forum.mautic.org/u/joeyk)
#### Post date: [July 27, 2021, 6:09am UTC](https://forum.mautic.org/t/text-messages-in-mautic/20271/6 "2021-07-27T06:09:08Z")
Hi,
Yeah, I’m sorry too. Sometimes there bugs in Mautic that need a bit of massaging in the code.
Most of the bugs are fixed pronto. Bitnami installs are not the most stable ones, and it seems you ran into an issue.
These are your options:
1. Find someone who can fix it for you → check the other thread
2. You read more and fix it for yourself
---
### Author:  [@aquib](https://forum.mautic.org/u/aquib)
#### Post date: [July 27, 2021, 9:39am UTC](https://forum.mautic.org/t/text-messages-in-mautic/20271/7 "2021-07-27T09:39:19Z")
Ok…
And Thank You For The Help. Actually I’m New To Mautic.
Also Can I Ask You one More Query In This Thread Regarding Mautic Or Do I Have To Create New Topic.
---
### Author:  [@joeyk](https://forum.mautic.org/u/joeyk)
#### Post date: [July 27, 2021, 11:45am UTC](https://forum.mautic.org/t/text-messages-in-mautic/20271/8 "2021-07-27T11:45:40Z")
If it’s another subject maybe better to start another topic. 🙂
---
### Author:  [@aquib](https://forum.mautic.org/u/aquib)
#### Post date: [July 27, 2021, 11:58am UTC](https://forum.mautic.org/t/text-messages-in-mautic/20271/9 "2021-07-27T11:58:18Z")
Sure.
No problem… 🙂