Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
Upon installing og and attempting to create a subgroup, I receive the following error:
PDOException: SQLSTATE[25000]: [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot roll back savepoint_1. No transaction or savepoint of that name was found.: ROLLBACK TO SAVEPOINT savepoint_1; Array ( ) in user_save() (line 591 of D:\vhosts\autodesk\modules\user\user.module).
I believe this is similar to the following post here for MySQL: https://drupal.org/node/1007830
Comment | File | Size | Author |
---|---|---|---|
#1 | sqlsrv-error.png | 11.64 KB | kpastore |
Comments
Comment #1
kpastore CreditAttribution: kpastore commentedSet up a completely fresh D7 install to test. The same error occurs when attempting to create a subgroup (a group that is set as both 'Group Type' and 'Group Content Type' in Structure>Content types). Marking issue critical as it effectively stalls any use of OG that requires more than one level of structure.
Comment #2
jaypark CreditAttribution: jaypark commentedreproduced this error on new d7 7.9 install with latest sqlsrv dev module - is anyone working on a patch? anyone like to be working on this patch, don't have enough time, but have an idea where to start? i could give it a go with some direction...
Comment #3
ArtusamakThis issue has normaly been fixed in the last release of the driver, please retest with the last version available.
Comment #4
jaypark CreditAttribution: jaypark commentedArt, you mean the latest dev release? Issue is with the last stable version, 1.1
Comment #5
ArtusamakYes the dev version rigt now, a 1.2 release will soon be tagged including this fix.
Comment #6
Anonymous (not verified) CreditAttribution: Anonymous commentedreproduced this error on new IIS 7.5, d7 7.10, sqlsrv 1.2, attempting to create an OG subgroup.
Error messagePDOException: SQLSTATE[25000]: [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot roll back savepoint_1. No transaction or savepoint of that name was found.: ROLLBACK TO SAVEPOINT savepoint_1; Array ( ) in user_save() (line 607 of C:\inetpub\wwwroot\drupal\modules\user\user.module).
Comment #7
katannshaw CreditAttribution: katannshaw commentedDrupal 7.12 / IIS 7.5 / SQL Server 2008 Express Edition
I received this exact same error when attempting to create my first organic group with this tutorial: http://modulesunraveled.com/organic-groups.
Is there any progress on a fix at this point?
Comment #8
katannshaw CreditAttribution: katannshaw commentedDrupal 7.17 / IIS 7.5 / SQL Server 2008
I'm surprised that there hasn't been any action on this issue report since my April post. I had postponed setting OG up to give the maintainers time to work on it, but I'm still receiving this exact error with the latest version of Drupal (7.17 at this point). Is anyone working on this?
I did find this related issue.
Comment #9
Damien Tournoud CreditAttribution: Damien Tournoud commentedComment #10
omegamonk CreditAttribution: omegamonk commentedI ran through the tutorial posted in #7 (http://modulesunraveled.com/organic-groups) and was not able to reproduce the issue. I also added some subgroups and still couldn't replicate the error. I used the following setup:
Drupal 7.22 with both 7.x-1.2 and 7.x-1.x-dev versions of sqlsrv
IIS 7.5
SQL Server 2012
Windows 2008R2
Can someone verify this is still an issue and steps to reproduce? Thanks...
Comment #11
katannshaw CreditAttribution: katannshaw commented@omegamonk: I haven't looked at this issue in quite awhile since it caused such a headache for my install.
I know that I use SQL Server 2008 with Windows 2008R2, so I'm not sure if that makes a difference. I currently don't have the option to use SQL Server 2012.
I'll test it out again using the tutorial referenced on #7 to see if I can reproduce the issue, and I'll let you know of the outcome. Thanks.
Comment #12
omegamonk CreditAttribution: omegamonk commented@jayhawkfan75:
Much appreciated. If you are able to replicate the issue, let me know the drupal version, sqlsrv version and Microsoft Drivers for PHP version and anything else that you think might be helpful.
Thanks
Comment #13
katannshaw CreditAttribution: katannshaw commentedAbsolutely...will do. I have it marked on my calendar for tomorrow morning.
Comment #14
katannshaw CreditAttribution: katannshaw commentedSorry that I didn't get to you yesterday; I ended up being out sick. Good news; I was able to install and use OG on the Article content type without a problem this morning!
Here are the properties of my install:
Drupal 7.22
PHP 5.3
PHP Drivers: php_sqlsrv_53_nts.dll and php_pdo_sqlsrv_53_nts.dll
SQL Driver 7.x-1.2
SQL Server 2008
IIS 7.5
Windows 2008R2
I did notice a lot of changes in OG between the referenced tutorial and the current version, but I was able to get through it successfully. Hopefully others can test the latest version as well to see if the issue is resolved for them as well. Thanks for looking into this omegamonk.
Comment #15
omegamonk CreditAttribution: omegamonk commented@jayhawkfan75, Thanks. I am going to mark this issue as closed (cannot reproduce). If someone can reproduce the issue, please either re-open this or reference this in the new issue....and please note the steps to reproduce the error.