[Plugin: Weekly Class Schedule] Failed to add item to the database when I try to add any item

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter Click7

    (@click7)

    11 years, 10 months ago

    Looks like only one wcs database was created – wp_wcs2_schedule during install.

    Thread Starter Click7

    (@click7)

    11 years, 10 months ago

    When I ran:
    CREATE TABLE wp_wcs2_classroom (
    id INT(11) NOT NULL AUTO_INCREMENT,
    classroom_name VARCHAR(256) NOT NULL DEFAULT ”,
    classroom_description TEXT,
    time_created VARCHAR(50) NOT NULL DEFAULT ”,
    user_created BIGINT(20) NOT NULL,
    time_modified VARCHAR(50) NOT NULL DEFAULT ”,
    user_modified BIGINT(20) NOT NULL,
    PRIMARY KEY (id),
    UNIQUE KEY classroom_name (classroom_name)
    );

    Got: “Error Code : 1071
    Specified key was too long; max key length is 767 bytes”

    microspective

    (@microspective)

    11 years, 8 months ago

    In ../weekly-class-schedule/includes/WcsDb.php

    in the CREATE table queries, change any instance of
    VARCHAR(256) to
    VARCHAR(255).

    Good to go.

    knauso

    (@knauso)

    11 years, 6 months ago

    It doesn’t seem to fix the problem 🙁

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘[Plugin: Weekly Class Schedule] Failed to add item to the database when I try to add any item’ is closed to new replies.