WordPress database error: [<div style="clear:both">&nbsp;</div><div class="queries" style="clear:both; margin_bottom:2px; border: red dotted thin;">Queries made or created this session were<br/> <ol> <li>Raw query: SELECT * FROM wp_options WHERE </li> <li>Rewritten: SELECT * FROM wp_options WHERE </li> <li>With Placeholders: SELECT * FROM wp_options WHERE </li> <li>Prepare: SELECT * FROM wp_options WHERE </li> </ol> </div><div style="clear:both; margin_bottom:2px; border: red dotted thin;" class="error_message" style="border-bottom:dotted blue thin;">Error occurred at line 1644 in Function prepare_query. <br/> Error message was: Problem preparing the PDO SQL Statement. Error was: SQLSTATE[HY000]: General error: 1 incomplete input </div><pre>#0 /home/nattaylor/public_html/wordpress/wp-content/db.php(2746): WP_SQLite_DB\PDOEngine->get_error_message() #1 /home/nattaylor/public_html/wordpress/wp-content/db.php(3484): WP_SQLite_DB\wpsqlitedb->query('...') #2 /home/nattaylor/public_html/wordpress/wp-content/db.php(2952): WP_SQLite_DB\PDOSQLiteDriver->execute_duplicate_key_update() #3 /home/nattaylor/public_html/wordpress/wp-content/db.php(1893): WP_SQLite_DB\PDOSQLiteDriver->rewrite_query('...', '...') #4 /home/nattaylor/public_html/wordpress/wp-content/db.php(1357): WP_SQLite_DB\PDOEngine->execute_insert_query_new('...') #5 /home/nattaylor/public_html/wordpress/wp-content/db.php(2739): WP_SQLite_DB\PDOEngine->query('...') #6 /home/nattaylor/public_html/wordpress/wp-includes/option.php(1143): WP_SQLite_DB\wpsqlitedb->query('...') #7 /home/nattaylor/public_html/wordpress/wp-includes/option.php(2170): add_option('...', 1764083324, '', '...') #8 /home/nattaylor/public_html/wordpress/wp-includes/option.php(1953): add_network_option(1, '...', 1764083324) #9 /home/nattaylor/public_html/wordpress/wp-includes/option.php(2661): add_site_option('...', 1764083324) #10 /home/nattaylor/public_html/wordpress/wp-includes/class-wp-theme.php(2047): set_site_transient('...', Array, 1800) #11 /home/nattaylor/public_html/wordpress/wp-includes/class-wp-theme.php(1856): WP_Theme->set_pattern_cache(Array) #12 /home/nattaylor/public_html/wordpress/wp-includes/block-patterns.php(374): WP_Theme->get_block_patterns() #13 /home/nattaylor/public_html/wordpress/wp-includes/class-wp-hook.php(324): _register_theme_block_patterns('') #14 /home/nattaylor/public_html/wordpress/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters(NULL, Array) #15 /home/nattaylor/public_html/wordpress/wp-includes/plugin.php(517): WP_Hook->do_action(Array) #16 /home/nattaylor/public_html/wordpress/wp-settings.php(727): do_action('...') #17 /home/nattaylor/public_html/wordpress/wp-config.php(84): require_once('...') #18 /home/nattaylor/public_html/wordpress/wp-load.php(50): require_once('...') #19 /home/nattaylor/public_html/wordpress/wp-blog-header.php(13): require_once('...') #20 /home/nattaylor/public_html/wordpress/index.php(17): require('...') </pre>]
SELECT * FROM wp_options WHERE

WordPress database error: [<div style="clear:both">&nbsp;</div><div class="queries" style="clear:both; margin_bottom:2px; border: red dotted thin;">Queries made or created this session were<br/> <ol> <li>Raw query: SELECT * FROM wp_options WHERE </li> <li>Rewritten: SELECT * FROM wp_options WHERE </li> <li>With Placeholders: SELECT * FROM wp_options WHERE </li> <li>Prepare: SELECT * FROM wp_options WHERE </li> </ol> </div><div style="clear:both; margin_bottom:2px; border: red dotted thin;" class="error_message" style="border-bottom:dotted blue thin;">Error occurred at line 1644 in Function prepare_query. <br/> Error message was: Problem preparing the PDO SQL Statement. Error was: SQLSTATE[HY000]: General error: 1 incomplete input </div><pre>#0 /home/nattaylor/public_html/wordpress/wp-content/db.php(2746): WP_SQLite_DB\PDOEngine->get_error_message() #1 /home/nattaylor/public_html/wordpress/wp-content/db.php(3484): WP_SQLite_DB\wpsqlitedb->query('...') #2 /home/nattaylor/public_html/wordpress/wp-content/db.php(2952): WP_SQLite_DB\PDOSQLiteDriver->execute_duplicate_key_update() #3 /home/nattaylor/public_html/wordpress/wp-content/db.php(1893): WP_SQLite_DB\PDOSQLiteDriver->rewrite_query('...', '...') #4 /home/nattaylor/public_html/wordpress/wp-content/db.php(1357): WP_SQLite_DB\PDOEngine->execute_insert_query_new('...') #5 /home/nattaylor/public_html/wordpress/wp-content/db.php(2739): WP_SQLite_DB\PDOEngine->query('...') #6 /home/nattaylor/public_html/wordpress/wp-includes/option.php(1143): WP_SQLite_DB\wpsqlitedb->query('...') #7 /home/nattaylor/public_html/wordpress/wp-includes/option.php(2170): add_option('...', Array, '', '...') #8 /home/nattaylor/public_html/wordpress/wp-includes/option.php(1953): add_network_option(1, '...', Array) #9 /home/nattaylor/public_html/wordpress/wp-includes/option.php(2663): add_site_option('...', Array) #10 /home/nattaylor/public_html/wordpress/wp-includes/class-wp-theme.php(2047): set_site_transient('...', Array, 1800) #11 /home/nattaylor/public_html/wordpress/wp-includes/class-wp-theme.php(1856): WP_Theme->set_pattern_cache(Array) #12 /home/nattaylor/public_html/wordpress/wp-includes/block-patterns.php(374): WP_Theme->get_block_patterns() #13 /home/nattaylor/public_html/wordpress/wp-includes/class-wp-hook.php(324): _register_theme_block_patterns('') #14 /home/nattaylor/public_html/wordpress/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters(NULL, Array) #15 /home/nattaylor/public_html/wordpress/wp-includes/plugin.php(517): WP_Hook->do_action(Array) #16 /home/nattaylor/public_html/wordpress/wp-settings.php(727): do_action('...') #17 /home/nattaylor/public_html/wordpress/wp-config.php(84): require_once('...') #18 /home/nattaylor/public_html/wordpress/wp-load.php(50): require_once('...') #19 /home/nattaylor/public_html/wordpress/wp-blog-header.php(13): require_once('...') #20 /home/nattaylor/public_html/wordpress/index.php(17): require('...') </pre>]
SELECT * FROM wp_options WHERE

Letter Writing Campaigns with Email Links by Nat Taylor

Nat TaylorBlog, AI, Product Management & Tinkering

Letter Writing Campaigns with Email Links

Published on .

mailto links that include subject, body and CCs (e.g. <a href="mailto:name@domain.com?&subject=HelloWorld&body=Hi">send email</a>) turn out to be a great way to streamline the process of writing to elected officials, like this:

Example of a email link with details
  1. Create a landing page with information about the issue
  2. Add mailto links that have include the subject, body and CC
  3. Distribute the landing page link via normal means

The results are quite positive. In one case, my city councilor reported they got 70 “letters” (emails) in just a few hours about a local issue.

Why does this work?

Even today, it is commonplace for elected officials to track constituent calls, letters and emails with a simple YES/NO tally for a given bill. So when a group wants to advocate for a policy, they must get supporters to write or call and reference the bill.

These days most people are on their phones scrolling through texts, emails or social feeds. They’re not likely to do the tedious task of looking up a politicians’ phone number or email, then switching back to writing an email, then switching to reading an email with the bill number, then back to writing, then maybe looking up another email to CC. They’re also not about to download an app or register an account somewhere. But they will click links!

However while the existence of email links it widely known, it is rare that they are implemented with parameters like CC, subject and body. By implementing these fields, advocacy groups can ensure that mails that reference specific bill names/IDs get sent to the proper addresses. This is perhaps because mailto links fell out of fashion in the desktop era, since not all users had a mail client configured and so web forms became commonplace. However, in the smartphone era, almost everyone has a Mail client.

Creating such links is easy.

You could read the RFC6068 (which obsoletes the original 1998 spec!) or this piece from MDN on creating email links, but the easiest way is to just use a site like https://mailtolink.me/

Let me know if you have any questions.

Post Navigation

«
»