Project

General

Profile

Σφάλματα #99

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

Added by Panayotis Katsaloulis about 11 years ago. Updated almost 11 years ago.

Status:
In Progress
Priority:
Υψηλή
Target version:
Start date:
21/03/2013
Due date:
% Done:

0%

Estimated time:
Spent time:

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

#1

Updated by Thanos Kyritsis about 11 years ago

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

#2

Updated by Thanos Kyritsis about 11 years ago

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

Updated by Yannis Exidaridis about 11 years ago

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

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

#4

Updated by Panayotis Katsaloulis about 11 years ago

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

#5

Updated by Panayotis Katsaloulis almost 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

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 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 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 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 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

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

#6

Updated by Panayotis Katsaloulis almost 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