# Form Problem after upgrade to 2.7.1 **URL:** \ **Category:** Product Support\ **Created:** [March 21, 2017, 3:11am UTC](https://forum.mautic.org/t/form-problem-after-upgrade-to-2-7-1/7979 "2017-03-21T03:11:04Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![waverider](https://avatars.discourse-cdn.com/v4/letter/w/49beb7/32.png) [@waverider](https://forum.mautic.org/u/waverider)\ **Post date:** [March 21, 2017, 3:11am UTC](https://forum.mautic.org/t/form-problem-after-upgrade-to-2-7-1/7979/1 "2017-03-21T03:11:04Z")
Just upgraded successfully from 2.5.1 to 2.7.1 However, I have also found that form redirect no longer works - although the form correctly submits the client information. The redirect URL is set correctly and appears in the correct column in the database, but on submitting the form it goes to: ‘Uh oh! I think I broke it. If I do it again, please report me to the system administrator! 500 Internal Server Error’ log entry shows: [2017-03-21 17:24:15] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionInvalidFieldNameException: “An exception occurred while executing ‘SELECT t0.date\_added AS date\_added\_1, t0.manually\_removed AS manually\_removed\_2, t0.manually\_added AS manually\_added\_3, t0.date\_last\_exited AS date\_last\_exited\_4, t0.rotation AS rotation\_5, t0.campaign\_id AS campaign\_id\_6, t0.lead\_id AS lead\_id\_7 FROM mauyu\_campaign\_leads t0 WHERE t0.lead\_id = ? AND t0.campaign\_id = ? LIMIT 1’ with params [514, 15]: Unknown column ‘t0.date\_last\_exited’ in ‘field list’” at /home/dd/public\_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘SELECT t0.date\_added AS date\_added\_1, t0.manually\_removed AS manually\_removed\_2, t0.manually\_added AS manually\_added\_3, t0.date\_last\_exited AS date\_last\_exited\_4, t0.rotation AS rotation\_5, t0.campaign\_id AS campaign\_id\_6, t0.lead\_id AS lead\_id\_7 FROM mauyu\_campaign\_leads t0 WHERE t0.lead\_id = ? AND t0.campaign\_id = ? LIMIT 1’ with params [514, 15]:nnUnknown column ‘t0.date\_last\_exited’ in ‘field list’ at /home/dd/public\_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Unknown column ‘t0.date\_last\_exited’ in ‘field list’ at /home/dd/public\_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:94)"} [] Any thoughts appreciated. ---
**Author:** ![waverider](https://avatars.discourse-cdn.com/v4/letter/w/49beb7/32.png) [@waverider](https://forum.mautic.org/u/waverider)\ **Post date:** [March 21, 2017, 3:11am UTC](https://forum.mautic.org/t/form-problem-after-upgrade-to-2-7-1/7979/2 "2017-03-21T03:11:04Z")
Just upgraded successfully from 2.5.1 to 2.7.1 However, I have also found that form redirect no longer works - although the form correctly submits the client information. The redirect URL is set correctly and appears in the correct column in the database, but on submitting the form it goes to: ‘Uh oh! I think I broke it. If I do it again, please report me to the system administrator! 500 Internal Server Error’ log entry shows: [2017-03-21 17:24:15] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionInvalidFieldNameException: “An exception occurred while executing ‘SELECT t0.date\_added AS date\_added\_1, t0.manually\_removed AS manually\_removed\_2, t0.manually\_added AS manually\_added\_3, t0.date\_last\_exited AS date\_last\_exited\_4, t0.rotation AS rotation\_5, t0.campaign\_id AS campaign\_id\_6, t0.lead\_id AS lead\_id\_7 FROM mauyu\_campaign\_leads t0 WHERE t0.lead\_id = ? AND t0.campaign\_id = ? LIMIT 1’ with params [514, 15]: Unknown column ‘t0.date\_last\_exited’ in ‘field list’” at /home/dd/public\_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing ‘SELECT t0.date\_added AS date\_added\_1, t0.manually\_removed AS manually\_removed\_2, t0.manually\_added AS manually\_added\_3, t0.date\_last\_exited AS date\_last\_exited\_4, t0.rotation AS rotation\_5, t0.campaign\_id AS campaign\_id\_6, t0.lead\_id AS lead\_id\_7 FROM mauyu\_campaign\_leads t0 WHERE t0.lead\_id = ? AND t0.campaign\_id = ? LIMIT 1’ with params [514, 15]:nnUnknown column ‘t0.date\_last\_exited’ in ‘field list’ at /home/dd/public\_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Unknown column ‘t0.date\_last\_exited’ in ‘field list’ at /home/dd/public\_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:94)"} [] Any thoughts appreciated. ---
**Author:** ![bizcrony](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/bizcrony/32/409_2.png) [@bizcrony](https://forum.mautic.org/u/bizcrony)\ **Post date:** [March 21, 2017, 9:17pm UTC](https://forum.mautic.org/t/form-problem-after-upgrade-to-2-7-1/7979/3 "2017-03-21T21:17:00Z")
Contact to your host for some PHP extenstion. ---
**Author:** ![waverider](https://avatars.discourse-cdn.com/v4/letter/w/49beb7/32.png) [@waverider](https://forum.mautic.org/u/waverider)\ **Post date:** [March 22, 2017, 12:48am UTC](https://forum.mautic.org/t/form-problem-after-upgrade-to-2-7-1/7979/4 "2017-03-22T00:48:11Z")
Thanks again for the help. There appears to be a missing column and schema update will not insert it: dd@s38b [~/public\_html/mautic]# php app/console doctrine:schema:update --dump-sql [DoctrineDBALSchemaSchemaException] There is no column with name ‘id’ on table ‘mauyu\_campaign\_lead\_event\_log’. doctrine:schema:update [–complete] [–dump-sql] [-f|–force] [–em [EM]] [-h|–help] [-q|–quiet] [-v|vv|vvv|–verbose] [-V|–version] [–ansi] [–no-ansi] [-n|–no-interaction] [-s|–shell] [–process-isolation] [-e|–env ENV] [–no-debug] [–] dd@s38b [~/public\_html/mautic]# php app/console doctrine:schema:update --force [DoctrineDBALSchemaSchemaException] There is no column with name ‘id’ on table ‘mauyu\_campaign\_lead\_event\_log’. doctrine:schema:update [–complete] [–dump-sql] [-f|–force] [–em [EM]] [-h|–help] [-q|–quiet] [-v|vv|vvv|–verbose] [-V|–version] [–ansi] [–no-ansi] [-n|–no-interaction] [-s|–shell] [–process-isolation] [-e|–env ENV] [–no-debug] [–] How do I proceed? ---
**Author:** ![waverider](https://avatars.discourse-cdn.com/v4/letter/w/49beb7/32.png) [@waverider](https://forum.mautic.org/u/waverider)\ **Post date:** [March 22, 2017, 2:47am UTC](https://forum.mautic.org/t/form-problem-after-upgrade-to-2-7-1/7979/5 "2017-03-22T02:47:07Z")
Yes it is- the link proveded to uodate at the top if the mautic dashbiard. Oruginally installed by Softalacious. I am beginning to realise that this may nit be a good idea. You think you are doing the right thing by using these processes but often not so. ---
**Author:** ![JoPitts](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/jopitts/32/636_2.png) [@JoPitts](https://forum.mautic.org/u/JoPitts)\ **Post date:** [March 22, 2017, 3:50am UTC](https://forum.mautic.org/t/form-problem-after-upgrade-to-2-7-1/7979/6 "2017-03-22T03:50:36Z")
@waverider, it is easy enough (if you’ve SSH access) to do the upgrades via the command line. Might be best to go down that path if you can in future. ---
**Author:** ![waverider](https://avatars.discourse-cdn.com/v4/letter/w/49beb7/32.png) [@waverider](https://forum.mautic.org/u/waverider)\ **Post date:** [March 22, 2017, 4:21am UTC](https://forum.mautic.org/t/form-problem-after-upgrade-to-2-7-1/7979/7 "2017-03-22T04:21:44Z")
I certainly will be doing that. However, I now have to create that missing column. Can someone please give me the correct code? Does anyone have a column ‘id’ on table ’ \*\*\*\*\_campaign\_lead\_event\_log’? There are a number of \_id columns ( event\_id, lead\_id, campaign\_id, ip\_id, channel\_id) but no ‘id’. If not why would it throw the error: [DoctrineDBALSchemaSchemaException] There is no column with name ‘id’ on table ‘mauyu\_campaign\_lead\_event\_log’. ---
**Author:** ![waverider](https://avatars.discourse-cdn.com/v4/letter/w/49beb7/32.png) [@waverider](https://forum.mautic.org/u/waverider)\ **Post date:** [March 22, 2017, 10:05am UTC](https://forum.mautic.org/t/form-problem-after-upgrade-to-2-7-1/7979/8 "2017-03-22T10:05:04Z")
I decided to create another instance of Mautic and compare the sql code for the table. There are distinct differences - not sure why, and should I drop the table and replace it??? Current problem database : `CREATE TABLE IF NOT EXISTS `mauyu_campaign_lead_event_log` ( `event_id` int(11) NOT NULL, `lead_id` int(11) NOT NULL,` New 2.7.1 `CREATE TABLE IF NOT EXISTS `mau9u_campaign_lead_event_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `event_id` int(11) NOT NULL, `lead_id` int(11) NOT NULL,` Current problem database : ` `non_action_path_taken` tinyint(1) DEFAULT NULL, PRIMARY KEY (`event_id`,`lead_id`), KEY `IDX_B7420BA171F7E88B` (`event_id`),` New 2.7.1 ``non_action_path_taken` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `mau9u_campaign_rotation` (`event_id`,`lead_id`,`rotation`), KEY `IDX_7BF8FB7D71F7E88B` (`event_id`),` ---
**Author:** ![waverider](https://avatars.discourse-cdn.com/v4/letter/w/49beb7/32.png) [@waverider](https://forum.mautic.org/u/waverider)\ **Post date:** [March 23, 2017, 7:10am UTC](https://forum.mautic.org/t/form-problem-after-upgrade-to-2-7-1/7979/9 "2017-03-23T07:10:13Z")
All problems now resolved - missing Columns and Keys causing the problem. How it happened? - no idea. Fixed by using clean install and comparing databases then altering tables to correct form. schema update then worked. Will only update using command line in future - lesson learnt. ---
**Author:** ![waverider](https://avatars.discourse-cdn.com/v4/letter/w/49beb7/32.png) [@waverider](https://forum.mautic.org/u/waverider)\ **Post date:** [March 23, 2017, 11:21pm UTC](https://forum.mautic.org/t/form-problem-after-upgrade-to-2-7-1/7979/10 "2017-03-23T23:21:01Z")
Thanks for the advice - much appreciated. This is my first instance of Mautic so i have a lot to learn 🙂