Job

Difficulty

Spec (updated on Thu Dec 4 15:47:53 2025)

describe("admin/globalprefs/OPACMySummaryHTML", function () {
    const languages = ['en', 'es-ES', 'fr-FR', 'de-DE', 'el-GR', 'hi', 'zh-Hant-TW'];
    languages.forEach((lang) => {
        describe(`in ${lang}`, () => {
            beforeEach(function(){
                // Skip if 'en' test failed
                if (Cypress.env("EN_TEST_FAILED")) {
                    this.skip();
                }
                cy.query("INSERT INTO issues (borrowernumber, itemnumber, date_due, branchcode, issuedate) VALUES (51, 578, ADDDATE(NOW(), INTERVAL 3 DAY), \"CPL\", ADDDATE(NOW(), INTERVAL -7 day))")
                cy.query("INSERT INTO issues (borrowernumber, itemnumber, date_due, branchcode, issuedate) VALUES (51, 54, ADDDATE(NOW(), INTERVAL 3 DAY), \"CPL\", ADDDATE(NOW(), INTERVAL -7 day))")
                /* No specific padding defined */
                cy.set_cookie_lang(lang);
            });

            it("OPACMySummaryHTML", function () {
                cy.visitOpac("/cgi-bin/koha/opac-user.pl");
                cy.waitForPageLoad();
                cy.get("input#userid").type("koha");
                cy.get("input#password").type("koha");
                cy.get("#opac-user-views").should('be.visible').screenshot("OPACMySummaryHTML");
            });
        });
    });
    afterEach(function () {
        cy.query("DELETE FROM issues WHERE borrowernumber=51 AND itemnumber=578")
        cy.query("DELETE FROM issues WHERE borrowernumber=51 AND itemnumber=54")
        Cypress.env('PADDING_BEFORE_SCREENSHOT', undefined);
        // Set EN_TEST_FAILED if the 'en' test failed
        if (this.currentTest.parent.title.includes('in en') && this.currentTest.state === 'failed') {
            Cypress.env("EN_TEST_FAILED", true);
        }
    });
});

Spec data

sql INSERT INTO issues (borrowernumber, itemnumber, date_due, branchcode, issuedate) VALUES (51, 578, ADDDATE(NOW(), INTERVAL 3 DAY), "CPL", ADDDATE(NOW(), INTERVAL -7 day))
sql INSERT INTO issues (borrowernumber, itemnumber, date_due, branchcode, issuedate) VALUES (51, 54, ADDDATE(NOW(), INTERVAL 3 DAY), "CPL", ADDDATE(NOW(), INTERVAL -7 day))

type input#userid=koha
type input#password=koha

sql DELETE FROM issues WHERE borrowernumber=51 AND itemnumber=578
sql DELETE FROM issues WHERE borrowernumber=51 AND itemnumber=54

Notes

requires you to be logged in to the opac first.

Additional KTD data

Test failure

CypressError: `cy.task('query')` failed with the following error:

> Duplicate entry '578' for key 'itemnumber'

https://on.cypress.io/api/task

Because this error occurred during a `before each` hook we are skipping the remaining tests in the current suite: `in en`
    at <unknown> (http://kohadev.mydnsname.org:8080/__cypress/runner/cypress_runner.js:135374:70)
    at tryCatcher (http://kohadev.mydnsname.org:8080/__cypress/runner/cypress_runner.js:1807:23)
    at Promise._settlePromiseFromHandler (http://kohadev.mydnsname.org:8080/__cypress/runner/cypress_runner.js:1519:31)
    at Promise._settlePromise (http://kohadev.mydnsname.org:8080/__cypress/runner/cypress_runner.js:1576:18)
    at Promise._settlePromise0 (http://kohadev.mydnsname.org:8080/__cypress/runner/cypress_runner.js:1621:10)
    at Promise._settlePromises (http://kohadev.mydnsname.org:8080/__cypress/runner/cypress_runner.js:1697:18)
    at _drainQueueStep (http://kohadev.mydnsname.org:8080/__cypress/runner/cypress_runner.js:2407:12)
    at _drainQueue (http://kohadev.mydnsname.org:8080/__cypress/runner/cypress_runner.js:2400:9)
    at Async._drainQueues (http://kohadev.mydnsname.org:8080/__cypress/runner/cypress_runner.js:2416:5)
    at Async.drainQueues (http://kohadev.mydnsname.org:8080/__cypress/runner/cypress_runner.js:2286:14)
From Your Spec Code:
    at Context.query (webpack://koha/./node_modules/cypress-mysql/dist/index.js:69:0)

From Node.js Internals:
  Error: Duplicate entry '578' for key 'itemnumber'
      at PromiseConnection.query (/e2e/node_modules/mysql2/promise.js:94:22)
      at <unknown> (/e2e/node_modules/cypress-mysql/dist/index.js:75:33)
      at processTicksAndRejections (node:internal/process/task_queues:95:5)

Thumbnails

Current

Current