Syntax error or access violation: 1305 SAVEPOINT LEVEL1 does not exist

[githubjeka]

What are you trying to achieve?

Install advanced Yii2

run tests

Time: 7.66 seconds, Memory: 28.00MB

OK (24 tests, 67 assertions)

Add to site/index code:

    public function actionIndex()
    {
        $tr = \Yii::$app->db->beginTransaction();
        $tr->commit();
        return $this->render('index');
    }

run tests

>  [yii\db\Exception] SQLSTATE[42000]: Syntax error or access violation: 1305 SAVEPOINT LEVEL1 does not exist
The SQL being executed was: RELEASE SAVEPOINT LEVEL1

ERRORS!
Tests: 24, Assertions: 66, Errors: 1.

Details

• Codeception version: 2.2.6
• PHP Version: 7.0.5
• Operating System: Windows 10
• Mysql 5.7.10

[githubjeka]

I tried:

class_name: FunctionalTester
modules:
    enabled:
        - Yii2:
          cleanup: false

try to set in http://www.yamllint.com/ is Valid :(

To fix my problem need to use

class_name: FunctionalTester
modules:
    enabled:
        - Yii2:
                                                                            cleanup: false

F%^%k

[githubjeka]

@DavertMik
Is it correct ?

class_name: FunctionalTester
modules:
    enabled:
        - Yii2: {cleanup: false}

Why that?

 [Symfony\Component\Yaml\Exception\ParseException]  Malformed inline YAML string { at line 6 (near "Yii2: {")

P.S. Nice http://yaml-online-parser.appspot.com/ parser

Upd: Ok. ref symfony/symfony#19874

[DavertMik]

Is it correct ?

No, there is no {} in YAML format. YAML is set with spaces. In your 1st config you didn't specify space for cleanup: false as it was required.

In your working example you had more than enough spaces. Just remember, 4 spaces is usually OK for yaml. THis conifg should work as well

class_name: FunctionalTester
modules:
    enabled:
        - Yii2:
            cleanup: false

[Naktibalda]

No, there is no {} in YAML format

There is, it is called flow style.

[githubjeka]

Just remember, 4 spaces is usually OK for yaml.

Now I know about it from you, but debug of this is a pain.

If you think that it not should be described in documentation, you can close this issue. Thanks.

[DavertMik]

There is, it is called flow style.

Ups, I'm so old-fashioned

If you think that it not should be described in documentation, you can close this issue. Thanks.

We have lots pages of documentation and I have no idea where better to place this notice. But thanks for the suggestion. I think we can make some validator to debug such issues

[DavertMik]

@githubjeka yep, I think I have an idea how to improve things. Please check my proposal at #3766

[Subb98]

Hello, @DavertMik! I encountered the same error. https://imgur.com/a/Uitxz0K

yiisofy/yii2: 2.0.39.3
codeception/codeception: 4.1.12

I checked the config with the command php vendor/bin/codecept config:validate, everything is fine.
What could be the problem?

[Naktibalda]

@Subb98 have you set cleanup: false in api.suite.yaml ? (I have no idea how it is relevant, but it was mentioned in comments above).

Also you said that you are using codeception/codeception: 4.1.12 but your screeshot shows that you used 3.1.2

[Subb98]

@Naktibalda thank you for your prompt response. The problem was the missing table. Sorry for the necroposting )