search

django-cms / django-cms

The easy-to-use and developer-friendly enterprise CMS powered by Django
http://www.django-cms.org
BSD 3-Clause "New" or "Revised" License
10.16k stars 3.1k forks source link

@zacqed can you provide additional information as requested in the issues template? #7180

Closed JosephBeekmans closed 2 years ago

JosephBeekmans commented 2 years ago

@zacqed can you provide additional information as requested in the issues template?

Originally posted by @FinalAngel in https://github.com/django-cms/django-cms/issues/6902#issuecomment-692495610

JosephBeekmans commented 2 years ago

Got the same issue. See

ProgrammingError at /nl/cms_wizard/create/

('42000', "[42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]'substr' is not a recognized built-in function name. (195) (SQLExecDirectW); [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'AND'. (156); [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared. (8180)")
Request Method: | POST -- | -- http://localhost:8000/nl/cms_wizard/create/ 3.0.14 ProgrammingError ('42000', "[42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]'substr' is not a recognized built-in function name. (195) (SQLExecDirectW); [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'AND'. (156); [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared. (8180)") D:\Oogheelkunde\ohkcms\venv\lib\site-packages\mssql\base.py in execute, line 576 D:\Oogheelkunde\ohkcms\venv\Scripts\python.exe 3.9.6 ['D:\\Oogheelkunde\\ohkcms\\ohkcms', 'C:\\Users\\z042149\\AppData\\Local\\Programs\\Python\\Python39\\python39.zip', 'C:\\Users\\z042149\\AppData\\Local\\Programs\\Python\\Python39\\DLLs', 'C:\\Users\\z042149\\AppData\\Local\\Programs\\Python\\Python39\\lib', 'C:\\Users\\z042149\\AppData\\Local\\Programs\\Python\\Python39', 'D:\\Oogheelkunde\\ohkcms\\venv', 'D:\\Oogheelkunde\\ohkcms\\venv\\lib\\site-packages'] vr, 7 Jan 2022 17:28:28 +0100

Local vars

Variable | Value -- | -- chunk_size | 100 chunked_fetch | False cursor | params | (10, False, 9, 'nl', 'homepage%') result_type | 'cursor' self | sql | ('SET NOCOUNT OFF; UPDATE [cms_title] SET [path] = substr([cms_title].[path], ' '%s) WHERE ([cms_title].[has_url_overwrite] = %s AND [cms_title].[page_id] IN ' '(SELECT V0.[id] FROM [cms_page] V0 WHERE V0.[node_id] IN (SELECT U0.[id] ' 'FROM [cms_treenode] U0 WHERE U0.[id] = %s)) AND [cms_title].[language] = %s ' "AND [cms_title].[path] LIKE %s ESCAPE '\\')")
JosephBeekmans commented 2 years ago

Version list (venv) λ pip list
Package Version

asgiref 3.4.1
cssselect2 0.4.1
dj-database-url 0.5.0
Django 3.0.14
django-classy-tags 2.0.0
django-cms 3.8.0
django-debug-toolbar 3.2.4
django-filer 2.1.2
django-formtools 2.3
django-js-asset 1.2.2
django-mptt 0.13.4
django-mssql-backend 2.8.1
django-polymorphic 3.0.0
django-sekizai 2.0.0
django-treebeard 4.5.1
djangocms-admin-style 2.0.2
djangocms-attributes-field 2.0.0
djangocms-bootstrap4 2.0.0
djangocms-file 3.0.0
djangocms-googlemap 2.0.0
djangocms-icon 2.0.0
djangocms-installer 2.0.0
djangocms-link 3.0.0
djangocms-picture 3.0.0
djangocms-style 3.0.0
djangocms-text-ckeditor 4.0.0
djangocms-video 3.0.0
easy-thumbnails 2.8
html5lib 1.1
lxml 4.7.1
mssql-django 1.1.1
Pillow 8.4.0
pip 21.3.1
pyodbc 4.0.32
pytz 2021.3
pytz-deprecation-shim 0.1.0.post0 reportlab 3.6.3
setuptools 56.0.0
six 1.16.0
sqlparse 0.4.2
svglib 1.1.0
tinycss2 1.1.1
tzdata 2021.5
tzlocal 4.1
Unidecode 1.1.2
webencodings 0.5.1