About internal server error 500 when aplay to form

Product Support
1

Hi, I’m masafu.

Thanks for us that provide mautic.

It’s very cool OSS.

Howerver, I wrong now.

These are about Internal server error 500 when aplay to form.

My mautic is 1.2 latest version.



Error message was below…

[2015-09-20 10:34:52] mautic.CRITICAL: Uncaught PHP Exception MauticCoreBundleExceptionSchemaException: “A column is missing required name key.” at /home/sites/heteml/users/c/a/r/cares/web/mautic/app/bundles/CoreBundle/Doctrine/Helper/TableSchemaHelper.php line 159 {“exception”:"[object] (Mautic\CoreBundle\Exception\SchemaException(code: 0): A column is missing required name key. at /home/sites/heteml/users/c/a/r/cares/web/mautic/app/bundles/CoreBundle/Doctrine/Helper/TableSchemaHelper.php:159)"} []

[2015-09-20 10:35:52] mautic.CRITICAL: Uncaught PHP Exception MauticCoreBundleExceptionSchemaException: “A column is missing required name key.” at /home/sites/heteml/users/c/a/r/cares/web/mautic/app/bundles/CoreBundle/Doctrine/Helper/TableSchemaHelper.php line 159 {“exception”:"[object] (Mautic\CoreBundle\Exception\SchemaException(code: 0): A column is missing required name key. at /home/sites/heteml/users/c/a/r/cares/web/mautic/app/bundles/CoreBundle/Doctrine/Helper/TableSchemaHelper.php:159)"} []

[2015-09-20 10:44:31] mautic.CRITICAL: Uncaught PHP Exception MauticCoreBundleExceptionSchemaException: “A column is missing required name key.” at /home/sites/heteml/users/c/a/r/cares/web/mautic/app/bundles/CoreBundle/Doctrine/Helper/TableSchemaHelper.php line 159 {“exception”:"[object] (Mautic\CoreBundle\Exception\SchemaException(code: 0): A column is missing required name key. at /home/sites/heteml/users/c/a/r/cares/web/mautic/app/bundles/CoreBundle/Doctrine/Helper/TableSchemaHelper.php:159)"} []

[2015-09-20 10:46:21] mautic.CRITICAL: Uncaught PHP Exception MauticCoreBundleExceptionSchemaException: “A column is missing required name key.” at /home/sites/heteml/users/c/a/r/cares/web/mautic/app/bundles/CoreBundle/Doctrine/Helper/TableSchemaHelper.php line 159 {“exception”:"[object] (Mautic\CoreBundle\Exception\SchemaException(code: 0): A column is missing required name key. at /home/sites/heteml/users/c/a/r/cares/web/mautic/app/bundles/CoreBundle/Doctrine/Helper/TableSchemaHelper.php:159)"} []



These error were output when new create form, so setup to “Actions”.

I try to “Action tab” into Add submit action select some one, but output Internal server error when click to save or aplay.

Please help me.

2

Hi, I’m masafu.
Thanks for us that provide mautic.
It’s very cool OSS.
Howerver, I wrong now.
These are about Internal server error 500 when aplay to form.
My mautic is 1.2 latest version.

Error message was below…
[2015-09-20 10:34:52] mautic.CRITICAL: Uncaught PHP Exception MauticCoreBundleExceptionSchemaException: “A column is missing required name key.” at /home/sites/heteml/users/c/a/r/cares/web/mautic/app/bundles/CoreBundle/Doctrine/Helper/TableSchemaHelper.php line 159 {“exception”:"[object] (Mautic\CoreBundle\Exception\SchemaException(code: 0): A column is missing required name key. at /home/sites/heteml/users/c/a/r/cares/web/mautic/app/bundles/CoreBundle/Doctrine/Helper/TableSchemaHelper.php:159)"} []
[2015-09-20 10:35:52] mautic.CRITICAL: Uncaught PHP Exception MauticCoreBundleExceptionSchemaException: “A column is missing required name key.” at /home/sites/heteml/users/c/a/r/cares/web/mautic/app/bundles/CoreBundle/Doctrine/Helper/TableSchemaHelper.php line 159 {“exception”:"[object] (Mautic\CoreBundle\Exception\SchemaException(code: 0): A column is missing required name key. at /home/sites/heteml/users/c/a/r/cares/web/mautic/app/bundles/CoreBundle/Doctrine/Helper/TableSchemaHelper.php:159)"} []
[2015-09-20 10:44:31] mautic.CRITICAL: Uncaught PHP Exception MauticCoreBundleExceptionSchemaException: “A column is missing required name key.” at /home/sites/heteml/users/c/a/r/cares/web/mautic/app/bundles/CoreBundle/Doctrine/Helper/TableSchemaHelper.php line 159 {“exception”:"[object] (Mautic\CoreBundle\Exception\SchemaException(code: 0): A column is missing required name key. at /home/sites/heteml/users/c/a/r/cares/web/mautic/app/bundles/CoreBundle/Doctrine/Helper/TableSchemaHelper.php:159)"} []
[2015-09-20 10:46:21] mautic.CRITICAL: Uncaught PHP Exception MauticCoreBundleExceptionSchemaException: “A column is missing required name key.” at /home/sites/heteml/users/c/a/r/cares/web/mautic/app/bundles/CoreBundle/Doctrine/Helper/TableSchemaHelper.php line 159 {“exception”:"[object] (Mautic\CoreBundle\Exception\SchemaException(code: 0): A column is missing required name key. at /home/sites/heteml/users/c/a/r/cares/web/mautic/app/bundles/CoreBundle/Doctrine/Helper/TableSchemaHelper.php:159)"} []

These error were output when new create form, so setup to “Actions”.
I try to “Action tab” into Add submit action select some one, but output Internal server error when click to save or aplay.
Please help me.

3

I think the problem is that your database schema is outdated. If you have SSH access, what happens if you run following command?

php app/console doctrine:schema:update --sql-dump
4

Great!.
Thanks for message.
I try your idea, but my hostings service could not submit that command by SSH.
Date Base is MySQL 5.6.
If I get SQL dump file, Can you understand to view it?
Maybe, I can get it from PHPMyAdmin.

5

If you don’t have SSH access, you can use this script to emulate Mautic commands: https://gist.github.com/escopecz/9a1a0b10861941a457f4

6

Thanks Mr.esoopecz

I tired your new idea.
So, I got below message.

Executing console doctrine:schema:update --dump-sql
Nothing to update - your database is already in sync with the current entity metadata.

Probably, that message is latest datebase schema.

I guess that ploblem is TableSchemaHelper.php file in Mautic .

[2015-xx-xx 10:35:52] mautic.CRITICAL: Uncaught PHP Exception MauticCoreBundleExceptionSchemaException: “A column is missing required name key.” at /home/sites/heteml/users/c/a/r/cares/web/mautic/app/bundles/CoreBundle/Doctrine/Helper/TableSchemaHelper.php line 159 {“exception”:"[object] (Mautic\CoreBundle\Exception\SchemaException(code: 0): A

What do you think?

7

Some how your fields aren’t generating aliases. I’ve not seen this happen before. Is reproducible every time? Are you able to trace the issue to a specific field and if so, how is it configured?

https://github.com/mautic/mautic/blob/fbef02439b1b5e60861a7a42971f1797b10471bf/app/bundles/FormBundle/Model/FormModel.php#L399

8

Great!
Thanks Mr.alanhartless
Are you sure?
I’ll try your idea.