If the question is about SQL queries, consider using "sql-queries"; if the question is about the database API, use "db-api."
0
votes
1answer
18 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
25 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
37 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
41 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
26 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
50 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;
...
1
vote
1answer
26 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
17 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
64 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
64 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
29 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
188 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
89 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 ...