Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sync_transmeta_db fails with SQL Server native client driver #19

Open
marsanyi opened this issue Feb 15, 2016 · 1 comment
Open

sync_transmeta_db fails with SQL Server native client driver #19

marsanyi opened this issue Feb 15, 2016 · 1 comment

Comments

@marsanyi
Copy link

(venv) PS C:\inetpub\wwwroot\admin\iO_web> python manage.py sync_transmeta_db --settings=iO_web.settings.staging
C:\inetpub\wwwroot\admin\iO_web\questionnaire\generate.py:6: DeprecationWarning: the md5 module is deprecated; use hashl
ib instead
import md5, random

This languages can change in "text" field from "questionnaire.questionset" model: en-us, fr, de, en, it

SQL to synchronize "questionnaire.questionset" schema:
ALTER TABLE [questionnaire_questionset] ADD COLUMN [text_en-us] nvarchar(max)
ALTER TABLE [questionnaire_questionset] ADD COLUMN [text_fr] nvarchar(max)
ALTER TABLE [questionnaire_questionset] ADD COLUMN [text_de] nvarchar(max)
ALTER TABLE [questionnaire_questionset] ADD COLUMN [text_it] nvarchar(max)

Are you sure that you want to execute the previous SQL: (y/n) [n]: y
Executing SQL...
DatabaseError: ('42000', "[42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near the keywor
d 'COLUMN'. (156) (SQLExecDirectW)")

@erny
Copy link
Member

erny commented Nov 7, 2018

I have the same issue with Oracle. Both seem not to support the optional "COLUMN" keyword Postgresql uses. See #20.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants