Title: Error with wpdb::prepare
Last modified: August 20, 2016

---

# Error with wpdb::prepare

 *  Resolved [Scott Lesovic](https://wordpress.org/support/users/gmagicscott/)
 * (@gmagicscott)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/error-with-wpdbprepare/)
 * On this page: `options-general.php?page=cjtoolbox` there is a PHP error showing
   twice within each block. [See screenshot](http://postimage.org/image/h3cz76ukb/).
 * The error is:
    `Warning: Missing argument 2 for wpdb::prepare(), called in <em
   >[removed]</em>/wp-content/plugins/css-javascript-toolbox/css-js-toolbox.php 
   on line 895 and defined in <em>[removed]</em>/wp-includes/wp-db.php on line 990`
 * From the source:
 *     ```
       /**
       		* Get code template selection list.
       		*
       		* @param string Type of template. It could be 'css' or 'js';
       		* @param string Unique identified for the block list.
       		* @return void
       		*/
       		function show_dropdown_box($type, $boxid) {
       			global $wpdb;
       			$query = $wpdb->prepare("SELECT id, title FROM {$wpdb->prefix}cjtoolbox_cjdata WHERE type = '{$type}'");
       			$list = $wpdb->get_results($query);
       			if(count($list)) {
       				echo '<select id="cjtoolbox-'.$type.'-'.$boxid.'" class="cjtoolbox-'.$type.'">';
       				foreach($list as $def) {
       					echo '<option value="' . $def->id . '">'. $def->title . '</option>';
       				}
       				echo '</select>';
       			}
       		}
       ```
   
 * The line is:
    `$query = $wpdb->prepare("SELECT id, title FROM {$wpdb->prefix}
   cjtoolbox_cjdata WHERE type = '{$type}'");`
 * My proposed solution:
    `$query = $wpdb->prepare("SELECT id, title FROM {$wpdb-
   >prefix}cjtoolbox_cjdata WHERE type = %s", $type);`
 * Let me know what you think.
 * [http://wordpress.org/extend/plugins/css-javascript-toolbox/](http://wordpress.org/extend/plugins/css-javascript-toolbox/)

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [wipeoutmedia](https://wordpress.org/support/users/wipeoutmedia/)
 * (@wipeoutmedia)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/error-with-wpdbprepare/#post-3262600)
 * Hi gMagicScott,
 * Thanks for your message Scott.
    This is so cool of you to not only let us know
   about this error but also providing a solution for it. Thank you so much!!! We
   appreciate those screenshots too. We will be working on a big update to CSS &
   JavaScript Toolbox and any issues such as this error will be addressed. Leave
   it with us and hope to roll an update out in the near future.
 * Kind Regards,
    Damian
 *  Plugin Author [wipeoutmedia](https://wordpress.org/support/users/wipeoutmedia/)
 * (@wipeoutmedia)
 * [13 years, 5 months ago](https://wordpress.org/support/topic/error-with-wpdbprepare/#post-3262615)
 * Just a heads up on the recent error (or more-so latest warning).
    This is has
   been forced in the latest version of WordPress 3.5 for more security. You may
   already know this, but for other users experiencing this warning error with CJT,
   you can read more about it in Andrew Nacin’s [latest post](http://make.wordpress.org/core/2012/12/12/php-warning-missing-argument-2-for-wpdb-prepare/).
 * We’ll take care of this in the next update.
 * Regards,
    Damian
 *  Plugin Author [wipeoutmedia](https://wordpress.org/support/users/wipeoutmedia/)
 * (@wipeoutmedia)
 * [13 years, 2 months ago](https://wordpress.org/support/topic/error-with-wpdbprepare/#post-3262691)
 * Thanks for reporting!
 * This issue has fixed in version 6.0.
 * Regards,
    Ahmed

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Error with wpdb::prepare’ is closed to new replies.

 * ![](https://ps.w.org/css-javascript-toolbox/assets/icon-256x256.gif?rev=3132209)
 * [CSS & JavaScript Toolbox](https://wordpress.org/plugins/css-javascript-toolbox/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/css-javascript-toolbox/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/css-javascript-toolbox/)
 * [Active Topics](https://wordpress.org/support/plugin/css-javascript-toolbox/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/css-javascript-toolbox/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/css-javascript-toolbox/reviews/)

## Tags

 * [$wpdb->prepare](https://wordpress.org/support/topic-tag/wpdb-prepare/)
 * [wpdb](https://wordpress.org/support/topic-tag/wpdb/)

 * 3 replies
 * 2 participants
 * Last reply from: [wipeoutmedia](https://wordpress.org/support/users/wipeoutmedia/)
 * Last activity: [13 years, 2 months ago](https://wordpress.org/support/topic/error-with-wpdbprepare/#post-3262691)
 * Status: resolved