MySQL is an open-source, relational database management system. Use this tag for questions specific MySQL, not for saying "I am using MySQL."

learn more… | top users | synonyms

0
votes
1answer
11 views

Why does drupal module only return one MySQL query result?

I have exactly the same code in both Drupal node page and Drupal module but the module only returns one row from MySQL while the node returns all rows? Does the Drupal modules require some special ...
0
votes
0answers
2 views

Views subquery keeping row arguments

I am trying to create a complex view and out of the box views UI just didn't do what i needed it to. As i need to sum up fields with multiple relationships i have decided the best approach would be ...
0
votes
1answer
9 views

How to display only Duplicate values with a view

Background My site is very large already and its only in its infancy. The content title table has 14000+ values in it. To make sure there are no duplicate values in the table I am creating a view ...
0
votes
0answers
25 views

Is this approach to importing data too convoluted in Drupal7?

My client manages a desktop app for adding, deleting, updating some products. Then the app uploads a SQLite database, which is converted to MySQL. Drupal cron triggers every 3 hours an schedule which ...
0
votes
1answer
23 views

what does {node} node mean

Background I'm trying to understand the SQL queries that Drupal generates when I select different content to be displayed on my site so I can write my own php filters. Issue I see this in the query ...
-6
votes
2answers
25 views

Access Denied/User login [on hold]

When I login using my admin username & password to drupal site, but it is displaying the access denied message .what to do?
0
votes
2answers
20 views

Export / import content from Drupal 7 to Drupal 7 via MySQL

I want to migrate all my content from my old D7 website to my new D7 site, with features I exported/imported from all my custom content, views, fields, etc. But I don't understand how to export ...
0
votes
1answer
22 views

Webform to add row to specific sql table

I have drupal running and have enabled a few modules including the webform module. I have opened phpmyadmin and added a new table with specific rows. Now I want to link the two so that a user can log ...
1
vote
1answer
31 views

Field with unique and auto-increments values

I have a content type that in one of their fields need a value that is unique and auto-increment. There are several obvious solutions: Use the node id that is unique and auto-increment. The Serial ...
-3
votes
1answer
59 views

Drupal query uses 'node' - how to change to normal mysql query [closed]

I have a view that is definining a taxonomy term as 'node' in the query eg.: select title as title, 'node' AS field_data_field_category_node_entity_type from node where node.type="product" how can ...
5
votes
2answers
100 views

Setting a user as an administrator via drush command line?

How can I set a user to a specific role via drush? In my case I want to give the role of administrator to the user.
0
votes
0answers
26 views

Importing a Database into Drupal shows no content

I've been trying to get my database imported into Drupal today and I'm having quite a few issues. I'm using VDD with Vagrant / Oracle VM and everything is working properly, I have Drupal 7 up and ...
3
votes
3answers
44 views

How to make an import of the very large Drupal database?

I'm using Vagrant and OracleVM to run Drupal 7. I've got the site up and running and I'm trying to get my database imported. So far I've run drush cc and cleared the drush cache, and then I did ...
1
vote
3answers
26 views

Need advice on remote storage for load balanced drupal site [closed]

Not quite sure if this is the correct thread to be posting this in, so please feel free to move it if its not. Background: Our developers have nearly finished developing our Drupal 7 based web ...
1
vote
1answer
31 views

db_select query advice

I have two content types: development and house. A development has many houses. Each house has a house_type field I'm trying to perform a db_select query that allows me to search all developments ...
0
votes
0answers
23 views

Date formatter fields in views while migrating mysql to PostgreSQL

I am using drupal 7 and recently migrate my website database from MySQL to PostgreSQL. But in Views ,when i set the date field formatter other than plain, the output display showing current date ...
1
vote
1answer
20 views

How are node and field tables related in MySQL?

I am working on a query that involves the field_data_body Drupal table, and I have been asked to return corresponding node ids for the relevant rows in field_data_body. However, after reaching a copy ...
0
votes
1answer
29 views

Using SQL to output link to a node

Does anyone know - using SQL only - how to output the link to a drupal node? If I was using PHP I think it would be something like this: print l($node->title, 'node/' . $node->nid); But I'm ...
0
votes
0answers
63 views

Why are we using utf8mb4_general_ci and not utf8mb4_unicode_ci?

Drupal is moving to support utf8mb4, however, it is using utf8nb4_general_ci. Why take the time to move over to support it, and then not fully support it? Is there a specific reason, or just ...
0
votes
1answer
18 views

migrating from postgresql 9.1 (non drupal) to Percona Server 5.5 (drupal 7)

We decide to go from a perl website to drupal 7 (PHP 5.5.23). My big question is how do i migrate the DB which is PSQL 9.1 to mySQL. I've heard of the the migrate module, drush, MySQL Workbench. ...
0
votes
1answer
12 views

How to get each db result value count

How to get values count in db_select My query is: $last_item = '2015-07-19'; $query = db_select('field_data_appointment_date','ap'); $query->join('field_data_appointment_slot','aps','aps.entity_id ...
1
vote
0answers
13 views

Umlauts grouped in summary (U and Ü, A and Ä etc)

I faced the problem with summary attachment which includes umlauts like: U and Ü, A and Ä; O and Ö etc. For example if two nodes starting with letters U and Ü Umlauts Ümlauts only U letter will be ...
0
votes
4answers
68 views

How can I run cron.php via crontab?

I'm trying to run cron.php via a cron job set up in crontab on my server via the following command (running every 2 minutes purely for testing while I try and get it working - it will be every 6 hours ...
1
vote
1answer
28 views

Using Cron and CURL in a custom module

I am using a hook_cron (mymodule_cron) in my custom module, but would like to know whether the cron run is successful or not and has sent the data using CURL, and from there, update a specific column ...
1
vote
3answers
45 views

PDOException: SQLSTATE[42S02] - Base table not found

So I am in a bind and have no idea where to go. I get the following message now after I tried to add a new field to a content type: Error message PDOException: SQLSTATE[42S02]: Base table or view not ...
0
votes
1answer
31 views

How to insert data into node and other tables at the same time?

I create a Drupal module which install database tables during module installation, table is created using Drupal way. The tables are created perfectly and now i have to insert data into those tables. ...
0
votes
1answer
18 views

Automated database history save and recovery Drupal 7

I have a site implemented in Drupal 7. I want to make a history database recovery tool, which will recover previously recorded MySQL data. I have tested correctly on non-Drupal content which is used ...
0
votes
0answers
32 views

Help sending specific fields' values to external url from Drupal webform

I have the following codes in webform remote post module, but instead of sending the whole webform fields as it is being done in the module, I need to send data from the fields only present in a ...
0
votes
0answers
22 views

drupal retrieve csv field values from sql table to post to url for webform

I have a scenario in Drupal 7 which is as follows, and need to eventually post the webform values to an external url: I have created a custom module which allows me to select a webform (based on the ...
0
votes
0answers
16 views

how to get unquoted value from $join-extra in views_query_alter

We use join->extra to specify a 2nd field in a join condition; this works fine when the value is a literal, but not for field references, which is returned as a quoted literal. For example a join ...
0
votes
1answer
67 views

How to resolve the MySQL error Duplicate entry 'comment_publish_action' for key 'PRIMARY'?

I'm a beginner in Drupal. I want to import my database to my webserver and get this error when trying to do so: "#1062 - Duplicate entry 'comment_publish_action' for key 'PRIMARY'" I don't know ...
0
votes
1answer
24 views

Is this SQL query even possible in Drupal 7?

I'm trying to find a way to run this query in a custom drush command to dump chunks of data from the DB into CVS files. The query works fine directly in the terminal but I was wondering how would ...
1
vote
1answer
78 views

How to access an external MySQL database in a view if SQLite support is not installed?

I would like to display other MySQL database by Views, and having the similar situation as this question. Except, I'm not able to enable the "SQLite", because I have no control on the server end. ...
0
votes
1answer
70 views

How to resolve my timeout during import of my Drupal database using phpMyAdmin? [closed]

I downloaded my Drupal database (in MySQL format, and using phpMyAdmin) from my new web site. I am attempting to import it using phpMyAdmin on my local Win 7 computer running Acquia Dev Desktop. It ...
0
votes
1answer
10 views

What is difference between field tables?

What is the difference between a content_field_myfield and field_data_field_myfield in the db?
0
votes
0answers
10 views

Error while instaling Drupal 7 [duplicate]

Please help about below error. i don't know how to resolve below error. i will try several ways follows from google search and drupal.org forums. but error still comes. please check the below image ...
1
vote
2answers
33 views

How can I build a contact form which will save its input to MySQL?

How can I build a contact form which will save its input to MySQL? Is there any relevant module you'd recommend?
0
votes
0answers
29 views

Error while adding any field in custom content type [duplicate]

I am unable to add any field in my custom content type, when I click on save button or click on upload after adding images it gives me the following error and for the text field the error is simply ...
0
votes
0answers
27 views

Add multiple conditions in search

I want to add two conditions in drupal core search. First condition contains taxonomy term parent and second condition contains taxonomy term child value. I have developed an interface now i want to ...
0
votes
1answer
40 views

I can't fetch anything else than '1' to my PDO query

Here is my PDO request : $query = db_select('review_ratings_table') ->fields('review_ratings_table',array('review_nid')) ->condition('loc_id', $loc_id, 'LIKE') ...
1
vote
3answers
112 views

Where is the base domain stored in database D7

Is there an equivalent row to the Wordpress "Home" and "Site"? In otherwords, where can I look in the database to figure out what the domain the site is on? I'm using mysql
0
votes
2answers
42 views

Why doesn't the field table in the Drupal database use entity_id as a primary key?

I'm working on trying to optimize a View SQL query and I noticed that the query being executed is using a join on a the entity_id field of a field table. I noticed that for some reason unbeknownst to ...
0
votes
0answers
28 views

GENERATE PDF WEBFORMS DRUPAL [duplicate]

I istalled webform2pdf and tcpdf for download forms and i create form i cconfigure webform2pdf but when i Click in download pdf on the form that i was created i have a error say : Fatal error: Call ...
0
votes
1answer
190 views

Fatal error: Call to undefined function system_run_automated_cron()

I migrated my database from oracle to mysql and when linking it to my drupal the following error: Fatal error: Call to undefined function system_run_automated_cron() in ...
0
votes
0answers
21 views

cpu at 100% after ubercart database update

Recently I updated ubercart tables of my database with newer ones. Now if I want to search for an existing customer inside the order based on email, cpu goes to 100% for 2 minutes freezing whole ...
1
vote
0answers
15 views

From a slow mysql query, is there a way to determine which Drupal module/path is the cause? [duplicate]

My hosting provider (Pantheon) provides mysql slow query logs. Is there a quick/easy way to determined, based on an entry in the log, which module/path is causing the problem? Since I built this ...
1
vote
2answers
101 views

How to subtract two columns with db_select()?

I have a db_select query that outputs two columns. I want to find the difference between these columns, output to another column, and then put a condition on this third column. Here is a mysql query ...
1
vote
0answers
63 views

Connection timed out and lock_may_be_available() on working site

I'm hoping someone can point me to a fix. My drupal 7 app was running fine locally this a.m. while I was testing a way to insert a row using mysql tools for a non-Drupal function. My environment is ...
1
vote
1answer
84 views

connect drupalgap app to drupal site

i have a problem and the documentation of drupalgap is not too specific. I have a site for example "www.mysite.com" and i have in a localhost a site built in drupalgap that i want to connect with ...
0
votes
1answer
118 views

Can't use drush site-install to drop tables and reinstall in MAMP

I have a local multisite instance running MAMP 3.0.7.3, and I can't use the drush site-install command to do a re-install of one of my sites without actually dropping the database first. If I try the ...