AppGini Community Forums

i have table 'mambers'. wenn i ask for memberslist from table members i get error.
"SELECT m.id AS 'Member ID', m.name AS 'Name', m.vorname AS 'Vorname', m.partner AS 'Partner', m.firma AS 'Firma', m.strasse AS 'Strasse', m.plz AS 'PLZ', m.ort AS 'Ort', m.email AS 'Email', m.telefon AS 'Telefon', m.schlussel AS 'Schlussel', m.geburtstag AS 'Geburtstag', m.pgeburtstag AS 'Partner Geburtstag', m.member_seit AS 'Member Seit', m.member

Unknown table 'm' in field list"

ending must be "..... from members as m " - not "... ,m.member"

This is a bug in the ChatGPT completion response unfortunately. It happens sometime and the fix is kind of trial and error by trying a slightly different version of your question. The guys at OpenAI do make frequent updates to ChatGPT so hopefully this will get fixed soon.