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

0
votes
1answer
19 views

Where are templates from hook_theme stored in the database

I have a module, called "bundles", there I created a file "attached_email.tpl.php" and a hook_theme: function bundles_theme($existing, $type, $theme, $path) { $path = drupal_get_path('module', ...
0
votes
0answers
12 views

When i run cron for a database function it returns me the same value [on hold]

here is the cron code: function blablabla_cron() { $i=1; do { $gad = blablabla(); $i++; }while ($i<6); } this code returns me always the same value of the table. and here is the ...
1
vote
1answer
14 views

How do I export all of my customers (not users) from Drupal into a CSV file?

I'm working on integrating a new accounting system and crm (Xero & Capsule) for a client - and they have just under 10,000 clients - only stored in their Drupal website. I need to export these ...
0
votes
1answer
20 views

What Drupal tables to export from broken site

I'm on localhost with Acquia Dev Desktop , Drupal 7.34. Php 5.3.29. I was just playing in the Views when suddenly the site crashed. After few drush cc and restart of Acquia Dev Desktop and trying to ...
0
votes
2answers
51 views

Restore hacked website from database without source

I have a database backup from a hacked drupal site. The source code of the hacked website has been lost. When I try to make another installation of the site working using the old database, I have the ...
1
vote
2answers
79 views

First page load/execution slow, login slower Drupal 7

Drupal 7 site experiencing slow execution/load time for first page visit and slower execution/load time for login. The web server and database servers are dedicated and well resourced, the site has no ...
0
votes
1answer
27 views

Drush unable to bootstrap to database

I am not able to get drush to work properly: 1) I can download modules & themes through drush but I cannot enable them (more details below). 2) Also I cannot use the omega commands even though ...
0
votes
1answer
17 views

how to update my custom table after execution of rules

i have created a table as follow <?php /** * @file * Implements hook_schema */ function core_sms_schema() { $schema['core_sms_details'] = array( 'description' => 'This table is used ...
0
votes
1answer
6 views

How to drop tables shown as Missing in Schema Report

During development/testing after using Backup and Migrate Restore in conjuction with Schema, Schema will show Extra tables no longer referenced in the database, used by modulesetc, and no longer ...
0
votes
1answer
35 views

Getting an error while installing drupal 7 using xampp

Getting an error while installing drupal 7 using xampp An AJAX HTTP error occurred. HTTP Result Code: 200 Debugging information follows. Path: ...
0
votes
1answer
17 views

Why are there two database tables to handle taxonomy terms structure

There is a taxonomy_term_data table and there is a taxonomy_term_hierarchy table. Why are there 2 tables, instead of them being combined? taxonomy_term_hierachy strucutre description of table: ...
0
votes
1answer
21 views

Share one back office (database) over three drupal websites

I'm wondering if there is a way to have one back office for three drupal websites with different domaine names, so I can share users over the three websites, I think I'm gonna have one database for ...
0
votes
0answers
13 views

Drupal 6 site importing with lack of data

I'm assigned to do some theming tasks on existing site, but had problem setting up site locally. I was provided with sites files and sites/design folder which consist of settings.php,modules,themes. I ...
0
votes
1answer
26 views

Drush clear cache without the codebase

Is possible to clear the cache using drush (or else?) when I don't have the codebase anymore. Here is the use case: I deleted the codebases of a lot of sites with backing up. Now I'm going to backup ...
3
votes
0answers
33 views

Drupal Commerce causing database deadlocks

I'm trying to get to the bottom of a known Drupal Commerce bug to do with row locking. When a user logs in on my development site, Drupal Commerce starts multiple identical queries that look like ...
1
vote
2answers
16 views

How to remove a unique key in an update hook

I have a primary key and a unique key in my modules' schema. I need to remove the unique key. To remove an an index it is simple: function draggableviews_update_7205() { if ...
0
votes
1answer
24 views

Base field provided by a module is not accessable

this is a follow up to my question here. In my .module file I use the following code to add a base field to all my nodes: /** * Implements hook_form_BASE_FORM_ID_alter() for node_form(). */ ...
0
votes
1answer
37 views

Setup existing drupal 6 site on local server

so far I've worked with Drupal 7 sites and have no experience importing Drupal 6 site to local server, so maybe you could help. I have 2 folders and .sql database file. First folder is named 'files' ...
-1
votes
0answers
13 views

SQL dump for cache_views

Has anyone got an SQL dump for the cache_views table?
0
votes
1answer
49 views

The website encountered an unexpected error. Please try again later

When creating a new user account, as a visitor or unregistered user, I get the following message: The website encountered an unexpected error. Please try again later. and the account is not fully ...
1
vote
1answer
15 views

Port database queries from d6 to d7

I have inherited a drupal 6 site with some custom modules, all of which are making use of db_query() commands. Now I'm porting the site with all it's modules to drupal 7, and consequently have to ...
-1
votes
1answer
17 views

Basic template - new drupal project

I would like to hear how other Drupal developers / companies are dealing with the following issues: Suppose that as a company you often have to make small Drupal websites with minor changes ...
2
votes
3answers
41 views

Git-like way of updating Drupal database

It's easy to update Drupal on the local / remote server using Git. However, sometimes when I make modifications in the actual module settings or any other settings on my local server – those are ...
0
votes
0answers
9 views

Where to change the input query of uc_order table

I had a requirement of modifying the columns of uc_order table. But now, I'm unable to find the input query which running during the checkout process. If anyone knows from which file this input query ...
0
votes
0answers
11 views

DUAL table query

How do I construct the following query with DB API (so it's database engine independent): SELECT 1 FROM DUAL This example is for MySQL. I believe the Postgres version is SELECT 1
1
vote
1answer
39 views

Getting information from database and giving it to javascript

The main thing I want to achieve is that my module makes a google map with markers. For now im doing this: ...
0
votes
0answers
6 views

Why changing a value in organic group table og_membership joined to a node it is not changing it at all?

I'm in a Drupal Database so... Why changing a value in og_membership joined to a node it is not changing it at all. I am looking for any other cache table or something but I can't.
1
vote
1answer
57 views

Adding an image base field to custom content entity

consider the following situation: I have created a custom content entity with several base fields (string and string_long fields) and it works flawlessly. In addition I want the entity to hold an ...
0
votes
2answers
28 views

Automatize user accounts

I have a database with x users. I would like to add those accounts on my drupal database without having to recreate them one by one. I would like to do a script mike that but i'm not really sure it ...
0
votes
0answers
20 views

How to fix encoding mismatch problem

So I had a local testing Drupal installation, which uses a MYSQL database version which supports utf8mb4 encoding. I deployed this local site to the remote server by copying the files and database, ...
1
vote
1answer
31 views

drush sql-dump gives warning

When I ran drush sql-dump --result-file, it came back with a warning and a success message. system(): Cannot execute a blank command exec.inc:36 [warning] Database dump saved to ...
0
votes
0answers
15 views

Database tables cck_scorm

I need some help aboute the database tables of cck_scorm module. Additional, where in the drupal site i could change these fields, like: whatgrade, updatefreq ..... Is there a document that I could ...
0
votes
2answers
23 views

Merge Users from Prod to Staging/Dev

I have users registering on my prod environment, but I also have accounts created internally on my staging environment. Is there a drush command similar to sql-sync or Drupal module that will simply ...
0
votes
0answers
6 views

Use exsisting database for user log-in

I am new to Drupal and would like to know if it's possible to use Log-in credentials from another database as the users table in Drupal. I have a web application with user accounts on a sql db that I ...
0
votes
1answer
37 views

Synchronize data between 2 Drupal sites dynamically

I currently have two Drupal sites and I would like to synchronize in a specific way the data of each one. More precisely, the first one contains detailed informations and the other only has the main ...
0
votes
0answers
18 views

Dynamic query: count groups even if row is empty

I have a dynamic query like this: $query = db_select('node', 'n'); $query->innerJoin('foo', 'f', 'n.nid = f.nid'); $query->leftJoin('bar', 'b', 'n.nid = b.nid'); $query->groupBy('b.nid'); ...
0
votes
0answers
24 views

Drupal, xampp and oci8

I would like to apologise in advance if have posted it in the wrong group. Here is the problem, I am trying to develop a Drupal site, on a local using XAMPP, and it wants me to install "oci8", here ...
0
votes
1answer
16 views

Can failure to increase new user's UID consistently by one be related to this line inside user.module file?

I have noticed at my Drupal 7 that there are gaps between the uid's of new users. The UID of a new user should increase by one from the highest assigned UID in database. However, I have noticed gaps ...
0
votes
0answers
38 views

Repair table structures in database

I've recently had a lot of trouble, self-inflicted I will admit, with my Drupal 7 website and as a result have had to restore my database from a backup several times. In doing so, the structure of ...
-3
votes
1answer
112 views

Fetch data from database and show in custom module's form [closed]

I used the following code in my module to build a form : $form['promo_type'] = array( '#type' => 'select', '#title' => 'Promotion Type', '#options' => array(t('Digital Coupon')), ); ...
5
votes
2answers
181 views

Where should I be storing custom node-related data?

There are several types of data my website generates for every node. Node's popularity score, node's comment count obtained from a 3rd party API, etc... This data is set for every node. In the past ...
1
vote
1answer
40 views

Calling a procedure from drupal

I have a procedure structure like this in an Oracle database: procedure overlapping_course ( v_id number, v_program varchar2, v_message_type varchar2, v_user_type varchar2, v_language ...
0
votes
0answers
22 views

Master master replication, variable table breaks replication

We have a setup that requires master master replication for both HA and load balancing. I have excluded all cache tables from replication, although only cache_form is actually used because we run ...
0
votes
1answer
121 views

Does Drupal 7 support connecting to DB using MySQLi?

I have tried to connect to Mysql DB using Mysqli by declaring 'driver' => 'mysqli' inside DB array in settings.php but I get the following error: Warning: ...
1
vote
1answer
177 views

Populate dropdown with data from database in Drupal7 using jQuery

Error is seen when i made a drop down list to populate data from Database. Database : dtable File in the template of hook_theme named : myModueForm_theme.tpl.php <?php $sel = "<select ...
0
votes
1answer
22 views

Nested select with Drupals DataBase interface

I have the following SQL query and need to translate it to the drupal API: SELECT *, (SELECT COUNT(*) FROM newsletter WHERE email = pupils.email ) AS newsletter_flag FROM ...
0
votes
2answers
59 views

Query on custom drupal 7 field

I'm facing problem in Drupal query for order by custom field Here is my query $result = db_query('SELECT n.nid FROM {node} n WHERE n.type = :ntype', array(':ntype' => 'portfolio')); this work ...
0
votes
1answer
37 views

Migration failed with source plugin exception

I'm getting the following error: Migration failed with source plugin exception Migration failed with source plugin exception: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ...
1
vote
1answer
37 views

Is it possible to done search indexing locally, then upload it?

I want to perform search items indexing on the local system . Due to high number of items and And slowing down the server Can I do something like this , then I upload the result to the DB? Without ...
0
votes
0answers
26 views

Need help debugging a DatabaseSchemaObjectExistsException error

I'm getting this error both when I try to flush the cache and when i try to run update.php. I honestly have no idea where to start so any help is greatly appreciated. ...