{"id":3308,"date":"2013-08-07T23:02:20","date_gmt":"2013-08-07T23:02:20","guid":{"rendered":"http:\/\/www.dognmonkey.com\/techs\/?p=3308"},"modified":"2016-02-05T13:32:03","modified_gmt":"2016-02-05T21:32:03","slug":"warning-missing-argument-2-for-wpdbprepare","status":"publish","type":"post","link":"https:\/\/www.dognmonkey.com\/techs\/warning-missing-argument-2-for-wpdbprepare.html","title":{"rendered":"Warning: Missing argument 2 for wpdb::prepare()"},"content":{"rendered":"

With all the new database version and WordPress updates, sometimes I get the warning from the footer scripts. This time with the WP 3.6 update.<\/em><\/p>\n

\n

Warning<\/b>: Missing argument 2 for wpdb::prepare(), called in C:\\xampp\\htdocs\\wp36\\wp-content\\themes\\i2010techs13\\footer.php on line 28 and defined in\u00a0C:\\xampp\\htdocs\\wp36\\wp-includes\\wp-db.php<\/b>\u00a0on line\u00a0992<\/b><\/p>\n<\/blockquote>\n

\"wpdbwarning\"<\/a><\/p>\n

The fix is to add the code to config.php file – anywhere.<\/em><\/p>\n

\n

@ini_set(‘display_errors’, 0);<\/p>\n<\/blockquote>\n

\"configfix\"<\/a><\/p>\n

This is the script I added to extract the date of the first post and the last post of my blog.<\/em><\/p>\n

<?php
\nglobal $wpdb;
\n$post_datetimes = $wpdb->get_row($wpdb->prepare(“SELECT YEAR(min(post_date_gmt)) AS firstyear, YEAR(max(post_date_gmt)) AS lastyear FROM $wpdb->posts WHERE post_date_gmt > 1970”));
\nif ($post_datetimes) {
\n$firstpost_year = $post_datetimes->firstyear;
\n$lastpost_year = $post_datetimes->lastyear;
\n$copyright = __(‘Copyright &copy;&nbsp; ‘, ‘idog’) . $firstpost_year;
\nif($firstpost_year != $lastpost_year) {
\n$copyright .= ‘-‘. $lastpost_year;
\n}
\n$copyright .= ‘ ‘;
\necho $copyright;
\n}<\/p><\/blockquote>\n