You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Emad Radwan <er...@gmail.com> on 2021/01/16 19:59:57 UTC
Table 'ofbiz.uom' doesn't exist
Hi Community,
I think I have the strangest error ever!
I had a working Ofbiz setup, however, while trying to delete demo data that I fount not easy, I decided to drop the DB - mySQL btw - and recreate again. Whatever steps I try I end up with the server not accepting './gradlew loadDefault' giving error 'Task 'loadDefault' not found in root project 'ofbiz', and while trying 'loadAll' it runs creating a lot of tables but missing a lot of them giving the subject message many times and end up with failing setup that is not working. Please help.
Regards,
Emad
Re: Table 'ofbiz.uom' doesn't exist
Posted by Deepak Dixit <de...@hotwax.co>.
Hi Emad,
It might be related to mysql lower case table setting[1],
You can set it to 1, restart mysql, create a database and load the data.
[1]
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_lower_case_table_names
https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html
Kind Regards,
Deepak Dixit
DIRECTOR OF PRODUCT ENGINEERING
mobile: +91 9826754548
email: deepak.dixit@hotwax.co
*www.hotwax.co <http://www.hotwax.co/>*
On Mon, Jan 18, 2021 at 2:51 AM Emad Radwan <er...@gmail.com> wrote:
> Hello Gents,
>
> I believe this issue is somehow related to MYSQL as when I re-installed
> Ofbiz with Derby things went fine. Any Idea what can cause a table like UOM
> not to be created?
>
> Also if you want to help, I use MySql while learning Ofbiz as via its
> tools - Workbench - I can search the whole DB for certain strings which
> will help me relate what tables is used in a specific transaction, and I'm
> not sure if Derby has tools that can help in such thing. Please advice.
>
> Regards,
>
> Emad
>
> On 2021/01/16 19:59:57, Emad Radwan <er...@gmail.com> wrote:
> > Hi Community,
> >
> > I think I have the strangest error ever!
> >
> > I had a working Ofbiz setup, however, while trying to delete demo data
> that I fount not easy, I decided to drop the DB - mySQL btw - and recreate
> again. Whatever steps I try I end up with the server not accepting
> './gradlew loadDefault' giving error 'Task 'loadDefault' not found in root
> project 'ofbiz', and while trying 'loadAll' it runs creating a lot of
> tables but missing a lot of them giving the subject message many times and
> end up with failing setup that is not working. Please help.
> >
> > Regards,
> >
> > Emad
> >
>
Re: Table 'ofbiz.uom' doesn't exist
Posted by Emad Radwan <er...@gmail.com>.
Hello Gents,
I believe this issue is somehow related to MYSQL as when I re-installed Ofbiz with Derby things went fine. Any Idea what can cause a table like UOM not to be created?
Also if you want to help, I use MySql while learning Ofbiz as via its tools - Workbench - I can search the whole DB for certain strings which will help me relate what tables is used in a specific transaction, and I'm not sure if Derby has tools that can help in such thing. Please advice.
Regards,
Emad
On 2021/01/16 19:59:57, Emad Radwan <er...@gmail.com> wrote:
> Hi Community,
>
> I think I have the strangest error ever!
>
> I had a working Ofbiz setup, however, while trying to delete demo data that I fount not easy, I decided to drop the DB - mySQL btw - and recreate again. Whatever steps I try I end up with the server not accepting './gradlew loadDefault' giving error 'Task 'loadDefault' not found in root project 'ofbiz', and while trying 'loadAll' it runs creating a lot of tables but missing a lot of them giving the subject message many times and end up with failing setup that is not working. Please help.
>
> Regards,
>
> Emad
>