nuBuilder Forum

In the Nudebugresults constantly pops up the message : SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Klantlijst' in 'SELECT' :

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

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Klantlijst' in 'SELECT'

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

SELECT
Klanten_id,
kla_klantid,
Klantlijst
FROM klanten
WHERE
`Klanten_id` = ?

===BACK TRACE====

/home/deb50460/domains/klokkenbouwen.nl/public_html/nubuilder/core/nuform.php - line 847 (nuRunQuery)

/home/deb50460/domains/klokkenbouwen.nl/public_html/nubuilder/core/nuform.php - line 400 (nuGetLookupValues)

/home/deb50460/domains/klokkenbouwen.nl/public_html/nubuilder/core/nuapi.php - line 92 (nuGetFormObject)


Apparently i did a sql with a field "+Klantlijst" Removed all entries, but the bug message continues.
Is er any idea how to clean the history of sql?

Thanks

Hi,

If you can't find the nuBuilder object that references the column *Klantlijst*, create a database dump (e.g., using phpMyAdmin) and search for the column name within the dump. This will help you identify exactly where the column is still being referenced.

Hi sietwolt,

If you are happy to share your database with us, I will make a video showing what Kev has explained.

I'm sure it would help other people as well.


Steven