Answers.Body: <p>I ended up just changing the version number in the info file to 3.1.0.  Then on the Manage Extensions page it then said there was an upgrade.  Hit upgrade and everything was good.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-01-11T03:53:48.347Z
Answers.LastActivityDate: 2019-01-11T03:53:48.347Z
Answers.UserDisplayName: Paul-Tahoe
Body: <p>The triggers weren't enabled and I tried to get them enabled.  Couldn't seem to.  Tried uninstalling and reinstalling still didn't work.  Dug into it and found it was getting an error when trying to copy the summary fields data from the temp table into the custom fields table.  The error was violating a constraint.  Debugged it a bit and found that it was creating a row with a null contact_id.  Dug into that and found that sumfields.php was doing an outer join incorrectly.  I figured that couldn't be current code and looked at the latest and greatest and found that sumfields.php file was different from ours.  Sadly, there are no version numbers or anything on that file so it's hard to tell what version it is.</p>
  
  <p>The info files says it's version 3.1.3.  I guessing the last upgrade somehow messed this up.  </p>
  
  <p>So the question is what's the best way to get current.  Is it to just replace all the files in the custom_ext with the current ones or is it to uninstall and delete those files or maybe change the info so it thinks it older so I'll prompt for upgrade. </p>
  
Tags: <summaryfields>
Title: Somehow our summary fields got a old version of sumfields.php. What's the best way to get the current versions?
ThreadText: # Somehow our summary fields got a old version of sumfields.php. What's the best way to get the current versions?
  
  (Asked by: username_0 on 2018-12-19)
  
  The triggers weren't enabled and I tried to get them enabled. Couldn't seem to. Tried uninstalling and reinstalling still didn't work. Dug into it and found it was getting an error when trying to copy the summary fields data from the temp table into the custom fields table. The error was violating a constraint. Debugged it a bit and found that it was creating a row with a null contact\_id. Dug into that and found that sumfields.php was doing an outer join incorrectly. I figured that couldn't be current code and looked at the latest and greatest and found that sumfields.php file was different from ours. Sadly, there are no version numbers or anything on that file so it's hard to tell what version it is.
  
  The info files says it's version 3.1.3. I guessing the last upgrade somehow messed this up.
  
  So the question is what's the best way to get current. Is it to just replace all the files in the custom\_ext with the current ones or is it to uninstall and delete those files or maybe change the info so it thinks it older so I'll prompt for upgrade.
  
  **Tags:** summaryfields
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2019-01-11. Score: 1
  
  I ended up just changing the version number in the info file to 3.1.0. Then on the Manage Extensions page it then said there was an upgrade. Hit upgrade and everything was good.
  
  
  ---
  
  