Base table or view not found: 1146 Table 'mailing.maulead_fields' doesn't exist

Product Support
1

Your software
My Mautic version is: 2.16.1
My PHP version is: 7.2.24

Your problem
My problem is:
The Campaign e-mails are not sent. The campaign has started, but it only changed a state and stopped on e-mail Send step.

These errors are showing in the log:
[2020-04-08 09:20:40] mautic.NOTICE: Doctrine\DBAL\Exception\ConnectionException: An exception occurred while executing ‘SELECT c0_.is_published AS is_published_0, c0_.date_added AS date_added_1, c0_.created_by AS created_by_2, c0_.created_by_user AS created_by_user_3, c0_.date_modified AS date_modified_4, c0_.modified_by AS modified_by_5, c0_.modified_by_user AS modified_by_user_6, c0_.checked_out AS checked_out_7, c0_.checked_out_by AS checked_out_by_8, c0_.checked_out_by_user AS checked_out_by_user_9, c0_.id AS id_10, c0_.name AS name_11, c0_.description AS description_12, c0_.publish_up AS publish_up_13, c0_.publish_down AS publish_down_14, c0_.canvas_settings AS canvas_settings_15, c0_.allow_restart AS allow_restart_16, c1_.is_published AS is_published_17, c1_.date_added AS date_added_18, c1_.created_by AS created_by_19, c1_.created_by_user AS created_by_user_20, c1_.date_modified AS date_modified_21, c1_.modified_by AS modified_by_22, c1_.modified_by_user AS modified_by_user_23, c1_.checked_out AS checked_out_24, c1_.checked_out_by AS checked_out_by_25, c1_.checked_out_by_user AS checked_out_by_user_26, c1_.id AS id_27, c1_.title AS title_28, c1_.description AS description_29, c1_.alias AS alias_30, c1_.color AS color_31, c1_.bundle AS bundle_32, c0_.category_id AS category_id_33 FROM campaigns c0_ LEFT JOIN categories c1_ ON c0_.category_id = c1_.id’: SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected (uncaught exception) at /home/kfam/domains/mailing.kfam.pl/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 103 while running console command mautic:campaigns:rebuild
[2020-04-08 09:21:26] mautic.ERROR: SCHEMA ERROR: An exception occurred while executing ‘SELECT f.alias, f.is_unique_identifer as is_unique, f.type, f.object FROM maulead_fields f WHERE f.object = ‘lead’ ORDER BY f.field_order ASC’: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘mailing.maulead_fields’ doesn’t exist
[2020-04-08 10:00:02] mautic.WARNING: MaxMind license key is required.
[2020-04-08 10:00:02] mautic.ERROR: Failed to fetch remote IP data: malformed

Steps I have tried to fix the problem:
I’ve updated the campaigns, as well as segments but it dont helps while the db is malformed.

2

Hi,

Have you tried this
http://[your-mautic-url]/s/update/schema
From the troubleshooting page
Make a backup of the dB first just in case :slight_smile:
By they way this url doesn’t give much feedback just be patient and let it run :slightly_smiling_face:

1 Like
3

Yes I’ve tried this as well as all the remaining ‘magic’ found in the installation and troubleshooting in the docs.
Still the campaign doesn’t go further.
If you wish we can try to look on it together via webex or skype live, so maybe its some stupidity, that I’ve set.