SQLSTATE[42000] on adding new field in Content Types

I'm sorry you're running into that error. However, it seems like the problem is with Drupal core, or maybe another contributed module or custom code somewhere, not with Views. I'm moving the issue to the Drupal core issue queue, maybe someone there will be able to help you get to the bottom of the problem.

Aditi Saraf → made their first commit to this issue’s fork.

i am working on it .

i am not getting this issue . Attaching screenshot here . I am able to add field without any error .

@snarf5 Can you please provide more information about the field you tried to add - what was the field type? Was the field type created by any contributed module you have installed on your site? Thanks!

Hi everyone,

i am getting the error message as per attached file.

so the field name is gst_flag. As for the field type, it is the standard one, i tried with 'integer' and 'text' and yet both are giving the same error message.

i am guessing that there might be an issue in another module/code like what @damianmckenna mentioned. But i just couldn't see any error in the error report page nor the php log file itself. Is there any way that i can debug this somehow?

Hi everyone,

i have figured out the root cause of this issue.

i had to debug the SQL and tested it. Apparently the hosting vendor updated mysql version (and some other stuff), so the issue was because the code in database' schema file is still using bracket {} for all of the table names in the sql statement. After i updated it all into ``, the issue is gone.