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

CommentFileSizeAuthor
#1 sqlsrv-error.png11.64 KBkpastore

Comments

kpastore’s picture

kpastore commented
Priority: Major » Critical
StatusFileSize
new sqlsrv-error.png11.64 KB

Set 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.

jaypark’s picture

jaypark commented

reproduced 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...

artusamak’s picture

artusamak
he/him
Primary language French
Location Bzh
commented
Status: Active » Postponed (maintainer needs more info)

This issue has normaly been fixed in the last release of the driver, please retest with the last version available.

jaypark’s picture

jaypark commented

Art, you mean the latest dev release? Issue is with the last stable version, 1.1

artusamak’s picture

artusamak
he/him
Primary language French
Location Bzh
commented
Version: 7.x-1.1 » 7.x-1.x-dev

Yes the dev version rigt now, a 1.2 release will soon be tagged including this fix.

Anonymous’s picture

Anonymous (not verified) commented
Version: 7.x-1.x-dev » 7.x-1.2
Status: Postponed (maintainer needs more info) » Needs review

reproduced 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).

katannshaw’s picture

katannshaw commented

Drupal 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?

katannshaw’s picture

katannshaw commented

Drupal 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.

damien tournoud’s picture

damien tournoud commented
Status: Needs review » Active
omegamonk’s picture

omegamonk commented
Status: Active » Postponed (maintainer needs more info)

I 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...

katannshaw’s picture

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.

omegamonk’s picture

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

katannshaw’s picture

katannshaw commented

Absolutely...will do. I have it marked on my calendar for tomorrow morning.

katannshaw’s picture

katannshaw commented

Sorry 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.

omegamonk’s picture

omegamonk commented
Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)

@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.