Home

mysql

Fix for Fix for WSOD error from menu_execute_active_handler() - on homepage (using Panels

November 27, 2011 - 11:12am — Anonymous
  1. menu_execute_active_handler(): returned NULL - it's very bad!
  2. WSOD detected!

Fix for WSOD error from menu_execute_active_handler() - on homepage (using Panels

November 27, 2011 - 11:12am — Anonymous
  1. menu_execute_active_handler(): returned NULL - it's very bad!
  2. WSOD detected!

Fix for WSOD error from menu_execute_active_handler() - on homepage (using Panels

November 15, 2011 - 5:04am — Anonymous
  1. menu_execute_active_handler(): returned NULL - it's very bad!
  2. WSOD detected!

A wrapper for mysql console so we can have both interactive console AND startup settings

August 23, 2011 - 3:43am — Anonymous
  1. #!/usr/bin/env zsh
  2.  
  3. MYSQL_CMD='mysql -uroot -pWhatever -DmyDB'
  4. SESSION_CMD="
  5. SET @userOption='Value';
  6. # put other commands here
  7. # any mysql commend/query will work
  8. "
  9.  
  10. expect -c "spawn $MYSQL_

I Need Help With MySQL Join Syntax

March 8, 2011 - 3:11pm — Anonymous
  1. Foreach term_data.tid as $tid {INSERT INTO tid_uid (tid, uid) VALUES $tid, (SELECT uid FROM “node” WHERE nid = the nid from term_node on the same line where tid = $tid (LIMIT 1)

Code

February 7, 2011 - 2:43pm — JGonzalez
  1. $SQL = "INSERT INTO {uc_event_tickets} (uid, order_id, ticket_code, title, ticket_nid) VALUES (%d, %d, %s, %s, %d)";
  2.                 db_query($SQL, 1, 37, 'soemcode', 'some title', 12);

importing users into a database with auto_increment still enabled with PRIMARY KEY and all

July 19, 2010 - 8:27pm — Anonymous
  1.     /* Where the total number of members in the database is 279, when importing the db, do the red stuff at the bottom:*/
  2.  
  3. DROP TABLE IF EXISTS `users`;
  4. CREATE TABLE IF NOT EXISTS `users` (
  5.   `uid

WSOD error from menu_execute_active_handler() - on homepage (using Panels

February 17, 2010 - 2:07pm — Anonymous
  1. menu_execute_active_handler(): returned NULL - it's very bad!
  2. WSOD detected!

Shell script for taking a copy of a remote database to your local machine.

May 29, 2009 - 3:58am — Anonymous
  1. if [ $1 = "--help" ];
  2.   then
  3.     echo "
  4.   #########
  5.   # USAGE #
  6.   #########
  7.  
  8.   Syntax for running this script is:
  9.     ./devdb2localdb.sh sshuser sshdomain remotedatabaseuser databasename

MySQL problem

May 22, 2009 - 1:57pm — Anonymous
  1. SELECT DISTINCT(node.nid), comments.timestamp AS comments_timestamp_timestamp, node.title AS node_title, node.changed AS node_changed FROM node node LEFT JOIN comments comments ON node.nid = comments.
Syndicate content