climsoft / Climsoft

Climsoft Desktop for Windows - http://www.climsoft.org
GNU General Public License v3.0
14 stars 28 forks source link

Error when I try to produce "Details of Data Record" inventory product #680

Open Patowhiz opened 2 years ago

Patowhiz commented 2 years ago

@smachua @mhabimana I'm getting an error when @dannyparsons and I try to produce the "Details of Data Records" inventory product. See screenshot below.

A quick search on this bug in stack overflow entails that I need to run sql code to get security rights on mysql server. I found myself doing this every time I restarted my computer. I wonder if users need to do the same too? Looking at the code, would it be useful to have this functionality done at the application level rather than at the database level?

Thanks.

climsoft_error

smachua commented 2 years ago

@Patowhiz the message indicates that your database is disabled for external data import(upload). The disabling must have been done through other methods outside Climsoft. Check if some settings have been done using some other database management tools. I have encountered such in a database at Madagascar where they were purposely disabling data uploads as a protective measure and enabling it when using Climsoft. They were doing this thro Mysql Workbench.