<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>

CC BY-SA 4.0
2020-03-30T02:49:37.783Z
2023-03-07T11:21:51.910Z
2023-03-07T11:21:51.910Z
Mark H.
<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>

<entries><query><mysql><sql>
Mass enable entries
# 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)).


---

