Re: Table 'ofbiz.uom' doesn't exist

Posted by Deepak Dixit-4 on
URL: http://ofbiz.116.s1.nabble.com/Table-ofbiz-uom-doesn-t-exist-tp4763891p4763903.html

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
> >
>