“Warning: Missing argument 2 for wpdb::prepare()”
How do I fix it?
If you are seeing an error after upgrading to WordPress 3.5 that says something like this, you need to upgrade your theme.
We have fixed this with all of our themes and they are ready to download and re-install from your account page.
What if I have customized my theme’s code and don’t want to upgrade?
For those of you who have customized your theme’s code and don’t want to do a full upgrade, you’ll need to take a look at the warning message.
Here’s a sample error we have fixed from the Biznify Theme:
Warning: Missing argument 2 for wpdb::prepare(), called in /home/mintthem/public_html/demo/wp-content/themes/Biznify/products-pagetemplate.php on line 39 and defined in /home/mintthem/public_html/demo/wp-includes/wp-db.php on line 990
Step 1: Open the file it tells you to open. In this case, it is products-pagetemplate.php and Go to the line it refers to. In this case it is line 39
Step 2: Find the code that looks like this: $wpdb->prepare(“SELECT price FROM $table_name WHERE item_number = ‘$item_number’;”)
Step 3: Replace $item_number with %d
Step 4: Add $item_number after the last quotation mark. Also, make sure to put a comma before it. (notice the comma before $item_number below)
Example: $wpdb->prepare(“SELECT price FROM $table_name WHERE item_number = ‘%d‘;”, $item_number)
Luciano Ferrer on 26 May 14"When setting up an e-commerce site on WordPress, security needs to be your number one priority. Any time you're dealing with people's personal information or financial data, you have to be doubly careful. Failing to show you're a trustworthy vendor via recognizable security logos and such could lose you customers. But failing to account for security could result in a much worse outcome: theft and data loss. This is the e-commerce site owner's worst nightmare. Thankfully, you don't have to let this happen to you. Here, I'll discuss some of the most common security issues that WordPress-based e-commerce sites face and walk you through the steps you need to take to plug those security holes for once and for all."
