Questions tagged [mysql]
The mysql tag has no usage guidance.
1
vote
1answer
51 views
Incorrect user-level lock name - Local Vagrant Environment - Craft 3
When creating a new field, I received a Database Exception error -
SQLSTATE[42000]: Syntax error or access violation: 3057 Incorrect user-level lock name '/var/www/storage/runtime/compiled_classes/...
0
votes
0answers
33 views
Help solving Integrity constraint violation: 1062 Duplicate entry - when editing entry types
On Craft CMS 3.0.25. Not sure if this is a bug.
When saving an entry type I am getting the following error (with x's being the values):
SQLSTATE[23000]: Integrity constraint violation: 1062 ...
0
votes
1answer
33 views
Importing a database from backup
Long story short, I migrated from Craft 2 to Craft 3 but had an issue with a plugin.
Database Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'emailTemplateId' in 'where clause'
The ...
0
votes
0answers
41 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
15 views
Installation UI DB SSL
I have added this to the db.php file, and am now trying to get craft setup over /admin/install. However, the database screen still reports that unsecured transport connections are not allowed. What's ...
1
vote
1answer
24 views
What could the possible causes be for a mismatch between `craft_fields` and `craft_fieldlayoutfields` MySQL tables?
I'm debugging an Internal Server Error on a site developed by, well, not me. :p The site has an absolutely enormous Matrix field called "Modules", and the blocks in said field have so many fields that ...
1
vote
2answers
28 views
Find entries that use a specific block in their Matrix field?
Suppose a Mtrix field named MyMatrixField has three blocks called Text, Images, and Buttons.
What MySQL query would list the section and title for all entries whose MyMatrixField field has a Buttons ...
1
vote
1answer
27 views
Joining sections (Channel) to query based on a related item attribute
I've been trying this for a while now, so might have read this before. Sorry about that, I'm struggling really hard to get this right. At first I tried (wrongly) with the eager load features.
I have ...
1
vote
0answers
15 views
Paginate entries based on related status
So, let's assume I have two channels. events and movies, being events the screening time of each movie. In the admin, in the event entry, you can select one movie.
The movie could be disabled. The ...
2
votes
1answer
27 views
Error on import to Craft production db
I just copied my database across from local server to production server. I used Craft's control panel to create a backup. Then I used Sequel Pro to import this into the live server.
I got this error:
...
0
votes
0answers
87 views
“Unsupported DB driver value”
In my quest to get Craft setup on my server, I've run into yet another error. When going to example.com/index.php?p=admin, it quickly redirects to example.com/admin/install, and I get the following ...
1
vote
1answer
71 views
Randomly getting the “Integrity constraint violation” sql error on saving entry
Randomly getting the "Integrity constraint violation" sql error on saving entry from backend. There no apparent cause of this at least not that I can see, because the same post saves without errors ...
0
votes
0answers
17 views
Modifying a custom entry source elementindex key handle?
I have a plugin that uses two custom entry sources within the entries section by using the modifyEntrySources function.
I noticed a typo has been made with one of source key handle values. I want to ...
1
vote
1answer
21 views
Use utf8mb4 for database operations
the plugin I'm currently working on has to store user inputs which might contain 4 byte unicode characters like emojis. MySQL is not able to handle this with a utf-8 charset. It works if the charset ...
1
vote
1answer
412 views
MySql 5.7 error - field doesn't have a default value
We've just switched server for one of our sites and I am now encountering a MySql error on one of our plugins. The MySql version on the new server is 5.7 and throws an error as a field has no default ...
1
vote
1answer
179 views
Problem connecting to MySQL db on installing Craft 3
Having installed Craft 3 using Composer, I'm attempting to run the Craft setup. Everytime I try, I get the following error:
Testing database credentials... failed: SQLSTATE[HY000] [1044] Access ...
1
vote
1answer
34 views
Does Craft do joined calls or multiple ones when fetching the related items? [Element API]
I'm checking Element API's performance to decide if it's a good idea to replace my own custom API with Element API. Right now, when fetching the related items (Via fields or matrix elements), my API ...
0
votes
0answers
90 views
Craft 2 Query Builder from SQL Help
I am trying to convert a plain SQL query I have into query builder. I am getting close, both subqueries seem to be working independently in the query builder syntax but I am struggling to get the ...
0
votes
0answers
29 views
How to backup Craft 3.x on Wampserver
I'm curious to know if anyone has successfully figured how to backup Craft CMS 3.x databases using WAMP server or the like? This is from the logs:
2018-04-30 05:58:18 [::1][1][-][error][craft\...
0
votes
1answer
80 views
Craft 2.6 incorrect string value SQL error for 4 byte UTF-8 characters when saving entries
On a Craft site that uses the Dukt Twitter plugin I have started seeing SQL errors when saving certain entries that use Twitter data:
CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: ...
0
votes
0answers
75 views
SQLSTATE[42S22] Error when trying to update to RC14
I have just tried to upgrade my Craft Installation from 3.0.0-RC1 to 3.0.0-RC14 and I got a 504 timeout error. After boosting max_execution_time I ran composer update craftcms/cms which seemed to work ...
0
votes
1answer
210 views
Alternatives to Mamp Pro – which works with Craft CMS
I've been a long time user of Mamp Pro, but I'm getting an error using v3 with Craft3, due to needing to update to Mamp Pro 4, however after some hrs trying to update to Mamp 4, I can't get mySQL to ...
1
vote
1answer
54 views
Install MySQL stored procedure to database on plugin install in Craft 3
I am trying to add a MySQL stored procedure to the database on plugin install in Craft 3. I currently have an install migration calling a function from the safeUp method. In this function I am using ...
1
vote
2answers
80 views
Importing a Craft database error
I dumped from Craft my database from server A and am trying to install it to a fresh copy of Craft on server B.
I've got Craft up and running, and when I try importing my Craft SQL file in PHPmyAdmin,...
2
votes
1answer
124 views
Craft 3 Ubuntu installation error via composer setup
After running composer and then initiating craft setup I keep getting this error:
Username: [admin]
Email: abc@test.com
Password:
Confirm:
Site name: test
Site URL: test.com
Site language: [en-US]
...
1
vote
2answers
396 views
How do I get past this MySQL error installing Craft 3 using CLI
I am using https://box.scotch.io/ (vagrant).
I'm trying to install Craft 3 with the cli, but can't get past these errors:
Connection refused
No such file or directory
One or the other error shows ...
1
vote
1answer
38 views
Publishing entry returns Internal Server Error (1030 Got error 139)
Trying to publish changes in one of 3 locales of an entry gives error:
Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1030 Got error 139 ...
1
vote
1answer
109 views
MySQL CPU pegged on specific query
Very similar (almost exact) to this question: Poor performance on midsized site / Queries without index?
CPU keeps getting pegged to 100% for MySQL, which makes the admin interface very slow (the ...
3
votes
1answer
32 views
Workflow for re-using data structures and setups across projects?
I am wondering if there is a way to re-use pre defined field types and image crops over various Craft projects. I currently in the process of e.g. manually defining 20 different image crops I already ...
6
votes
2answers
944 views
Craft CLI RC1 Connectivity Issues with MAMP Pro
I've been trying to run the new Craft CLI for the last couple of versions without any success. I figured maybe since we weren't at RC1 yet that it wasn't fully working. After seeing Ryan's video about ...
1
vote
1answer
57 views
Craft 2.6.2999 install error: Base table or view already exists: 1050 Table 'craft_entryversions' already exists'
I keep getting stranded at the "Oops" modal on install. This is on the third Craft site I've started. The other two Craft 2 sites stood up fine, an I've been developing them for nearly a year.
I've ...
1
vote
0answers
55 views
Creating coupon using Charge 2 plugin
I just updated the Charge 2 plugin to latest (version 2.2.1) and when I try to create a new coupon, I get this error:
CDbException
CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: ...
0
votes
0answers
103 views
Base table or view already exists: 1050 Table
I don't know if this is the proper place to ask my question, as I'm running into this error on a local development setup with Vagrant/Homestead.
I'm getting the "oops" screen during the install. ...
1
vote
1answer
29 views
Pruning the users table
I have a site that deals exclusively with user generated content.
After a few years, the users table is getting to a stage where it can probably be pruned of folk who have registered but not actually ...
0
votes
0answers
20 views
Ghost submission entries in amforms data transfer
I have a temporary site I've created that is currently accepting applications using amforms. Meanwhile, I am building a new site on a staging server that will eventually replace the temp site. ...
1
vote
1answer
89 views
MySQL Error 1064 when trying to create a Matrix
Running Craft Version 2.6.2994 on an EC2 instance that has PHP 7.0.21, and MySQL v 5.6.37 installed. When I try to create a new Matrix, I get the following error when saving.
When I test this on my ...
1
vote
1answer
54 views
Base table or view already exists
Getting the following error on production environment when trying to add a new Field.
CDbCommand failed to execute the SQL statement: SQLSTATE[42S01]: Base table or view already exists: 1050 Table '...
1
vote
2answers
35 views
What might cause logins to work locally yet not in deployed environment?
We're getting a 404 (or a Craft 'page not found' error) with this path on the remote server:
http://foo.example.net/admin/actions/users/login
Same database using remote mySQL. Local logins work fine....
1
vote
0answers
64 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 ...
3
votes
1answer
271 views
Entry view count in the last 24 hours
I'm working on a typical craft blog with articles. I know there is a plugin that was used to teach craft plugin development that tracks entry visit counts here:
https://straightupcraft.com/craft-...
1
vote
1answer
330 views
SQL Error - cannot add foreign key constraints
I'm uploading a site to a new environment and getting the following error:
The assetfiles table structure:
0
votes
1answer
85 views
Help with admin panel errors. Fresh install. Mysql version issue? [duplicate]
I get this on the admin panel:
CDbException
CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #18 of SELECT list is not in GROUP BY ...
3
votes
1answer
235 views
Poor performance on midsized site / Queries without index?
I'm running a mid sized website (couple hundred articles, between 30-50k visits per day) on a Digital Ocean 16GB / 8 Cores web server and I have two questions:
Most of the time the website runs ...
2
votes
2answers
247 views
See the SQL query that gets executed when saving entry
I'm creating a pretty specific entry with some fields. And I want to create the from a third party app. For that, I'd like to see the SQL query that get executed.
I've tried it with events, entries....
1
vote
1answer
327 views
Internal server error in Admin after migration
I'm setting up a website using Craft Cms.
Everything was working fine on local dev, but now I moved it to a development server, I'm getting an error every time I try to create a new entry (or section)...
1
vote
1answer
70 views
Tagging all assets in a sub directory
I'm building a project with a lot of photo assets organized into sub directories of the main photos asset source. I'm trying to add tags to these assets so they are searchable when I try to use them ...
2
votes
1answer
144 views
DB back-up gives syntax errors on import in new DB
I had this issue on two different sites on two different occasions and hosts.
When creating a database back-up through the Craft CMS admin and importing that SQL file into a new database through PhP ...
1
vote
2answers
108 views
Order entries, exclude 'the' from order criteria
I know this is partly a Twig question, but I've poked around quite a bit here, in Twig docs, Craft docs, and cannot find the right syntax.
I have a bunch of entries with titles like:
Hotel A
Grand ...
4
votes
2answers
554 views
Dump SQL query in Twig template
Is possible to dump a query made on a twig template for a statement like this one for example:
craft.entries.section('homepage')
Can we some how see the actual SQL query ?
1
vote
1answer
3k views
PHP notice unserialize(): Unexpected end of serialized data
Ok so this is an incredibly wierd one and I have no idea how to explain the problem in just one sentence so I just put the error message as the title.
So I am building a site with craft...in fact its ...
