Questions tagged [mysql]
The mysql tag has no usage guidance.
122
questions
0
votes
0
answers
17
views
How to dump the db for running testing function
I want to set up the db for running testing function. I don't want to dump the whole db but just with the required table structure and records. Probably need to do it again if any new field has beed ...
- 27
0
votes
0
answers
30
views
Craft CMS - General Error: 1364 Field 'id' dosen't have a default value
I'm migrating my craft cms site from shared hosting to vps.
I did install all the basic services required by Craft under vps.
-> Install LAMP Stack.
-> cloned code base from git
-> SSL Cert
-&...
1
vote
1
answer
24
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 [
...
- 13
1
vote
1
answer
90
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 ...
- 125
0
votes
0
answers
206
views
SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ''
My website is running on Fortrabbit with the following settings:
PHP version 7.4.15
OS version Linux 4.15.0-50-generic
Database driver & version MySQL 8.0.23
Image driver & version Imagick ...
- 75
0
votes
0
answers
35
views
Error trying to push Craftcms DB from staging to Production
I am having a problem trying to use command php craft copy/db/up prod, when craft starts to push the DB to the production stage it stops at halfway and the website goes down! the error in MySQL is ...
- 33
1
vote
0
answers
45
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 ...
- 5,985
1
vote
1
answer
39
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 ...
- 139
0
votes
0
answers
15
views
Craft 2 cannot connect to db after pw reset
This is a MySql/Craft question.
I recently had difficulty in gaining access to MySql Workbench (which I use to access the MySql database to which my CraftCMS app connects). After numerous attempts, ...
- 368
1
vote
1
answer
158
views
How do you change from MySQL 5.7 to MySQL 8 in Nitro on MacOS
I usually use Nitro and docker to run Craft.
Nitro created a Docker container with MySQL 5.7. How can I change that version to MySQL 8?
- 33
0
votes
0
answers
47
views
SQL Queries Performing Full Table Scan
Per the title, our application's db query has from time to time pegged our CPU to the max and taken down the site. Our site has gotten quite large in terms of content and trying to figure out how best ...
- 31
0
votes
0
answers
70
views
Certain Queries Pegging CPU and Causing Production Site to go Down
I read these two posts
MySQL CPU pegged on specific query
Poor performance on midsized site / Queries without index?
and and am in a similar situation although for us it actually breaks our site and ...
- 31
1
vote
1
answer
136
views
MySQL error when sync database using Craft Script from Craft Nitro
I'm trying to sync the database from staging to local (Craft Nitro) using the craft-script as per the article.
Here is the error message,
Usage: mysqldump [OPTIONS] database [tables]
OR mysqldump [...
- 139
0
votes
0
answers
49
views
SyncDB with Nitro Fail to sync database from local to staging
I'm trying to sync the database for my local Craft Nitro to the staging environment using SyncDB.
Here is the error,
[2021-06-04T15:49:51.623536+08:00] sync.NOTICE: Starting database sync [] []
[2021-...
- 139
1
vote
2
answers
142
views
Unable to backup the database or apply migrations
I'm running CraftCMS via 3 Docker containers in 1 Docker network:
Container 1 - MySQL
Container 2 - Nginx
Container 3 - PHP:7.4-fpm
When I run php craft update craft from container 3 and choose to ...
- 111
1
vote
0
answers
30
views
Building a yii query for Connect plugin
I'm using the Connect plugin by Andrew Welch to get some data from an external database. Somewhere in the data, I need data from another related table. The way I'm doing this now is like this:
{% set ...
- 197
2
votes
1
answer
35
views
Deleted rows from elements_sites hunting stray slugs now I can't login
Working on a migration up/down testing I went through and deleted TOO much from the element_sites table to remove unwanted slugs, not understanding really what's in there. Now I understand many ...
- 53
1
vote
0
answers
166
views
Craft warning: Tried to release a savepoint, but it does not exist
I'm working on a plug-in for Craft 3. For this plug-in is a migration is needed.
When this migration runs and adds the entries, fields, and groups then the following warning occurs in the logs.
[...
- 53
1
vote
1
answer
68
views
Database driver & version after server upgrade
The server I'm running Craft installations on just got an upgrade to Ubuntu 20 with MariaDB 10.5 Before MySql 5.7 was used.
When I look at the System Report in the Craft CP, it says: Database driver &...
- 433
1
vote
1
answer
104
views
Craft Setup 3.6.5.1 with MYSQL with SSL version 5.7.29
I'm trying to install Craft version 3.6.5.1 with MYSQL version 5.7.29 from Azure.
While setup it fails with the following error
Testing database credentials ... failed: SQLSTATE[HY000] [9002] SSL ...
- 65
1
vote
0
answers
61
views
Very slow `INSERT` transactions on the resourcepaths table
After a recent update (Craft 3.4.x to 3.5.x) I'm seeing some suspiciously slow response times in relation to INSERT actions on the resourcepaths table. Some in the upwards of a half second for a ...
- 485
1
vote
0
answers
32
views
Craft cannot backup - Azure
When attempting to backup with Craft, the system returns the following error:
The shell command "mysqldump --defaults-extra-file="D:\local\Temp\my.cnf" --add-drop-table --comments --...
- 138
2
votes
1
answer
353
views
Running Craft CMS 2 on MySQL 8.0+ (Any major considerations?)
Yes, that's not a typo. This is for a Craft 2 site (long story). Because MySQL 5.6 is EOL in a few weeks, I am validating how feasible it can be to run under MySQL 8.0, there's not really any option ...
- 586
1
vote
1
answer
47
views
MySQL 5.6 backup to MySQL 5.7... what to do
I just changed my db server, and I managed to import a db dump to the new system.
What troubles me is that, once done, I noticed I have now MySQL 5.7.32, while the previous database server was 5.6.48.
...
- 173
1
vote
1
answer
125
views
Using MySQL With just InnoDB storage engine
What are the implications if I create all the Craft database tables on the InnoDB storage engine? Will there be any performance problem?
- 65
2
votes
1
answer
287
views
Craft CMS Entries Disappearing
I've setup a Craft 3 site for a client and we are seeing the strangest thing where pages are just disappearing. Best we can tell no-one has deleted the entry, but we get a 404 on the front-end and it ...
- 151
0
votes
0
answers
37
views
Saving to db with devMode true works, but not when false
// Upload and save as temp file
$request = Craft::$app->request;
$file = UploadedFile::getInstanceByName('file');
$tempPath = $file->saveAsTempFile();
// Create as permanent asset
$folder = ...
- 584
4
votes
1
answer
518
views
Is there a way to convert a Craft MySQL database to PostgreSQL?
I have an existing Craft installation using MySQL and I've only recently realized the error of my ways and would like to convert the database to PostgreSQL.
Is this possible?
- 66.3k
1
vote
1
answer
84
views
Download database in gzip
With using the CraftCMS builtin database export feature, is it possible to specify the export config to have the file in .gzip instead of just .zip? If, yes, then how can I do it?
- 153
3
votes
2
answers
205
views
Migrate Craft CMS installation from PgSQL to MySQL - any hints?
We need to migrate a Craft installation with a pgsql dump to MySQL.
Any hints on the procedure?
Thanks,
Matthias
- 1,630
1
vote
1
answer
40
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'...
- 389
0
votes
1
answer
66
views
How do I upgrade the MYSQL database from Craft 2 to Craft 3 on GoDaddy
How do I upgrade my MySQL DB for a Craft 2 site to Craft 3. I don't have access to the SSH server or use of Composer, so I have to move files via FTP and do everything manually.
My client is on ...
1
vote
1
answer
170
views
Craft Internal Server Error
I am getting the following error:
Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #34 of SELECT list is not in ...
- 121
1
vote
1
answer
167
views
How to query in MySQL all entries with related categories
I have a custom product grid not associated with Craft Commerce. I am wondering, how can I query, in the SQL database, all entries and their related categories?
- 53
0
votes
0
answers
435
views
Control panel - Entry indexes very slow
Craft CMS 3.3.15
PHP 7.1.3
MySQL 5.5.42
I have a structure with 360 entries.
Right now in the CP it takes 3.5 - 10 seconds to load the first 50.
And another 3.5 - 10 seconds for every additional ...
- 440
1
vote
1
answer
908
views
ERROR 1370 (42000) alter routine command denied to user
I am trying to upload my DB using MySQL Workbench but am getting this error:
ERROR 1370 (42000) at line 4534: alter routine command denied to user 'detectalocal'@'%' for routine 'detectalocal....
1
vote
1
answer
62
views
Using {% cache %} tags around {% template %} includes (or in Header)
I was wondering if it makes sense to wrap these {% cache %} around {% include %} tags that call a separate file with params. Is it better to just include them in the actual file itself?
For example, ...
2
votes
1
answer
345
views
Can't backup DB locally with MAMP PRO 5.5.1
I have followed the instructions for this article (https://craftcms.com/guides/database-backups-in-craft-3-with-mamp) to get local backups working with MAMP. However, when I attempt a backup, I get ...
- 699
2
votes
1
answer
391
views
Local DB SQL 'CDbException' Errors on Craft 2 site
Just tried to get a local site working again but getting all sorts of issues.
I have updated the website online and downloaded the database, installed locally. I have also the craft/app folder to my ...
- 343
1
vote
1
answer
150
views
Is MariaDB required with Craft CMS or can MySQL be used?
I am currently installing Craft CMS on a test server, The server runs other development services. Currently installed on the server is MySQL 14.4.
Is Mariadb are requirement or can I utilise MySQL?
- 11
2
votes
2
answers
299
views
Get last item added to cart
Does anyone know a nice way to get the last lineItem(s) added to a cart in craft commerce via twig template? Example use case, an 'added to cart' confirmation page. I know for this you could query ...
- 101
1
vote
1
answer
490
views
Can't Backup Database - "Failed with exit code 1" (WAMP Server)
I'm running Craft 3 on a local windows machine, but every time I try to update certain plugins (or Craft itself) I get a message "Couldn't back up the database. How would you like to proceed".
The ...
- 182
0
votes
0
answers
98
views
Unable to delete Entry: Numeric value out of range
I have a Structure section that I converted to a Channel. I then tried to delete an Entry Type from the Control Panel and get the following error:
{"error":"SQLSTATE[22003]: Numeric value out of ...
- 13.2k
1
vote
0
answers
126
views
Database Query in debugger consistently showing over 2000ms
In trying to optimize my Craft 3 site, I have discovered that it's apparently taking longer than expected to query my database. The duration for the apparent culprit is typically between 1900 and ...
- 409
1
vote
1
answer
107
views
Craft 2.X Local setup error – Craft not connecting to MySQL (via Sequel Pro)
Novice dev here, really struggling to get my local setup functioning. After a couple of days of wrestling with Apache config settings, I finally have Craft connecting via a VHOST setup. The problem –
...
- 21
1
vote
1
answer
119
views
templatecachequeries entries with of 157.000 characters in query column
after enableling querycaching in craft3 I found rows in templatecachequeries with big amount of characters in the query field. I decoded it with base64 and got this as the largest entry:
query_length:...
- 171
0
votes
0
answers
113
views
Emojis on Craft 3 front office
I'm making a blog.
I have a wheelform comments input type that needs to be stored as utf8mb4 in the local database.
My MySQL database version 5.6 is configured to utf8mb4 in the database, tables, ...
- 203
1
vote
1
answer
2k
views
What is CDbException Error: SQLSTATE[42000]: Syntax error or access violation while moving a site to remote?
CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #28 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'site....
- 55
1
vote
1
answer
466
views
MySQL "Access denied for user" after moving to new server
I've moved my Craft 3 installation to a new server.
When connecting to the original database, everything works fine.
However, when trying to connect to a new MySQL database (I've tried hosting this ...
- 161
1
vote
2
answers
75
views
Upload failed. The error message was: "SQLSTATE[23000]: Integrity constant violation:
I'm getting this strange error when I'm trying to upload an .jpg in the assets.
Env: Localhost
Craft version 3.1.8
MAMP:
- PHP(7.2.7)
- MySQL: 5.7.21
Upload failed. The error message was: "...
- 11