Questions tagged [database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
2answers
37 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
30 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
46 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
23 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 ...
0
votes
0answers
26 views

Description of Craft database tables

Is there some kind of description of Craft database tables that explains what each table is used for?
1
vote
1answer
24 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
32 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
vote
1answer
26 views

Entry Search Unbearably Slow

Anyone have any tips on speeding up entry searches? Ours are currently taking about 90 seconds per search. Some stats about our Craft database: Entries: 336,000 Relations: 4,390,000 (!!!) Search ...
0
votes
0answers
50 views

Custom Elements + Joins

I'm having a bit of trouble wrapping my head around an SQL issue with a custom Element. One column in my Element's table—for the case of this question, let's call it myplugin_things—has a foreign key ...
1
vote
1answer
60 views

Craft CMS 3 - Manual database backup

Since my hosting provider is blocking mysqldump on its server, I'm trying to do a manual backup of my database in order to import the DB into my test environment. I'm stuck on the elements to ignore ...
1
vote
2answers
27 views

Querying across relationships in a template

I have two Sections on my site: Country and Alert. The Alert section has a relation with Country via an "Entries" field. An Alert represents something that is happening in a particular country for a ...
1
vote
1answer
47 views

How to host a huge website on Craft (10k pages, over a dozen languages, 2GB database)

We have what appears to be a very large website. We have a strong content strategy which has led us to develop a huge number of pages (over 10k) for our website, as well as building out a significant ...
0
votes
0answers
17 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 ...
1
vote
1answer
146 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 ...
2
votes
1answer
122 views

Best practice for multi site development, staging, etc. [Special snowflake details inside]

The story: Site A is running in Craft 3 as the primary site. (On a subdomain, if that matters.) Sites B and C are running in ExpressionEngine 2. I need to write new HTML/CSS for sites B & C. I ...
1
vote
1answer
27 views

Restoring a database results in error

I downloaded a database backup from the craft back-end. I've tried to restore it via PHPMyAdmin and MySQL workbench, and I get the following errors: ERROR 1227 (42000) at line 18: Access denied; you ...
0
votes
0answers
245 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 ...
1
vote
1answer
28 views

Field removed from entry layout is still displaying

So I'm setting my meta author tag this way: <meta name="author" content="{% if seoAuthor is defined %}{{seoAuthor}}{% else %}{{globalSeo.seoAuthor}}{% endif %}"> seoAuthor is a field that ...
1
vote
1answer
65 views

Why is this Twig code generating large numbers of DB queries?

I have a Twig include that generates a News Archive side-bar. It works great, but I've just noticed that on a particular project it's contributing in the region of 800 DB Queries when caching is off. ...
1
vote
1answer
27 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 \ ...
0
votes
0answers
121 views

Database Exception – yii\db\Exception

I created a plaintext field called 'researchYear' that was add to a section called 'research'. I added a record to the section. I went back to the field, renamed it to 'researchDate' and made it a ...
1
vote
1answer
93 views

How do I set up Craft 3 to web server in WAMP?

I'm very new to Craft CMS, and I certainly love this concept! However, I keep trying to run it locally onto my computer following the documentation here https://docs.craftcms.com/v3/installation.html ...
1
vote
2answers
57 views

In a plugin, how to get entry status?

This seems like it should be simple to find, but where does Craft store the status of entries (lightswitch for enabled/disabled)? It doesn't seem to be a column in the entries table, and I can't ...
0
votes
0answers
22 views

When doing dry-runs of a Craft 2-3 migration, why don't plugin migrations run on fresh databases?

I've been working on migrating our site from Craft 2 to Craft 3 and even our business logic plugin seems to be running well. In order to be sure that we have all the steps needed to get our testing/...
1
vote
1answer
33 views

ERROR: relation “assetindexdata_id_seq” already exists on new database

I'm using PostgreSQL locally and everything is working as expected. However, when I decided to move/restore the database to the staging environment I am getting this error (even through the tables do ...
1
vote
1answer
187 views

How save data from form in headless Craft via Vue.js

I have front-end form on Vue.js and Craft CMS for the backend. I need form. And I want to save data from the form in Craft CMS. How to save data from user frontend to backend on Craft CMS?
0
votes
0answers
49 views

Database level fix for corrupted Structure section generating “unknown errors”

This is a partial duplicate of a direct support request raised through email. I have 2 Structure sections that have been behaving just fine in Craft 3.1.32.1: One of them continues to be fine But ...
1
vote
0answers
25 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
166 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
1answer
51 views

Database migrations on environments - in which env do I apply updates to Craft and Plugins?

When developing a Craft 3 site on a multi-environment setup, where would I apply the Craft and Plugin updates? Should I apply them locally and then commit and replace the database in the dev env, or ...
1
vote
1answer
15 views

some assets have volumeId set to NULL in database

I noticed that some of my assets have volemeId column set to NULL in the database table assets. Is it normal? Should I attach them manually to some volume?
0
votes
0answers
22 views

Possible to move matrix content from one global set to another

Is it possible within the database to manipulate a couple of keys to move matrix content to another global set without having to re-enter it all in Craft 3? I have the matrix field in both global ...
1
vote
2answers
470 views

Craft “Unsupported DB driver” error after resetting Windows

I'm using WinNMP for my local dev environment. I installed and configured everything successfully last week, and everything was running well. Unfortunately, I needed to reset my windows installation ...
1
vote
1answer
143 views

Assets Error: Unknown or bad format (years) at position 0 (y)

I am getting a new error, after no apparent updates from me or the client. The error only appears on pages with this one particular field. "DateInterval::createFromDateString(): Unknown or bad ...
1
vote
1answer
314 views

Migrating Server - Craft isn't installed yet

I've set up a new Forge server and connected the repo to my site. I've also uploaded the database and copied over the db credentials to the dotenv file. However when I visit the site control panel ...
1
vote
0answers
54 views

Should project config be used during development when migrating from Craft 2?

I'm looking for general advice on the best approach to handle a reasonable sized Craft 2 site to Craft 3.1, related to DB changes. Because the Craft 2 project is live and constantly changing, I ...
1
vote
1answer
109 views

Can't login after restoring production DB locally

I'm attempting to restore a postgres DB backup on to my local dev environment but I encounter an error when trying to login as the admin user (the salient parts being): SQLSTATE[23502]: Not null ...
1
vote
1answer
378 views

How do I import database using the CMS Craft 3

We have previously used the Schematic plugin for database import inside a Docker container for a Python script. This is the command used for the importing, $/data/craft/craft schematic/export --file=...
1
vote
1answer
194 views

Install Failed - Numerous Errors when running with pgsql

Getting Numerous errors when trying to test a staging environment with Craft 3.1. States Install Failed - Check Logs which I have and I'm seeing the following logs being given. I don't understand what'...
1
vote
1answer
641 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....
1
vote
1answer
188 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 ...
2
votes
0answers
128 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. ...
1
vote
1answer
90 views

Setting Up Multiple Sites

I've tried following the guide for setting up multiple sites (https://docs.craftcms.com/v3/sites.html#creating-a-site) but I think i'm missing something. Firstly the craft install on your beta site, ...
4
votes
2answers
671 views

“Craft CMS does not support backtracking to this version. Please upload Craft CMS 0 or later.”

I have a problem related this and this question. I began updating a long time ago (2017?) and got the error "Craft CMS does not support backtracking to this version. Please upload Craft CMS 0 or later"...
1
vote
1answer
61 views

Craft 2, MySQL database, Twig, JavaScript files

I have created in Craft 2 CMS, under the profile of users (ex. parents), new tab for (children), where parents can fill in there children information. The data is saved in a database under the ...
1
vote
1answer
67 views

Craft CMS 3 Content Mover

My database was corrupted after updating to 3.1.0 and no backup. Is there any script to move fields, sections and other staff to new fresh database? Update I found something like this scripts, but ...
1
vote
2answers
144 views

Unable to access site after importing DB

I am installing a repo locally, and everything runs smoothly and I am able to see the site and login to my admin. But when I import my DB then visit my site: I get the error message "Site unavailable"....
1
vote
1answer
385 views

How to connect to a Remote DB using CraftCMS 3.1+

I tried using Andrew Welch's craft-connect plugin, but the plugin was throwing an error on the REMOTE_DB_SERVER variable. I commented the variable out in the .env file, but I still could not connect. ...
1
vote
1answer
92 views

Connect to an external database from a Craft 2.x plugin

I recently saw a very helpful post about how to connect to an external database from a Craft plugin and I wanted to confirm I understood the implementation correctly. On this response the author ...
1
vote
2answers
300 views

Import database backup when using docker

I am trying to import a database backup into a craft instance running on Docker, but none of the fields or content from the latest backup are importing. Here are the steps I took I used these ...

1
2 3 4 5
7