Erreur [La table ‘_lpc_outward_label’ n’existe pas

  • Resolved subb

    (@subb)


    4 years, 8 months ago

    Erreur [La table ‘_lpc_outward_label’n’existe pas la page “colissimo” dans Woocomerce > colissimo

    Pour info:
    je suis sur la dernière version de WordPress en date 5.4.2
    Php version 7.4.8 (testé avec php vesrion 7.1* et 7.2*)
    J’ai déjà essayer de réinstaller le plugin.

    D’avance merci

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Colissimo

    (@iscpcolissimo)

    Bonjour,

    vous pouvez la creer directement en base de données:

    voici les requettes pour les deux tables (outward et inward)

    CREATE TABLE BDD_lpc_outward_label (
    id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    order_id BIGINT(20) UNSIGNED NOT NULL,
    label MEDIUMBLOB NULL,
    label_format VARCHAR(255) NULL,
    label_created_at DATETIME NULL,
    cn23 MEDIUMBLOB NULL,
    tracking_number VARCHAR(255) NULL,
    PRIMARY KEY (id),
    INDEX order_id (order_id),
    INDEX tracking_number (tracking_number)
    ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
    ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

    CREATE TABLE BDD_lpc_inward_label (
    id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    order_id BIGINT(20) UNSIGNED NOT NULL,
    label MEDIUMBLOB NULL,
    label_format VARCHAR(255) NULL,
    label_created_at DATETIME NULL,
    cn23 MEDIUMBLOB NULL,
    tracking_number VARCHAR(255) NULL,
    outward_tracking_number VARCHAR(255) NULL,
    PRIMARY KEY (id),
    INDEX order_id (order_id),
    INDEX tracking_number (tracking_number),
    INDEX outward_tracking_number (outward_tracking_number)
    ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

    BDD etant le schemat sur lequel vous créez la table (normalement le meme que celui de la table options)

    Cordialement.

    Plugin Author Colissimo

    (@iscpcolissimo)

    pour la premiere table le premier default est a supprimer.

    Cordialement

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Erreur [La table ‘_lpc_outward_label’ n’existe pas’ is closed to new replies.