Hi,
me once again. Because of the databasejoin element to another database fabrik is not able to show me the data in list view. It is seaching in the joom database for a table called Adresse....
Here's the error message:
Table 'usr_web54_1.Adresse' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS DISTINCT `listtest`.`meilenstein_ausgabe` AS `listtest___meilenstein_ausgabe`,
`listtest`.`meilenstein_ausgabe` AS `listtest___meilenstein_ausgabe_raw`,
`listtest`.`datetime` AS `listtest___datetime`,
`listtest`.`datetime` AS `listtest___datetime_raw`,
`listtest`.`bestandskunden` AS `listtest___bestandskunden`,
`listtest`.`bestandskunden` AS `listtest___bestandskunden_raw`,
`listtest`.`id` AS `listtest___id`,
`listtest`.`id` AS `listtest___id_raw`,
(SELECT GROUP_CONCAT(CONCAT_WS('', (SELECT Adresse.firma from Adresse WHERE Adresse.AdresseID = `lookup`.AdresseID),' - ',(SELECT Adresse.vorname from Adresse WHERE Adresse.AdresseID = `lookup`.AdresseID),' ',(SELECT Adresse.nachname from Adresse WHERE Adresse.AdresseID = `lookup`.AdresseID)) SEPARATOR '//..*..//') FROM listtest_repeat_auftrags_id
LEFT JOIN Auftrag AS lookup ON lookup.kundennummer = listtest_repeat_auftrags_id.auftrags_id WHERE listtest_repeat_auftrags_id.parent_id = `listtest`.`id`) AS listtest___auftrags_id,
(SELECT GROUP_CONCAT(id SEPARATOR '//..*..//') FROM listtest_repeat_auftrags_id WHERE parent_id = `listtest`.`id`) AS `listtest___auftrags_id_raw`, (SELECT GROUP_CONCAT(auftrags_id SEPARATOR '//..*..//') FROM listtest_repeat_auftrags_id WHERE listtest_repeat_auftrags_id.parent_id = `listtest`.`id`) AS listtest___auftrags_id_id,
(SELECT GROUP_CONCAT(params SEPARATOR '//..*..//') FROM listtest_repeat_auftrags_id WHERE parent_id = `listtest`.`id`) AS `listtest___auftrags_id___params`,
`listtest`.`id` AS slug
, `listtest`.`id` AS `__pk_val`
How do you handle such things?