Open eClass

Database Upgrade eclass
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP INDEX document' at line 4

ALTER TABLE `document`
CHANGE `visibility` `visible` TINYINT NOT NULL DEFAULT 1,
ADD `public` TINYINT NOT NULL DEFAULT 1
DROP INDEX document

1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP INDEX annonces' at line 6

ALTER TABLE announcement CHANGE `contenu` `content` TEXT,
CHANGE `temps` `date` DATETIME,
CHANGE `cours_id` `course_id` INT,
CHANGE `ordre` `order` MEDIUMINT,
CHANGE `visibility` `visible` TINYINT DEFAULT 0
DROP INDEX annonces

1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP INDEX cours' at line 18

ALTER TABLE course CHANGE `cours_id` `id` INT,
CHANGE `languageCourse` `lang` VARCHAR DEFAULT 'el',
CHANGE `intitule` `title` VARCHAR NOT NULL DEFAULT '',
CHANGE `description` `description` MEDIUMTEXT NOT NULL,
CHANGE `course_keywords` `keywords` TEXT NOT NULL,
DROP COLUMN `course_addon`,
CHANGE `titulaires` `prof_names` varchar(200) NOT NULL DEFAULT '',
CHANGE `fake_code` `public_code` varchar(20) NOT NULL DEFAULT '',
DROP COLUMN `departmentUrlName`,
DROP COLUMN `departmentUrl`,
DROP COLUMN `lastVisit`,
DROP COLUMN `lastEdit`,
DROP COLUMN `expirationDate`,
DROP COLUMN `type`,
DROP COLUMN `faculteid`,
CHANGE `first_create` `created` datetime NOT NULL default '0000-00-00 00:00:00',
CHANGE `expand_glossary` `glossary_expand` BOOL NOT NULL DEFAULT 0
DROP INDEX cours

1054: Unknown column 'lang' in 'field list'

SELECT DISTINCT lang from course

Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /Users/teras/Works/Development/WebApps/OpeneClass/eclass/upgrade/upgrade.php on line 1352
1054: Unknown column 'id' in 'field list'

SELECT id, code, lang FROM course ORDER BY code

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /Users/teras/Works/Development/WebApps/OpeneClass/eclass/upgrade/upgrade.php on line 1404

Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /Users/teras/Works/Development/WebApps/OpeneClass/eclass/upgrade/upgrade.php on line 1406
1214: The used table type doesn't support FULLTEXT indexes

ALTER TABLE `announcement` ENGINE = InnoDB

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

ALTER TABLE `course` ENGINE = InnoDB

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

ALTER TABLE `document` ENGINE = InnoDB