Σφάλματα #99: Εμφάνιση λαθών και warnings κατά τη διαδικασία του upgrade - Open eClass - Open eClass Dev

Σφάλματα #99

Εμφάνιση λαθών και warnings κατά τη διαδικασία του upgrade

Added by Panayotis Katsaloulis over 11 years ago. Updated over 11 years ago.

Status:

In Progress

Priority:

Υψηλή

Assignee:

Yannis Exidaridis

Target version:

3.0

Start date:

21/03/2013

Due date:

% Done:

Estimated time:

Spent time:

1.00 h

Description

Στη σελίδα του Upgrade εμφανίζονται τα εξής προβλήματα:


1214: The used table type doesn't support FULLTEXT indexes

CREATE TABLE IF NOT EXISTS `forum` (
                        `id` INT(10) NOT NULL AUTO_INCREMENT,
                        `name` VARCHAR(150) DEFAULT '' NOT NULL,
                        `desc` MEDIUMTEXT NOT NULL,
                        `num_topics` INT(10) DEFAULT 0 NOT NULL,
                        `num_posts` INT(10) DEFAULT 0 NOT NULL,
                        `last_post_id` INT(10) DEFAULT 0 NOT NULL,
                        `cat_id` INT(10) DEFAULT 0 NOT NULL,
                        `course_id` INT(11) NOT NULL,
                        PRIMARY KEY (`id`),
                        FULLTEXT KEY `forum` (`name`,`desc`)) DEFAULT CHARACTER SET=utf8

1214: The used table type doesn't support FULLTEXT indexes

CREATE TABLE IF NOT EXISTS video (
                            `id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                            `course_id` INT(11) NOT NULL,
                            `path` VARCHAR(255),
                            `url` VARCHAR(200),
                            `title` VARCHAR(200),
                            `description` TEXT,
                            `creator` VARCHAR(200),
                            `publisher` VARCHAR(200),
                            `date` DATETIME,
                            FULLTEXT KEY `video`
                               (`url`, `title`, `description`))

1214: The used table type doesn't support FULLTEXT indexes

CREATE TABLE IF NOT EXISTS videolinks (
                            `id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                            `course_id` INT(11) NOT NULL,
                            `url` VARCHAR(200),
                            `title` VARCHAR(200),
                            `description` TEXT,
                            `creator` VARCHAR(200),
                            `publisher` VARCHAR(200),
                            `date` DATETIME,
                            FULLTEXT KEY `video`
                               (`url`, `title`, `description`))

1214: The used table type doesn't support FULLTEXT indexes

CREATE TABLE IF NOT EXISTS `agenda` (
                            `id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                            `course_id` INT(11) NOT NULL,
                            `title` VARCHAR(200) NOT NULL,
                            `content` TEXT,
                            `day` DATE NOT NULL DEFAULT '0000-00-00',
                            `hour` TIME NOT NULL DEFAULT '00:00:00',
                            `lasting` VARCHAR(20),
                            `visible` TINYINT(4),
                            FULLTEXT KEY `agenda` (`title` ,`content`))

1214: The used table type doesn't support FULLTEXT indexes

CREATE TABLE IF NOT EXISTS `exercise` (
                            `id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                            `course_id` INT(11) NOT NULL,
                            `title` VARCHAR(250) DEFAULT NULL,
                            `description` TEXT,
                            `type` TINYINT(4) UNSIGNED NOT NULL DEFAULT '1',
                            `start_date` DATETIME DEFAULT NULL,
                            `end_date` DATETIME DEFAULT NULL,
                            `time_constraint` INT(11) DEFAULT 0,
                            `attempts_allowed` INT(11) DEFAULT 0,
                            `random` SMALLINT(6) NOT NULL DEFAULT 0,
                            `active` TINYINT(4) NOT NULL DEFAULT 1,
                            `results` TINYINT(1) NOT NULL DEFAULT 1,
                            `score` TINYINT(1) NOT NULL DEFAULT 1,
                            FULLTEXT KEY `exercise` (`title`, `description`))

Upgrade of Course TMA100 (3.0) (1 / 2)
1146: Table 'eclass.forum' doesn't exist

SELECT MAX(id) FROM `eclass`.forum

Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /home/teras/Works/Development/WebApps/eclass/upgrade/upgrade_functions.php on line 349
1146: Table 'eclass.forum' doesn't exist

INSERT INTO `eclass`.`forum`
                        (`id`, `name`, `desc`, `num_topics`, `num_posts`, `last_post_id`, `cat_id`, `course_id`)
                        SELECT forum_id + 0, forum_name, forum_desc, forum_topics,
                               forum_posts, forum_last_post_id, cat_id + 0, 1
                        FROM forums ORDER by forum_id

1146: Table 'eclass.forum' doesn't exist

UPDATE `eclass`.`forum_topic` ft, `eclass`.`forum` f
                                       SET f.last_post_id = f.last_post_id + 0,
                                           ft.last_post_id = ft.last_post_id + 0
                                       WHERE ft.forum_id = f.id AND
                                             course_id = 1

1146: Table 'eclass.video' doesn't exist

SELECT MAX(id) FROM `eclass`.video

Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /home/teras/Works/Development/WebApps/eclass/upgrade/upgrade_functions.php on line 394
1146: Table 'eclass.video' doesn't exist

INSERT INTO `eclass`.video
                        (`id`, `course_id`, `path`, `url`, `title`, `description`, `creator`, `publisher`, `date`)
                        SELECT `id` + 0, 1, `path`, `url`, `titre`, `description`,
                               `creator`, `publisher`, `date` FROM video ORDER by id

1146: Table 'eclass.videolinks' doesn't exist

SELECT MAX(id) FROM `eclass`.videolinks

Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /home/teras/Works/Development/WebApps/eclass/upgrade/upgrade_functions.php on line 423
1146: Table 'eclass.videolinks' doesn't exist

INSERT INTO `eclass`.videolinks
                        (`id`, `course_id`, `url`, `title`, `description`, `creator`, `publisher`, `date`)
                        SELECT `id` + 0, 1, `url`, `titre`, `description`, `creator`,
                               `publisher`, `date` FROM videolinks ORDER by id

1146: Table 'eclass.agenda' doesn't exist

SELECT max(id) FROM `eclass`.agenda

Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /home/teras/Works/Development/WebApps/eclass/upgrade/upgrade_functions.php on line 903
1146: Table 'eclass.agenda' doesn't exist

INSERT INTO `eclass`.agenda
                         (`id`, `course_id`, `title`, `content`, `day`, `hour`, `lasting`, `visible`)
                         SELECT `id` + 0, 1, `titre`, `contenu`, `day`, `hour`, `lasting`,
                                `visibility` FROM agenda ORDER BY id

1146: Table 'eclass.exercise' doesn't exist

SELECT max(id) FROM `eclass`.exercise

Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /home/teras/Works/Development/WebApps/eclass/upgrade/upgrade_functions.php on line 926
1146: Table 'eclass.exercise' doesn't exist

INSERT INTO `eclass`.exercise
                         (`id`, `course_id`, `title`, `description`, `type`, `start_date`, `end_date`,
                          `time_constraint`, `attempts_allowed`, `random`, `active`, `results`, `score`)
                         SELECT `id` + 0, 1, `titre`, `description`, `type`,
                                `StartDate`, `EndDate`, `TimeConstrain`, `AttemptsAllowed`, `random`,
                                `active`, `results`, `score`
                           FROM exercices ORDER BY id

Upgrade of Course TMA101 (3.0) (2 / 2)
1146: Table 'eclass.forum' doesn't exist

SELECT MAX(id) FROM `eclass`.forum

Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /home/teras/Works/Development/WebApps/eclass/upgrade/upgrade_functions.php on line 349
1146: Table 'eclass.forum' doesn't exist

INSERT INTO `eclass`.`forum`
                        (`id`, `name`, `desc`, `num_topics`, `num_posts`, `last_post_id`, `cat_id`, `course_id`)
                        SELECT forum_id + 0, forum_name, forum_desc, forum_topics,
                               forum_posts, forum_last_post_id, cat_id + 0, 2
                        FROM forums ORDER by forum_id

1146: Table 'eclass.forum' doesn't exist

UPDATE `eclass`.`forum_topic` ft, `eclass`.`forum` f
                                       SET f.last_post_id = f.last_post_id + 0,
                                           ft.last_post_id = ft.last_post_id + 0
                                       WHERE ft.forum_id = f.id AND
                                             course_id = 2

1146: Table 'eclass.video' doesn't exist

SELECT MAX(id) FROM `eclass`.video

Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /home/teras/Works/Development/WebApps/eclass/upgrade/upgrade_functions.php on line 394
1146: Table 'eclass.video' doesn't exist

INSERT INTO `eclass`.video
                        (`id`, `course_id`, `path`, `url`, `title`, `description`, `creator`, `publisher`, `date`)
                        SELECT `id` + 0, 2, `path`, `url`, `titre`, `description`,
                               `creator`, `publisher`, `date` FROM video ORDER by id

1146: Table 'eclass.videolinks' doesn't exist

SELECT MAX(id) FROM `eclass`.videolinks

Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /home/teras/Works/Development/WebApps/eclass/upgrade/upgrade_functions.php on line 423
1146: Table 'eclass.videolinks' doesn't exist

INSERT INTO `eclass`.videolinks
                        (`id`, `course_id`, `url`, `title`, `description`, `creator`, `publisher`, `date`)
                        SELECT `id` + 0, 2, `url`, `titre`, `description`, `creator`,
                               `publisher`, `date` FROM videolinks ORDER by id

1146: Table 'eclass.agenda' doesn't exist

SELECT max(id) FROM `eclass`.agenda

Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /home/teras/Works/Development/WebApps/eclass/upgrade/upgrade_functions.php on line 903
1146: Table 'eclass.agenda' doesn't exist

INSERT INTO `eclass`.agenda
                         (`id`, `course_id`, `title`, `content`, `day`, `hour`, `lasting`, `visible`)
                         SELECT `id` + 0, 2, `titre`, `contenu`, `day`, `hour`, `lasting`,
                                `visibility` FROM agenda ORDER BY id

1146: Table 'eclass.exercise' doesn't exist

SELECT max(id) FROM `eclass`.exercise

Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /home/teras/Works/Development/WebApps/eclass/upgrade/upgrade_functions.php on line 926
1146: Table 'eclass.exercise' doesn't exist

INSERT INTO `eclass`.exercise
                         (`id`, `course_id`, `title`, `description`, `type`, `start_date`, `end_date`,
                          `time_constraint`, `attempts_allowed`, `random`, `active`, `results`, `score`)
                         SELECT `id` + 0, 2, `titre`, `description`, `type`,
                                `StartDate`, `EndDate`, `TimeConstrain`, `AttemptsAllowed`, `random`,
                                `active`, `results`, `score`
                           FROM exercices ORDER BY id

History

Updated by Thanos Kyritsis over 11 years ago

Αυτά τα FULLTEXT indexes πρέπει να διαγραφούν, σχετίζεται με issues #97 και #98

Updated by Thanos Kyritsis over 11 years ago

Priority changed from Κανονική to Υψηλή
Target version set to 3.0

Updated by Yannis Exidaridis over 11 years ago

Status changed from Νέα to Επιλυμένο
Assignee set to Yannis Exidaridis

Οκ τα "ξήλωσα".

Updated by Panayotis Katsaloulis over 11 years ago

Πέρα από τα FULLTEXT, έχει και κάτι missing tables κλπ...

Updated by Panayotis Katsaloulis over 11 years ago

Status changed from Επιλυμένο to In Progress

Επίσης, κάποιες εικόνες κατά το upgrade έλλειπαν...

Starting Open eClass upgrade

Upgrading configuration file (config.php)

Database Upgrade eclass
1214: The used table type doesn't support FULLTEXT indexes

CREATE TABLE IF NOT EXISTS `forum` (
`id` INT NOT NULL AUTO_INCREMENT,
`name` VARCHAR DEFAULT '' NOT NULL,
`desc` MEDIUMTEXT NOT NULL,
`num_topics` INT DEFAULT 0 NOT NULL,
`num_posts` INT DEFAULT 0 NOT NULL,
`last_post_id` INT DEFAULT 0 NOT NULL,
`cat_id` INT DEFAULT 0 NOT NULL,
`course_id` INT NOT NULL,
PRIMARY KEY (`id`),
FULLTEXT KEY `forum` (`name`,`desc`)) DEFAULT CHARACTER SET=utf8

1214: The used table type doesn't support FULLTEXT indexes

CREATE TABLE IF NOT EXISTS video (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`course_id` INT NOT NULL,
`path` VARCHAR,
`url` VARCHAR,
`title` VARCHAR,
`description` TEXT,
`creator` VARCHAR,
`publisher` VARCHAR,
`date` DATETIME,
FULLTEXT KEY `video`
(`url`, `title`, `description`))

1214: The used table type doesn't support FULLTEXT indexes

CREATE TABLE IF NOT EXISTS videolinks (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`course_id` INT NOT NULL,
`url` VARCHAR,
`title` VARCHAR,
`description` TEXT,
`creator` VARCHAR,
`publisher` VARCHAR,
`date` DATETIME,
FULLTEXT KEY `video`
(`url`, `title`, `description`))

1214: The used table type doesn't support FULLTEXT indexes

CREATE TABLE IF NOT EXISTS `agenda` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`course_id` INT NOT NULL,
`title` VARCHAR NOT NULL,
`content` TEXT,
`day` DATE NOT NULL DEFAULT '0000-00-00',
`hour` TIME NOT NULL DEFAULT '00:00:00',
`lasting` VARCHAR,
`visible` TINYINT,
FULLTEXT KEY `agenda` (`title` ,`content`))

1214: The used table type doesn't support FULLTEXT indexes

CREATE TABLE IF NOT EXISTS `exercise` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`course_id` INT NOT NULL,
`title` VARCHAR DEFAULT NULL,
`description` TEXT,
`type` TINYINT UNSIGNED NOT NULL DEFAULT '1',
`start_date` DATETIME DEFAULT NULL,
`end_date` DATETIME DEFAULT NULL,
`time_constraint` INT DEFAULT 0,
`attempts_allowed` INT DEFAULT 0,
`random` SMALLINT NOT NULL DEFAULT 0,
`active` TINYINT NOT NULL DEFAULT 1,
`results` TINYINT NOT NULL DEFAULT 1,
`score` TINYINT NOT NULL DEFAULT 1,
FULLTEXT KEY `exercise` (`title`, `description`))

Upgrade of Course TMA100 (3.0) (1 / 2)
1146: Table 'eclass.forum' doesn't exist

SELECT MAX FROM `eclass`.forum

Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /home/teras/Works/Development/WebApps/eclass/upgrade/upgrade_functions.php on line 349
1146: Table 'eclass.forum' doesn't exist

INSERT INTO `eclass`.`forum`
(`id`, `name`, `desc`, `num_topics`, `num_posts`, `last_post_id`, `cat_id`, `course_id`)
SELECT forum_id + 0, forum_name, forum_desc, forum_topics,
forum_posts, forum_last_post_id, cat_id + 0, 1
FROM forums ORDER by forum_id

1146: Table 'eclass.forum' doesn't exist

UPDATE `eclass`.`forum_topic` ft, `eclass`.`forum` f
SET f.last_post_id = f.last_post_id + 0,
ft.last_post_id = ft.last_post_id + 0
WHERE ft.forum_id = f.id AND
course_id = 1

1146: Table 'eclass.video' doesn't exist

SELECT MAX FROM `eclass`.video

INSERT INTO `eclass`.video
(`id`, `course_id`, `path`, `url`, `title`, `description`, `creator`, `publisher`, `date`)
SELECT `id` + 0, 1, `path`, `url`, `titre`, `description`,
`creator`, `publisher`, `date` FROM video ORDER by id

1146: Table 'eclass.videolinks' doesn't exist

SELECT MAX FROM `eclass`.videolinks

Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /home/teras/Works/Development/WebApps/eclass/upgrade/upgrade_functions.php on line 423
1146: Table 'eclass.videolinks' doesn't exist

INSERT INTO `eclass`.videolinks
(`id`, `course_id`, `url`, `title`, `description`, `creator`, `publisher`, `date`)
SELECT `id` + 0, 1, `url`, `titre`, `description`, `creator`,
`publisher`, `date` FROM videolinks ORDER by id

1146: Table 'eclass.agenda' doesn't exist

SELECT max(id) FROM `eclass`.agenda

Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /home/teras/Works/Development/WebApps/eclass/upgrade/upgrade_functions.php on line 903
1146: Table 'eclass.agenda' doesn't exist

INSERT INTO `eclass`.agenda
(`id`, `course_id`, `title`, `content`, `day`, `hour`, `lasting`, `visible`)
SELECT `id` + 0, 1, `titre`, `contenu`, `day`, `hour`, `lasting`,
`visibility` FROM agenda ORDER BY id

1146: Table 'eclass.exercise' doesn't exist

SELECT max(id) FROM `eclass`.exercise

INSERT INTO `eclass`.exercise
(`id`, `course_id`, `title`, `description`, `type`, `start_date`, `end_date`,
`time_constraint`, `attempts_allowed`, `random`, `active`, `results`, `score`)
SELECT `id` + 0, 1, `titre`, `description`, `type`,
`StartDate`, `EndDate`, `TimeConstrain`, `AttemptsAllowed`, `random`,
`active`, `results`, `score`
FROM exercices ORDER BY id

Upgrade of Course TMA101 (3.0) (2 / 2)
1146: Table 'eclass.forum' doesn't exist

SELECT MAX FROM `eclass`.forum

1146: Table 'eclass.forum' doesn't exist

UPDATE `eclass`.`forum_topic` ft, `eclass`.`forum` f
SET f.last_post_id = f.last_post_id + 0,
ft.last_post_id = ft.last_post_id + 0
WHERE ft.forum_id = f.id AND
course_id = 2

1146: Table 'eclass.video' doesn't exist

SELECT MAX FROM `eclass`.video

INSERT INTO `eclass`.video
(`id`, `course_id`, `path`, `url`, `title`, `description`, `creator`, `publisher`, `date`)
SELECT `id` + 0, 2, `path`, `url`, `titre`, `description`,
`creator`, `publisher`, `date` FROM video ORDER by id

1146: Table 'eclass.videolinks' doesn't exist

SELECT MAX FROM `eclass`.videolinks

INSERT INTO `eclass`.videolinks
(`id`, `course_id`, `url`, `title`, `description`, `creator`, `publisher`, `date`)
SELECT `id` + 0, 2, `url`, `titre`, `description`, `creator`,
`publisher`, `date` FROM videolinks ORDER by id

1146: Table 'eclass.agenda' doesn't exist

SELECT max(id) FROM `eclass`.agenda

INSERT INTO `eclass`.agenda
(`id`, `course_id`, `title`, `content`, `day`, `hour`, `lasting`, `visible`)
SELECT `id` + 0, 2, `titre`, `contenu`, `day`, `hour`, `lasting`,
`visibility` FROM agenda ORDER BY id

1146: Table 'eclass.exercise' doesn't exist

SELECT max(id) FROM `eclass`.exercise

INSERT INTO `eclass`.exercise
(`id`, `course_id`, `title`, `description`, `type`, `start_date`, `end_date`,
`time_constraint`, `attempts_allowed`, `random`, `active`, `results`, `score`)
SELECT `id` + 0, 2, `titre`, `description`, `type`,
`StartDate`, `EndDate`, `TimeConstrain`, `AttemptsAllowed`, `random`,
`active`, `results`, `score`
FROM exercices ORDER BY id

Upgrade Database of Open eClass finished successfully!
You are ready to use the new version of Open eClass!

Updated by Panayotis Katsaloulis over 11 years ago

Αγνοήστε το προηγούμενο email :)

Το σωστό μήνυμα λάθους είναι το
1060: Duplicate column name 'extra_path'

ALTER TABLE `document`
CHANGE `visibility` `visible` TINYINT NOT NULL DEFAULT 1,
ADD `public` TINYINT NOT NULL DEFAULT 1,
ADD `extra_path` VARCHAR NOT NULL DEFAULT '' AFTER `path`

Also available in: Atom PDF

Project

General

Profile

Open eClass

Issues