MySQL is an open-source, relational database management system. Use this tag for questions specific MySQL, not for saying "I am using MySQL."
0
votes
0answers
23 views
Drupal 7 website on my hosting-“Fatal error: Undefined class constant ‘MYSQL_ATTR_USE_BUFFERED_QUERY’ [duplicate]
I can’t transfer a Drupal 7 website on my hosting place due to the following error.
“Fatal error: Undefined class constant ‘MYSQL_ATTR_USE_BUFFERED_QUERY’ in includes\database\mysql\database.inc on ...
1
vote
1answer
24 views
logging in after exiting website under maintenance
i was installing updates for drupal website, while on maintenace mode. waited for updates to finish and then signed out. i've been trying a lot of things i'm reading online and it doesn't work. on ...
1
vote
1answer
25 views
How do I get a new database connection with a new setting?
I want to set the GLOBAL variable innodb_flush_log_at_trx_commit, and then run a migration after getting a new connection since changes to a global variable does not affect the current session.
So ...
0
votes
1answer
22 views
how do I make use of a calorie mysql datatable
I have a database (MySQL) with information about food. It has several columns, for example
product name | calories | fat | unit
bread | 100 | 10 | grams
potatoes | 5 0 | 20 ...
-1
votes
0answers
14 views
Cache conflict with boost
I cached my website with the great Boost module and i need the cache expiration module too to manage my expiration logic .
I installed also the cron cache module to help me flushing all the database ...
2
votes
1answer
101 views
What are some benchmarks with Mysql vs MariaDB while on Drupal 7?
I was wondering how much faster is MariaDB vs Mysql in a Drupal 7 setup.
0
votes
1answer
16 views
Using Drush with ENVVARS
I use EnvVars (vhost) to set my MySQL settings so I can have cross-server settings.php file without having to update it 3 different times.
I am wondering if there is a way to get drush to do one of ...
4
votes
1answer
43 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 ...
2
votes
1answer
29 views
Can db_select cope with mysql “case when” structures?
I have a complex mysql query with "case when" to combine values across multiple rows in columns. I'm currenty using db_query, but I would like to use the TableSort and Pager extenders. But (correct me ...
0
votes
0answers
28 views
Anyone using memsql? [closed]
Memsql claims to be the fastest DB on earth and it is compatible with MySQL, so apparently you can migrate MySQL data over to Memsql. So I am wondering whether Memsql is compatible with drupal? and if ...
2
votes
2answers
54 views
Drupal 7 db_insert() execute() error when table contains unique keys
I have a database (mysql) table that contains a unique key in barcode column.
What I intend is this:
I have a form that has a barcode field.
When user submits the form and the barcode entered ...
2
votes
2answers
88 views
how to choose a db for a drupal 7 site?
I have a question which is so basic I'm embarrassed to ask it.
I am NOT a developer or DB guy but a webmaster who has manipulated mysql successfully for several wordpress sites. I know how to use ...
-4
votes
0answers
36 views
Can someone please tell me if this has happened to them and how to fix it? [closed]
According to GoDaddy
Your *** MySQL database caused an overload of shared resources for the server that it resides on. This overload threatened the health of the server and, in turn, threatened the ...
2
votes
1answer
70 views
How to implement a mysql date or datetime field correctly in hook_schema()?
I have written a mymodule.install file which contains a schema definition to create a table in my database. This table contains two data fields. Theese fields will be populated by the users when they ...
0
votes
0answers
22 views
two and operators in one MySQL query in drupal [closed]
I have a query which run and shows result in phpmyadmin but in drupal gives mysql syntax error
this is the code
$result12 = db_query("SELECT * FROM Donation_match_data WHERE donation_id =".$don_id." ...
