modmore / VersionX

Resource & Element Versioning Extra for MODX Revolution (supports 2.2 and up). Extends the core in a future-proof manner to keep copies of every change to resources, templates, template variables, chunks, snippets and plugins.
https://modmore.com/extras/versionx/
40 stars 20 forks source link

Install on MSSQL failed - Broke installation and no way to reverse? #57

Closed robcarey1971 closed 11 years ago

robcarey1971 commented 11 years ago

Howdy :)

Doing an install on a Apache/MSSQL setup, and the install failed (see dump below)

Since then, the extra shows as not installed in package manager, but the interface is present in the manager. Nothing will save anymore and I can't see how to go back.

ERROR DUMP BELOW:

Error 42000 executing statement: INSERT INTO [modx_actions]([namespace], [controller], [haslayout], [lang_topics], [assets], [help_url]) VALUES ('versionx', 'controllers/index', 1, 'versionx:default', '', '') Array ( [0] => 42000 [1] => 545 [2] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Explicit value must be specified for identity column in table 'modx_actions' either when IDENTITY_INSERT is set to ON or when a replication user is inserting into a NOT FOR REPLICATION identity column. ) Error saving vehicle object of class modAction; criteria: Array ( [namespace] => versionx [controller] => controllers/index ) Could not install related objects with foreign owned keys for vehicle object of class modMenu; criteria: Array ( [text] => versionx ) Attempting to preserve files at C:/wamp/xxxx/www/core/components/versionx into archive C:/wamp/Sandvine2013/www/core/packages/versionx-2.1.0-pl/modCategory/552331055ceb4df9b2c2c4ae997faf2b.0.preserved.zip Attempting to preserve files at C:/wamp/xxxx/www/assets/components/versionx into archive C:/wamp/xxxx/www/core/packages/versionx-2.1.0-pl/modCategory/552331055ceb4df9b2c2c4ae997faf2b.1.preserved.zip Could not load package metadata for package versionx. Could not load class: vxResource from sqlsrv.vxresource. Could not load class: vxTemplate from sqlsrv.vxtemplate. Could not load class: vxSnippet from sqlsrv.vxsnippet. Could not load class: vxChunk from sqlsrv.vxchunk. Could not load class: vxPlugin from sqlsrv.vxplugin. Could not load class: vxTemplateVar from sqlsrv.vxtemplatevar. Starting snapshot process for selected objects... Iterating over Resources and storing snapshots.. Could not load class: vxResource from sqlsrv.vxresource.

Mark-H commented 11 years ago

It doesn't show as installed? I'm afraid you'll have to fix it manually then (otherwise you could've just uninstalled). You'll need to:

As you figured out, VersionX does not support MSSQL and as I do not have (or want) a MSSQL server/localhost I can't promise MSSQL support either in any future release. If someone (maybe you?) feels like making VersionX work with MSSQL I'll gladly accept a pull request for it. I just don't have the infrastructure or MSSQL experience to do it myself.

robcarey1971 commented 11 years ago

Thanks - those steps worked to resolve the issue. Frankly, I don't want an MSSQL version either - I was more or less going through the motions to appease the IT department here that is somewhat MS-centric :)

I can honestly say now that it's best to stick to LAMP :) Thanks for your help!