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

mikeytown2’s picture

gdbwb05’s picture

I saw that issue but wasn't sure about it just because I was using a newer version. Thanks for the fast reply.

gdbwb05’s picture

I just want to let you know that I tried the patch from the other issue and it fixed that problem -- thanks alot.

mikeytown2’s picture

Status: Active » Closed (duplicate)