Answers.Body: <p>It sounds as if you haven't updated the database after upgrading CiviCRM.</p>
  
  <p>CiviCRM 4.7.13 <a href="https://github.com/civicrm/civicrm-core/blob/master/CRM/Upgrade/Incremental/sql/4.7.13.mysql.tpl" rel="nofollow noreferrer">added a new column</a> 'language' to the 'civicrm_mailing' table.</p>
  
  <p>You can update the database by visiting this URL:</p>
  
  <pre><code>http://&lt;your_drupal_home&gt;/civicrm/upgrade?reset=1
  </code></pre>
  
  <p>Full details here: <a href="https://wiki.civicrm.org/confluence/display/CRMDOC/Upgrading+CiviCRM+for+Drupal+7#UpgradingCiviCRMforDrupal7-11.RuntheUpgradescript" rel="nofollow noreferrer">Run the upgrade script</a></p>
  
  <p>Alternatively if you have drush you can run <code>drush cvupdb</code>. See this post for more details: <a href="https://civicrm.stackexchange.com/questions/4829/is-it-easy-to-upgrade-civicrm-using-drush">Is it easy to upgrade CiviCRM using drush?</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-12-13T19:35:33.587Z
Answers.Text: Thanks, but I have run the upgrade step. I have checked the civicrm_mailing table and see the language column in there.
Answers.UserDisplayName: Tony Michael
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-12-13T18:43:30.770Z
Answers.LastActivityDate: 2016-12-13T18:56:39.640Z
Answers.LastEditDate: 2017-04-13T12:53:13.167Z
Answers.UserDisplayName: William Mortada
Answers.Body: <p>One thing i have found is that if you have the detailed logging turned on under the misc settings, this kind of error can show if the log_civicrm_mailing table doesn't have the language column. This can suggest there was something that went wrong in the upgrade. </p>
  
  <p>I would recommend you check to see if there is a log_civicrm_mailing table and if that has the language column if not add it as the same as in the civicrm_mailing table. Then go to http(s):///civicrm/menu/rebuild?reset=1&amp;triggerRebuild=1</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-12-15T13:55:19.730Z
Answers.Text: Brilliant! Thank you.   Language was not in log_civicrm_mailing. I turned off Misc->Logging to check, and found that I could start a new mailing. I then turned on Misc->Logging, and found that I could still  start a new mailing. There is now a language column in the log_civicrm_mailing table. Just turning logging on again must have fixed those tables.
Answers.UserDisplayName: Tony Michael
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-12-15T19:34:39.357Z
Answers.Text: Wow, thanks @Seamus Lee for having spotted that !
Answers.UserDisplayName: samuelsov
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-12-15T20:15:30.163Z
Answers.Text: @TonyMichael I suspect that by turning it off and on you triggered the function in CiviCRM that scans the logging tables and adds any columns missing to logging tables alters any to match what is in civicrm_x or set any columns in the logging tables to be NULL for any columns that the log table has that no longer exists in the civicrm_x table
Answers.UserDisplayName: Seamus Lee
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-12-15T05:46:12.043Z
Answers.LastActivityDate: 2016-12-15T05:46:12.043Z
Answers.UserDisplayName: Seamus Lee
Body: <p>I recently upgraded from 4.7.11 to 4.7.14 in a Drupal 7 installation.
  Now I have noticed that when trying to create a new Mailing, the page shows nothing.</p>
  
  <p>This message appears in the log file:</p>
  
  <pre><code>nativecode=1054 ** Unknown column 'language' in 'field list'
  </code></pre>
  
  <p>The "INSERT INTO" statement doesn't mention 'language', but the DB error does. Why would that happen?</p>
  
  <p>I checked that database table civicrm_mailing, and there is a field called  "language". </p>
  
  <p>Where else could be 'language' be needed? What else can I do to work out what the problem is?</p>
  
  <p>This is the whole report from the log file:</p>
  
  <pre><code>Dec 13 16:01:12  [info] $Fatal Error Details = Array
  (
      [callback] =&gt; Array
          (
              [0] =&gt; CRM_Core_Error
              [1] =&gt; exceptionHandler
          )
  
      [code] =&gt; -19
      [message] =&gt; DB Error: no such field
      [mode] =&gt; 16
      [debug_info] =&gt; INSERT INTO civicrm_mailing (domain_id , header_id , footer_id , reply_id , unsubscribe_id , resubscribe_id , optout_id , name , mailing_type , from_name , from_email , replyto_email , subject , body_text , body_html , url_tracking , forward_replies , auto_responder , open_tracking , override_verp , created_id , created_date , visibility , dedupe_email ) VALUES ( 1 ,  1 ,  2 ,  7 ,  5 ,  8 ,  6 ,  NULL , 'standalone' , '{name}' , '{email_address}' ,  NULL ,  NULL ,  NULL ,  NULL ,  1 ,  0 ,  0 ,  1 ,  1 ,  1 ,  20161213160112 , 'Public Pages' ,  1 )  [nativecode=1054 ** Unknown column 'language' in 'field list']
      [type] =&gt; DB_Error
      [user_info] =&gt; INSERT INTO civicrm_mailing (domain_id , header_id , footer_id , reply_id , unsubscribe_id , resubscribe_id , optout_id , name , mailing_type , from_name , from_email , replyto_email , subject , body_text , body_html , url_tracking , forward_replies , auto_responder , open_tracking , override_verp , created_id , created_date , visibility , dedupe_email ) VALUES ( 1 ,  1 ,  2 ,  7 ,  5 ,  8 ,  6 ,  NULL , 'standalone' , '{name}' , '{email_address}' ,  NULL ,  NULL ,  NULL ,  NULL ,  1 ,  0 ,  0 ,  1 ,  1 ,  1 ,  20161213160112 , 'Public Pages' ,  1 )  [nativecode=1054 ** Unknown column 'language' in 'field list']
      [to_string] =&gt; [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="INSERT INTO civicrm_mailing (domain_id , header_id , footer_id , reply_id , unsubscribe_id , resubscribe_id , optout_id , name , mailing_type , from_name , from_email , replyto_email , subject , body_text , body_html , url_tracking , forward_replies , auto_responder , open_tracking , override_verp , created_id , created_date , visibility , dedupe_email ) VALUES ( 1 ,  1 ,  2 ,  7 ,  5 ,  8 ,  6 ,  NULL , 'standalone' , '{name}' , '{email_address}' ,  NULL ,  NULL ,  NULL ,  NULL ,  1 ,  0 ,  0 ,  1 ,  1 ,  1 ,  20161213160112 , 'Public Pages' ,  1 )  [nativecode=1054 ** Unknown column 'language' in 'field list']"]
  )
  </code></pre>
  
  <p>Here is the backtrace:</p>
  
  <pre><code>Dec 13 16:01:12  [info] $backTrace = #0 /home/mysite/sites/all/modules/civicrm/CRM/Core/Error.php(932): CRM_Core_Error::backtrace("backTrace", TRUE)
  #1 [internal function](): CRM_Core_Error::exceptionHandler(Object(DB_Error))
  #2 /home/mysite/sites/all/modules/civicrm/packages/PEAR.php(921): call_user_func((Array:2), Object(DB_Error))
  #3 /home/mysite/sites/all/modules/civicrm/packages/DB.php(985): PEAR_Error-&gt;__construct("DB Error: no such field", -19, 16, (Array:2), "INSERT INTO civicrm_mailing (domain_id , header_id , footer_id , reply_id , u...")
  #4 /home/mysite/sites/all/modules/civicrm/packages/PEAR.php(575): DB_Error-&gt;__construct(-19, 16, (Array:2), "INSERT INTO civicrm_mailing (domain_id , header_id , footer_id , reply_id , u...")
  #5 [internal function](): PEAR-&gt;_raiseError(Object(DB_mysqli), NULL, -19, NULL, NULL, "INSERT INTO civicrm_mailing (domain_id , header_id , footer_id , reply_id , u...", "DB_Error", TRUE)
  #6 /home/mysite/sites/all/modules/civicrm/packages/PEAR.php(224): call_user_func_array((Array:2), (Array:8))
  #7 /home/mysite/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR-&gt;__call("raiseError", (Array:7))
  #8 /home/mysite/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR-&gt;raiseError(NULL, -19, NULL, NULL, "INSERT INTO civicrm_mailing (domain_id , header_id , footer_id , reply_id , u...", "DB_Error", TRUE)
  #9 /home/mysite/sites/all/modules/civicrm/packages/DB/mysqli.php(933): DB_common-&gt;raiseError(-19, NULL, NULL, NULL, "1054 ** Unknown column 'language' in 'field list'")
  #10 /home/mysite/sites/all/modules/civicrm/packages/DB/mysqli.php(403): DB_mysqli-&gt;mysqliRaiseError()
  #11 /home/mysite/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysqli-&gt;simpleQuery("INSERT INTO civicrm_mailing (domain_id , header_id , footer_id , reply_id , u...")
  #12 /home/mysite/sites/all/modules/civicrm/packages/DB/DataObject.php(2438): DB_common-&gt;query("INSERT INTO civicrm_mailing (domain_id , header_id , footer_id , reply_id , u...")
  #13 /home/mysite/sites/all/modules/civicrm/packages/DB/DataObject.php(1060): DB_DataObject-&gt;_query("INSERT INTO civicrm_mailing (domain_id , header_id , footer_id , reply_id , u...")
  #14 /home/mysite/sites/all/modules/civicrm/CRM/Core/DAO.php(487): DB_DataObject-&gt;insert()
  #15 /home/mysite/sites/all/modules/civicrm/CRM/Mailing/BAO/Mailing.php(1585): CRM_Core_DAO-&gt;save()
  #16 /home/mysite/sites/all/modules/civicrm/CRM/Mailing/BAO/Mailing.php(1703): CRM_Mailing_BAO_Mailing::add((Array:33), (Array:0))
  #17 [internal function](): CRM_Mailing_BAO_Mailing::create((Array:33))
  #18 /home/mysite/sites/all/modules/civicrm/api/v3/utils.php(1279): call_user_func_array((Array:2), (Array:1))
  #19 /home/mysite/sites/all/modules/civicrm/api/v3/Mailing.php(67): _civicrm_api3_basic_create("CRM_Mailing_BAO_Mailing", (Array:33))
  #20 /home/mysite/sites/all/modules/civicrm/Civi/API/Provider/MagicFunctionProvider.php(89): civicrm_api3_mailing_create((Array:27))
  #21 /home/mysite/sites/all/modules/civicrm/Civi/API/Kernel.php(161): Civi\API\Provider\MagicFunctionProvider-&gt;invoke((Array:9))
  #22 /home/mysite/sites/all/modules/civicrm/Civi/API/Kernel.php(92): Civi\API\Kernel-&gt;runRequest((Array:7))
  #23 /home/mysite/sites/all/modules/civicrm/api/api.php(23): Civi\API\Kernel-&gt;runSafe("Mailing", "create", (Array:10), NULL)
  #24 /home/mysite/sites/all/modules/civicrm/CRM/Utils/REST.php(404): civicrm_api("Mailing", "create", (Array:10))
  #25 /home/mysite/sites/all/modules/civicrm/CRM/Utils/REST.php(641): CRM_Utils_REST::process((Array:3), (Array:8))
  #26 [internal function](): CRM_Utils_REST::ajax()
  #27 /home/mysite/sites/all/modules/civicrm/CRM/Core/Invoke.php(276): call_user_func((Array:2))
  #28 /home/mysite/sites/all/modules/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:12))
  #29 /home/mysite/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
  #30 /home/mysite/sites/all/modules/civicrm/drupal/civicrm.module(448): CRM_Core_Invoke::invoke((Array:3))
  #31 [internal function](): civicrm_invoke("ajax", "rest")
  #32 /home/mysite/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:2))
  #33 /home/mysite/index.php(22): menu_execute_active_handler()
  #34 {main}
  </code></pre>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-12-13T18:51:17.103Z
Comments.Text: Be careful what you post on a public forum.  I have removed the personal information (though unfortunately it is still available in the post revisions).
Comments.UserDisplayName: William Mortada
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-12-13T21:24:09.260Z
Comments.Text: Could you try enabling "Administer => System Settings => Debugging => Display Backtrace"? Then create a new mailing. It *might* provided a more detailed log.
Comments.UserDisplayName: Tim Otten
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-12-13T23:34:50.573Z
Comments.Text: I have the backtrace, and tried to include it in original post, but found it wouldn't post as it was flagged as spam. I'll see if I can edit it in.
Comments.UserDisplayName: Tony Michael
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-12-14T14:25:14.403Z
Comments.Text: The query runs fine on a civicrm database with or without language column. Can you try clearing cache : https://www.yoursite.org/civicrm/menu/rebuild?reset=1 ? Also, can you confirm that you are on a single language installation ?
Comments.UserDisplayName: samuelsov
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-12-14T16:01:23.047Z
Comments.Text: I have tried clearing the cache, and get the same result.
Comments.UserDisplayName: Tony Michael
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-12-14T16:08:46.830Z
Comments.Text: I am on a single language installation.  I looked at civicrm/admin/setting/localization to check  this, and saved the page in case it helped.It came up with a DB Error:  Unknown column 'data_type' in 'field list'
Comments.UserDisplayName: Tony Michael
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-12-14T16:12:56.050Z
Comments.Text: From the log:     [debug_info] =>
  DELETE g, v
    FROM civicrm_option_group g,
         civicrm_option_value v
   WHERE g.id = v.option_group_id
     AND g.name = 'currencies_enabled' [nativecode=1054 ** Unknown column 'data_type' in 'field list']
      [type] => DB_Error
      [user_info] =>
Comments.UserDisplayName: Tony Michael
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-12-14T16:13:01.027Z
Comments.Text: DELETE g, v
    FROM civicrm_option_group g,
         civicrm_option_value v
   WHERE g.id = v.option_group_id
     AND g.name = 'currencies_enabled' [nativecode=1054 ** Unknown column 'data_type' in 'field list']
      [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="
  DELETE g, v
    FROM civicrm_option_group g,
         civicrm_option_value v
   WHERE g.id = v.option_group_id
     AND g.name = 'currencies_enabled' [nativecode=1054 ** Unknown column 'data_type' in 'field list']"]
  )
Comments.UserDisplayName: Tony Michael
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-12-14T16:38:28.417Z
Comments.Text: The table civicrm_option_group does contain a data_type column.
Comments.UserDisplayName: Tony Michael
Tags: <civimail><drupal><upgrade>
Title: 4.7.14 Upgrade: CiviMail pages broken - Unknown column 'language' in 'field list'
ThreadText: # 4.7.14 Upgrade: CiviMail pages broken - Unknown column 'language' in 'field list'
  
  (Asked by: username_0 on 2016-12-13)
  
  I recently upgraded from 4.7.11 to 4.7.14 in a Drupal 7 installation.
  Now I have noticed that when trying to create a new Mailing, the page shows nothing.
  This message appears in the log file:
  nativecode=1054 ** Unknown column 'language' in 'field list'
  
  The "INSERT INTO" statement doesn't mention 'language', but the DB error does. Why would that happen?
  I checked that database table civicrm_mailing, and there is a field called  "language". 
  Where else could be 'language' be needed? What else can I do to work out what the problem is?
  This is the whole report from the log file:
  Dec 13 16:01:12  [info] $Fatal Error Details = Array
  (
      [callback] => Array
          (
              [0] => CRM_Core_Error
              [1] => exceptionHandler
          )
  
      [code] => -19
      [message] => DB Error: no such field
      [mode] => 16
      [debug_info] => INSERT INTO civicrm_mailing (domain_id , header_id , footer_id , reply_id , unsubscribe_id , resubscribe_id , optout_id , name , mailing_type , from_name , from_email , replyto_email , subject , body_text , body_html , url_tracking , forward_replies , auto_responder , open_tracking , override_verp , created_id , created_date , visibility , dedupe_email ) VALUES ( 1 ,  1 ,  2 ,  7 ,  5 ,  8 ,  6 ,  NULL , 'standalone' , '{name}' , '{email_address}' ,  NULL ,  NULL ,  NULL ,  NULL ,  1 ,  0 ,  0 ,  1 ,  1 ,  1 ,  20161213160112 , 'Public Pages' ,  1 )  [nativecode=1054 ** Unknown column 'language' in 'field list']
      [type] => DB_Error
      [user_info] => INSERT INTO civicrm_mailing (domain_id , header_id , footer_id , reply_id , unsubscribe_id , resubscribe_id , optout_id , name , mailing_type , from_name , from_email , replyto_email , subject , body_text , body_html , url_tracking , forward_replies , auto_responder , open_tracking , override_verp , created_id , created_date , visibility , dedupe_email ) VALUES ( 1 ,  1 ,  2 ,  7 ,  5 ,  8 ,  6 ,  NULL , 'standalone' , '{name}' , '{email_address}' ,  NULL ,  NULL ,  NULL ,  NULL ,  1 ,  0 ,  0 ,  1 ,  1 ,  1 ,  20161213160112 , 'Public Pages' ,  1 )  [nativecode=1054 ** Unknown column 'language' in 'field list']
      [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="INSERT INTO civicrm_mailing (domain_id , header_id , footer_id , reply_id , unsubscribe_id , resubscribe_id , optout_id , name , mailing_type , from_name , from_email , replyto_email , subject , body_text , body_html , url_tracking , forward_replies , auto_responder , open_tracking , override_verp , created_id , created_date , visibility , dedupe_email ) VALUES ( 1 ,  1 ,  2 ,  7 ,  5 ,  8 ,  6 ,  NULL , 'standalone' , '{name}' , '{email_address}' ,  NULL ,  NULL ,  NULL ,  NULL ,  1 ,  0 ,  0 ,  1 ,  1 ,  1 ,  20161213160112 , 'Public Pages' ,  1 )  [nativecode=1054 ** Unknown column 'language' in 'field list']"]
  )
  
  Here is the backtrace:
  Dec 13 16:01:12  [info] $backTrace = #0 /home/mysite/sites/all/modules/civicrm/CRM/Core/Error.php(932): CRM_Core_Error::backtrace("backTrace", TRUE)
  #1 [internal function](): CRM_Core_Error::exceptionHandler(Object(DB_Error))
  #2 /home/mysite/sites/all/modules/civicrm/packages/PEAR.php(921): call_user_func((Array:2), Object(DB_Error))
  #3 /home/mysite/sites/all/modules/civicrm/packages/DB.php(985): PEAR_Error->__construct("DB Error: no such field", -19, 16, (Array:2), "INSERT INTO civicrm_mailing (domain_id , header_id , footer_id , reply_id , u...")
  #4 /home/mysite/sites/all/modules/civicrm/packages/PEAR.php(575): DB_Error->__construct(-19, 16, (Array:2), "INSERT INTO civicrm_mailing (domain_id , header_id , footer_id , reply_id , u...")
  #5 [internal function](): PEAR->_raiseError(Object(DB_mysqli), NULL, -19, NULL, NULL, "INSERT INTO civicrm_mailing (domain_id , header_id , footer_id , reply_id , u...", "DB_Error", TRUE)
  #6 /home/mysite/sites/all/modules/civicrm/packages/PEAR.php(224): call_user_func_array((Array:2), (Array:8))
  #7 /home/mysite/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->__call("raiseError", (Array:7))
  #8 /home/mysite/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -19, NULL, NULL, "INSERT INTO civicrm_mailing (domain_id , header_id , footer_id , reply_id , u...", "DB_Error", TRUE)
  #9 /home/mysite/sites/all/modules/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-19, NULL, NULL, NULL, "1054 ** Unknown column 'language' in 'field list'")
  #10 /home/mysite/sites/all/modules/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError()
  #11 /home/mysite/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysqli->simpleQuery("INSERT INTO civicrm_mailing (domain_id , header_id , footer_id , reply_id , u...")
  #12 /home/mysite/sites/all/modules/civicrm/packages/DB/DataObject.php(2438): DB_common->query("INSERT INTO civicrm_mailing (domain_id , header_id , footer_id , reply_id , u...")
  #13 /home/mysite/sites/all/modules/civicrm/packages/DB/DataObject.php(1060): DB_DataObject->_query("INSERT INTO civicrm_mailing (domain_id , header_id , footer_id , reply_id , u...")
  #14 /home/mysite/sites/all/modules/civicrm/CRM/Core/DAO.php(487): DB_DataObject->insert()
  #15 /home/mysite/sites/all/modules/civicrm/CRM/Mailing/BAO/Mailing.php(1585): CRM_Core_DAO->save()
  #16 /home/mysite/sites/all/modules/civicrm/CRM/Mailing/BAO/Mailing.php(1703): CRM_Mailing_BAO_Mailing::add((Array:33), (Array:0))
  #17 [internal function](): CRM_Mailing_BAO_Mailing::create((Array:33))
  #18 /home/mysite/sites/all/modules/civicrm/api/v3/utils.php(1279): call_user_func_array((Array:2), (Array:1))
  #19 /home/mysite/sites/all/modules/civicrm/api/v3/Mailing.php(67): _civicrm_api3_basic_create("CRM_Mailing_BAO_Mailing", (Array:33))
  #20 /home/mysite/sites/all/modules/civicrm/Civi/API/Provider/MagicFunctionProvider.php(89): civicrm_api3_mailing_create((Array:27))
  #21 /home/mysite/sites/all/modules/civicrm/Civi/API/Kernel.php(161): Civi\API\Provider\MagicFunctionProvider->invoke((Array:9))
  #22 /home/mysite/sites/all/modules/civicrm/Civi/API/Kernel.php(92): Civi\API\Kernel->runRequest((Array:7))
  #23 /home/mysite/sites/all/modules/civicrm/api/api.php(23): Civi\API\Kernel->runSafe("Mailing", "create", (Array:10), NULL)
  #24 /home/mysite/sites/all/modules/civicrm/CRM/Utils/REST.php(404): civicrm_api("Mailing", "create", (Array:10))
  #25 /home/mysite/sites/all/modules/civicrm/CRM/Utils/REST.php(641): CRM_Utils_REST::process((Array:3), (Array:8))
  #26 [internal function](): CRM_Utils_REST::ajax()
  #27 /home/mysite/sites/all/modules/civicrm/CRM/Core/Invoke.php(276): call_user_func((Array:2))
  #28 /home/mysite/sites/all/modules/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:12))
  #29 /home/mysite/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
  #30 /home/mysite/sites/all/modules/civicrm/drupal/civicrm.module(448): CRM_Core_Invoke::invoke((Array:3))
  #31 [internal function](): civicrm_invoke("ajax", "rest")
  #32 /home/mysite/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:2))
  #33 /home/mysite/index.php(22): menu_execute_active_handler()
  #34 {main}
  
  **Tags:** civimail, drupal, upgrade
  
  > **Comments:**
  > **username_1**: Be careful what you post on a public forum.  I have removed the personal information (though unfortunately it is still available in the post revisions).  
  > **username_2**: Could you try enabling "Administer => System Settings => Debugging => Display Backtrace"? Then create a new mailing. It *might* provided a more detailed log.  
  > **username_0**: I have the backtrace, and tried to include it in original post, but found it wouldn't post as it was flagged as spam. I'll see if I can edit it in.  
  > **username_3**: The query runs fine on a civicrm database with or without language column. Can you try clearing cache : https://www.yoursite.org/civicrm/menu/rebuild?reset=1 ? Also, can you confirm that you are on a single language installation ?  
  > **username_0**: I have tried clearing the cache, and get the same result.  
  > **username_0**: I am on a single language installation.  I looked at civicrm/admin/setting/localization to check  this, and saved the page in case it helped.It came up with a DB Error:  Unknown column 'data_type' in 'field list'  
  > **username_0**: From the log:     [debug_info] => DELETE g, v   FROM civicrm_option_group g,        civicrm_option_value v  WHERE g.id = v.option_group_id    AND g.name = 'currencies_enabled' [nativecode=1054 ** Unknown column 'data_type' in 'field list']     [type] => DB_Error     [user_info] =>  
  > **username_0**: DELETE g, v   FROM civicrm_option_group g,        civicrm_option_value v  WHERE g.id = v.option_group_id    AND g.name = 'currencies_enabled' [nativecode=1054 ** Unknown column 'data_type' in 'field list']     [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info=" DELETE g, v   FROM civicrm_option_group g,        civicrm_option_value v  WHERE g.id = v.option_group_id    AND g.name = 'currencies_enabled' [nativecode=1054 ** Unknown column 'data_type' in 'field list']"] )  
  > **username_0**: The table civicrm_option_group does contain a data_type column.  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_4 on 2016-12-15. Score: 3 | Accepted answer
  
  One thing i have found is that if you have the detailed logging turned on under the misc settings, this kind of error can show if the log\_civicrm\_mailing table doesn't have the language column. This can suggest there was something that went wrong in the upgrade.
  
  I would recommend you check to see if there is a log\_civicrm\_mailing table and if that has the language column if not add it as the same as in the civicrm\_mailing table. Then go to http(s):///civicrm/menu/rebuild?reset=1&triggerRebuild=1
  
  > **Comments:**
  > **username_0**: Brilliant! Thank you.   Language was not in log_civicrm_mailing. I turned off Misc->Logging to check, and found that I could start a new mailing. I then turned on Misc->Logging, and found that I could still  start a new mailing. There is now a language column in the log_civicrm_mailing table. Just turning logging on again must have fixed those tables.  
  > **username_3**: Wow, thanks @username_4 for having spotted that !  
  > **username_4**: @TonyMichael I suspect that by turning it off and on you triggered the function in CiviCRM that scans the logging tables and adds any columns missing to logging tables alters any to match what is in civicrm_x or set any columns in the logging tables to be NULL for any columns that the log table has that no longer exists in the civicrm_x table  
  
  ---
  
  ### Answer by username_1 on 2016-12-13. Score: 2
  
  It sounds as if you haven't updated the database after upgrading CiviCRM.
  CiviCRM 4.7.13 added a new column 'language' to the 'civicrm_mailing' table.
  You can update the database by visiting this URL:
  http:///civicrm/upgrade?reset=1
  
  Full details here: Run the upgrade script
  Alternatively if you have drush you can run drush cvupdb. See this post for more details: Is it easy to upgrade CiviCRM using drush?
  
  > **Comments:**
  > **username_0**: Thanks, but I have run the upgrade step. I have checked the civicrm_mailing table and see the language column in there.  
  
  ---
  
  