Database addExpression SUM: Call to a member function execute() on string

Ricardo Castañeda

7/10/24, 6:01 PM

I need to get the sum of all points values of the user with uid 1 from the test_sum_expression table. But when I try to execute I get this message Error: Call to a member function execute() on string.

If I don't execute, I get the count 6 of the word points, as if it were counting the characters from the string points.

$queryPoints = $connection->select('test_sum_expression', 'n')
    ->fields('n', ['uid', 'points'])
    ->condition('n.uid', 1, '=')
    ->groupBy('n.uid')
    ->addExpression('SUM(n.points)', 'points')
    ->execute();


dpm($queryPoints);

1 + 0

database

Score:3

Drupal

Jaypan

7/10/24, 6:20 PM

This is because addExpression() returns the unique alias assigned to the expression, and not the query. You can fix this by adjusting your code as follows:

$query = $connection->select('test_sum_expression', 'n')
    ->fields('n', ['uid', 'points'])
    ->condition('n.uid', 1, '=')
    ->groupBy('n.uid');
$query->addExpression('COUNT(n.points)', 'points');
$queryPoints = $query->execute();

+ 2

Ricardo Castañeda

7/10/24, 9:15 PM

Thanks for your answer. But by mistake in the question I wrote the code with COUNT instead of SUM. My apologies. I've corrected the question. Does this code work with SUM? I'm getting with dpm($queryPoints): $queryPoints Drupal\Core\Database\StatementWrapper#458455 (3)

Jaypan

7/10/24, 9:59 PM

`addExpression()` returns a string, whether you pass it SUM or COUNT, so my code is the same either way. Whether that code does what you are hoping is a different question - I am helping with the syntax only.

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: Database addExpression SUM: Call to a member function execute() on string

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.