Questions tagged [database]
Drupal provides a standard, vendor-agnostic abstraction layer for accessing database servers.
3,091
questions
0
votes
0
answers
9
views
Auto increment value less than max uid on users table
I'm seeing these errors flooding my log file.
They come from commerce order complete pages - and some registration pages too.
Drupal\Core\Entity\EntityStorageException: SQLSTATE[23000]: Integrity ...
- 91
1
vote
0
answers
32
views
How to add groupBy option WITH ROLLUP
With Drupal 9.5.3, a group by like this:
$query->groupBy("myfieldname WITH ROLLUP");
will result in
(...) Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S22]: Column not ...
- 11
1
vote
0
answers
22
views
How can I find all the nodes that use a hierarchical vocabulary taxonomy term and reference a child term but not its parent term
I am using Drupal 7.
I have a content type "Public Resource" that uses a hierarchical vocabulary called "Resource Topics" that has up to 3 levels (parent->child->child of ...
- 11
4
votes
0
answers
64
views
How can I dynamically switch between two databases for ALL queries?
I need to copy some entities from one Drupal 9 database to different Drupal 9 database. I have searched and looked high and low, but none of the examples I have found work anywhere. I found no help on ...
0
votes
1
answer
37
views
How do I enable all error messages altering directly a database table?
When I try to log in on a site, I get a generic error, which doesn't help in understanding what exactly is going wrong.
I would like to enable the All messages, with backtrace information option shown ...
-1
votes
1
answer
263
views
Unable to connect to database when launching a new Drupal site with Lando [closed]
I tried to set up a new local drupal9 site using Lando, but it is unable to connect to the database and I am getting the following error.
Failed to connect to your database server. The server reports ...
0
votes
1
answer
88
views
Database update doesn't work after update from 9.2 to 9.3
I have unfortunately not found anything that seems to solve my issue. My Google-fu may be defunct.
I have upgraded a Drupal site from 9.2 to 9.3. This works as expected with composer (I use drupal/...
0
votes
1
answer
26
views
How can I delete properly an old translation string?
I found an old string into locales_source table, like that:
The associated 8.5.3 version seems outdated.
I would like to understand the usefulness of the keep this data in my database ? How to clean ...
- 355
1
vote
1
answer
92
views
Migrating from D7 / MySQL 5.6 to D9 / MySQL 8
I've read the documentation of upgrading (migrating) from D7 to D9, but didn't see anything about how to handle
changing MySQL versions in the process.
My D7 instance is on MySQL 5.6, which is ...
- 47
0
votes
1
answer
70
views
How to get fields of a product type using a database dynamic query
So I currently have multiple different product types that have varying fields. I was able to fetch all products using EntityTypeManager the following way:
$productStorage = \Drupal::entityTypeManager()...
- 41
-2
votes
2
answers
75
views
SQL error in Module
I'm trying to query the database inside my module, but I get this error.
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in ...
- 11
0
votes
0
answers
495
views
Argument 2 passed to Symfony\Component\Routing\RouteCollection::add() must be an instance of Symfony\Component\Routing\Route, boolean given
Ubuntu 18.04.6
Apache2, Postgresql 10, Drupal 8.9.6, PHP 7.2.34 (most of the modules require these versions)
I've tried trouble shooting this problem for multiple weeks. I'm attempting to migrate a ...
0
votes
1
answer
54
views
How can I collaborate with multiple developers? [closed]
I am developing a website on Drupal with 2 other developers. What would be the best way to collaborate? We plan to work on different git branches and there will be a dev and production branch as well. ...
0
votes
0
answers
11
views
Can I calculate percentages between two subqueries in addExpression()?
I am trying to calculate the results of two COUNT() subqueries in order to produce a completion percentage. In this case I am getting the total number of courses assigned to an entity then comparing ...
- 1
3
votes
2
answers
105
views
Where is it documented that fields included in the entity_keys are 'required' regardless of the required property value in the field definition?
I've created a custom entity. One of the fields I've added is an entity reference field that was created calling BaseFieldDefinition::setRequired(FALSE). When I installed my module and tried to add a ...
- 55
-3
votes
1
answer
75
views
Access denied in Drush but granted in GUI [closed]
I am trying to install Drupal on a CentOS based shared server environment (namecheap.com) with mysql, ssh and Composer.
I have created a database username and a database with the same name and a ...
- 1
0
votes
0
answers
48
views
Uninstalling Commerce Recurring and Commerce License
For some time now, I have been experiencing trouble related to the commerce_recurring and the commerce_licence module. The problems seem to have started to occur once I tried to uninstall the prior. ...
1
vote
2
answers
251
views
How to display results database query in a custom block
This is my first post - so hello everyone :)
I am trying to write a custom module that displays a certain number of posts from a certain category. I need a few of these blocks to display posts from ...
- 9
0
votes
1
answer
225
views
Delete a custom field from node_field_data table
A custom module added a field to the node_field_data table. Deleting the field in a hook update like this:
function HOOK_update_N() {
Database::getConnection()->schema()->dropField('...
- 285
-3
votes
1
answer
56
views
How to change a text with one dynamic term in all nodes? [closed]
I have a core website, no contrib modules or themes are installed.
All my nodes, from several content types, start with the following text, which is written in WYSIWYG CKeditor.
The term X is used to ...
- 3
1
vote
0
answers
36
views
Multiple value field create duplicate results when using leftJoin
I have a query to the database for a specific content type. Everything is working as expected but when I add a leftJoin query on the field 'node__field_country' which is a taxonomy term reference ...
- 11
1
vote
0
answers
1k
views
I can't import the configuration on production servers [closed]
I am unable to uninstall the MySQL module. I can't import the configuration on production servers when I upgrade Drupal from 9.3.x to 9.4.x.
I get the following error.
The import failed due to the ...
- 539
4
votes
1
answer
180
views
Is it possible to have a nested SELECT in a WHERE clause using dynamic queries?
I need to execute this SQL query using dynamic queries.
WHERE (node_field_data.status = 1)
AND (node__field_document_places.entity_id IN (SELECT entity_id FROM node__field_document_places where ...
- 383
3
votes
3
answers
98
views
How to check if secondary database definition exists
Can anyone please help me on how to check if secondary database is set. If not throw an error.
I am currently defining database connection as below.
Database::getConnection('default', 'sqlite')
I am ...
- 1,511
0
votes
1
answer
24
views
Access FieldItem object from Widget
I have a custom FieldItem with a method doing a calculation on the field's values:
class MyFieldItem extends FieldItemBase {
...
public function getAmountInEuros() {
$amount = $this->get('...
- 559
0
votes
0
answers
46
views
TableSort with entity query aggregate
I'm trying to implement a table sort for a custom Drupal 9.x entity type Packet which represents published medical literature articles which have batched together and assigned for review. Each Packet ...
- 85
0
votes
1
answer
453
views
How to solve "Mismatched entity and/or field definitions", specifically, "The URL alias field needs to be installed"?
After migrating from 7.89 to 9.3.12 this warning appears:
ENTITY/FIELD DEFINITIONS Mismatched entity and/or field definitions
The following changes were detected in the entity type and field ...
- 21
2
votes
2
answers
146
views
How to use a referenced entity's values in a TableSort?
I have a custom entity with a field which is defined as follows.
$fields['file'] = BaseFieldDefinition::create('file')
->setDescription('Reference to the built-in core File entity type.')
->...
- 85
1
vote
0
answers
82
views
Trying to get to the bottom of an out of memory error related to the database
I've inherited a highly problematic site built in Drupal 7. Upon installing the site on my dev space I get a 'This page isn’t working' error 500. Looking at the web logs I get this message:
lmu.[...
- 161
-1
votes
1
answer
84
views
Installer can't create sqlite database
I have a drupal page, hosted with azure webapps, on nginx. However, when i start the site, the installer wants to have a database. I am aware that it's bad, but sqlite is an intentional choice because ...
- 11
0
votes
0
answers
63
views
How do I set an incremental property on a custom field?
I built a custom module which creates a custom field type (with formatter and widget), and I would like to make one property of the field incremental (to increase its value by one for each instance of ...
- 247
1
vote
1
answer
173
views
Does a database transaction rollback if a PHP/Gateway timeout / connection dropped/lost occurs?
I am using Drupal behind a reverse proxy/cache layer (e.g. Cloud Front/ Akamai) and sometimes the service goes quite slow (so I get a Gateway timeout, for reasons such as too many people are using ...
- 344
2
votes
1
answer
968
views
How do I get the names of the tables where field data is stored?
In Drupal 7, one was able to retrieve the physical names of the database tables using some code like the following, it was pretty simple.
$field_definitions = field_info_fields();
foreach ($...
- 834
1
vote
1
answer
110
views
"[message] => DB Error: no such table" error after installing civicrm
I installed CiviCRM 5.47.3 plugin using composer in the centos 8 server.
my drupal version is 9.3.5
After installing CiviCRM on the server CiviCRM plugin is enabled automatically in admin extension ...
2
votes
1
answer
112
views
How to check which module db updates have been applied?
For a specific module, how can I check which database updates have been applied in Drupal 9? I've downloaded a database from a server and I want to check what the current module schema is.
In Drupal ...
- 27k
1
vote
0
answers
216
views
EntityQuery, exclude nodes with NOT IN from a multivalued entity reference field
Drupal v. 9.3.8
I recently used the entityQuery command and for simpler queries I had no problems.
Now I need to filter, as well as for the '=' and 'IN' operators, also the nodes, whose multivalued ...
- 61
0
votes
0
answers
48
views
Add prefix on tables break my site
I have an old site on an old shared server which used an old shared PHP 5 we can not update. I create a copy of this website which will run on a different (and dedicated) server with PHP 5.6 and ...
- 646
0
votes
1
answer
477
views
How do i save a base64 decoded image to file_managed?
I'm trying to save my image to Drupal's file_managed table. However, my image is coming from base64 decode:
$filename = "sign-".$user->id(); // returns "sign-1234"
$image_raw =...
0
votes
0
answers
78
views
Get count of related entities
I have two entities, Post and Category
A Post belongs to a Category via a entity_reference field type name category_id
I want to get a count of posts belonging to a category (To prevent deleting a ...
- 123
1
vote
0
answers
309
views
Installing to a MySQL database that requires SSL
I am attempting to install Drupal 9 to a fresh host using an AWS MySQL RDS instance for a database. The database is configured to require SSL. When attempting to install via the web GUI, I receive ...
- 111
0
votes
1
answer
106
views
Change a node's type/bundle keep the old type/bundle in field tables
I need to change the bundle/type of some nodes. I tried https://www.drupal.org/project/convert_bundles but there was no way to select just a few nodes and change the bundle/type so I tried the very ...
- 1,578
0
votes
1
answer
769
views
ERROR 1062 (23000): Duplicate entry '/-de' for key 'PRIMARY'
When importing a dump from a production site with mysql in a xampp environment I got this error:
ERROR 1062 (23000): Duplicate entry '/-de' for key 'PRIMARY'
These lines are affected:
ALTER TABLE `...
- 382
0
votes
2
answers
434
views
Load node entities by owner
I want to load entities by their owner. This is what I have so far:
\Drupal::logger('migrate_users')->notice("Hello start");
$userStorage = \Drupal::entityTypeManager()->getStorage('...
0
votes
1
answer
62
views
Where are path aliases stored?
I know that, in Drupal 7, path aliases are stored in the url_alias table. Which database table does Drupal 8 use to store path aliases?
- 143
0
votes
1
answer
269
views
Problem with database version for drupal 9 db upgrade
Hi I am trying to upgrade drupal 9 on godaddy and when I go to update.php I get this note on the screen...
DATABASE SYSTEM VERSION
5.6.51-cll-lve
The database server version 5.6.51-cll-lve is less ...
user105659
0
votes
1
answer
349
views
Search and Replace URL in database?
I need to move a Drupal 9 website to a different server and a lot of links have the old server URL. Normally for Word Press I use this tool - https://github.com/interconnectit/Search-Replace-DB https:/...
- 173
-1
votes
1
answer
99
views
Can't import sql dump file from the live site (trying to create a development site)
I am trying to create a development site which I can work on. So far, I have done:
creating a backup.sql using drush sql-dump > backup.sql
coping and pasting the live site folder for the ...
- 1
4
votes
0
answers
1k
views
Schema information for module is missing - how to fix?
I tried to install the Scheduler module but it did not install properly because we somehow did not have code for another custom module that the database thinks was installed. I got the code for the ...
- 127
1
vote
0
answers
74
views
Problems in collations when restoring
I'm quite lost with this issue I'm experiencing, so any clue will be appreciated. Let's start with the "symptoms".
Whenever I restore a Drupal 7 site that has been previously backed up with ...
- 245
1
vote
1
answer
493
views
Get raw SQL query from Drupal::entityTypeManager
How can I fetch the raw sql version of the following statement?
$t = \Drupal::entityTypeManager()
->getStorage('taxonomy_term')
->loadByProperties(['name'...
- 595