# Uh oh! I think I broke it. If I do it again, please report me to the system administrator

**URL:** <https://forum.mautic.org/t/uh-oh-i-think-i-broke-it-if-i-do-it-again-please-report-me-to-the-system-administrator/18380>\
**Category:** Product Support\
**Created:** [March 2, 2021, 3:55am UTC](https://forum.mautic.org/t/uh-oh-i-think-i-broke-it-if-i-do-it-again-please-report-me-to-the-system-administrator/18380 "2021-03-02T03:55:56Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![punctual](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/punctual/32/1445_2.png) [@punctual](https://forum.mautic.org/u/punctual)\
**Post date:** [March 2, 2021, 3:55am UTC](https://forum.mautic.org/t/uh-oh-i-think-i-broke-it-if-i-do-it-again-please-report-me-to-the-system-administrator/18380/1 "2021-03-02T03:55:56Z")

</div>

**Your software**  
My Mautic version is: 3,2  
My PHP version is:7.3.27  
My Database type and version is:

**Your problem**  
My problem is:  
have i created a text message under channels, and trying to send it out, i got this message Uh oh! I think I broke it. If I do it again, please report me to the system administrator

These errors are showing in the log:

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 maupn\_lead\_lists ll ON ll.id = sml.leadlist\_id and ll.is\_published = 1 INNER JOIN maupn\_lead\_lists\_leads lll ON lll.leadlist\_id = sml.leadlist\_id and lll.manually\_removed = 0 INNER JOIN maupn\_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 maupn\_sms\_message\_stats stat WHERE (stat.lead\_id = l.id) AND (stat.sms\_id = 1))) AND (NOT EXISTS (SELECT null FROM maupn\_lead\_donotcontact dnc WHERE (dnc.lead\_id = l.id) AND (dnc.channel = ‘sms’))) AND (NOT EXISTS (SELECT null FROM maupn\_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]: Table ‘timodoyn\_maut580.sms\_message\_list\_xref’ doesn’t exist” at /home1/timodoyn/public\_html/mautic/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 maupn\_lead\_lists ll ON ll.id = sml.leadlist\_id and ll.is\_published = 1 INNER JOIN maupn\_lead\_lists\_leads lll ON lll.leadlist\_id = sml.leadlist\_id and lll.manually\_removed = 0 INNER JOIN maupn\_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 maupn\_sms\_message\_stats stat WHERE (stat.lead\_id = l.id) AND (stat.sms\_id = 1))) AND (NOT EXISTS (SELECT null FROM maupn\_lead\_donotcontact dnc WHERE (dnc.lead\_id = l.id) AND (dnc.channel = ‘sms’))) AND (NOT EXISTS (SELECT null FROM maupn\_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\nTable ‘timodoyn\_maut580.sms\_message\_list\_xref’ doesn’t exist at /home1/timodoyn/public\_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:42, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Table ‘timodoyn\_maut580.sms\_message\_list\_xref’ doesn’t exist at /home1/timodoyn/public\_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:86)"}

Steps I have tried to fix the problem:

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [March 2, 2021, 6:05am UTC](https://forum.mautic.org/t/uh-oh-i-think-i-broke-it-if-i-do-it-again-please-report-me-to-the-system-administrator/18380/2 "2021-03-02T06:05:10Z")

</div>

Do you have links in your sms?

---

<div class="post-metadata">

**Author:** ![puneetsethi25](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/puneetsethi25/32/1128_2.png) [@puneetsethi25](https://forum.mautic.org/u/puneetsethi25)\
**Post date:** [March 20, 2021, 9:50am UTC](https://forum.mautic.org/t/uh-oh-i-think-i-broke-it-if-i-do-it-again-please-report-me-to-the-system-administrator/18380/3 "2021-03-20T09:50:14Z")

</div>

> [@punctual](#):
>
> sms\_message\_list\_xref

I have the same problem. i updated mautic:  
Mautic: 3.3.1  
PHP: 7.4.1

Errors: [2021-03-20 07:38:39] 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 whm\_lead\_lists ll ON ll.id = sml.leadlist\_id and ll.is\_published = 1 INNER JOIN whm\_lead\_lists\_leads lll ON lll.leadlist\_id = sml.leadlist\_id and lll.manually\_removed = 0 INNER JOIN whm\_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 whm\_sms\_message\_stats stat WHERE (stat.lead\_id = l.id) AND (stat.sms\_id = 1))) AND (NOT EXISTS (SELECT null FROM whm\_lead\_donotcontact dnc WHERE (dnc.lead\_id = l.id) AND (dnc.channel = ‘sms’))) AND (NOT EXISTS (SELECT null FROM whm\_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 ‘whm\_siemens.sms\_message\_list\_xref’ doesn’t exist” at /Users/puneetsethi/Downloads/development/willhire.co/mautic/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 whm\_lead\_lists ll ON ll.id = sml.leadlist\_id and ll.is\_published = 1 INNER JOIN whm\_lead\_lists\_leads lll ON lll.leadlist\_id = sml.leadlist\_id and lll.manually\_removed = 0 INNER JOIN whm\_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 whm\_sms\_message\_stats stat WHERE (stat.lead\_id = l.id) AND (stat.sms\_id = 1))) AND (NOT EXISTS (SELECT null FROM whm\_lead\_donotcontact dnc WHERE (dnc.lead\_id = l.id) AND (dnc.channel = ‘sms’))) AND (NOT EXISTS (SELECT null FROM whm\_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 ‘whm\_siemens.sms\_message\_list\_xref’ doesn’t exist at /Users/puneetsethi/Downloads/development/willhire.co/mautic/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 ‘whm\_siemens.sms\_message\_list\_xref’ doesn’t exist at /Users/puneetsethi/Downloads/development/willhire.co/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:123, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘whm\_siemens.sms\_message\_list\_xref’ doesn’t exist at /Users/puneetsethi/Downloads/development/willhire.co/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:121)”}

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [March 20, 2021, 10:45am UTC](https://forum.mautic.org/t/uh-oh-i-think-i-broke-it-if-i-do-it-again-please-report-me-to-the-system-administrator/18380/4 "2021-03-20T10:45:47Z")

</div>

Do you have links in your sms?

---

<div class="post-metadata">

**Author:** ![puneetsethi25](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/puneetsethi25/32/1128_2.png) [@puneetsethi25](https://forum.mautic.org/u/puneetsethi25)\
**Post date:** [March 20, 2021, 10:57am UTC](https://forum.mautic.org/t/uh-oh-i-think-i-broke-it-if-i-do-it-again-please-report-me-to-the-system-administrator/18380/5 "2021-03-20T10:57:52Z")

</div>

@joeyk yes I do have links. Does it matter?

---

<div class="post-metadata">

**Author:** ![puneetsethi25](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/puneetsethi25/32/1128_2.png) [@puneetsethi25](https://forum.mautic.org/u/puneetsethi25)\
**Post date:** [March 20, 2021, 3:55pm UTC](https://forum.mautic.org/t/uh-oh-i-think-i-broke-it-if-i-do-it-again-please-report-me-to-the-system-administrator/18380/6 "2021-03-20T15:55:27Z")

</div>

@joeyk can you help me on this. Is this because there’s a link in the SMS. I think this is only with latest version.

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [March 22, 2021, 8:38am UTC](https://forum.mautic.org/t/uh-oh-i-think-i-broke-it-if-i-do-it-again-please-report-me-to-the-system-administrator/18380/7 "2021-03-22T08:38:07Z")

</div>

Are you Text Message settings set up okay? Did you turn off URL tracking in SMS?

---

<div class="post-metadata">

**Author:** ![puneetsethi25](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/puneetsethi25/32/1128_2.png) [@puneetsethi25](https://forum.mautic.org/u/puneetsethi25)\
**Post date:** [April 16, 2021, 6:45pm UTC](https://forum.mautic.org/t/uh-oh-i-think-i-broke-it-if-i-do-it-again-please-report-me-to-the-system-administrator/18380/8 "2021-04-16T18:45:14Z")

</div>

@joeyk I Fixed it. I should have noticed that earlier. If you look in the query result - TABLE\_PREFIX is not appended in this table name - “sms\_message\_list\_xref” but its appended with the other table names

---

<div class="post-metadata">

**Author:** ![puneetsethi25](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/puneetsethi25/32/1128_2.png) [@puneetsethi25](https://forum.mautic.org/u/puneetsethi25)\
**Post date:** [April 16, 2021, 6:46pm UTC](https://forum.mautic.org/t/uh-oh-i-think-i-broke-it-if-i-do-it-again-please-report-me-to-the-system-administrator/18380/9 "2021-04-16T18:46:58Z")

</div>

i think dev team should this fix deployed asap.

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [April 18, 2021, 3:30pm UTC](https://forum.mautic.org/t/uh-oh-i-think-i-broke-it-if-i-do-it-again-please-report-me-to-the-system-administrator/18380/10 "2021-04-18T15:30:53Z")

</div>

Could you plz share the changes you did? Maybe even submit a PR?  
Thx