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(2189): add_option('...', 1773070965, '', '...') #8 /home/nattaylor/public_html/wordpress/wp-includes/option.php(1953): add_network_option(1, '...', 1773070965) #9 /home/nattaylor/public_html/wordpress/wp-includes/option.php(2680): add_site_option('...', 1773070965) #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(341): _register_theme_block_patterns('') #14 /home/nattaylor/public_html/wordpress/wp-includes/class-wp-hook.php(365): WP_Hook->apply_filters(NULL, Array) #15 /home/nattaylor/public_html/wordpress/wp-includes/plugin.php(522): WP_Hook->do_action(Array) #16 /home/nattaylor/public_html/wordpress/wp-settings.php(742): 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(2189): 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(2682): 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(341): _register_theme_block_patterns('') #14 /home/nattaylor/public_html/wordpress/wp-includes/class-wp-hook.php(365): WP_Hook->apply_filters(NULL, Array) #15 /home/nattaylor/public_html/wordpress/wp-includes/plugin.php(522): WP_Hook->do_action(Array) #16 /home/nattaylor/public_html/wordpress/wp-settings.php(742): 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

Backing Up Google Authenticator by Nat Taylor

Nat Taylor — Blog, AI, Product Management & Tinkering

Backing Up Google Authenticator

Published on .

It’s a best practice to secure your accounts with multi-factor authentication for extra protection in the case of a password leak, or something. Time-based one-time passwords (TOTP) are a common approach, and Google Authenticator is very common, but it does not allow backups natively, which you may need in case you lose your phone, or something. Here’s how:

  1. Go to ⠇>Transfer Accounts > Export Accounts and literally take a picture of the QR code (since screenshots aren’t allowed.) This will contain all the info you need, in an encoded form of URIs like this otpauth://totp/Example:alice@google.com?secret=JBSWY3DPEHPK3PXP&issuer=Example (more info here)
  2. Decode the QR codes. I choose to brew install zbar pngpaste then alias qrpaste='zbarimg -q --raw <(pngpaste -)' and take screenshots of the pictures I took with Photo Booth
  3. Get https://github.com/dim13/otpauth (Note: on MacOS you make need to xattr -d com.apple.quarantine otpauth)
  4. Pass the decoded strings from step 2 into optauth (e.g. ./otpauth -link "otpauth-migration://offline?data=stuffhere")
  5. Now you’ll have URIs that you can backup and use.

It’s a good idea to encrypt these!

Post Navigation

«
»