Questions tagged [database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
13 views

Nitro: location auf databases / can not delete db

I am experiencing some weird behavior with data in my Postgres 11 db in Nitro so I completely want to reinstall it. I used nitro db destroy to remove the complete container, but after creating it ...
1
vote
1answer
19 views

Craft CMS admin intermittent internal server errors

I'm getting intermittent Internal server errors in Craft admin. This has happened out of the blue on an active site. Craft pro 3.041 phperrors.log: PHP Notice: Undefined index: constraint_name in /...
1
vote
1answer
34 views

Migrating Craft CMS 2 to 3

I have a craft CMS 2 codebase that a former developer had made for running on our PHP 5 server. Recently, the server upgraded its PHP version to 7.3 so I am trying to migrate the website to a later ...
0
votes
0answers
28 views

Can someone help me solve for this error message: "Craft can't connect to the database with the credentials...."

Can someone help me solve for this error message: An exception has been thrown during the rendering of a template ("Craft can't connect to the database with the credentials in craft/config/db.php....
1
vote
1answer
20 views

how to write db-commands on custom table (PHP syntax) inside twig file?

if i have a custom table (ct_table) and i have to use MySQLi commands on it using the PHP syntax, it won't work if i put the PHP snippets inside a twig file. So are there any tools or official methods ...
0
votes
0answers
61 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
31 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 ...
1
vote
1answer
37 views

Reapplying Users and Related Content to Database During Pipeline Promotion

I was on a dev ops call this afternoon and am wondering about the viability of a proposed solution for pushing changes to a Craft product through a dev pipeline. For context, this is for a big company ...
1
vote
1answer
24 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 ...
1
vote
1answer
43 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, ...
0
votes
0answers
13 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, ...
1
vote
1answer
61 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?
0
votes
0answers
37 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
20 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
45 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 ...
1
vote
1answer
83 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 [...
0
votes
0answers
44 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-...
1
vote
2answers
95 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 ...
0
votes
0answers
90 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 ...
1
vote
2answers
63 views

Synching content and template files across environments

I'm new to CraftCMS and have a few basic questions about synching contents between local and remote development environments. This has been discussed in other posts by I'm looking for more specific ...
1
vote
1answer
24 views

Why does the matrix field produce such a massive amount of duplicate information?

The matrix field in Craft CMS is producing massive quantities of duplicate data. About 70 database rows per entry. Is there something I'm doing wrong? I don't think this will be sustainable for my ...
1
vote
0answers
23 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
106 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. [...
2
votes
1answer
40 views

How to keep staging install synced with member registration

What is the best way to keep live and staging environments synced with member registrations? I can export/import the database from the live to staging environment to keep it in sync - and have a ...
1
vote
1answer
47 views

Use Emoji in Title?

I need to be able to store emoji in the title field of several entries, but whenever the entry is saved the emoji characters are stripped out and replaced with four question marks i.e. ????. I imagine ...
0
votes
0answers
21 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
43 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 ...
1
vote
3answers
85 views

Deleting user data from the database

I'm using Craft 3.6.4.1 and I need to delete a whole tranche of users from the database (that has derived from another Craft instance). I've been deleting by hand via the CMS but note that loads of ...
0
votes
0answers
22 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 ...
1
vote
1answer
107 views

New security key for existing database

I've been hunting through questions here, Discord, Craft docs for solutions for a boilerplate Craft CMS install. Because I want to include section & field configurations, I'm planning on importing ...
1
vote
1answer
77 views

Cannot connect to outside mssql database in production

Error: Craft CMS can’t connect to the database with the credentials in config/db.php. I have two database connections. One to mysql for the bulk of the website including all things craft, and one ...
1
vote
1answer
77 views

Craft CMS: Data too long for column 'cacheKey' at row 1

We have Craft CMS v3 using multi-sites. We are using cache to cache whole pages based on the absolute URL as some URLs have query parameters which seem to be ignored when not using a key. So the ...
2
votes
1answer
118 views

Is there a name for Craft 3's database model?

I find Craft 3 to have a very clever database structure which eschews all of the issues I've seen with EAV. Despite contrasting the differences between Craft 3's model and EAV, I'm having difficulty ...
1
vote
1answer
165 views

Database Exception Column not found: 1054 Unknown column 'configVersion' in 'field list'

I get this Error when i want to save a Field. Also when i want to create a new field. I can hit the goback button and strangely the field gets still saved. I work local and have project config ...
1
vote
3answers
200 views

How to delete old content in a Craft CMS database?

I've create 20+ websites in Craft and each time I've always started with the use of another site's database. (time saving to not have to create all fields, sections and more) On my latest site's ...
1
vote
1answer
223 views

Deleting Duplicate Fields Brings down Craft Website and Server

I have somehow managed to duplicate some fields in my Craft install (see image of unused fields). When I delete the unused duplicates I create a server error and can't access Craft. To rectify I had ...
0
votes
1answer
99 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 ...
1
vote
1answer
27 views

Trying to create a new field returns "General Error: 1030 Got error 1 from storage engine"

I recently updated the site to 3.5.5, so not sure if this has anything to do with it. It's been a while since the last field we created, so can not say for sure if this is correlated. Database on this ...
1
vote
1answer
39 views

Is this a basic error, or do I misunderstand how Craft queries the database?

I’ve been wrestling with a site from another developer (who will not be named). He seems to have a pretty solid grasp of PHP, and I had assumed that he also understood Craft well. However, as I ...
1
vote
1answer
69 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
187 views

Database backup fails

I'm building my Craft site locally, but need to make it live. When I go into Utilities -> Database Backup and try to create a backup, I get the error "There was a problem backing up your ...
1
vote
1answer
181 views

Get id of row inserted into database

I insert data into database table using query builder: $command = Craft::$app->db->createCommand()->insert('test2', array()); $command->execute(); How can i retrieve id of newly inserted ...
1
vote
1answer
68 views

Import / Aggregation DB - with 50 Million Records - Best Practice?

I'm working on my second Craft project ever. (First was an ultra-simple site just to learn the basics.) With this new project I need to accomplish 2 things... (1) - Private - Import/aggregate mass ...
1
vote
2answers
100 views

Problems transferring updates back to live server

For quite a long time i've updated and amended Craft by taking a copy of the files and database (.zip) from the live server, making the updates/changes/amendments locally and then transferring ...
1
vote
1answer
272 views

SQLite database support

Is there any plan on supporting SQLite someday? It would be very interesting for small instances where we can't create any MySQL or MariaDB databases for example (in my case, free tier hosting coming ...
1
vote
1answer
111 views

How to create an entry with MySQL?

I'm trying to create a new entry from within the database. The section is defined in craft_sections, and the entries for craft_elements, and craft_entries seem correct after the script is run, but no ...
1
vote
1answer
75 views

Click counter for links (craft v2)

So I'm new to PHP and ok with Javascript. I have a page on my site with a long list of external links, would it be possible to add a counter to be displayed next to each link that shows how many times ...
1
vote
1answer
367 views

AWS EC2, Load Balancer and Updating Craft

I have a pretty large Craft site that needs to be load balanced with multiple ec2 instances and one RDS mysql instance. Everything is working great, except for I noticed that if I get to the admin ...
1
vote
1answer
539 views

Database Exception: Column not found: 1054 Unknown column 'position' in 'order clause'

I deployed the project from the git repository on hosting. When trying to open the homepage I get the following error: Database Exception SQLSTATE[42S22]: Column not found: 1054 Unknown column '...

1
2 3 4 5
7