[GeoNode-users] Geonode 3.2.0/Python 3.8.9(32bit)/Windows 10 : Developpment mode : DatabaseError

[G. Allegri]

Hi Miloud,

I see that you're using spatialite. I warmly invite you to switch to
PostGIS, since the sqlite3 / spatialite is not well supported.

Giovanni

Il mer 19 mag 2021, 14:18 miloud it design <miloud.it.design at gmail.com> ha
scritto:

> Hi,
> I have successfully installed geonode 3.2.0 on Windows 10 but when I try
> to test the application locally on Chrome navigator at
> http://localhost:8000; I get some error messages after adding a layer in
> arcgis format (alger_regions.shp).
>
> To start geonode, I executed the command ( command prompt windows 10):
> *paver start_django | paver start_geoserver*
>
> Thanks.
> Miloud.
>
> The error message on chrome navigator
> See the attached file (pdf) for more details.
>
> *--------------------------------------------------------------------------*
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> *DatabaseError at /layers/:geonode:alger_regionsORDER BY not allowed in
> subqueries of compound statements.Request Method: GETRequest URL:
> http://localhost:8000/layers/:geonode:alger_regions
> <http://localhost:8000/layers/:geonode:alger_regions>Django Version:
> 2.2.20Exception Type: DatabaseErrorException Value: ORDER BY not allowed in
> subqueries of compound statements.Exception Location:
> C:\cygwin\home\pc\geonode_env\lib\site-packages\django\db\models\sql\compiler.py
> in get_combinator_sql, line 421Python Executable:
> C:\cygwin\home\pc\geonode_env\Scripts\python.exePython Version: 3.8.9Python
> Path:
> ['C:\\Users\\pc\\Desktop\\geonode', 'C:\\Users\\pc\\Desktop\\geonode', 'c:\\users\\pc\\appdata\\local\\programs\\python\\python38-32\\python38.zip', 'c:\\users\\pc\\appdata\\local\\programs\\python\\python38-32\\DLLs', 'c:\\users\\pc\\appdata\\local\\programs\\python\\python38-32\\lib', 'c:\\users\\pc\\appdata\\local\\programs\\python\\python38-32', 'C:\\cygwin\\home\\pc\\geonode_env', 'C:\\cygwin\\home\\pc\\geonode_env\\lib\\site-packages', 'c:\\users\\pc\\desktop\\geonode', 'C:\\cygwin\\home\\pc\\geonode_env\\lib\\site-packages\\win32', 'C:\\cygwin\\home\\pc\\geonode_env\\lib\\site-packages\\win32\\lib', 'C:\\cygwin\\home\\pc\\geonode_env\\lib\\site-packages\\Pythonwin']Server
> time: mer, 19 Mai 2021 11:59:38 +0000*
>
> *-------------------------------------------------------------------------------------------------*
> _______________________________________________
> geonode-users mailing list
> geonode-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/geonode-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-users/attachments/20210519/c061ca7c/attachment.html>