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

miloud it design miloud.it.design at gmail.com
Wed May 19 05:17:52 PDT 2021


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*
*-------------------------------------------------------------------------------------------------*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-users/attachments/20210519/da002b06/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: geonode message error.pdf
Type: application/pdf
Size: 6348080 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/geonode-users/attachments/20210519/da002b06/attachment-0001.pdf>


More information about the geonode-users mailing list