mysql

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

  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

  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

  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

  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

  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

  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

  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

  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.

  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

  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