I am using the current dev, 6.x-1.x-dev as of 2011-Dec-20 on my site. But I keep getting in my error logs this warning below which I can't figure out why I am getting. I searched to see if there is a solution but couldn't find one. The module works fine and everything works but I keep getting this log every time a page is loaded. I have tried removing this module and re installing it (made sure tables removed) but no luck with that. Also I went over again the included read me file in this modules folder.
User warning: 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 'varchar), 8, '00000000') AS count, bundle_md5, filename_' at line 8 query: advagg_bundler_analysis /* bradb : advagg_bundler_analysis */ SELECT count, bundle_md5, filename FROM ( SELECT LPAD(CAST(COUNT(*) AS varchar), 8, '00000000') AS count, bundle_md5, filename_md5 FROM advagg_bundles WHERE root = 1 AND timestamp > 1323252073 GROUP BY filename_md5) AS ab INNER JOIN advagg_files AS af USING ( filename_md5 ) in _db_query() (line 148 of /home/content/30/5317830/html/includes/database.mysql.inc).
Comments
Comment #1
mikeytown2 CreditAttribution: mikeytown2 commentedLooks like fallout from #1338188: PostgreSQL: Improper argument to SQL lpad() in advagg_bundler_analysis()
Its a MySQL bug http://bugs.mysql.com/bug.php?id=34564
Comment #2
gdbwb05 CreditAttribution: gdbwb05 commentedI saw that issue but wasn't sure about it just because I was using a newer version. Thanks for the fast reply.
Comment #3
gdbwb05 CreditAttribution: gdbwb05 commentedI just want to let you know that I tried the patch from the other issue and it fixed that problem -- thanks alot.
Comment #4
mikeytown2 CreditAttribution: mikeytown2 commentedMoving this to the other issue.
#1338188: PostgreSQL: Improper argument to SQL lpad() in advagg_bundler_analysis()