I would submit a bug on this.  I ran across another MySQL 4.1
incompatibility last week and they fixed it.  But first update to the
latest SVN version, because maybe this has already been fixed.

I came across another MySQL 4.1 issue that luckily wasn't causing me
any problems, so I didn't dig deeper, so I know there are multiple
incompatibilities between the current version of Cake and MySQL 4.x

-Aran

On Jun 24, 11:56 am, wholewheat <[EMAIL PROTECTED]> wrote:
> I am having a problem ever since moving to a sever that is limted to
> MySQL 4.0.
> Delete no longer works, and after some research in to why, it seems
> that MySQL 4.0 does not like a table alias in a DELETE statement. So,
> what Cake (1.2 RC1) is generating  is:
> DELETE `MyTable` FROM `cake_my_table` AS `MyTable` WHERE
> `MyTable`.`id` IN (7)
> but it only works when simplified down to...
> DELETE FROM `cake_my_table` WHERE `id` IN (7)
>
> Does anyone have a work around that will save me from over-riding
> delete (or del) for every model in the application.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to