Questions tagged [mysql]
The mysql tag has no summary.
128 questions
0
votes
1
answer
181
views
Problems with search index using MySQL 8 and CraftCMS 4.8.0
I have been testing our site using MySQL 8.0.36, and all seems great other than the search index seems to be not working as expected as any entry search with a string over 10 characters in length ...
1
vote
1
answer
164
views
Use table prefix after installation
I finally have been able to install Craft CMS. During installation I left the table prefix field empty. I assume that for each site separate tables are created. Therefore, it would be more user-...
7
votes
2
answers
424
views
Craft loses contact with database, and stops daemon
Somehow the queue/listen occasionally loses access to the database:
FATAL Exited too quickly
.
Database Connection Error: Craft CMS can’t connect to the database.
As the connection is lost, it ...
0
votes
0
answers
135
views
Duplicate entry '2022' for key 'categorygroups_sites.PRIMARY'
I'm trying to get a live site running locally (using DDEV) and having trouble importing the database. The database is an export from the live site (which is running and has been for a short time).
...
0
votes
0
answers
171
views
SQLSTATE[HY000]: General error: 5 Out of memory (Needed 418490224 bytes)
I'm building a webtoon with CraftCMS 4 but facing this issue: SQLSTATE[HY000]: General error: 5 Out of memory (Needed 418490224 bytes)
Screenshot: https://i.sstatic.net/oMKud.png
All entries are a ...
1
vote
1
answer
174
views
Azure returning incorrect MySQL version. MySQL 5.7.8 or higher is required to run Craft CMS
I have upgraded one of our sites to Craft CMS 4 and moved it to a staging site on Azure. The front-end works but the control panel gives the MySQL 5.7.8 or higher is required to run Craft CMS error.
...
2
votes
1
answer
327
views
Migrating a Craft 4 instance from MySQL to PostgreSQL
I've managed to convert a fairly basic Craft 4 MySQL db to PostgreSQL using the pgloader tool, which came with it's own auth related issues when running PSQL v14+ instance - see https://github.com/...
1
vote
1
answer
439
views
MySQL 5.7.8 or higher is required to run Craft CMS Error
I'm extremely new to Craft CMS and having to ensure it can be ran from a Azure Virtual Machine. I have added, Apache, PHP and MySQL and the website does run on the server. However the issue occurs ...
2
votes
2
answers
289
views
Nitro: how risky is it to dev using MariaDB and then go live with MySQL?
Nitro does not support MySQL for Apple Silicon, but you can use MariaDB interchangeably.
I'm using an Apple Silicon computer, and my server run with MySQL only.
However, as read in the Craft Database ...
1
vote
1
answer
275
views
How to make Craft CMS 4 works with the older version of MySQL of MAMP Pro?
I'm used to working with MAMP instead of Nitro and would like to keep this setup as I find it easy to manage my other older setups.
As MAMP (Pro) support is until MySQL 5.7.34 and as Craft CMS 4 ...
1
vote
2
answers
785
views
MySQL server has gone away / max_allowed_packet
After adding a second block type to an existing matrix field, we started receiving a "General error: 2006 MySQL server has gone away" error when additional content was saved to the new block ...
1
vote
1
answer
107
views
Getting 503 error when setting up a site with CraftCMS nitro
I am experimenting with Nitro and getting the 503 db error when trying to connect db. I am able to connect to my GUI (Sequel Ace) but not get the browser connecting.
My db.php is as follows:
return [
...
1
vote
1
answer
315
views
Unable to setup Craft on a DigitalOcean managed DB
I just cloned an existing droplet with a working instance of Craft, I created a MySQL8 managed DB but whenever I run php ./craft setup I get this error:
Caused by: Exception 'yii\db\Exception' with ...
1
vote
0
answers
198
views
Order element query by number of related categories
I'm building an entry template that displays related entries to the current entry. To be related, an entry needs to be the same type as the current entry and share at least one category in one of two ...
1
vote
1
answer
104
views
Craft Script: Environment variable GLOBAL_DB_DRIVER was neither 'mysql' nor 'pgsql'
I keep getting the error Environment variable GLOBAL_DB_DRIVER was neither 'mysql' nor 'pgsql'. Aborting. when trying to pull the database from the production server to staging using Craft Script.
I ...