rif / web2admin

web2py administration plugin
26 stars 10 forks source link

fails to work with MSSQL #7

Closed sp1d3rx closed 11 years ago

sp1d3rx commented 11 years ago

<class 'pyodbc.ProgrammingError'> ('42000', "[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Introducing FOREIGN KEY constraint 'plugin_web2admin_history_modified_by__constraint' on table 'plugin_web2admin_history' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. (1785) (SQLExecDirectW); [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Could not create constraint. See previous errors. (1750)")

rif commented 11 years ago

Should be fixed by web2py commit https://github.com/web2py/web2py/commit/ae803727e9d2e706868dcab655189c9e78a59740