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

[sietwolt]

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

[kev1n]

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.

[steven]

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