PDO complains about the temporary table for the report.

[kknm]

When creating a report I encountered a problem unknown to me:

Code: Select all

[0] : ===PDO MESSAGE===

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nubuilder.___nu166582ecf8ce51____nu_summary' doesn't exist

===SQL===========

SELECT SUM(nu_sum_a_tn) AS the_sum_a FROM ___nu166582ecf8ce51____nu_summary  

===BACK TRACE====

/var/www/report/core/nurunpdf.php - line 821 (nuRunQuery)

/var/www/report/core/nurunpdf.php - line 668 (nuGetFieldValue)

/var/www/report/core/nurunpdf.php - line 434 (getObjectRows)

/var/www/report/core/nurunpdf.php - line 597 (setObjectLines)

/var/www/report/core/nurunpdf.php - line 587 (pageHeaderFooter)

/var/www/report/core/nurunpdf.php - line 383 (chopSectionOverPages)

/var/www/report/core/nurunpdf.php - line 316 (buildSection)

/var/www/report/core/nurunpdf.php - line 68 (nuBuildReport)

/var/www/report/core/nurunpdf.php - line 23 (nuRunReportId)

But in phpMyAdmin my SQL works fine.Where to look for the error?

[kev1n]

What nuBuilder version are you using?

[kknm]

V.4.5-2023.09.18.02
Similar tables work fine...
Although ...
I seem to have found a problem - some 'a_tn' fields are empty. When grouping, phpMyadmin does not consider this an error, PDO swears.