PDO complains about the temporary table for the report.
Posted: Thu May 30, 2024 10:13 am
When creating a report I encountered a problem unknown to me:
But in phpMyAdmin my SQL works fine.Where to look for the error?
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)