[TYPO3] MySQL question

[Oliver Rowlands]

Hi Livius,

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.

Regards,

Oliver

Livius Agrippa wrote:
> Hi,
> 
> 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,
> Livius


-- 
Oliver Rowlands
:: 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