mysql
Move core block settings across to a new theme
April 18, 2012 - 3:49pm — doublejosh- # Reset blocks to remove standard placements.
- UPDATE block SET status = 0, region = -1 WHERE theme = 'OLD-THEME';
- # Pull data across.
- UPDATE block AS export_blocks
- INNER JOIN block AS import
monster beats pro
March 26, 2012 - 8:42pm — Anonymous- menu_execute_active_handler(): returned NULL - it's very bad!
- WSOD detected!
Fix for Fix for WSOD error from menu_execute_active_handler() - on homepage (using Panels
November 27, 2011 - 11:12am — Anonymous- menu_execute_active_handler(): returned NULL - it's very bad!
- WSOD detected!
Fix for WSOD error from menu_execute_active_handler() - on homepage (using Panels
November 27, 2011 - 11:12am — Anonymous- menu_execute_active_handler(): returned NULL - it's very bad!
- WSOD detected!
Fix for WSOD error from menu_execute_active_handler() - on homepage (using Panels
November 15, 2011 - 5:04am — Anonymous- menu_execute_active_handler(): returned NULL - it's very bad!
- WSOD detected!
A wrapper for mysql console so we can have both interactive console AND startup settings
August 23, 2011 - 3:43am — Anonymous- #!/usr/bin/env zsh
- MYSQL_CMD='mysql -uroot -pWhatever -DmyDB'
- SESSION_CMD="
- SET @userOption='Value';
- # put other commands here
- # any mysql commend/query will work
- "
- expect -c "spawn $MYSQL_
I Need Help With MySQL Join Syntax
March 8, 2011 - 3:11pm — Anonymous- 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- $SQL = "INSERT INTO {uc_event_tickets} (uid, order_id, ticket_code, title, ticket_nid) VALUES (%d, %d, %s, %s, %d)";
- 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- /* Where the total number of members in the database is 279, when importing the db, do the red stuff at the bottom:*/
- DROP TABLE IF EXISTS `users`;
- CREATE TABLE IF NOT EXISTS `users` (
- `uid
WSOD error from menu_execute_active_handler() - on homepage (using Panels
February 17, 2010 - 2:07pm — Anonymous- menu_execute_active_handler(): returned NULL - it's very bad!
- WSOD detected!
