Questions tagged [database]

The tag has no usage guidance.

33 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
0answers
283 views

Diagnosing Slow Database Connection for Entries (Frontend and Craft Admin)

We have set up a remote database connection for Craft CMS so that I and my colleague can work on the same database locally. The connect seems very slow both front end and in the admin area. ...
2
votes
0answers
41 views

Data Model to Accommodate Statutory Text?

I am planning to build a searchable database of statutory text, and am wondering what would be the best way to model my data for ease of linking spot citations and related text. The statutes are ...
1
vote
1answer
40 views

Special characters like ✓ are not being saved in text fields

we have just noticed that characters like ✓ are being saved in the title field but not in plain text fields regardless of the database type (PostgreSQL / MySQL) or field type in the database (text, ...
1
vote
0answers
21 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 ...
1
vote
0answers
72 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. [...
1
vote
1answer
60 views

How can I change the Date Created for Assets?

I'm using graphql to pull in some assets/pdfs and ordering them by dateCreated, however the files go back a few years (i.e. files from 2019, files from 2018 etc.) but they weren't uploaded in the ...
1
vote
1answer
48 views

Store phonetics in plain text field

I need to store phonetics for word definitions in a plain text field. An example would be something like "Craft Website" => \ ˈkraft ˈweb-ˌsīt \, like you'd see in a dictionary. If I try saving \ ...
1
vote
0answers
27 views

Storing complex field content (plugin)

I'm trying to work through some issues with the field content for our Maps plugin, but I'm not sure about the best way to go about it. Currently the value for each map field is stored as an element ...
1
vote
1answer
401 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 ...
1
vote
0answers
469 views

Cannot add more fields - SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large

I've been bumping into a field limit when attempting to mirgrate fields in, which is a massive limitation for the way the site was originally set up. I've read a bunch of other threads where it's ...
1
vote
0answers
362 views

Craft 3 : Can't backup database ("failed with exit code -1")

I can't backup database, the log says : [error][yii\base\Exception] yii\base\Exception: Could not create backup: The shell command "mysqldump {{...blablabla...}} failed with exit code -1. in /...
1
vote
0answers
102 views

Problems while setting up a cross region Craft website in AWS

In order to create a cross region setup for my craft website, I've created a read-only replica of my RDS DB from North Virginia region to Canada Central region. I'm facing the internal server error ...
1
vote
0answers
45 views

The fieldtype class “insert fieldtype class here” could not be found

I'm specifically having this issue with Sprout SEO, but I would imagine the problem would persist across any plugin, given whatever solution is used. Anywho, so I've got three environments - dev, ...
0
votes
0answers
56 views

Very slow site speed

Most pages on our large site are taking far too long to load. I have gone through and made some template changes that have been suggested, and currently have been running rebuild search index for over ...
0
votes
0answers
30 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 ...
0
votes
0answers
20 views

Extending model from yii\db\ActiveRecord, still get error missing column "dateUpdated" on save()

title says it all. I prefer not to have these columns and I read that these are the only difference between Craft\activeRecord and yii\ActiveRecord, and that extending from yii version should be ...
0
votes
0answers
12 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, ...
0
votes
0answers
28 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 ...
0
votes
0answers
19 views

Adding A Soft Delete in Craft 2 Entries

I've been thinking of adding a "Soft Delete" or just perhaps a means in which deleting in certain sections (e.g. News) will archive the entry with an update, rather than deleting it. As I ...
0
votes
0answers
38 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 ...
0
votes
0answers
42 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-...
0
votes
0answers
50 views

When Using Nitro Add and it gets to the choose database engine question, the choices arent there and typing in doesn't work

I'm totally new at craft cms and nitro and I'm having trouble adding a new site. When I get to the part where it asks you which database engine to use there's no options there to choose from and ...
0
votes
0answers
19 views

Avoid Camel Case for S3 VolumeFolder

I have an S3 volume with a row in the volumefolders table that uses camel case. This is not appropriate for our S3 configuration. Can I just update the row to downcase the name and path? Is it ...
0
votes
0answers
38 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 ...
0
votes
0answers
21 views

Need to populate new field based on existing data

Say I have a section called "Stores" that has an existing field called "Store Hours". The client has populated the store hours for 1000 some stores. Now, however, it seems what the ...
0
votes
1answer
81 views

Database Connection Error after updating from Craft 2 to 3

Good evening all, I am updating a small site from Craft 2 to 3, and after following the instructions in the documents, I loaded up the backend of my site and was greeted with the install screen. I ...
0
votes
0answers
47 views

Deleted plugins still in database? (and reappearing in project.yaml)

I can see about 10 plugins in the craft_plugins table that have been long removed via the Craft CP panel, and removed from the composer files also. However when I enable project config, these deleted ...
0
votes
0answers
1k views

Craft can’t connect to the database with the credentials in craft/config/db.php

I'm trying to upgrade from 2.7.10 to Craft 3. I follow the instructions/ docs to the letter, go to https://###.com/admin and am greeted with the above can't connect to database message. So far, I ...
0
votes
0answers
323 views

Setting up Craft 3 database backup command for a remote database server

I have my Craft 3 database on a separate server than my Craft webserver (load balancing) and when I use the download database backup function in Craft 3, it doesn't know where to look. I haven't ...
0
votes
0answers
93 views

amforms: Import form submissions from one site into another

Using Craft 2 and amforms, I created a massive form on a client's temporary site while working on the full refresh on a staging server. While that development's been going on, the live temp site has ...
0
votes
0answers
613 views

How to get GoDaddy to connect to db?

I've been trying to get a quick staging environment setup on GoDaddy all day. By using die('foo') I can tell that GoDaddy is able to reach all of my files (public/index.php, craft/config/db.php and ...
0
votes
0answers
149 views

CDbException: Column not found

I created a Matrix field with 1 block type called "Logo" and 2 fields inside that: 1) a related entries field and 2) an image asset. I then created a global that has this Matrix field in it that ...
0
votes
0answers
76 views

Craft requires MySQL 5.1, got 5.1.73 and an error

I just moved my website on my production environment, and when I try to login, I get the "MySQL 5.1.0 is required..." So I did a phpinfo() and got Client API version 5.1.73 for MySQL. What did I do ...