Table 'ofbiz.uom' doesn't exist

[Emad Radwan]

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

[Emad Radwan]

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 <[hidden email]> 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
>

[Deepak Dixit-4]

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: [phone]
email: [hidden email]
*www.hotwax.co <http://www.hotwax.co/>*


On Mon, Jan 18, 2021 at 2:51 AM Emad Radwan <[hidden email]> 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 <[hidden email]> 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
> >
>