zzz_zwp | z z z z z z z z z

Solved – Warning: Unknown column ‘serialized’ in ‘field list’ – error while upgrading Drupal

Link

Solved – Warning: Unknown column ‘serialized’ in ‘field list’ – error while upgrading Drupal

ALTER TABLE cache_similarterms ADD serialized SMALLINT(6) NOT NULL;

Cauliflower Provencale

Link

Cauliflower Provencale

Ingredients

1 cauliflower, broken into flourettes
1 medium onion
1-2 clove garlic
1 tablespoon olive oil
1 can plum tomato
1 teaspoon salt
1 tablespoon herbes de provence
black pepper
1 tablespoon roux (“50:50” flour mashed with softened butter)

Directions

1

Boil or (preferably) steam Cauliflower until barely done- still slightly crunchy.
2

In a separate pan fry finely chopped onion on medium heat for 4 or 5 minutes adding minced or finely chopped Garlic halfway through.
3

When soft but not brown add tomato (do not break up too much)& other ingredients.
4

simmer gently for 3 or 4 minutes.
5

Adjust seasoning.
6

Mix Cauliflower and sauce and serve.

When appending to a string in Ruby use the << method instead of +=

Link

When appending to a string in Ruby use the << method instead of +=

If you come from another language, you might be tempted to use the += operator when appending to a string.

my_str = “Marco ”
my_str += “Polo”

It works… but there is a better way to do it : the « method.

my_str = “Marco ”
my_str « “Polo”

#UPDATE
I have removed my initial claim about operator precedence as it isn’t really accurate. There is a much better reason to use « instead of += when appending to a string… something I didn’t even realize (Thanks to Gregory). += will create a new String instance and will assign it to your left object. On the other hand, « will append the new string directly into your already existing left object. One could argue that += is only different than « and not better, but to me « is what you’ll want to use 99% of the time (if not 100%) when appending to a String. I have yet to see a real case where one would want to “lose” it’s existing String instance just to get a new one containing the exact same value.

You can also use the « method with arrays :

[1,2,3] « 4 #gives [1,2,3,4]

Be careful however when using « with Fixnum/Bignum instances. With these objects, the « method will shift the bits of your integer to the left. If you want to do a summation (append style that is), you will have to use +=

Posted on October 16, 2009 by zzz_zwp

http://www.youtube.com/watch?v=ozn31QBOHtk The spider that invented the wheel (via ikemen) (Source: http://www.youtube.com/)

Baklava Salmon (Salmon With Honey, Butter, Walnuts, and Mustard)

Link

Baklava Salmon (Salmon With Honey, Butter, Walnuts, and Mustard)

Gallery

Posted on October 14, 2009 by zzz_zwp

This gallery contains 1 photo.

Get ready to totally freak out! img.photobucket.com

Nurses to sue New York over vaccination mandate

Link

Nurses to sue New York over vaccination mandate

Upgrading from Drupal 5.x to Drupal 6.x – Tutorial | drupal.org

Link

Upgrading from Drupal 5.x to Drupal 6.x – Tutorial | drupal.org

Upgrading from Drupal 5.x to Drupal 6.x – Tutorial

Recompiling PHP5 With Bundled Support for GD on Ubuntu – CuMu.Li

Link

Recompiling PHP5 With Bundled Support for GD on Ubuntu – CuMu.Li

This helped me resolve the Drupal error when setting up a local development environment.

Gallery

Posted on October 13, 2009 by zzz_zwp

This gallery contains 1 photo.

Cats… in my beard?

SELECT option_name, option_value FROM wp_options WHERE option_name IN ('_site_transient_wp_theme_files_patterns-521ceac6f7ea50d1f2c96a08a1af8fc4','_site_transient_timeout_wp_theme_files_patterns-521ceac6f7ea50d1f2c96a08a1af8fc4')

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND (wp_posts.post_author = 1) AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish'))) ORDER BY wp_posts.post_date DESC LIMIT 800, 10

SELECT DISTINCT t.term_id, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (1046, 1047, 1048, 1049, 1051, 1052, 1055, 1056, 1057, 1058) ORDER BY t.name ASC

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (116,117,65,115,110,95,109,113,121,104,112,120,58,6,51,7,119,14,118,9,114,111,1,108,98)

SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (468) ) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC

SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_name = '35180681ad36c802296cb73a7670c463' AND wp_posts.post_type = 'oembed_cache' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC

SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_parent = 1052 AND (wp_posts.post_mime_type LIKE 'image/%') AND wp_posts.post_type = 'attachment' AND ((wp_posts.post_status <> 'trash' AND wp_posts.post_status <> 'auto-draft')) ORDER BY wp_posts.menu_order ASC LIMIT 0, 999

SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_parent = 1058 AND (wp_posts.post_mime_type LIKE 'image/%') AND wp_posts.post_type = 'attachment' AND ((wp_posts.post_status <> 'trash' AND wp_posts.post_status <> 'auto-draft')) ORDER BY wp_posts.menu_order ASC LIMIT 0, 999

SELECT wp_comments.comment_ID FROM wp_comments JOIN wp_posts ON wp_posts.ID = wp_comments.comment_post_ID WHERE ( comment_approved = '1' ) AND comment_type NOT IN ('note') AND wp_posts.post_status IN ('publish') ORDER BY wp_comments.comment_date_gmt DESC LIMIT 0,5

SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC

[0] => themes/twentyeleven/inc/theme-options.php [1] => themes/twentyeleven/inc/widgets.php [2] => themes/twentyeleven/author.php [3] => themes/twentyeleven/header.php [4] => themes/twentyeleven/searchform.php [5] => themes/twentyeleven/content-link.php [6] => themes/twentyeleven/content.php [7] => themes/twentyeleven/content-gallery.php [8] => themes/twentyeleven/sidebar.php [9] => themes/twentyeleven/footer.php [10] => themes/twentyeleven/sidebar-footer.php

$_SERVER = array ( 'SERVER_SOFTWARE' => 'Apache', 'REQUEST_URI' => '/author/zzz_zwp/page/81/', 'LSPHP_ENABLE_USER_INI' => 'on', 'PATH' => '/usr/local/bin:/usr/bin:/bin', 'TEMP' => '/tmp', 'TMP' => '/tmp', 'TMPDIR' => '/tmp', 'PWD' => '/', 'HTTP_ACCEPT' => '*/*', 'HTTP_ACCEPT_ENCODING' => 'gzip, br, zstd, deflate', 'CONTENT_LENGTH' => '0', 'HTTP_HOST' => 'www.zzzzzzzzz.net', 'HTTP_USER_AGENT' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'HTTP_X_HTTPS' => '1', 'REDIRECT_UNIQUE_ID' => 'aidNd64r6oW-rSUhxEBWOwAAmnw', 'REDIRECT_QS_ConnectionId' => '178096063160706448646901', 'REDIRECT_SCRIPT_URL' => '/author/zzz_zwp/page/81/', 'REDIRECT_SCRIPT_URI' => 'https://www.zzzzzzzzz.net/author/zzz_zwp/page/81/', 'REDIRECT_HTTPS' => 'on', 'REDIRECT_SSL_TLS_SNI' => 'www.zzzzzzzzz.net', 'REDIRECT_HTTP2' => 'on', 'REDIRECT_H2PUSH' => 'off', 'REDIRECT_H2_PUSH' => 'off', 'REDIRECT_H2_PUSHED' => '', 'REDIRECT_H2_PUSHED_ON' => '', 'REDIRECT_H2_STREAM_ID' => '1', 'REDIRECT_H2_STREAM_TAG' => '646901-1119-1', 'REDIRECT_STATUS' => '200', 'UNIQUE_ID' => 'aidNd64r6oW-rSUhxEBWOwAAmnw', 'QS_ConnectionId' => '178096063160706448646901', 'SCRIPT_URL' => '/author/zzz_zwp/page/81/', 'SCRIPT_URI' => 'https://www.zzzzzzzzz.net/author/zzz_zwp/page/81/', 'HTTPS' => 'on', 'SSL_TLS_SNI' => 'www.zzzzzzzzz.net', 'HTTP2' => 'on', 'H2PUSH' => 'off', 'H2_PUSH' => 'off', 'H2_PUSHED' => '', 'H2_PUSHED_ON' => '', 'H2_STREAM_ID' => '1', 'H2_STREAM_TAG' => '646901-1119-1', 'SERVER_SIGNATURE' => '', 'SERVER_NAME' => 'www.zzzzzzzzz.net', 'SERVER_ADDR' => '10.37.77.36', 'SERVER_PORT' => '443', 'REMOTE_ADDR' => '216.73.216.236', 'DOCUMENT_ROOT' => '/home1/zzz/public_html', 'REQUEST_SCHEME' => 'https', 'CONTEXT_PREFIX' => '', 'CONTEXT_DOCUMENT_ROOT' => '/home1/zzz/public_html', 'SERVER_ADMIN' => 'webmaster@zzzzzzzzz.net', 'SCRIPT_FILENAME' => '/home1/zzz/public_html/index.php', 'REMOTE_PORT' => '6287', 'REDIRECT_URL' => '/author/zzz_zwp/page/81/', 'SERVER_PROTOCOL' => 'HTTP/2.0', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => '', 'SCRIPT_NAME' => '/index.php', 'PHP_SELF' => '/index.php', 'REQUEST_TIME_FLOAT' => 1780960631.6106359958648681640625, 'REQUEST_TIME' => 1780960631, 'argv' => array ( ), 'argc' => 0, );

0.0300	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_nonce_array' LIMIT 1`
0.0191	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_definitions_array' LIMIT 1`
0.1512	SELECT * FROM `wp_posts` WHERE post_type = 'gotmls_results' AND post_name = 'ade6a2f0a80f93453d55cfa8169006e0'
0.0310	`SELECT option_value FROM wp_options WHERE option_name = 'gzipcompression' LIMIT 1`
0.0319	`SELECT option_value FROM wp_options WHERE option_name = 'rsssl_encryption_keys_set' LIMIT 1`
0.0279	`SELECT option_value FROM wp_options WHERE option_name = 'rsssl_le_certificate_generated_by_rsssl' LIMIT 1`
0.0231	`SELECT option_value FROM wp_options WHERE option_name = 'rsssl_ssl_activation_active' LIMIT 1`
0.1111	`SELECT option_name, option_value FROM wp_options WHERE option_name IN ('_site_transient_wp_theme_files_patterns-521ceac6f7ea50d1f2c96a08a1af8fc4','_site_transient_timeout_wp_theme_files_patterns-521ceac6f7ea50d1f2c96a08a1af8fc4')`
0.0370	`SELECT option_value FROM wp_options WHERE option_name = 'preload_cache_counter' LIMIT 1`
0.0789	`SELECT * FROM wp_users WHERE user_nicename = 'zzz_zwp' LIMIT 1`
0.2351	`SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC`
2.6991	`SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND (wp_posts.post_author = 1) AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish'))) ORDER BY wp_posts.post_date DESC LIMIT 800, 10`
0.0291	`SELECT FOUND_ROWS()`
0.0880	`SELECT wp_posts.* FROM wp_posts WHERE ID IN (1046,1047,1048,1049,1051,1052,1055,1056,1057,1058)`
0.1538	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1046,1047,1048,1049,1051,1052,1055,1056,1057,1058) ORDER BY meta_id ASC`
0.5019	`SELECT DISTINCT t.term_id, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (1046, 1047, 1048, 1049, 1051, 1052, 1055, 1056, 1057, 1058) ORDER BY t.name ASC`
0.2551	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (116,117,65,115,110,95,109,113,121,104,112,120,58,6,51,7,119,14,118,9,114,111,1,108,98)`
0.0401	`SELECT option_value FROM wp_options WHERE option_name = 'mwp_communication_key' LIMIT 1`
0.0219	`SELECT option_value FROM wp_options WHERE option_name = 'mwp_communication_keys' LIMIT 1`
0.0310	`SELECT option_value FROM wp_options WHERE option_name = 'can_compress_scripts' LIMIT 1`
0.0551	`SELECT * FROM wp_posts WHERE ID = 1716 LIMIT 1`
0.0219	`SELECT option_value FROM wp_options WHERE option_name = 'https_migration_required' LIMIT 1`
0.0219	`SELECT option_value FROM wp_options WHERE option_name = 'site_logo' LIMIT 1`
0.0548	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id = 468`
0.3450	`SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (468) ) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC`
0.1690	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1670,1671,1672,1681,1682) ORDER BY meta_id ASC`
0.0470	`SELECT wp_posts.* FROM wp_posts WHERE ID IN (1542,1534,1579,1544)`
0.0710	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1542,1534,1579,1544) ORDER BY meta_id ASC`
0.1361	`SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_name = '35180681ad36c802296cb73a7670c463' AND wp_posts.post_type = 'oembed_cache' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC`
0.2520	`SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_parent = 1052 AND (wp_posts.post_mime_type LIKE 'image/%') AND wp_posts.post_type = 'attachment' AND ((wp_posts.post_status <> 'trash' AND wp_posts.post_status <> 'auto-draft')) ORDER BY wp_posts.menu_order ASC LIMIT 0, 999`
0.0551	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1053) ORDER BY meta_id ASC`
0.1900	`SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_parent = 1058 AND (wp_posts.post_mime_type LIKE 'image/%') AND wp_posts.post_type = 'attachment' AND ((wp_posts.post_status <> 'trash' AND wp_posts.post_status <> 'auto-draft')) ORDER BY wp_posts.menu_order ASC LIMIT 0, 999`
0.0401	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1059) ORDER BY meta_id ASC`
0.1099	`SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC LIMIT 0, 5`
1.2231	`SELECT wp_posts.* FROM wp_posts WHERE ID IN (1771,1734,1728,1725,1721)`
0.0682	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1771,1734,1728,1725,1721) ORDER BY meta_id ASC`
0.2990	`SELECT DISTINCT t.term_id, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (1771, 1734, 1728, 1725, 1721) ORDER BY t.name ASC`
0.1609	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (489,490,478,484,492,483,479,480,485,486,481,482,37,491,82)`
0.0691	`SELECT wp_comments.comment_ID FROM wp_comments JOIN wp_posts ON wp_posts.ID = wp_comments.comment_post_ID WHERE ( comment_approved = '1' ) AND comment_type NOT IN ('note') AND wp_posts.post_status IN ('publish') ORDER BY wp_comments.comment_date_gmt DESC LIMIT 0,5`
2.5380	SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC
0.1099	`SELECT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') AND tt.count > 0 ORDER BY t.name ASC`
0.0670	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (475,474)`