Hi all,
I tried to enable the sql_multi_values option, but setting it to a
reasonable number of rows to insert at once (100) to avoid hitting the
MySQL packet size limit. But I get these errors in the logs:
Sep 2 17:59:01 microserver pmacctd[17603]: ERROR ( summary/mysql ):
'sql_multi_values' is too small (100). Try with a larger value.
Sep 2 16:57:46 microserver pmacctd[17608]: ERROR ( inbound/mysql ): You
have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'VALUES
(FROM_UNIXTIME(1378141141), FROM_UNIXTIME(1378141080), '00:1b:21:92:98:17'
at line 1
This looks like a bug to me? Surely it should be reasonable to insert
up to 100 rows at a time (per SQL statement) instead of just 1?
Cheers, Chris.
--
Aptivate | http://www.aptivate.org | Phone: +44 1223 967 838
Citylife House, Sturton Street, Cambridge, CB1 2QF, UK
Aptivate is a not-for-profit company registered in England and Wales
with company number 04980791.
_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists