Questions tagged [sql]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
30 views

After Migration from v2.9 to 3.5 - some entries added into an entry-relation-field get added twice after saving

We migrated a craft cms site with 3 locales from v2.9 to 3.5 We have a section with a field of type "Entries". When editing the entry, and adding certain entries to this field, those get ...
0
votes
0answers
86 views

Craft CMS hangs when deleting a field then throws 504

We have an instance of Craft CMS running that has a lot of content entries and a lot of fields, using Neo and SuperTable. At some point, something changed and now when we try to delete one of the ...
1
vote
1answer
36 views

Mass enable entries

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'...
1
vote
1answer
37 views

Least CPU intensive way to get number of matching elements?

Which is the least CPU intensive (SQL-intensive) way to get the sum of products that are relatedTo a category? Like this? {% set productCount = craft.products.relatedTo(category)|length %}