_time_tracker’ doesn’t exist for query

  • Resolved soudshoja

    (@soudshoja)


    5 years, 7 months ago

    when i activate the time tracker it gives me error that it dose not exiist. and i cant see the task unless i disable that moudle.

    if i want to reset the plugin whats the best way? removeing database and setting back to the original factory. i delete the plugin but when i install a new one all my data was there

Viewing 1 replies (of 1 total)
  • Thread Starter soudshoja

    (@soudshoja)

    5 years, 7 months ago

    problem solved, it was not on data base so i had to create a new database as per error log in my file manager:

    WordPress database error Cannot add foreign key constraint for query CREATE TABLE IF NOT EXISTS wp5i_pm_time_tracker (
    id int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    user_id int(11) UNSIGNED NOT NULL,
    project_id int(11) UNSIGNED NOT NULL,
    list_id int(11) UNSIGNED NOT NULL,
    task_id int(11) UNSIGNED NOT NULL,
    start int(11) UNSIGNED NOT NULL,
    stop int(11) UNSIGNED NOT NULL,
    total int(11) UNSIGNED NOT NULL,
    run_status tinyint(4) NOT NULL,
    created_by int(11) UNSIGNED DEFAULT NULL,
    updated_by int(11) UNSIGNED DEFAULT NULL,
    created_at timestamp NULL DEFAULT NULL,
    updated_at timestamp NULL DEFAULT NULL,
    PRIMARY KEY (id),
    KEY task_id (task_id),
    KEY project_id (project_id),
    FOREIGN KEY (task_id) REFERENCES wp5i_pm_tasks (id) ON DELETE CASCADE

Viewing 1 replies (of 1 total)

The topic ‘_time_tracker’ doesn’t exist for query’ is closed to new replies.