Unknown column 'max_allowed_packet' in 'where clause'

Yes. I just noticed the same thing but only when I view admin/reports/status
6.x-2.0-beta6

+1 I am getting this error also. I was trying to figure out where max_allowed_packet is set in the VARIABLES table since it appears absent in most of my Drupal sites (some which use views_data_export).

It's a bug created by issue #1421828: Warn if max allowed packet is too small, and commit http://cgit.drupalcode.org/views_data_export/commit/?h=6.x-2.x&id=26887a....

It's not looking at the Drupal variables table, it's looking for variables defined in mysql/maraidb (Don't know if it works in postgres or sqlite...)

To fix the warning, change

$max_allowed_packet = db_result(db_query('SHOW VARIABLES WHERE variable_name = %s', array('max_allowed_packet')));

to

$max_allowed_packet = db_result(db_query("SHOW VARIABLES WHERE variable_name = '%s'", array('max_allowed_packet')));

Here's a patch for consideration.

Meh, that patch was wrong.

Committed #5. Thanks everyone!

Nah, that's fine testbot, I already committed it.