If the question is about SQL queries, consider using "sql-queries"; if the question is about the database API, use "db-api."
0
votes
2answers
33 views
What items in the DB do I need to edit when switching from a multisite to a single site? [closed]
I've copied a single site from a live multisite setup to my local (MAMP) server. The content is showing from the site however it is unstyled (and also the home page is showing the 404 page). I assume ...
2
votes
1answer
47 views
why some PDOException errors are displayed in details on users screen and some other not
A user reported to me seeing the following error on his screen:
The watchdog entry for this error looks like this:
PDOException: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try ...
-4
votes
0answers
27 views
How can we backup Database from rackspace? [closed]
I am working on a site that is made in drupal 7 and store in rackspace so can anybody help me to get backup or use phpmyadmin of that site
I want to run on my local pc to edit that site
0
votes
1answer
25 views
Drupal 7 - Login with external Database
I want my users to be able to login into Drupal with an external user database.
I searched for a long time and don't get any module/trick/whatever that is out there.
Please help me a little, I'm new ...
0
votes
1answer
46 views
PHP Fatal error: Cannot call overloaded function for non-object in /var/www/html/includes/database/query.inc on line 331
We have a Drupal 7.12 Setup in production.
Recently we upgraded PHP to 5.4.10 and we are getting the following error,
PHP Fatal error: Cannot call overloaded function for non-object in ...
0
votes
2answers
53 views
Drupal 7: DAL - Using db_insert creates duplicate records
I am doing a simple insert query using the db_insert call and no matter where I try this I am getting the same result, is this an error with the Drupal 7 DAL or am I doing something wrong?
The script ...
-4
votes
1answer
46 views
How can I upload a Drupal Website into Wampserver [closed]
Someone built me a website a year ago. I want to upload this website into a local wampserver so I can make changes before going live. I need step by step instructions on how to upload the files.
...
-1
votes
1answer
34 views
How to make a sql mysql-view of all nodes and the roles of the nodes
Is there a way to create a mysql-view of all nodes and the roles of the nodes.
Something like:
Select * from nodes a ,roles b
where a.nid=b.nid
Or is there a module that shows the node and his ...
0
votes
0answers
53 views
How to optimize this query generated from a View?
In a D6 site, I log queries and get this monster frequently in the MySQL slow query log:
Query_time: 13.817393 Lock_time: 0.000261 Rows_sent: 1 Rows_examined: 3655810 SET timestamp=1366964215;
...
2
votes
1answer
29 views
Internal Server Error? Why is this happening?
All normal to start my website, but to click on any of the links, menus, etc, I get redirected to this with the following message:
Internal Server Error
The server encountered an internal ...
-1
votes
0answers
23 views
Displaying data from table using array [closed]
I need help guys, i want to retrieve data from a table and compare it with a variable, if the IF function is true it must keep that data and continue to the next one till all are compared, after that ...
2
votes
2answers
66 views
Trying to Understand Where I am Going Wrong Modifying User Registration Form
I am working with Drupal as part of a student project. As background, I work professionally doing front end development and I've taught myself at least the basics of the back end.
Here's my problem, ...
0
votes
0answers
11 views
Database Showing Comments as Deleted
Hello i have recently changed domains and ..well it cant be related can it? anyhow all my old comments are not showing. When i went into the database via phpmyadmin i notice that the deleted coloum ...
2
votes
2answers
81 views
Automate clear of mysql database in drush site install
Is is possible to automate clearing the database when I run site install?
e.g. here is my drush command:
drush si geoslate --db-url='mysql://root:root@localhost/geo_test' --site-name=Geoslate
But ...
0
votes
0answers
34 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 ...
1
vote
3answers
212 views
PHP in database: bad practice but
Lots of times here I've been told that using views custom php fields, filters or others is a bad practice, because putting php in the sql is dangerous.
My question is, if you only call to a function, ...
2
votes
2answers
95 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
2answers
146 views
Using Ajax, how can I populate a div with Database Content from a form select?
This is what I have so far. I can populate the select field just fine, however when another option is selected I can not get the data to populate in the ajax callback div.
function ...
1
vote
1answer
94 views
Cache Form table size is enormous
Cache table's size had increased to 10+ GB last month, and I had fixed it temporarily by truncating it. Last time I checked it was around 1GB. So in couple of months it will hit 10GB again. How should ...
2
votes
0answers
34 views
Why does drupal create revision table?
From database design perspective, Why does Drupal even create these tables? They are so much alike. There are modules & methods for getting rid of these tables, But why are they there?
MariaDB ...
0
votes
1answer
37 views
Migration not importing into image fields
I'm working on a Migration class to import from a depreciated WordPress plugin and everything's just about there -- everything succeeds when importing and there aren't any errors; taking the SQL from ...
0
votes
1answer
37 views
Migrating SQL dump from Drupal 5 into Drupal 7
My site went recently down, and all the data were lost (PHP installation of Drupal 5). What I am left is simple SQL dump from PHPMyAdmin.
I would like to "use" this disaster and finally migrate to ...
1
vote
1answer
121 views
500 internal server error while installing drupal
What is the reason for the error "500 internal server error" while trying to install drupal,
i have created database successfully
After that i have downloaded and extracted the drupal 7.22 in my ...
0
votes
0answers
17 views
How to Quickly Create Webform Content with a Group of Textareas
I am making a top 25 albums of all time webform in drupal 7, which requires me to make 25 artist textareas and 25 album name text areas that should all be paired when submitted to the database. I've ...
1
vote
1answer
47 views
Migrating taxonomy terms when source is a separate table?
I'm writing a migrator for a now-unsupported WordPress plugin that used a single "attachments" table to store data ranging from thumbnails to musical genres. It looks like this:
mysql> describe ...
0
votes
2answers
69 views
how to manually add a node in drupal 7 in the database [duplicate]
I have managed to display the title but im missing the body of the title. i cant find in the database which table i missed to edit.
here's the list of tables i editted:
node
node_revision
...
1
vote
0answers
52 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 ...
0
votes
1answer
64 views
how to add form data in database
My registration form is multi-step and the form is shown in popup. I m using lighbox2 for popup and working perfectly fine and i have added the form filed in a file that comes with lightbox2 and place ...
1
vote
0answers
75 views
High performance DB Cluster with Drupal
I am looking for a system where I can cluster MySQL. I saw an article which guided me to custom Drupal schema for NDBCluster engine for MySQL clustering, Btw. I am using Drupal 7 with Varnish, ...
1
vote
1answer
57 views
building a query with the database api and groupby multiple fields in drupal 7
first of all I simplified my query so it might be more useable to other users on this site.
I'm looking for a solution to use group by on multiple fields.
This query selects the values of the ...
1
vote
1answer
55 views
While developing a custom module, which function creates table in database?
While developing a custom module in Drupal 7, which function actually creates tables in the database?
I have implemented hook_schema in mymodule.install, mymodule.info, mymodule.module file and ...
0
votes
1answer
70 views
Simpletest fails to create the field_config table
I'm only just getting into TDD with Drupal and unfortunately run into trouble right away. For some reason the simpletest####field_config table isn't being created, and I don't get why; many other ...
1
vote
1answer
124 views
PDOException: SQLSTATE[HY000]: General error: 1 cannot rollback
I have managed to cause this error while working with exposed filters weighting in views.
Any idea how I can correct it? I am running Sqlite for database. Is it possible to clear transactions or ...
0
votes
1answer
60 views
Moving SQLite-D7 Installation to other Server throws Uncaught exception in shutdown function
When I move my Drupal7-Website (with SQLite Database) from my XAMP to another Computer also running XAMP I got the following error message.
Uncaught exception thrown in shutdown function.
...
0
votes
0answers
35 views
Change Comment Text Format in phpmyadmin
Hello i seem to hav changed the text format for my comments and now all my old comments cannot be seen. When i edit the comment the text format select list has no default value. I would like to give ...
1
vote
2answers
57 views
How do you add a prefix to an existing drupal database for single site use?
I have a drupal 7 site running on a webserver, it is currently using a database that was created with out a prefix.
I am attempting to restore that database to a new drupal instance from a shared ...
0
votes
1answer
62 views
2 Drupal Multisites, Separate Databases, Changing 1 Also Changes the Other
I have a very weird issue. Been doing Multisites in Drupal 7 for a while now without any hitches... until last week. I have 2 multisites both with separate databases, however when I change content on ...
0
votes
1answer
42 views
using an existing token as a variable in a custom token
I am using simplenews to send out a newsletter. I have a custom module. It has a table that relates a user code to the user's email.
email_address user_code
...
0
votes
0answers
47 views
EntityFieldQuery and “legacy” nodes
Here's the situation, which I suspect is pretty common:
A site is deployed where a node type has no fields added.
Lots of nodes are added.
The site is changed and a new field is added to the node ...
0
votes
0answers
18 views
How to insert the record by default on distributing the module
Im developing the custom module in drupal 6 .
Inside the custom module development ,i have created one .install file and wrote the database schema inside it using the _schema() hook function.
The ...
-3
votes
1answer
40 views
Propagate changes inside module.install schema to database
Using schema module, I was able to easily describe tables that I included in Drupal DB, by creating .install files to appropriate modules.
Now i have updated field descriptions for each field ...
2
votes
3answers
47 views
Admin custom module not displaying in theoverlay
How to show the data fetched from the database in the overlay of the admin custom module.
The data are retrieved but not showing in the overlay. Kindly help me out
1
vote
2answers
114 views
how to Insert form data in table
i have an enquiry form and submitting the form using jquery/ajax method.
$.ajax({
url:enquiry.php
I am able to insert records into database table using php mysql_query. When i use ...
1
vote
1answer
30 views
how to check non existent field added later using entityfieldquery? [duplicate]
I added a required field in a Job type node later. So existing nodes don't have that particular field value.
I want to include all such field values. But how can I do it?
Here is query sample:
...
0
votes
1answer
48 views
How to add table column aliases
I am trying to perform a query on a database that has the following info (in Drupal 7.21):
nid | sid | cid | data
----------------------
32 | 2 | 1 | date
32 | 2 | 2 | name
32 | 3 | 1 ...
0
votes
2answers
74 views
how to make unique fields in profile type in drupal 7
I am using drupal 7 and want to save unique mobile number for users. I have created a profile type field of phone number type.I have installed unique field module but not getting any option to make it ...
0
votes
1answer
62 views
Which table does the Phone module store data in?
I have installed the Phone module to create a field to take input data as mobile number.
I would like to fetch the mobile number back from database to be displayed in a block. I am not getting the ...
0
votes
0answers
61 views
PDOException on Article page
In my Drupal site, when I tried to save an article page I'm getting the following error:
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146
Table ...
1
vote
1answer
61 views
Share same database tables with multisite instances
What I'm trying to do is to make 2 sites one for developing and one for live using which share same instalation and database. I want to see same content like on live site when I developing theme or ...
0
votes
1answer
152 views
How do I use bigdump.php with Acquia Dev Desktop?
I am trying to import a rather large database (~450MB) on my local machine (running Acquia Dev Desktop). To do this, I was going to use BigDump.
However, I must not be configuring bigdump.php ...
