mysql_real_escape_string() expects parameter 1 to be string

Error in #1 comes from a bad update function and was introduced in #1204338: Request for new "changed" field in "uc_shipments" table for automated tracking purposes. There's a fix in that issue.

The patch only solves the problem in #1, not the mysql_real_escape_string() problem.

Yes, as far as I know you're the only one. It's going to be impossible to track this down without more information. It's not even clear to me that it's an Ubercart problem; since the error is from Drupal core it could be caused by any module you have installed. A quick search of drupal.org shows a number of issues like this: http://drupal.org/node/766256

If you could put some print statements into db_escape_string() like suggested in that thread, that would help narrow down the problem. In particular, we need to know what are the contents of the array variable that's supposed to be a string according to the error message, and we need to see a backtrace that shows where in Ubercart (if it's Ubercart) this function is being invoked.

I'm getting the same problem here as well - wondered why i wasn't getting any sales for a whole week!

mysqli_real_escape_string() expects parameter 2 to be string, array given in database.mysqli.inc on line 329.

Data from the checkout form doesn't appear to get passed to the review page as the user details are blank in review form

Also noticed that it appears to bypass PayPal completely (my payment processor) - you get to the order review page, no data, then when you hit submit, instead of diverting to PayPal, it completes order, which is left pending

Just did some deductive work...

and it appears that there was a problem with the mailchimp integration module. I disabled it and everything appears to work

Will be posting to the ubercart mailchimp issue queue

Sounds like this can be closed then.

Fix for "mysqli_real_escape_string() expects parameter 2 to be string, array given in db_escape_string()":

--- uc_mailchimp.module.orig 2009-12-17 01:00:00.000000000 +1100
+++ uc_mailchimp.module 2011-08-17 13:58:03.000000000 +1000
@@ -118,7 +118,7 @@
         return $review;
     break;
     case 'process':
-        $arg1->uc_mailchimp = $arg2;
+        $arg1->uc_mailchimp = serialize($arg2);
      
     break;
     case 'settings':

Problem persists for me. I've tried disabling Mailchimp all together but still having the issue.

warning: mysql_real_escape_string() expects parameter 1 to be string, array given domain.com/html/includes/database.mysql.inc on line 329. displayed on 'review' page of checkout.

'Paying by' field is blank on review screen even though paypal was selected on previous page. Clicking on submit order completes the order but does not redirect to paypal to take payment.

Mailchimp was working fine with ubercart up until now. I've recently installed Ubercart Marketplace and more specifically a this patch: http://drupal.org/node/763220#comment-4900560.

I believe that my problem has occurred since this patch but cannot be certain.

Please help. Thank you.

The error is so generic that we cannot help you further without more information - you should try reverting that patch and see if it still occurs. And if you find this only occurs with Ubercart Marketplace, then you should raise this issue in the Ubercart Marketplace queue.

Patch in #13 worked for me - thanks

Had a bug after an update of Ubercart that was causing orders to not save properly after cart/checkout (resulting in address fields showing UNKNOWN), and this turned out to be the culprit.

Patch in #13 worked for me as well.