[TYPO3] MySQL question
oliver at liquidlight.co.uk
Sun Apr 22 17:02:42 CEST 2007
What version of mysQL are you using?
Sub-selects have only been available in mySQL since version 4.1.
Upgrade mySQL or split that query into two queries.
Livius Agrippa wrote:
> I want to create a service for the cal extension but I encountered a
> mysql problem. Can someone tell me what is wrong with this mysql
> statement, because I don't have any idea.
> SELECT name, email FROM fe_users WHERE disable = "0" AND deleted = "0"
> AND fe_users.uid IN (SELECT uid_foreign FROM
> tx_cal_fe_user_event_monitor_mm WHERE uid_local = "48")
> The error returned by the MySQL is:
> #1064 - You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'SELECT uid_foreign FROM tx_cal_fe_user_event_monitor_mm WHERE u
> Best regards,
:: Liquid Light ::
E - oliver at liquidlight.co.uk
W - http://www.liquidlight.co.uk
T - 00 44 (0)845 6 58 88 35
F - 00 44 (0)845 6 58 44 35
More information about the TYPO3-english