Tagged Questions
0
votes
0answers
37 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
96 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 ...
1
vote
0answers
55 views
Saving form data and running custom queries in mysql
I'm new to drupal and although I've researched and asked some questions I'm still stuck on how I can achieve my end result.
I have built a php/html/mysql website (www.gbpokerclub.co.uk) but I now want ...
3
votes
1answer
290 views
Fatal PHP error on Drupal 7 with IIS
Logging as Admin user on Drupal 7 website stored on an IIS machine, I get the following error:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]:
General error: 2006 MySQL ...
1
vote
0answers
54 views
My queue table is huge, is it safe to empty it?
I have launched some batch jobs that I didn't finish. Now I notice my queue table is almost 1 GB. Is it safe to empty it?
4
votes
1answer
61 views
Issue with module's hook_uninstall (not uninstalling db entries)
I have a custom Drupal 6 module (based on this issue) that puts some custom date and time formats into the date_format_types table and then can be accessed from /admin/settings/date-time/formats. ...
1
vote
1answer
106 views
changing a MySQL query to a drupal query any ideas
I'm trying to change the following query to a drupal db_query:
SELECT first_name, SUBSTR(first_name,1,3) AS firstname_substr FROM civicrm_contact WHERE id != 'NULL' ;
I have tried this, but its not ...
5
votes
2answers
133 views
Use a database specific function in dbtng (e.g. uuid in db_insert)
I have a table that contains a char(36) field for a uuid. It seems like I can insert data into that field with a mysql query like: INSERT INTO mytable (uid, event_guid) VALUES (1, uuid());. I'd like ...
0
votes
0answers
267 views
Migrating database from Mysql to SQLite in Drupal7
I want to convert my site's database from MySQL to SQLite. So i got the DBTNG-Migrator and tried using it. I changed the settings.php files as follows -
$databases = array (
'default' =>
...
3
votes
1answer
119 views
Convert a static query to dynamic one, with a having clause
i am writing a patch for ubercart 3, for a attribute ignore module i am building.
For this module, i need to be able to query alter the query for the uc_product_adjustments_form.
I need to convert ...
1
vote
1answer
765 views
PDOException: SQLSTATE[42000]: Syntax error or access violation
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1118
Row size too large. The maximum row size for the used table type, not
counting BLOBs, is 8126. You have to change some ...
0
votes
1answer
133 views
Why Drupal 7 takes too time in connecting to mysql db? - measured with xdebugger
i have drupal 7 on localhost (core i7 - 12gb ram etc)
on Nginx with APC and mySql on windows7.
standard installation with standard theme and a bounch of new modules. about NO content.
The problem is ...
3
votes
2answers
212 views
What is the best way to migrate and optimize 300 GB database to drupal?
I have a database that was running on a propitiatory system with a hosting company. The data is about 10 years old and mostly text. The database it too large aprox 300GB. We are trying to migrate the ...
1
vote
2answers
128 views
Import Drupal Database, Excluding Database Connection Parameters
Another developer and I have the same Drupal theme installed. The other developer is the one doing the development work and I'm simply trying to import his updates into my theme so I have the latest ...
1
vote
1answer
65 views
What will happen if I restore backup DB with empty session table?
It seems that only the session is really big compared with other tables.
Is there any bad effect to Drupal site if I restore my backup Mysql file after deleting all the rows in session table?
