# Issue after restore Database in mautic **URL:** \ **Category:** Product Support\ **Created:** [June 2, 2021, 9:09am UTC](https://forum.mautic.org/t/issue-after-restore-database-in-mautic/19706 "2021-06-02T09:09:52Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![nataly](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/nataly/32/441_2.png) [@nataly](https://forum.mautic.org/u/nataly)\ **Post date:** [June 2, 2021, 9:09am UTC](https://forum.mautic.org/t/issue-after-restore-database-in-mautic/19706/1 "2021-06-02T09:09:52Z")
**Your software** My Mautic version is: 3.3.1 My PHP version is: 7.3.27 My Database type and version is: Mysql Ver 8.0.23 for Linux on x86\_64 I have problems showing all the data after importing from Mautic version 2.0.1-1 These errors are showing in the log: ated\_by\_2, m0\_.created\_by\_user AS created\_by\_user\_3, m0\_.date\_modified AS date\_modified\_4, m0\_.modified\_by AS\_Modified\_by\_che0, m0\_.modified\_by modified\_userche0\_4, m0\_.modified\_by Modified\_userchecked\_06, m0\_.modified\_by Modified\_userche06, m0\_.modified\_by Modified\_userche0\_4, m0\_.modified\_by Modified\_userche0\_4, m0\_.modified\_by Modified\_user\_checked06, m0\_.modified\_by Modified\_userche0\_4, m0\_.modified\_by Modified\_userche0\_4, m0\_.modified\_by Modified\_userche0\_4, m0\_.modified\_outcked\_by\_usercked.m0\_cked. AS checked\_out\_by\_8, m0\_.checked\_out\_by\_user AS checked\_out\_by\_user\_9, m0\_.id AS id\_10, m0\_.name AS name\_11, m0\_.description AS description\_12, m0\_.type AS type\_13, m0\_.publish\_up AS publish\_up\_down\_14, m0\_.publish\_uptable publish\_up\_down\_down\_16.publish\_peatable publish\_up\_down\_16, m0\_15.publish table publish\_up\_down\_down\_16 , m0\_.delta AS delta\_17, m0\_.properties AS properties\_18, m1\_.is\_published AS is\_published\_19, m1\_.date\_added AS date\_added\_20, m1\_.created\_by AS created\_by\_21, m1\_.created\_by\_user AS created\_by\_use r\_22, m1\_.date\_modified AS date\_modified\_23, m1\_.modified\_by AS modified\_by\_24, m1\_.modified\_by\_user AS modified\_by\_user\_25, m1\_.checked\_out AS checked\_out\_26, m1\_.checked\_out\_by AS checked\_out\_by\_27, m1\_.byuser\_29\_userid\_title\_out1, m1\_.checked\_userid\_title\_out1\_27, m1\_. m1\_.description AS description\_31, m1\_.alias AS alias\_32, m1\_.color AS color\_33, m1\_.bundle AS bundle\_34 FROM ma\_points m0\_ LEFT JOIN ma\_categories m1\_ ON m0\_.category\_id = m1\_.id ORDER BY m0\_.name ASC) dctrn\_restable BY m0\_.name ASC) dctrn\_restable ') dctrn\_restable BY m0\_.name ASC) SQLSTATE [42S22]: Column not found: 1054 Unknown column ‘m0\_.repeatable’ in ‘field list’ "at / opt / bitnami / apps / mautic / htdocs / vendor / doctrine / dbal / lib / Doctrine / DBAL / Driver / AbstractMySQLDriver .php line 60 {“exception”: "[object] (Doctrine \ DBAL \ Exception \ InvalidFieldNameException (code: 0): An exception occurred while executing 'SELECT COUNT (\*) AS dctrn\_count FROM (SELECT DISTINCT id\_10 FROM ( SELECT m0\_.is\_published AS is\_published\_0, m0\_.date\_added AS date\_added\_1, m0\_.crea ted\_by AS created\_by\_2, m0\_.created\_by\_user AS created\_by\_user\_3, m0\_.date\_modified AS date\_modified\_4, m0\_.modified\_by AS modified\_by\_5, m0\_.modified\_by\_user AS modified\_by\_user\_6, m0\_.checked\_out\_out AS checked\_out\_by\_user08, m0\_.checked\_out\_out\_user\_by\_checked\_by\_user08, m0\_.checked\_out\_out\_user\_by\_check08, m0\_.checkedout\_out\_user\_by\_byuser\_06, m0\_.checkedout\_out\_user\_by\_check\_out\_by\_user06, m0\_.checkedout\_out\_user\_by\_checked\_byuser08, m0\_.checked\_out\_user\_out\_by\_byuser\_06, m0\_.checkedout\_out\_user\_by\_check08\_byuser06, m0\_. id\_10, m0\_.name AS name\_11, m0\_.description AS description\_12, m0\_.type AS type\_13, m0\_.publish\_up AS publish\_up\_14, m0\_.publish\_down AS publish\_down\_15, m0\_.repeatable AS repeatable\_16, m0\_. m1\_.is\_published AS is\_published\_19, m1\_.date\_added AS date\_added\_20, m1\_.created\_by AS created\_by\_21, m1\_.created\_by\_user AS created\_by\_user\_22, m1\_.date\_modified AS date\_modified\_23, m1\_.musercked\_24\_by modified\_out1\_.muserche2\_by modified\_by1\_modified\_by1 modified\_2, musercked\_25\_by\_modified\_25, m1\_.musercked\_by\_25 modified\_by1\_modified\_by1\_modified\_by1\_2 modified\_by1\_modified\_25, m1\_.musercked\_24\_by\_modified\_23, m1\_.musercked. checked\_out\_by AS checked\_out\_by\_27, m1\_.checked\_out\_by\_user AS checked\_out\_by\_user\_28, m1\_.id AS id\_29, m1\_.title AS title\_30, m1\_.descr iption AS description\_31, m1\_.alias AS alias\_32, m1\_.color AS color\_33, m1\_.bundle AS bundle\_34 FROM ma\_points m0\_ LEFT JOIN ma\_categories m1\_ ON m0\_.category\_id = m1\_.id ORDER BY m0\_.name ASC) dctrn\_result ‘) dctrn\_result’) \ nSQLSTATE [42S22]: Column not found: 1054 Unknown column ‘m0\_.repeatable’ in ‘field list’ at / opt / bitnami / apps / mautic / htdocs / vendor / doctrine / dbal / lib / Doctrine / DBAL / Driver / AbstractMySQLDriver .php: 60, Doctrine \ DBAL \ Driver \ PDOException (code: 42S22): SQLSTATE [42S22]: Column not found: 1054 Unknown column ‘m0\_.repeatable’ in ‘field list’ at / opt / bitnami / apps /mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:80, PDOException (code: 42S22): SQLSTATE [42S22]: Column not found: 1054 Unknown column ‘m0\_.repeatable’ in ‘field list’ at /opt/bitnami/apps/mautic/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:75) "} Steps I have tried to fix the problem: I have already done [http://34.77.174.96/s/update/schema](http://34.77.174.96/s/update/schema) And I have run the commands: php bin / console doctrine: migration: migrate php bin / console doctrine: schema: update --force But the error persists, it shows me information about contacts and companies, but not about campaigns, or segments … ---
**Author:** ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)\ **Post date:** [June 2, 2021, 11:09am UTC](https://forum.mautic.org/t/issue-after-restore-database-in-mautic/19706/2 "2021-06-02T11:09:09Z")
Hi there, You can’t just restore from 2-\>3 without migrating first. The correct process is to update to the latest in the 2.x series, then update (ideally at command line) to 3. The migration script will migrate the whole instance - files, folders and database. Of course, ensure you have a working backup first before you start! ---
**Author:** ![nataly](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/nataly/32/441_2.png) [@nataly](https://forum.mautic.org/u/nataly)\ **Post date:** [June 2, 2021, 11:30am UTC](https://forum.mautic.org/t/issue-after-restore-database-in-mautic/19706/3 "2021-06-02T11:30:41Z")
I already tried that a month ago and it also gives error > **[Update Issue bitnami](https://community.bitnami.com/t/update-issue-bitnami/93304)** > > Keywords: Mautic - Google Cloud Platform - Technical issue - Upgrade bnsupport ID: fac0f020-d6da-dcbc-a176-709fa4710052 Description: Hi, I was tried to Update my Nautic versión using this Commands cd /opt/bitnami/apps/mautic/htdocs ... In the end they told me that since it cannot be updated, I should create a new machine with the recent version and perform the backup there. After many errors, I have gotten mautic to let me log in after resetting the database, but now I have the error that I mentioned. ---
**Author:** ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)\ **Post date:** [June 3, 2021, 12:22pm UTC](https://forum.mautic.org/t/issue-after-restore-database-in-mautic/19706/4 "2021-06-03T12:22:18Z")
As they suggest you need to back up your 2.x installation, then create a new instance with the right PHP/MySQL versions, then restore your Mautic instance to that server, and run the Mautic 3 migration. > You need to upgrade de full stack and then restore your files. You should launch a new cloud image with the latest version, and then migrate your data there. You may need to hire someone to help with this if you cannot do it yourself. ---
**Author:** ![nataly](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/nataly/32/441_2.png) [@nataly](https://forum.mautic.org/u/nataly)\ **Post date:** [June 4, 2021, 6:21am UTC](https://forum.mautic.org/t/issue-after-restore-database-in-mautic/19706/5 "2021-06-04T06:21:22Z")
I already tried that too, but when trying to update mautic, from the restoration, I got the same error as always. "\* Your server does not meet the minimum PHP requirements. Mautic requires PHP version 7.2.21 while your server has 5.6 .24. Please contact your host to update your PHP installation. Your MySQL / MariaDB version is not supported. You need at least MySQL 5.7.14 or MariaDB 10.2 in order to run Mautic 3 “” Even, when I created the instance whith PHP 7 and MYSQL 5.7.14 Therefore, the recommendation they gave me was to migrate only the database. and now this happens to me.