Answers.Body: <p>The <code>resave</code> CLI command has helped (<a href="https://craftcms.com/docs/4.x/console-commands.html#resave-entries" rel="nofollow noreferrer"><code>./craft resave/entries</code></a>).</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-03-30T02:49:37.783Z
Answers.LastActivityDate: 2023-03-07T11:21:51.910Z
Answers.LastEditDate: 2023-03-07T11:21:51.910Z
Answers.UserDisplayName: Mark H.
Body: <p>I'm trying to set statuses to enabled in mysql. Around 150k entries.</p>
  <p>The tables are <code>elements</code> and <code>elements_sites</code>. Set status to <code>1</code>.</p>
  <p>The query runs OK. In the cp is also everything fine but entries don't show up on the site itself.</p>
  <p>By manually entering one random entry disabling and enabling it again it works as expected.</p>
  <p>Did I missed something?</p>
  
Tags: <entries><query><mysql><sql>
Title: Mass enable entries
ThreadText: # Mass enable entries
  
  (Asked by: username_0 on 2020-03-29)
  
  I'm trying to set statuses to enabled in mysql. Around 150k entries.
  
  The tables are `elements` and `elements_sites`. Set status to `1`.
  
  The query runs OK. In the cp is also everything fine but entries don't show up on the site itself.
  
  By manually entering one random entry disabling and enabling it again it works as expected.
  
  Did I missed something?
  
  **Tags:** entries, query, mysql, sql
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2020-03-30. Score: 2
  
  The `resave` CLI command has helped ([`./craft resave/entries`](https://craftcms.com/docs/4.x/console-commands.html#resave-entries)).
  
  
  ---
  
  