Answers.Body: <p>Comparing a fresh CiviCRM DB with my own revealed the differences between existing and expected. </p>
  
  <p>I added the weight field to the civicrm_activity table in the right place and things were resolved. </p>
  
  <p>This installation has been through years and years of updates and there have been several occasions over the years where half-baked upgrade scripts have left the DB in similarly half-baked corners.</p>
  
  <p>Gladly, this only caused some UI issues and is now resolved. </p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-11-05T22:00:27.167Z
Answers.LastActivityDate: 2017-11-05T22:00:27.167Z
Answers.UserDisplayName: Derek
Body: <p>Upgraded a few days ago, everything seems fine. Just word that there are some issues registering new participants/payments, the UI "hangs" on submitting the form, but still records the participation.</p>
  
  <p>Trying it myself, as administrator, I could see that an error was being generated during the transaction, breaking the ajax UI for non-admins.</p>
  
  <pre><code>    DB Error: No such field. 
  </code></pre>
  
  <p>After looking at the logs, it becomes pretty obvious that the error is being caused by a bad query relating to civicrm_activity. It would also explain why the registrations are being recorded despite the issue.</p>
  
  <pre><code>[nativecode=1054 ** Unknown column 'a.weight' in 'field list']
  
      [type] =&gt; DB_Error
  
      [user_info] =&gt; SELECT a.id as `id`, a.source_record_id as `source_record_id`, a.activity_type_id as `activity_type_id`, a.subject as `subject`, a.activity_date_time as `activity_date_time`, a.duration as `duration`, a.location as `location`, a.phone_id as `phone_id`, a.phone_number as `phone_number`, a.details as `details`, a.status_id as `status_id`, a.priority_id as `priority_id`, a.parent_id as `parent_id`, a.is_test as `is_test`, a.medium_id as `medium_id`, a.is_auto as `is_auto`, a.relationship_id as `relationship_id`, a.is_current_revision as `is_current_revision`, a.original_id as `original_id`, a.result as `result`, a.is_deleted as `is_deleted`, a.campaign_id as `campaign_id`, a.engagement_level as `engagement_level`, a.weight as `weight`, a.is_star as `is_star`, a.created_date as `created_date`, a.modified_date as `modified_date`
  FROM civicrm_activity a
  WHERE (a.source_record_id = "77904") AND (a.activity_type_id = "6")
  LIMIT 25
  OFFSET 0
  </code></pre>
  
  <p>I can confirm that my civicrm_activity table DOES NOT have the weight column...</p>
  
  <p>Does anyone have any experience with this kind of nuttiness? </p>
  
Tags: <error><activities><payment>
Title: CiviCRM 4.7.25 - No such field - unknown column a.weight in field list on Activity
ThreadText: # CiviCRM 4.7.25 - No such field - unknown column a.weight in field list on Activity
  
  (Asked by: username_0 on 2017-11-03)
  
  Upgraded a few days ago, everything seems fine. Just word that there are some issues registering new participants/payments, the UI "hangs" on submitting the form, but still records the participation.
  Trying it myself, as administrator, I could see that an error was being generated during the transaction, breaking the ajax UI for non-admins.
      DB Error: No such field. 
  
  After looking at the logs, it becomes pretty obvious that the error is being caused by a bad query relating to civicrm_activity. It would also explain why the registrations are being recorded despite the issue.
  [nativecode=1054 ** Unknown column 'a.weight' in 'field list']
  
      [type] => DB_Error
  
      [user_info] => SELECT a.id as `id`, a.source_record_id as `source_record_id`, a.activity_type_id as `activity_type_id`, a.subject as `subject`, a.activity_date_time as `activity_date_time`, a.duration as `duration`, a.location as `location`, a.phone_id as `phone_id`, a.phone_number as `phone_number`, a.details as `details`, a.status_id as `status_id`, a.priority_id as `priority_id`, a.parent_id as `parent_id`, a.is_test as `is_test`, a.medium_id as `medium_id`, a.is_auto as `is_auto`, a.relationship_id as `relationship_id`, a.is_current_revision as `is_current_revision`, a.original_id as `original_id`, a.result as `result`, a.is_deleted as `is_deleted`, a.campaign_id as `campaign_id`, a.engagement_level as `engagement_level`, a.weight as `weight`, a.is_star as `is_star`, a.created_date as `created_date`, a.modified_date as `modified_date`
  FROM civicrm_activity a
  WHERE (a.source_record_id = "77904") AND (a.activity_type_id = "6")
  LIMIT 25
  OFFSET 0
  
  I can confirm that my civicrm_activity table DOES NOT have the weight column...
  Does anyone have any experience with this kind of nuttiness?
  
  **Tags:** error, activities, payment
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2017-11-05. Score: 0 | Accepted answer
  
  Comparing a fresh CiviCRM DB with my own revealed the differences between existing and expected.
  
  I added the weight field to the civicrm\_activity table in the right place and things were resolved.
  
  This installation has been through years and years of updates and there have been several occasions over the years where half-baked upgrade scripts have left the DB in similarly half-baked corners.
  
  Gladly, this only caused some UI issues and is now resolved.
  
  
  ---
  
  