mysqli_real_escape_string() expects parameter 2 to be string, array given

[JRGoold]

Here is the complete "myDEBUG" message of which there are a "bunch" in the log directory:

[02-Jun-2016 00:59:28 GMT] PHP Warning:  mysqli_real_escape_string() expects parameter 2 to be string, array given in /home/content/53/6837553/html/www/ebb/includes/classes/db/mysql/query_factory.php on line 115

I have no idea what is provoking this error (I haven't seen it on my test site that I have upgraded to 1.5.5a and am testing/debugging). If I do, I'll reply to this thread with additional information.

[DrByte]

In simplest terms the error means: when a query was sent to mysql it was found to have incorrect parameters.

Zen Cart only sends query parameters based on what your code is telling it to do.

I'm guessing one of your plugins or customizations is sending query data that's an array and has not been squashed down to a string. How to find it? Compare all your files against original files to identify all the places in which your code differs from ZC original code: http://www.zen-cart.com/wiki/index.p...Obscure_Issues

Additionally for your v154 site you might try installing lat9's debug backtrace plugin to help get more detailed error messages about which specific SQL query is triggering the problem, to help you isolate the issue more quickly.



(Moderator note: I moved this thread out of the Bug Reports section because it's not a bug in Zen Cart core code.)

[lat9]

If you install the "myDEBUG Backtrace" plugon, you'll see what module made that errant call; it's in the core for Zen Cart 1.5.5 and later.

[JRGoold]

The problem is being caused in the SuperTracker plugin. I have applied a fix described in the Forum thread devoted to SuperTracker, but will need to monitor the live site to see if the problem is truly resolved.

The thread is: https://www.zen-cart.com/showthread....62#post1202262 and the immediately following post.