# No modules found on Sao web interface

**URL:** https://discuss.tryton.org/t/no-modules-found-on-sao-web-interface/416
**Category:** User
**Created:** [September 23, 2017, 8:25am UTC](https://discuss.tryton.org/t/no-modules-found-on-sao-web-interface/416 "2017-09-23T08:25:55Z")
**Posts on this page:** 8
**Page:** 2

<div class="post-metadata">

### Author: ![Aaron](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/a/e19adc/32.png) [@Aaron](https://discuss.tryton.org/u/Aaron)
#### Post date: [October 18, 2017, 6:06pm UTC](https://discuss.tryton.org/t/no-modules-found-on-sao-web-interface/416/21 "2017-10-18T18:06:12Z")

</div>

I was trying to run the update on SAO interface( because I can’t see any modules on there), which didn’t work. Could this error cause that the modules are not shown on the Sao interface? And how can I get report the issue to them? Do you know any website? Thanks a lot!

---

<div class="post-metadata">

### Author: ![ced](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/ced/32/1237_2.png) [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [October 18, 2017, 6:40pm UTC](https://discuss.tryton.org/t/no-modules-found-on-sao-web-interface/416/22 "2017-10-18T18:40:19Z")

</div>

> [@Aaron](#):
>
> Could this error cause that the modules are not shown on the Sao interface?

Maybe, you should check with the desktop client. But also check the browser javascript console. And finally the table `ir_module` if it is really empty.

> [@Aaron](#):
>
> And how can I get report the issue to them?

On their website: [GNU Health - Summary [Savannah]](https://savannah.gnu.org/projects/health)

---

<div class="post-metadata">

### Author: ![Aaron](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/a/e19adc/32.png) [@Aaron](https://discuss.tryton.org/u/Aaron)
#### Post date: [November 8, 2017, 7:22pm UTC](https://discuss.tryton.org/t/no-modules-found-on-sao-web-interface/416/23 "2017-11-08T19:22:21Z")

</div>

1.There are python problems on desktop client, which even fails on running. I still wanna make the Sao interface work, because it got me the furthest so far. The ir\_module is not empty, but only two of them are activated. Any ideas how I can activate others?  
 ![Untitled](https://discuss-cdn.tryton.org/uploads/default/original/1X/772d291db828d8f0b7b2d8c798781da2dfa0daa9.jpg)

1. Another thing I noticed is that in the log file there are a lot of sql statements ending up with “limit 0”, which makes it return 0 result. Is this designed to implement in this way? if not, where can I fix the sql script?

```auto
gnuhealth@tryton:[29899]:LOG: statement: SELECT "a"."id" AS "id", "a"."create_date" AS "create_date", "a"."write_date" AS "write_date", "a"."name" AS "name", "a"."write_uid" AS "write_uid", "a"."create_uid" AS "create_uid", "a"."state" AS "state", CAST(EXTRACT('EPOCH' FROM COALESCE("a"."write_date", "a"."create_date")) AS VARCHAR) AS "_timestamp" FROM "ir_module" AS "a" WHERE (("a"."name" != 'tests')) ORDER BY "a"."name" ASC, "a"."id" ASC LIMIT 0

```

1. Is it possible that the Jquery or java script causing the problem?

---

<div class="post-metadata">

### Author: ![ced](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/ced/32/1237_2.png) [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [November 8, 2017, 7:57pm UTC](https://discuss.tryton.org/t/no-modules-found-on-sao-web-interface/416/24 "2017-11-08T19:57:31Z")

</div>

> [@Aaron](#):
>
> Any ideas how I can activate others?

In the admin menu under modules.

> [@Aaron](#):
>
> Another thing I noticed is that in the log file there are a lot of sql statements ending up with “limit 0”, which makes it return 0 result. Is this designed to implement in this way? if not, where can I fix the sql script?

This is very weird. Did you change anything in the source code? There is `Sao.config.limit` but it is set to 1000 by default.

---

<div class="post-metadata">

### Author: ![Aaron](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/a/e19adc/32.png) [@Aaron](https://discuss.tryton.org/u/Aaron)
#### Post date: [November 8, 2017, 8:24pm UTC](https://discuss.tryton.org/t/no-modules-found-on-sao-web-interface/416/25 "2017-11-08T20:24:00Z")

</div>

I couldn’t update them on the Sao interface, because none of the module are shown there.  
No I didn’t. Where is the Sao.config.limit file located? I couldn’t find it.

---

<div class="post-metadata">

### Author: ![Aaron](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/a/e19adc/32.png) [@Aaron](https://discuss.tryton.org/u/Aaron)
#### Post date: [November 10, 2017, 9:01pm UTC](https://discuss.tryton.org/t/no-modules-found-on-sao-web-interface/416/26 "2017-11-10T21:01:21Z")

</div>

Hi. Could you tell me where the file is ?

---

<div class="post-metadata">

### Author: ![semarie](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/semarie/32/112_2.png) [@semarie](https://discuss.tryton.org/u/semarie)
#### Post date: [November 11, 2017, 5:55am UTC](https://discuss.tryton.org/t/no-modules-found-on-sao-web-interface/416/27 "2017-11-11T05:55:32Z")

</div>

> [@Aaron](#):
>
> Could you tell me where the file is ?

@ced speak about `src/sao.js` file that contains a line defining `Sao.config.limit = 1000;`.

---

<div class="post-metadata">

### Author: ![Aaron](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/a/e19adc/32.png) [@Aaron](https://discuss.tryton.org/u/Aaron)
#### Post date: [November 14, 2017, 9:35pm UTC](https://discuss.tryton.org/t/no-modules-found-on-sao-web-interface/416/28 "2017-11-14T21:35:58Z")

</div>

Thanks. Just checked the Sao.js file and it’s set to 1000, so that’s correct.  
At the same time I checked the python file  
/home/gnuhealth/gnuhealth/tryton/server/trytond-4.2.6/trytond/model/modelsql.py  
There is a read function at line 620 that creates the SELECT statement to read data from the database. Line 662 has a variable called history\_limit, which is set to None. The value is not reset. So when you get to line 702 where the SELECT statement is being created dynamically, you will see it sets limit=history\_limit.

[Previous page](https://discuss.tryton.org/t/no-modules-found-on-sao-web-interface/416.md?page=1)
