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).

Comments

raulmuroc’s picture

Issue summary: View changes

  • mikeytown2 committed cd66873 on 7.x-2.x
    Issue #2385551 by mikeytown2: MS SQL does not support LPAD
    
mikeytown2’s picture

Status: Active » Fixed
StatusFileSize
new1.44 KB

Used 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.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.