Additional uncaught exception thrown while handling exception.
Original
PDOException: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 10.0][SQL Server]'LPAD' wird nicht als Name einer integrierten Funktion erkannt.: /* Query called from advagg_bundler_analysis() */ SELECT af.[filename] AS [filename], af.[filesize] AS [filesize], af.[mtime] AS [mtime], af.[changes] AS [changes], af.[linecount] AS [linecount], af.[filename_hash] AS [filename_hash], aa.[counter] AS [counter] FROM {advagg_files} af INNER JOIN (SELECT aa.[filename_hash] AS [filename_hash], LPAD(CAST(COUNT(aav.aggregate_filenames_hash) AS char(8)), 8, '0') AS counter, aa.filename_hash AS _field_0 FROM {advagg_aggregates} aa INNER JOIN (SELECT aav.* FROM {advagg_aggregates_versions} aav WHERE ( ([aav].[root] = :db_condition_placeholder_0) AND ([aav].[atime] > :db_condition_placeholder_1) )) aav ON aav.aggregate_filenames_hash=aa.aggregate_filenames_hash GROUP BY aa.filename_hash) aa ON af.filename_hash=aa.filename_hash ORDER BY aa.counter DESC; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => 1416307381 ) in advagg_bundler_analysis() (line 205 of C:\websites\\sites\all\modules\advagg\advagg_bundler\advagg_bundler.module).
Additional
PDOException: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 10.0][SQL Server]'LPAD' wird nicht als Name einer integrierten Funktion erkannt.: /* Query called from advagg_bundler_analysis() */ SELECT af.[filename] AS [filename], af.[filesize] AS [filesize], af.[mtime] AS [mtime], af.[changes] AS [changes], af.[linecount] AS [linecount], af.[filename_hash] AS [filename_hash], aa.[counter] AS [counter] FROM {advagg_files} af INNER JOIN (SELECT aa.[filename_hash] AS [filename_hash], LPAD(CAST(COUNT(aav.aggregate_filenames_hash) AS char(8)), 8, '0') AS counter, aa.filename_hash AS _field_0 FROM {advagg_aggregates} aa INNER JOIN (SELECT aav.* FROM {advagg_aggregates_versions} aav WHERE ( ([aav].[root] = :db_condition_placeholder_0) AND ([aav].[atime] > :db_condition_placeholder_1) )) aav ON aav.aggregate_filenames_hash=aa.aggregate_filenames_hash GROUP BY aa.filename_hash) aa ON af.filename_hash=aa.filename_hash ORDER BY aa.counter DESC; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => 1416307381 ) in advagg_bundler_analysis() (line 205 of C:\websites\\sites\all\modules\advagg\advagg_bundler\advagg_bundler.module).
| Comment | File | Size | Author |
|---|---|---|---|
| #3 | advagg-2385551-2-fix-sqlsrv-lpad.patch | 1.44 KB | mikeytown2 |
Comments
Comment #1
raulmuroc commentedComment #3
mikeytown2 commentedUsed this http://stackoverflow.com/questions/5912416/lpad-in-sql-server-2008
Patch has been committed; I might have gotten it wrong since I can't test it.