Skip to content

MSSQL unit test failures #203

@matthewhilton

Description

@matthewhilton

On Moodle 4.5 branch https://github.com/catalyst/moodle-tool_crawler/tree/MOODLE_310_STABLE

273) tool_crawler_robot_crawler_test::test_reset_queries
dml_write_exception: Error writing to database (SQLState: 42000<br>
Error Code: 102<br>
Message: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Incorrect syntax near 'u'.<br>

UPDATE phpu_tool_crawler_url u
                                 SET needscrawl = '0',
                                     lastcrawled = null,
                                     priority = '100'
                                FROM phpu_tool_crawler_edge e
                               WHERE e.a = u.id
                                 AND e.b = '1'
[array (
  0 => 0,
  1 => 100,
  2 => 1,
)])

/var/www/site/lib/dml/moodle_database.php:500
/var/www/site/lib/dml/sqlsrv_native_moodle_database.php:331
/var/www/site/lib/dml/sqlsrv_native_moodle_database.php:438
/var/www/site/lib/dml/sqlsrv_native_moodle_database.php:829
/var/www/site/admin/tool/crawler/classes/local/url.php:185
/var/www/site/admin/tool/crawler/tests/phpunit/robot_crawler_test.php:208
/var/www/site/lib/phpunit/classes/advanced_testcase.php:76

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions