Mautic Community Forums

About internal server error 500 when aplay to form

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.

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.

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

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.

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

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?

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

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