Project

General

Profile

Σφάλματα #290

MySQL 5.7.10 issues

Added by Panayotis Katsaloulis about 8 years ago. Updated almost 4 years ago.

Status:
Κλειστό
Priority:
Κανονική
Assignee:
-
Target version:
-
Start date:
02/02/2016
Due date:
% Done:

50%

Estimated time:

Description

Με τη MySQL υπάρχουν ακόμα θέματα, τα αναφέρω εδώ για να τα έχουμε ως αναφορά για να τα επιλύσουμε.

In file /Users/teras/Works/Development/WebApps/eClass/server/install/install_db.php on line 36 : Unable to execute statement:"Unknown system variable 'storage_engine'", sqlstate:"1193", errornum:"HY000", statement:"SET storage_engine = InnoDB", elapsed:0.001235

In file /Users/teras/Works/Development/WebApps/eClass/server/install/install_db.php on line 731 : Unable to execute statement:"Invalid default value for 'ltime_alive'", sqlstate:"1067", errornum:"42000", statement:"CREATE TABLE IF NOT EXISTS `wiki_locks` ( `ptitle` VARCHAR(255) NOT NULL DEFAULT '', `wiki_id` INT(11) UNSIGNED NOT NULL, `uid` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0, `ltime_created` TIMESTAMP NOT NULL, `ltime_alive` TIMESTAMP NOT NULL, PRIMARY KEY (ptitle, wiki_id) ) DEFAULT CHARACTER SET=utf8", elapsed:0.00055000000000005

In file /Users/teras/Works/Development/WebApps/eClass/server/install/install_db.php on line 1065 : Unable to execute statement:"Cannot load from mysql.proc. The table is probably corrupted", sqlstate:"1728", errornum:"HY000", statement:"DROP PROCEDURE IF EXISTS `add_node`", elapsed:0.001768

In file /Users/teras/Works/Development/WebApps/eClass/server/install/install_db.php on line 1079 : Unable to execute statement:"Cannot load from mysql.proc. The table is probably corrupted", sqlstate:"1728", errornum:"HY000", statement:"CREATE PROCEDURE `add_node` (IN name TEXT CHARSET utf8, IN parentlft INT(11), IN p_code VARCHAR(20) CHARSET utf8, IN p_allow_course BOOLEAN, IN p_allow_user BOOLEAN, IN p_order_priority INT(11)) LANGUAGE SQL BEGIN DECLARE lft, rgt INT(11); SET lft = parentlft + 1; SET rgt = parentlft + 2; CALL shift_right(parentlft, 2, 0); INSERT INTO `hierarchy` (name, lft, rgt, code, allow_course, allow_user, order_priority) VALUES (name, lft, rgt, p_code, p_allow_course, p_allow_user, p_order_priority); END", elapsed:0.001726

In file /Users/teras/Works/Development/WebApps/eClass/server/install/install_db.php on line 1081 : Unable to execute statement:"Cannot load from mysql.proc. The table is probably corrupted", sqlstate:"1728", errornum:"HY000", statement:"DROP PROCEDURE IF EXISTS `add_node_ext`", elapsed:0.00056499999999998

In file /Users/teras/Works/Development/WebApps/eClass/server/install/install_db.php on line 1095 : Unable to execute statement:"Cannot load from mysql.proc. The table is probably corrupted", sqlstate:"1728", errornum:"HY000", statement:"CREATE PROCEDURE `add_node_ext` (IN name TEXT CHARSET utf8, IN parentlft INT(11), IN p_code VARCHAR(20) CHARSET utf8, IN p_number INT(11), IN p_generator INT(11), IN p_allow_course BOOLEAN, IN p_allow_user BOOLEAN, IN p_order_priority INT(11)) LANGUAGE SQL BEGIN DECLARE lft, rgt INT(11); SET lft = parentlft + 1; SET rgt = parentlft + 2; CALL shift_right(parentlft, 2, 0); INSERT INTO `hierarchy` (name, lft, rgt, code, number, generator, allow_course, allow_user, order_priority) VALUES (name, lft, rgt, p_code, p_number, p_generator, p_allow_course, p_allow_user, p_order_priority); END", elapsed:0.00060000000000002

In file /Users/teras/Works/Development/WebApps/eClass/server/install/install_db.php on line 1097 : Unable to execute statement:"Cannot load from mysql.proc. The table is probably corrupted", sqlstate:"1728", errornum:"HY000", statement:"DROP PROCEDURE IF EXISTS `update_node`", elapsed:0.000474

In file /Users/teras/Works/Development/WebApps/eClass/server/install/install_db.php on line 1110 : Unable to execute statement:"Cannot load from mysql.proc. The table is probably corrupted", sqlstate:"1728", errornum:"HY000", statement:"CREATE PROCEDURE `update_node` (IN p_id INT(11), IN p_name TEXT CHARSET utf8, IN nodelft INT(11), IN p_lft INT(11), IN p_rgt INT(11), IN parentlft INT(11), IN p_code VARCHAR(20) CHARSET utf8, IN p_allow_course BOOLEAN, IN p_allow_user BOOLEAN, IN p_order_priority INT(11)) LANGUAGE SQL BEGIN UPDATE `hierarchy` SET name = p_name, lft = p_lft, rgt = p_rgt, code = p_code, allow_course = p_allow_course, allow_user = p_allow_user, order_priority = p_order_priority WHERE id = p_id; IF nodelft <> parentlft THEN CALL move_nodes(nodelft, p_lft, p_rgt); END IF; END", elapsed:0.001049

In file /Users/teras/Works/Development/WebApps/eClass/server/install/install_db.php on line 1112 : Unable to execute statement:"Cannot load from mysql.proc. The table is probably corrupted", sqlstate:"1728", errornum:"HY000", statement:"DROP PROCEDURE IF EXISTS `delete_node`", elapsed:0.00042700000000001

In file /Users/teras/Works/Development/WebApps/eClass/server/install/install_db.php on line 1122 : Unable to execute statement:"Cannot load from mysql.proc. The table is probably corrupted", sqlstate:"1728", errornum:"HY000", statement:"CREATE PROCEDURE `delete_node` (IN p_id INT(11)) LANGUAGE SQL BEGIN DECLARE p_lft, p_rgt INT(11); SELECT lft, rgt INTO p_lft, p_rgt FROM `hierarchy` WHERE id = p_id; DELETE FROM `hierarchy` WHERE id = p_id; CALL delete_nodes(p_lft, p_rgt); END", elapsed:0.00053600000000001

In file /Users/teras/Works/Development/WebApps/eClass/server/install/install_db.php on line 1124 : Unable to execute statement:"Cannot load from mysql.proc. The table is probably corrupted", sqlstate:"1728", errornum:"HY000", statement:"DROP PROCEDURE IF EXISTS `shift_right`", elapsed:0.00036600000000001

In file /Users/teras/Works/Development/WebApps/eClass/server/install/install_db.php on line 1139 : Unable to execute statement:"Cannot load from mysql.proc. The table is probably corrupted", sqlstate:"1728", errornum:"HY000", statement:"CREATE PROCEDURE `shift_right` (IN node INT(11), IN shift INT(11), IN maxrgt INT(11)) LANGUAGE SQL BEGIN IF maxrgt > 0 THEN UPDATE `hierarchy` SET rgt = rgt + shift WHERE rgt > node AND rgt <= maxrgt; ELSE UPDATE `hierarchy` SET rgt = rgt + shift WHERE rgt > node; END IF; IF maxrgt > 0 THEN UPDATE `hierarchy` SET lft = lft + shift WHERE lft > node AND lft <= maxrgt; ELSE UPDATE `hierarchy` SET lft = lft + shift WHERE lft > node; END IF; END", elapsed:0.00042200000000001

In file /Users/teras/Works/Development/WebApps/eClass/server/install/install_db.php on line 1141 : Unable to execute statement:"Cannot load from mysql.proc. The table is probably corrupted", sqlstate:"1728", errornum:"HY000", statement:"DROP PROCEDURE IF EXISTS `shift_left`", elapsed:0.00026100000000001

In file /Users/teras/Works/Development/WebApps/eClass/server/install/install_db.php on line 1156 : Unable to execute statement:"Cannot load from mysql.proc. The table is probably corrupted", sqlstate:"1728", errornum:"HY000", statement:"CREATE PROCEDURE `shift_left` (IN node INT(11), IN shift INT(11), IN maxrgt INT(11)) LANGUAGE SQL BEGIN IF maxrgt > 0 THEN UPDATE `hierarchy` SET rgt = rgt - shift WHERE rgt > node AND rgt <= maxrgt; ELSE UPDATE `hierarchy` SET rgt = rgt - shift WHERE rgt > node; END IF; IF maxrgt > 0 THEN UPDATE `hierarchy` SET lft = lft - shift WHERE lft > node AND lft <= maxrgt; ELSE UPDATE `hierarchy` SET lft = lft - shift WHERE lft > node; END IF; END", elapsed:0.00034299999999998

In file /Users/teras/Works/Development/WebApps/eClass/server/install/install_db.php on line 1158 : Unable to execute statement:"Cannot load from mysql.proc. The table is probably corrupted", sqlstate:"1728", errornum:"HY000", statement:"DROP PROCEDURE IF EXISTS `shift_end`", elapsed:0.000306

In file /Users/teras/Works/Development/WebApps/eClass/server/install/install_db.php on line 1165 : Unable to execute statement:"Cannot load from mysql.proc. The table is probably corrupted", sqlstate:"1728", errornum:"HY000", statement:"CREATE PROCEDURE `shift_end` (IN p_lft INT(11), IN p_rgt INT(11), IN maxrgt INT(11)) LANGUAGE SQL BEGIN UPDATE `hierarchy` SET lft = (lft - (p_lft - 1)) + maxrgt, rgt = (rgt - (p_lft - 1)) + maxrgt WHERE lft BETWEEN p_lft AND p_rgt; END", elapsed:0.000416

In file /Users/teras/Works/Development/WebApps/eClass/server/install/install_db.php on line 1167 : Unable to execute statement:"Cannot load from mysql.proc. The table is probably corrupted", sqlstate:"1728", errornum:"HY000", statement:"DROP PROCEDURE IF EXISTS `get_maxrgt`", elapsed:0.000467

In file /Users/teras/Works/Development/WebApps/eClass/server/install/install_db.php on line 1172 : Unable to execute statement:"Cannot load from mysql.proc. The table is probably corrupted", sqlstate:"1728", errornum:"HY000", statement:"CREATE PROCEDURE `get_maxrgt` (OUT maxrgt INT(11)) LANGUAGE SQL BEGIN SELECT rgt INTO maxrgt FROM `hierarchy` ORDER BY rgt DESC LIMIT 1; END", elapsed:0.00034600000000001

In file /Users/teras/Works/Development/WebApps/eClass/server/install/install_db.php on line 1174 : Unable to execute statement:"Cannot load from mysql.proc. The table is probably corrupted", sqlstate:"1728", errornum:"HY000", statement:"DROP PROCEDURE IF EXISTS `get_parent`", elapsed:0.000501

In file /Users/teras/Works/Development/WebApps/eClass/server/install/install_db.php on line 1179 : Unable to execute statement:"Cannot load from mysql.proc. The table is probably corrupted", sqlstate:"1728", errornum:"HY000", statement:"CREATE PROCEDURE `get_parent` (IN p_lft INT(11), IN p_rgt INT(11)) LANGUAGE SQL BEGIN SELECT * FROM `hierarchy` WHERE lft < p_lft AND rgt > p_rgt ORDER BY lft DESC LIMIT 1; END", elapsed:0.000393

In file /Users/teras/Works/Development/WebApps/eClass/server/install/install_db.php on line 1181 : Unable to execute statement:"Cannot load from mysql.proc. The table is probably corrupted", sqlstate:"1728", errornum:"HY000", statement:"DROP PROCEDURE IF EXISTS `delete_nodes`", elapsed:0.00029699999999999

In file /Users/teras/Works/Development/WebApps/eClass/server/install/install_db.php on line 1191 : Unable to execute statement:"Cannot load from mysql.proc. The table is probably corrupted", sqlstate:"1728", errornum:"HY000", statement:"CREATE PROCEDURE `delete_nodes` (IN p_lft INT(11), IN p_rgt INT(11)) LANGUAGE SQL BEGIN DECLARE node_width INT(11); SET node_width = p_rgt - p_lft + 1; DELETE FROM `hierarchy` WHERE lft BETWEEN p_lft AND p_rgt; UPDATE `hierarchy` SET rgt = rgt - node_width WHERE rgt > p_rgt; UPDATE `hierarchy` SET lft = lft - node_width WHERE lft > p_lft; END", elapsed:0.00034700000000001

In file /Users/teras/Works/Development/WebApps/eClass/server/install/install_db.php on line 1193 : Unable to execute statement:"Cannot load from mysql.proc. The table is probably corrupted", sqlstate:"1728", errornum:"HY000", statement:"DROP PROCEDURE IF EXISTS `move_nodes`", elapsed:0.000275

In file /Users/teras/Works/Development/WebApps/eClass/server/install/install_db.php on line 1218 : Unable to execute statement:"Cannot load from mysql.proc. The table is probably corrupted", sqlstate:"1728", errornum:"HY000", statement:"CREATE PROCEDURE `move_nodes` (INOUT nodelft INT(11), IN p_lft INT(11), IN p_rgt INT(11)) LANGUAGE SQL BEGIN DECLARE node_width, maxrgt INT(11); SET node_width = p_rgt - p_lft + 1; CALL get_maxrgt(maxrgt); CALL shift_end(p_lft, p_rgt, maxrgt); IF nodelft = 0 THEN CALL shift_left(p_rgt, node_width, 0); ELSE CALL shift_left(p_rgt, node_width, maxrgt); IF p_lft < nodelft THEN SET nodelft = nodelft - node_width; END IF; CALL shift_right(nodelft, node_width, maxrgt); UPDATE `hierarchy` SET rgt = (rgt - maxrgt) + nodelft WHERE rgt > maxrgt; UPDATE `hierarchy` SET lft = (lft - maxrgt) + nodelft WHERE lft > maxrgt; END IF; END", elapsed:0.00043000000000001

In file /Users/teras/Works/Development/WebApps/eClass/server/install/install_db.php on line 1717 : Unable to execute statement:"Table 'eclass.wiki_locks' doesn't exist", sqlstate:"1146", errornum:"42S02", statement:"CREATE INDEX `wiki_id` ON wiki_locks(wiki_id)", elapsed:0.00052599999999997

History

#1

Updated by Yannis Exidaridis about 8 years ago

  • % Done changed from 0 to 50

διορθώθηκαν τα default engine και ο πίνακας wiki_locks.

#2

Updated by Yannis Exidaridis almost 4 years ago

έχει διορθωθεί.

#3

Updated by Yannis Exidaridis almost 4 years ago

  • Status changed from Νέα to Κλειστό

Also available in: Atom PDF