Closed (duplicate)
Project:
Workbench Moderation
Version:
7.x-1.3
Component:
Code
Priority:
Normal
Category:
Support request
Assigned:
Unassigned
Reporter:
Created:
15 Feb 2013 at 15:42 UTC
Updated:
18 Mar 2013 at 06:20 UTC
Setup: Drupal 7.19 / IIS 7.5 / SQL Server 2008
I tried installing this module twice and when I tried to enable the module, it unfortunately crashed my site with the following error both times:
PDOException: SQLSTATE[42S02]: [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'workbench_moderation_transitions'.: SELECT t.[from_name] AS [from_name], t.[to_name] AS [to_name] FROM {workbench_moderation_transitions} t INNER JOIN {workbench_moderation_states} workbench_moderation_states ON t.from_name = workbench_moderation_states.name INNER JOIN {workbench_moderation_states} workbench_moderation_states_2 ON t.to_name = workbench_moderation_states_2.name ORDER BY workbench_moderation_states.weight ASC, workbench_moderation_states_2.weight ASC; Array ( ) in workbench_moderation_transitions() (line 1341 of E:\drupal\sites\all\modules\workbench_moderation\workbench_moderation.module).
The website encountered an unexpected error. Please try again later.I then had to revert to my backups to get this site back online.
I received this error after having an issue with another error from this issue report. Any help on how to get this working for me would be greatly appreciated, as I'd really love to use this module.
Comments
Comment #1
katannshaw commentedI was advised in another issue report by to update my drivers, which I did. But I'm still getting this error, and no new tables get created. If anyone has any ideas on why this is happening, please advise. Thanks.
Updated Setup: Drupal 7.20 / IIS 7.5 / SQL Server 2008
Comment #2
hass commented#1260112: SQL reserved word 'current' used as column name