Tagged Questions

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
2answers
27 views

Using db_select, how can I select all nodes with any of an array of taxonomy terms and order by the number of terms it is associated with?

I have this so far: // for example, $tags = array(2, 8, 18); $query = db_select('node', 'n') ->fields('n', array('nid')) ->condition('n.type', 'post') ->condition('n.status', 1); ...
0
votes
2answers
242 views

Help on Drupal table prefix

I just installed Drupal 7 and made some content and configuration. After that, I just realized I did not put any table prefix on installation. My problem is: Is there anyone here that knows the SQL ...
1
vote
0answers
49 views

Drupal takes 2+ min to post an article

I am hosting a Drupal 7 Instant on Amazon Ec2 and have database on RDS. The site loads and works pretty fast. But admin side, when articles are posted its dead slow. In the MySql Log I found error ...
1
vote
1answer
48 views

Changing the field date type from 'datetime' to 'unix timestamp' without losing data

I am investigating how could I convert the date format in the 4 database tables: field_data_field_article_publication_date from the actual datetime format: 2013-09-10 12:43:03 to its unix timestamp ...
0
votes
0answers
14 views

Why doesn't my dates display on this graph (charts_graphs, php, mysql, bluff)? [closed]

My mission this week has been to create a sales graph for my Drupal 6, Ubercart and Ubercart Marketplace installation. I settled on the charts_graphs module and decided to use the Bluff library to ...
1
vote
1answer
26 views

How to get number of results from MySQL query without getting all result data?

For a Google Maps application, I built an AJAX call that dynamically checks whether there are markers in a given viewport range. All marker information is stored in a node (note that I am using ...
0
votes
0answers
6 views

Use Rules with Vote Up Down to insert extra points for admin?

I was thinking of using the rules modules and php to insert say an extra 5 points every time an admin votes something up or down. Would this have any kind of detrimental repercussions on the database? ...
1
vote
3answers
536 views

What permissions of MySQL user should be enabled for Drupal to work

When I am creating a user for my Drupal in Cpanel, it asks me to check all permissions like alter, delete, create, drop etc. Which "all" are the ones that should be enabled for Drupal to work? ...
16
votes
4answers
2k views

How to get core to leverage a MySQL master/slave configuration?

I read this question MySQL master/slave replication not working and its answer: Using slave databases is barely implemented in Drupal core. If you are developing your own modules then calls to ...
0
votes
1answer
25 views

how to do a conditional subquery with db_delete

I currently am deleting by a manually constructed query, but there should be a better way to do this. $query = "DELETE FROM {$table1} "; $query .= "WHERE col1 = '$col1' "; $query .= "AND table2_id in ...
0
votes
1answer
217 views

Issues migrating site back to local server

I have issues migrating my Drupal 7.14 site from Live Server back to local. This might be more sql related, but not sure at this point where the error comes from. Might be specifically Acquia related. ...
1
vote
1answer
63 views

Drupal site with 300+ modules slow on localhost [duplicate]

A drupal website which has large database of nearly 130 MB is taking too long to run on drupal. Sometimes the home page doesn't load also. Any tip or help for this? on windows 7 I have WAMP server ...
0
votes
1answer
25 views

Flag Module: Possible to make admin's flags worth more points?

I'd like the admin's flagging of a node to carry more clout than with regular users. Is it possible to either; Insert the count into the mysql database as a number larger than 1 whenever admin flags ...
4
votes
2answers
142 views

What complications are there if i switch Mysql to MariaDB? Any Drush issues?

I have a heavy mysql drupal 7 site and i was thinking about switching mysql over to mariadb, but i wasn't sure what issues i would run into. From what i'm reading mariadb seems to be just a drop in ...
1
vote
0answers
14 views

Error: The file used in the Video field may not be referenced

I want to edit some rows of the table vc1_file_managed to change some flv videos to mp4,but when I do the update and try to save it shows an error: "The file used in the Video field may not be ...

1 2 3 4 5 … 14
15 30 50 per page