Morgähn,
habe ein Problem mit einer Extension die ich mir gebastelt habe. Lokal mit mysql4 (Typo3 Winstaller) funktioniert alles wunderbar. Auf dem Webserver mit mysql5 allerdings sagt mir typo3 + phpmyadmin:
Unknown column 'pi_mm.uid_foreign' in 'on clause'
Hier mal der Query...
SELECT p.uid AS uid,
p.title AS title,
p.first_name AS first_name,
p.surname AS surname,
i.uid AS institute_uid,
i.abbreviation AS institute_abbreviation,
i.full_name AS institute_full_name,
c.uid AS country_uid,
c.name AS country
FROM user_eurametctcp_person AS p,
user_eurametctcp_person_institute_mm AS pi_mm,
user_eurametctcp_person_country_mm AS pc_mm
INNER JOIN user_eurametctcp_institute AS i
ON pi_mm.uid_foreign = i.uid
AND pi_mm.uid_local = p.uid
INNER JOIN user_eurametctcp_country AS c
ON pc_mm.uid_foreign = c.uid
AND pc_mm.uid_local = p.uid
WHERE p.hidden = 0
ORDER BY surname DESC,
first_name DESC,
institute DESC,
country DESC,
title DESC
LIMIT 0,3
Wo liegt der Fehler?
Danke schonmal im voraus...