Unknown column 'beauftragter_id' in 'field list'

[Kant]

Hello,

I get the above error message and am not sure if I created a wrong join.

http://prntscr.com/irk14i
http://prntscr.com/irjxsx
http://prntscr.com/irjzie
http://prntscr.com/irjzuj
http://prntscr.com/irk73w

https://seglerjugend.berlin/segeln/segeln-1/termine/schlauchbootreservierung/terminuebersicht

An empty data record is generated in the List"Fahrzeugstandort"?

Is not it allowed to create a join this way?

regards,
Oliver

 

[troester]

Are you using "or concat label" in your database joins with "hardcoded" table names?
use {thistable} instead, e.g.
{thistable}.beauftragter_id
not
fahrzeuge.beauftragter_id

If there are multiple joins and database joins Fabrik will use table aliases (e.g. ... FROM fahrzeuge AS fahrezeuge_1 ....).

 

[Kant]

I did not use any hardcode table names.
I have removed the values from "or concat label", but the error persists

 

[cheesegrits]

I don't see an error on that page.

What are the steps to reproduce the error?

-- hugh

 

[Kant]

The error occurs when the form is saved.
https://seglerjugend.berlin/segeln/segeln-1/termine/schlauchbootreservierung/reservierungsanfrage/
in the ""Fahrzeugstandorte"" list, a new record will be added each time the form is saved.
https://seglerjugend.berlin/datenbank/mieten/mieten-1/standort

I am not sure if I will accept these joins or if I have a thought mistake
https://prnt.sc/irjxsx
All xxx_id are dbjoin elements

If you are so kind, you can log in and create a new record

regards,
Oliver

 

[cheesegrits]

OK, this form / list is waaay to complex for me to debug this remotely, so I'll need to install a copy locally, and set up a debug project on it. I kicked off an Akeeba backup, but it's almost a gigabyte, and won't download via http, so I'll need ftp credentials - can you add those to you My Sites.

-- hugh

 

[Kant]

Please keep in mind that I do not use DB joomla. Does it make sense in this case or should I try to simplify the structure? The error occurs even in the very simple structure.
regards
Oliver

 

[Kant]

Have the data deposited

 

[Kant]

A friendly beep - is there something new?

 

[Kant]

Seven days no answer. Where is the problem?