failing to create tables

Post your support requests/solutions for phpJobScheduler [website]
davidgwalker
MODS thats what I do that is! But definately NO mod music! It has to be ROCK!
Posts: 1807
Joined: Mon Oct 25, 2004 8:20 pm
Location: Huddersfield, UK
Contact:

failing to create tables

Postby davidgwalker » Mon Mar 09, 2015 7:56 pm

If your install is not creating the tables for you, try running this SQL to create the tables for you:

Code: Select all

CREATE TABLE IF NOT EXISTS `phpjobscheduler_logs` (
  id int(11) NOT NULL auto_increment,
    date_added int(11),
    script varchar(128) default NULL,
    output text default NULL,
    execution_time varchar(60) default NULL,
    PRIMARY KEY (id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE IF NOT EXISTS `phpjobscheduler` (
  id int(11) NOT NULL auto_increment,
  scriptpath varchar(255) default NULL,
  name varchar(128) default NULL,
  time_interval int(11) default NULL,
  fire_time int(11) NOT NULL default '0',
  time_last_fired int(11) default NULL,
  run_only_once tinyint(1) NOT NULL DEFAULT '0',
  currently_running BOOLEAN NOT NULL DEFAULT '0',
  paused BOOLEAN NOT NULL DEFAULT '0',
  PRIMARY KEY (id),
  KEY fire_time (fire_time)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


Thanks for this suggestion go to: Gerbrand van der Haak

We hope it helps you!

All the best

Dave

Return to “phpJobScheduler [forum]”

Who is online

Users browsing this forum: No registered users and 2 guests