Skip to content
This repository has been archived by the owner on Jun 10, 2018. It is now read-only.

doc/db.sql uses lowercase names while lggr_class doesn't #3

Open
mserve opened this issue Jan 19, 2018 · 1 comment
Open

doc/db.sql uses lowercase names while lggr_class doesn't #3

mserve opened this issue Jan 19, 2018 · 1 comment

Comments

@mserve
Copy link

mserve commented Jan 19, 2018

I am using 10.1.26-MariaDB as database, running Debian Stretch. I used the db.sql stuff to setup the database but run into a case sensitivity issue.

MariaDB is case sensitive running on linux, so lggr doesn't find its tables and views, e.g. lggrdev.Today if there are lower case in the database.

Workarround: rename the views to lowercase in lggr_class.php, or strtolower() them

@kkretsch
Copy link
Owner

Well spotted. I'm still missing a good setup or upgrade method. So I didn't see that problem coming for a long running system where the sql was hand created.
Will have a look at it in the next days.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants