If the question is about SQL queries, consider using "sql-queries"; if the question is about the database API, use "db-api."

learn more… | top users | synonyms

1
vote
2answers
18 views

Splitting up a Drupal database

Is it possible to split the Drupal database into multiple databases. For example I have one database having the watchdog table and another database having all the other tables? I know if I created my ...
-1
votes
0answers
15 views

how to connect Neo4j (DB) with Drupal 7? [on hold]

We have a problem with connecting Neo4j DB to Drupal 7, is there anyone have a solution or plug-in for it? Requirements for plug-in or solution. Match of skills (Nodes) Recommendation engine / ...
0
votes
1answer
15 views

changing unicode characters in a module

There are hundreds of records in a database that are in windows-1256 charset, I want to read these data and convert them to utf8 then insert them in a new table, to read these data I need to change ...
0
votes
0answers
11 views

Database connection error [on hold]

I am running into an issue. I have a single database with two diffrent sites like abc.com and xyz.com sharing a single database . the problem is abc.com is running fine but xyz.com giving pdoexception ...
0
votes
1answer
25 views

Shared database during development?

Sometimes I need to collaborate with a more frontend-centric developer to help implement a site. So typically they're only changing CSS and minor template changes. The way we've handled this in the ...
0
votes
1answer
14 views

Schema relationship

The problems I am trying to solve are: 1- How can I connect tables defined by $schema to each other? 2- How do you insert data consistently into the database? Is there any possibility of having ...
0
votes
2answers
22 views

How add/update a record conditionally based on existence of primary key?

I have a table with structure: Table ( record_1 int, record_2 int, PRIMARY KEY (record_1) ); I want to write/update a record based on its existence. I was told to use drupal_write_record(), but for ...
0
votes
1answer
26 views

Changing Drupal database

How would you think if a designer extends the database of Drupal for a desired system? (for example adding field to some tables) Would it be really PRACTICAL?
0
votes
1answer
6 views

Bulk change radio button setting in admin/content using database

I am using a paywall module called TinyPass where I have to check a radio button in order to activate the paywall for a specific node. I now have a situation where I want to uncheck (or deactivate) ...
0
votes
1answer
9 views

Database error after transferring Drupal 6 site

I just moved a Drupal 6 site from one server to another and have just started getting an error. Warning: Table 'mydatabase.watchdog' doesn't exist. The table does exist in the database and it does ...
0
votes
1answer
15 views

Why does user column name has UNIQUE Constraint?

I got aware that the column name in TABLE users has a UNIQUE Constraint, when I tried to register a 2nd user with the same username : it returned a `integrity constraint violation 1062 duplicate entry ...
0
votes
1answer
28 views

How can I make Drupal/MySql accept special characters in ANSI (without changing the file's encoding)?

I'm developing a custom module where a user (actually an admin of sorts) can upload a CSV file. Based on the contents of this file, certain rows are inserted into a table. I'm now having problems ...
0
votes
0answers
11 views

Why does create node timeout with a certain taxonomy term selected?

After applying all core and contrib module updates to an old Drupal 6 installation (updated to 6.32), creating or updating a node with one specific taxonomy term now fails with: "Fatal error: Maximum ...
0
votes
1answer
43 views

How to create multi sites

I have just started to learn Drupal. So, I apologize to ask such a silly question here. I wanted to create multi sites in Drupal. I have unlimited access to create Subdomains, Parked Domains, Addon ...
0
votes
2answers
28 views

Can't correctly reference bundle in EntityFieldQuery, field_get_items

I'm using EntityFieldQuery in an attempt to query for specific field values (dates in an event db) then perform some analysis on them. I've gotten far enough to correctly query and return specific ...
0
votes
1answer
11 views

how do i rename multiple content at once with find and replace same issue in names?

I imported about 15,000 pieces of content and didnt realize that the "&" in many titles are "&" and " ' " (apostrophes) are displayed as "'" Is there a way to replace all of these at one ...
0
votes
2answers
72 views

how to output image file from database drupal 7?

I have created testing module that will upload image and outputting it to my page. but, I can't seem to output my image file from my database. here's my code function database_ex_menu() { $items = ...
0
votes
1answer
14 views

Where is saved the value of the 'help text' of field of content type?

I know that you can set help text for any field in the content type, but where this text is saved in databese, because I want to access it in other way not only for tooltip? Thanks
0
votes
1answer
37 views

White screen of Death after clearing cache, can't find a way to get the site back up

My problem is that I keep getting the white screen of Death ever since I cleared the cache of my Drupal website. The error is the following : PHP Fatal error: Call to undefined function ...
0
votes
1answer
39 views

What is the preferred way to delete large amount of data from a Drupal site?

We have a client site that currently has a very, very large data set in Drupal. We are working on generating a 'stripped' copy of the database to be used for testing new code by eliminating the bulk ...
0
votes
1answer
47 views

Create a MySQL view table on one database but fill with results from another database

I have 2 databases: myshop (the Drupal db) and myshop_migrate (the Migrate db). To make things tricky - both databases reside on different AWS instances. I need to create a mysql view on myshop to ...
1
vote
0answers
47 views

Custom migrate with cross database joins issue

I'm facing an issue when running cross-database joins whilst implementing a custom module using Drupal Migrate. The set up: I have 2 databases: myshop_migrate - the migrate db and myshop - the ...
0
votes
2answers
26 views

Safe to delete cache_form table while site is in maintenance mode?

My site has a very large database of 100MB, most of this is in a table called cache_form. Ive tried clearing the cache. When I try and run the cron I just get a white screen. My site is in ...
1
vote
1answer
19 views

Why do we duplicate field data in the field_revision_* tables when revisions are disabled?

Even with revisions turned off for a given content type, the field_revision_* tables for the fields each contain a single record that matches the corresponding record in the corresponding field_data_* ...
0
votes
2answers
31 views

Commerce: What field to join line_item in order to get product price in custom query?

I'm starting with line 'commerce_line_item' as a base table, and I want to get prices for each of the line item products attached to a Drupal Commerce Order, rather than just the order total. I need a ...
0
votes
1answer
17 views

Import a list of suscribers from Excel

I have a big problem with a database. I have a list of suscribers in an excel list with their names, phone and other info. I need to import that suscribers to my drupal website and use them for send ...
1
vote
1answer
51 views

Why are there so many settings.php files one in each folder or sub-directory?

I am Drupal newbie taking over a poorly documented D6 group of sites organized by sub-domains. In examining the dev.[domain].org/sites/ folder I discover folders: all, default, demo.[domain].org and ...
-3
votes
1answer
33 views

simplest way to read and write data in database table. [closed]

I am new to drupal. I need to know what is the basic way to read and write content to a table of drupal database. also, can we add/update/delete data from a table inside the same drupal database ...
0
votes
1answer
31 views

LEFT JOIN with db_select()

I'm trying to do a left join but it isn't working. I have 2 tables: TABLE profile - uid - pid TABLE field_data_field_naam - entity_id - field_naam_value I want to select the field_naam_value ...
0
votes
2answers
54 views

How to create sql alias in drupal 7

How do you achieve the highlighted 'node' alias when using the Drupal 7 database abstraction language? This is the original query produced by the view SELECT node.title AS node_title, node.nid AS ...
0
votes
3answers
43 views

What entity should entity_id be joined on?

I'm writing a complex custom query to get order information from a Drupal Commerce install for export. The table "field_data_commerce_customer_address" has a column "entity_id." I've tried to join ...
0
votes
1answer
31 views

TRUNCATE error -1 obliterating my sites

So I'm having a pure and miserable time with Drupal. I keep getting a cache related error: PDOException: SQLSTATE[HY000]: General error: 1030 Got error -1 from storage engine: TRUNCATE {cache} ; ...
0
votes
1answer
20 views

Database Synchronisation Manually

There is a situation where I need to check the changes(what tables) done at database level after a particular date as the two databases have to be merged now. Is there any tool or module in drupal ...
0
votes
1answer
42 views

Programmatically add PDF file to user

So using the 'file' module i have added a field to the user table called 'user_files'. What i want to know if how can i programmatically add a file to the user, so that it is displayed on the users ...
0
votes
2answers
26 views

Body field data disappeared - Drupal 7

EDIT: Looks like I accidentally changed number of values for this field to 1 - it should be Unlimited. It's working now, thanks everyone. I don't know what I did but I noticed that all (except the ...
0
votes
2answers
67 views

How can I tell what is causing commerce to throw entity wrapper exception errors?

I'm attempting to repair and reconfigure a site that was created by another admin. I ran across some issues with commerce coupon that I've been able to get past with help I received here first then ...
0
votes
1answer
32 views

Correct way for a db_query for nodes between two timestamps

I have a very simple db_query. I want to look for any node created between two timestamps. This query works fine in MySQL shell SELECT nid as id,created as start,title FROM node WHERE created ...
0
votes
0answers
22 views

how can i save webform in a different table in my database?

i have a webform that receive values from database and empty fields are edited by user. and after that when user submit that form, it should update the records in the same table from where it receives ...
0
votes
2answers
51 views

What is the proper way to drop database references for an uninstalled drupal module?

I've uninstalled the Commerce Coupon 7.x-2.0-beta3 through the admin ui and removed the corresponding folder from the sites/all/modules directory. Now when I install the previous version of Commerce ...
0
votes
0answers
24 views

Different domains and content with one database

I would like to have different content for each domain. This is my scenario: I would like to have these domains: country1.hello.com country2.hello.com country3.hello.com country4.hello.com They ...
0
votes
1answer
12 views

How to delete all but the current revision from the field_collection_item_revision table?

I have a Drupal 7.24 Website making heavy use of field collections. The field_collection_item_revision keeps getting bigger and bigger (9'000'000 rows) and only 200'000 entries are in ...
0
votes
2answers
22 views

Facing trouble in insertion of data in to table after creating table by using hook_update_N function

I have created a table by using hook_update_N() function. After creation, if i am trying to insert data into table but it is not storing. Is there any thing else is there to do after creating table by ...
0
votes
0answers
24 views

How to retrieve data from table to a webform in drupal 7?

I am using drupal 7 and created a webform. i just want to show data from my existing table to that webform. i just created this code in .module file: function publish_webform_node_load($nodes, ...
0
votes
1answer
45 views

Corrupted mysql cache_rules table - dropped the table and now I cannot create it anymore!? Stuck

I'm not sure how this happens, but the cache_rules table is corrupted and it prevents me from doing a drush cache clear all. I dropped the table successfully, but now I can't create it. Throws this ...
0
votes
1answer
25 views

How to manually delete a node from the database knowing its id

Well, look my problem is weird, I have a view that lists content of a desired type, it is listing all the content of a type, I have deleted from the drupal admin UI a node of that type, but the view ...
0
votes
2answers
27 views

How to use tables that are claimed by other modules in drupal?

How to use tables that are claimed by other modules in drupal? I have a table in my database named "dictionary" used by a module for translation . now i want to use that table in views to show all ...
0
votes
2answers
27 views

Create a script page for handling ajax

I am a bit confused on the appropriate way to generate a drupal page for handling ajax posts. For example I'm creating a custom module that has favorites buttons. When a user clicks the button the ...
0
votes
0answers
53 views

Better Exposed Filters slider max/min - database request

I am trying to use this hook function in order to get the min/max values from the database. As I am no coder I am facing some trouble with this. Here's my approach: At first I recognized that I don't ...
0
votes
1answer
68 views

PDO exception error [database].semaphore doesnot exist

I created a website in drupal 7, tested it in my localhost and works good. Now, I want to host the site in our Main server. So, I uploaded the site directory to the server and created a corresponding ...
0
votes
2answers
45 views

Using Acquia DevDesktop locally, where are the DB settings located? not in settings.php..?

i've been learning Drupal 7 using Acquia DevDesktop and i have several sandbox type website running on my laptop but now i'm trying to access the databases from the command line. but in the ...