1093, "You can't specify target table 'catalogue_category' for update in FROM clause")

[rohit kumar sinha]

Hi ,

 I am using MySql as database , after the Oscar setup when creating a category I am getting below error "1093, "You can't specify target table 'catalogue_category' for update in FROM clause")" .  I am creating category once i created 'Partner' and 'Product  type'  , same instance never had any issue creating category when was connected to "Sqlite" after switching to 'mysql'  I am  getting this error.

Please advice, evert thing else works fine except creating Categories.

[solari...@gmail.com]

Unfortunately Oscar doesn't currently officially support for MySQL - and this is one of the places where MySQL fails. See https://github.com/django-oscar/django-oscar/issues/3335 . Patches to improve compatibility with MySQL are welcome.

[rohit kumar sinha]

Is this issue only with category ? What is your suggestion which database should I preffer instead ?

Do you suggest using sqlite for few years or using Postgress Sql ? If issue is only with category we can have a work around.

Thanks.

On Tue, 27 Oct 2020, 08:07 solari...@gmail.com, <solari...@gmail.com> wrote:

Unfortunately Oscar doesn't currently officially support for MySQL - and this is one of the places where MySQL fails. See https://github.com/django-oscar/django-oscar/issues/3335 . Patches to improve compatibility with MySQL are welcome.

--
https://github.com/django-oscar/django-oscar
http://django-oscar.readthedocs.org/en/latest/
---
You received this message because you are subscribed to the Google Groups "django-oscar" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-oscar...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/django-oscar/4cc02345-b943-4f8b-b6f7-520de16b7cdbn%40googlegroups.com.

[solari...@gmail.com]

I'd recommend using PotsgreSQL. You definitely should not use SQlite in production.

I'm not sure whether you will run into issues elsewhere - the code base is not tested on MySQL it is possible that other queries may also be problematic.

[rohit kumar sinha]

Thanks for the help :)

On Tue, Oct 27, 2020 at 11:32 AM solari...@gmail.com <solari...@gmail.com> wrote:

I'd recommend using PotsgreSQL. You definitely should not use SQlite in production.

I'm not sure whether you will run into issues elsewhere - the code base is not tested on MySQL it is possible that other queries may also be problematic.

--

https://github.com/django-oscar/django-oscar
http://django-oscar.readthedocs.org/en/latest/
---
You received this message because you are subscribed to the Google Groups "django-oscar" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-oscar...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/django-oscar/58af2257-4b3d-4bb4-8b21-8a7db0a1e251n%40googlegroups.com.

--

Thanks and Regards,

Rohit Kumar Sinha

Mob: 9990075303