Answers.Body: <p>I compared the mysql tables on a site that had 5.52.0 running without having a message to upgrade the database with the tables on the site that said that the database needed upgrade. I found 5 tables that had zero records on the good site that were not in the other site. I added the missing tables and now the site no longer says the database needs to be undated. Here are the tables that were missing:
  civicrm_queue
  civicrm_search_display
  civicrm_search_segment
  civicrm_translation
  civicrm_user_job</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-09-01T14:17:07.290Z
Answers.LastActivityDate: 2022-09-01T14:17:07.290Z
Answers.UserDisplayName: Ben Bachrach
Answers.Body: <p>I would suggest checking the CiviCRM logs for the error to get a more detailed explanation of what happened. I would also suggest the 5.52.2 patch update, in case there were any regressions.</p>
  <p>I am assuming that you made a backup of your CiviCRM database before running this update (though this was 6 days ago), it may be worth restoring the backup and running the update again if that is possible.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-08-17T00:29:51.040Z
Answers.LastActivityDate: 2022-08-17T00:29:51.040Z
Answers.UserDisplayName: Kristin
Body: <p>I upgraded to 5.52.0. The last step was to reset the database.
  I got an error message -
  &quot;
  Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
  DB Error: syntax error&quot;</p>
  <p>I contacted the admin and he could find nothing wrong.</p>
  <p>Now on</p>
  <p>../wp-admin/admin.php?page=CiviCRM&amp;q=civicrm%2Fa%2F#/status</p>
  <p>it says
  &quot;
  New codebase version detected. You must visit upgrade screen to upgrade the database.&quot;</p>
  <p>but at the bottom of each page that usually shows red if there is a problem it now shows:
  Powered by CiviCRM 5.52.0. System Status: Ok CiviCRM is openly available under the GNU AGPL License.</p>
  <p>I retried resetting the database and got the same results.</p>
  <p>I have not been able to find any civicrm features that I use that do not work.</p>
  <p>Any suggestions?</p>
  
Tags: <upgrade><database>
Title: Upgrade to 5.52.0 - database won't reset
ThreadText: # Upgrade to 5.52.0 - database won't reset
  
  (Asked by: username_0 on 2022-08-10)
  
  I upgraded to 5.52.0. The last step was to reset the database.
  I got an error message -
  "
  Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
  DB Error: syntax error"
  
  I contacted the admin and he could find nothing wrong.
  
  Now on
  
  ../wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fa%2F#/status
  
  it says
  "
  New codebase version detected. You must visit upgrade screen to upgrade the database."
  
  but at the bottom of each page that usually shows red if there is a problem it now shows:
  Powered by CiviCRM 5.52.0. System Status: Ok CiviCRM is openly available under the GNU AGPL License.
  
  I retried resetting the database and got the same results.
  
  I have not been able to find any civicrm features that I use that do not work.
  
  Any suggestions?
  
  **Tags:** upgrade, database
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_0 on 2022-09-01. Score: 0
  
  I compared the mysql tables on a site that had 5.52.0 running without having a message to upgrade the database with the tables on the site that said that the database needed upgrade. I found 5 tables that had zero records on the good site that were not in the other site. I added the missing tables and now the site no longer says the database needs to be undated. Here are the tables that were missing:
  civicrm\_queue
  civicrm\_search\_display
  civicrm\_search\_segment
  civicrm\_translation
  civicrm\_user\_job
  
  
  ---
  
  ### Answer by username_1 on 2022-08-17. Score: 0
  
  I would suggest checking the CiviCRM logs for the error to get a more detailed explanation of what happened. I would also suggest the 5.52.2 patch update, in case there were any regressions.
  
  I am assuming that you made a backup of your CiviCRM database before running this update (though this was 6 days ago), it may be worth restoring the backup and running the update again if that is possible.
  
  
  ---
  
  