Open eClass Dev: Issueshttps://dev.openeclass.org/https://dev.openeclass.org/favicon.ico?15861920342021-01-20T16:18:07ZOpen eClass Dev
Redmine Open eClass - Σφάλματα #301 (Νέα): Cannot modify header informationhttps://dev.openeclass.org/issues/3012021-01-20T16:18:07ZLefteris Zacharia
<p>PHP Warning: Cannot modify header information - headers already sent by (output started at/modules/course_home/course_home.php:1) in include/init.php on line 41<br /> PHP Warning: Cannot modify header information - headers already sent by (output started at modules/course_home/course_home.php:1) in include/main_lib.php on line 3177<br />PHP Warning: Cannot modify header information - headers already sent by (output started at modules/course_home/course_home.php:1) in include/main_lib.php on line 3188<br />PHP Warning: Cannot modify header information - headers already sent by (output started at modules/course_home/course_home.php:1) in include/main_lib.php on line 3198</p>
<p>The mobile app is not working for browsing the menus of the lessons.</p> Open eClass - Σφάλματα #298 (Νέα): Group by mysql: group creationhttps://dev.openeclass.org/issues/2982020-05-26T10:58:44ZGeorge Miliotis
<p>In file modules\group\group_creation.php on line 177 : Unable to execute statement:"'eclass-hg.u.surname' isn't in GROUP BY", sqlstate:"1055", errornum:"42000", statement:"SELECT u.id, u.surname, u.givenname, u.am FROM (user u, course_user cu) WHERE cu.course_id = 1 AND cu.user_id = u.id AND cu.status = 5 AND u.id NOT IN (SELECT user_id FROM group_members, `group` WHERE `group`.id = group_members.group_id AND `group`.course_id = ?) GROUP BY u.id ORDER BY u.surname, u.givenname", elapsed:1590490405</p>
<p>Warning: Invalid argument supplied for foreach() in D:\www\openeclass-hg\modules\group\group_creation.php on line 189</p> Open eClass - Σφάλματα #294 (Νέα): mod_fcgid: stderr: PHP Warning: fileatime() ../include/main_li...https://dev.openeclass.org/issues/2942017-01-03T18:49:19ZIraklis Markelisimark@ekppanou.gr
<p>Έχω το συγκεκριμένο μήνυμα από διαφορετικές ip:<br />mod_fcgid: stderr: PHP Warning: fileatime(): open_basedir restriction in effect. File(/tmp/autoinstaller3.log) is not within the allowed path(s): (/var/www/vhosts/ekppanou.gr/:/tmp/) in /var/www/vhosts/ekppanou.gr/epanoub/include/main_lib.php on line 2884</p>
<p>Ως αποτέλεσμα μου εμφανίζει μήνυμα στην σελίδα της φόρμας Ασκήσεων:<br />Forbidden<br />You don't have permission to access /modules/exercise/admin.php on this server.</p>
<p>Το πρόβλημα εμφανήστηκε μετά την αναβάθμηση του συστήματος σε έκδοση 3.5.2 και κατά τη διάκρεια σημιουργίας ερωτήσεων σε ασκήσεις και δεν με αφήνει να προσθέσω άλλες ερωτήσεις στην άσκηση.</p> Open eClass - UI #238 (Νέα): Portfolio - Υποσύστημα 'Ημερολόγιο' - διόρθωση UIhttps://dev.openeclass.org/issues/2382014-11-25T08:27:54ZIoannis Fenerisifeneris@it.auth.gr
<p>Αλλαγή well και buttons<br />Προσθήκη panel<br />Αλλαγή χρωμάτων στα buttons<br />Αλλαγή απο well σε panel για τα νέα γεγονότα και αλλαγή buttons</p> Open eClass - UI #208 (Νέα): UI/UX Review για υποσύστημα WIKIhttps://dev.openeclass.org/issues/2082014-11-24T12:38:49ZIoannis Fenerisifeneris@it.auth.grOpen eClass - Σφάλματα #199 (Νέα): missing texthttps://dev.openeclass.org/issues/1992014-10-11T10:52:33ZPanayotis Katsaloulispanayotis@panayotis.com
<p>στο dmform.php γίνεται αναφορά στο λεκτικό<br />$langdbpassencr<br />το οποίο όμως δεν υπάρχει πουθενά, άρα και το λεκτικό φαίνεται κενό<br />πρέπει να το προσθέσουμε στις μεταφράσεις και να γίνουν και οι μεταφράσεις</p> Open eClass - Σφάλματα #125 (Νέα): Μαζική δημιουργία μαθημάτων https://dev.openeclass.org/issues/1252013-12-22T23:31:04ZPanayotis Katsaloulispanayotis@panayotis.com
<p>Η διαδικασία της μαζικής δημιουργίας μαθημάτων δεν λειτουγεί <br />modules/admin/multicourse.php</p>
<p>Από όσο μπόρεσα να δω, έχει να κάνει με το faculte (που μου μοιάζει υπερβολικά γαλλικό για να είναι σωστό).<br />Η έλλειψη αυτής της παραμέτρου ανακυκλώνεται σε διάφορα σημεία, γι'αυτό το λάθος εμφανίζεται πολλαπλές φορές</p>
<p>Tα μηνύματα λάθους είναι</p>
<p>Notice: Undefined index: faculte in /Users/teras/Works/Development/WebApps/eClass/eclass/modules/admin/multicourse.php on line 36</p>
<p>Notice: Undefined offset: 1 in /Users/teras/Works/Development/WebApps/eClass/eclass/include/main_lib.php on line 809</p>
<p>Notice: Undefined offset: 0 in /Users/teras/Works/Development/WebApps/eClass/eclass/include/main_lib.php on line 808</p>
<p>Warning: Invalid argument supplied for foreach() in /Users/teras/Works/Development/WebApps/eClass/eclass/modules/create_course/functions.php on line 59</p>
<p>Notice: Undefined variable: set_fac in /Users/teras/Works/Development/WebApps/eClass/eclass/modules/create_course/functions.php on line 67</p> Open eClass - Σφάλματα #117 (Νέα): Να σβήνονται τα cookies στον client κατά τη διαδικασία του upg...https://dev.openeclass.org/issues/1172013-09-24T10:16:22ZPanayotis Katsaloulispanayotis@panayotis.com
<p>Αλλιώς βγάινουν κάποια περίεργα μηνύματα λάθους</p> Open eClass - Σφάλματα #114 (Νέα): Σφάλμα κατά την απαίτηση του καταλόγου μαθημάτωνhttps://dev.openeclass.org/issues/1142013-09-17T23:53:26ZPanayotis Katsaloulispanayotis@panayotis.com
<p>1054: Unknown column 'course.id' in 'where clause'</p>
<p>SELECT <abbr title="code">COUNT</abbr> FROM course, course_department<br /> WHERE course.id = course_department.course AND course_department.department = 21</p>
<p>Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /Users/teras/Works/Development/WebApps/OpeneClass/eclass/modules/auth/courses.php on line 178<br />1054: Unknown column 'course.id' in 'where clause'</p>
<p>SELECT <abbr title="*">COUNT</abbr><br /> FROM course, course_department<br /> WHERE course.id = course_department.course<br /> AND course_department.department = 1</p>
<p>Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /Users/teras/Works/Development/WebApps/OpeneClass/eclass/include/lib/hierarchy.class.php on line 1291<br />1054: Unknown column 'course.id' in 'where clause'</p>
<p>SELECT <abbr title="*">COUNT</abbr><br /> FROM course, course_department<br /> WHERE course.id = course_department.course<br /> AND course_department.department = 6</p>
<p>Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /Users/teras/Works/Development/WebApps/OpeneClass/eclass/include/lib/hierarchy.class.php on line 1291<br />1054: Unknown column 'course.id' in 'where clause'</p>
<p>SELECT <abbr title="*">COUNT</abbr><br /> FROM course, course_department<br /> WHERE course.id = course_department.course<br /> AND course_department.department = 7</p>
<p>Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /Users/teras/Works/Development/WebApps/OpeneClass/eclass/include/lib/hierarchy.class.php on line 1291<br />1054: Unknown column 'course.id' in 'where clause'</p>
<p>SELECT <abbr title="*">COUNT</abbr><br /> FROM course, course_department<br /> WHERE course.id = course_department.course<br /> AND course_department.department = 8</p>
<p>Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /Users/teras/Works/Development/WebApps/OpeneClass/eclass/include/lib/hierarchy.class.php on line 1291<br />1054: Unknown column 'course.id' in 'where clause'</p>
<p>SELECT <abbr title="*">COUNT</abbr><br /> FROM course, course_department<br /> WHERE course.id = course_department.course<br /> AND course_department.department = 2</p>
<p>Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /Users/teras/Works/Development/WebApps/OpeneClass/eclass/include/lib/hierarchy.class.php on line 1291<br />1054: Unknown column 'course.id' in 'where clause'</p>
<p>SELECT <abbr title="*">COUNT</abbr><br /> FROM course, course_department<br /> WHERE course.id = course_department.course<br /> AND course_department.department = 9</p>
<p>Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /Users/teras/Works/Development/WebApps/OpeneClass/eclass/include/lib/hierarchy.class.php on line 1291<br />1054: Unknown column 'course.id' in 'where clause'</p>
<p>SELECT <abbr title="*">COUNT</abbr><br /> FROM course, course_department<br /> WHERE course.id = course_department.course<br /> AND course_department.department = 10</p>
<p>Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /Users/teras/Works/Development/WebApps/OpeneClass/eclass/include/lib/hierarchy.class.php on line 1291<br />1054: Unknown column 'course.id' in 'where clause'</p>
<p>SELECT <abbr title="*">COUNT</abbr><br /> FROM course, course_department<br /> WHERE course.id = course_department.course<br /> AND course_department.department = 11</p>
<p>Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /Users/teras/Works/Development/WebApps/OpeneClass/eclass/include/lib/hierarchy.class.php on line 1291<br />1054: Unknown column 'course.id' in 'where clause'</p>
<p>SELECT <abbr title="*">COUNT</abbr><br /> FROM course, course_department<br /> WHERE course.id = course_department.course<br /> AND course_department.department = 3</p>
<p>Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /Users/teras/Works/Development/WebApps/OpeneClass/eclass/include/lib/hierarchy.class.php on line 1291<br />1054: Unknown column 'course.id' in 'where clause'</p>
<p>SELECT <abbr title="*">COUNT</abbr><br /> FROM course, course_department<br /> WHERE course.id = course_department.course<br /> AND course_department.department = 12</p>
<p>Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /Users/teras/Works/Development/WebApps/OpeneClass/eclass/include/lib/hierarchy.class.php on line 1291<br />1054: Unknown column 'course.id' in 'where clause'</p>
<p>SELECT <abbr title="*">COUNT</abbr><br /> FROM course, course_department<br /> WHERE course.id = course_department.course<br /> AND course_department.department = 13</p>
<p>Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /Users/teras/Works/Development/WebApps/OpeneClass/eclass/include/lib/hierarchy.class.php on line 1291<br />1054: Unknown column 'course.id' in 'where clause'</p>
<p>SELECT <abbr title="*">COUNT</abbr><br /> FROM course, course_department<br /> WHERE course.id = course_department.course<br /> AND course_department.department = 14</p>
<p>Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /Users/teras/Works/Development/WebApps/OpeneClass/eclass/include/lib/hierarchy.class.php on line 1291<br />1054: Unknown column 'course.id' in 'where clause'</p>
<p>SELECT <abbr title="*">COUNT</abbr><br /> FROM course, course_department<br /> WHERE course.id = course_department.course<br /> AND course_department.department = 4</p>
<p>Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /Users/teras/Works/Development/WebApps/OpeneClass/eclass/include/lib/hierarchy.class.php on line 1291<br />1054: Unknown column 'course.id' in 'where clause'</p>
<p>SELECT <abbr title="*">COUNT</abbr><br /> FROM course, course_department<br /> WHERE course.id = course_department.course<br /> AND course_department.department = 15</p>
<p>Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /Users/teras/Works/Development/WebApps/OpeneClass/eclass/include/lib/hierarchy.class.php on line 1291<br />1054: Unknown column 'course.id' in 'where clause'</p>
<p>SELECT <abbr title="*">COUNT</abbr><br /> FROM course, course_department<br /> WHERE course.id = course_department.course<br /> AND course_department.department = 16</p>
<p>Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /Users/teras/Works/Development/WebApps/OpeneClass/eclass/include/lib/hierarchy.class.php on line 1291<br />1054: Unknown column 'course.id' in 'where clause'</p>
<p>SELECT <abbr title="*">COUNT</abbr><br /> FROM course, course_department<br /> WHERE course.id = course_department.course<br /> AND course_department.department = 17</p>
<p>Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /Users/teras/Works/Development/WebApps/OpeneClass/eclass/include/lib/hierarchy.class.php on line 1291<br />1054: Unknown column 'course.id' in 'where clause'</p>
<p>SELECT <abbr title="*">COUNT</abbr><br /> FROM course, course_department<br /> WHERE course.id = course_department.course<br /> AND course_department.department = 5</p>
<p>Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /Users/teras/Works/Development/WebApps/OpeneClass/eclass/include/lib/hierarchy.class.php on line 1291<br />1054: Unknown column 'course.id' in 'where clause'</p>
<p>SELECT <abbr title="*">COUNT</abbr><br /> FROM course, course_department<br /> WHERE course.id = course_department.course<br /> AND course_department.department = 18</p>
<p>Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /Users/teras/Works/Development/WebApps/OpeneClass/eclass/include/lib/hierarchy.class.php on line 1291<br />1054: Unknown column 'course.id' in 'where clause'</p>
<p>SELECT <abbr title="*">COUNT</abbr><br /> FROM course, course_department<br /> WHERE course.id = course_department.course<br /> AND course_department.department = 19</p>
<p>Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /Users/teras/Works/Development/WebApps/OpeneClass/eclass/include/lib/hierarchy.class.php on line 1291<br />1054: Unknown column 'course.id' in 'where clause'</p>
<p>SELECT <abbr title="*">COUNT</abbr><br /> FROM course, course_department<br /> WHERE course.id = course_department.course<br /> AND course_department.department = 20</p>
<p>Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /Users/teras/Works/Development/WebApps/OpeneClass/eclass/include/lib/hierarchy.class.php on line 1291</p> Open eClass - Σφάλματα #99 (In Progress): Εμφάνιση λαθών και warnings κατά τη διαδικασία του upgradehttps://dev.openeclass.org/issues/992013-03-21T17:25:41ZPanayotis Katsaloulispanayotis@panayotis.com
<p>Στη σελίδα του Upgrade εμφανίζονται τα εξής προβλήματα:<br /><pre>
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
</pre></p> Open eClass - Σφάλματα #97 (Νέα): Πρόβλημα στην αρχική σελίδα μετά από updatehttps://dev.openeclass.org/issues/972013-03-21T17:23:10ZPanayotis Katsaloulispanayotis@panayotis.com
<p>Μετά από update από 2.6 σε 3.0, η αρχική σελίδα εμφανίζει αυτό το μήνυμα:</p>
<pre>
1146: Table 'eclass.agenda' doesn't exist
SELECT agenda.title, agenda.content, agenda.day, DATE_FORMAT(agenda.hour, '%H:%i'),
agenda.lasting, course.code, course.title
FROM agenda, course WHERE agenda.course_id IN ('1','2')
AND agenda.course_id = course.id
AND agenda.visible = 1
HAVING (TO_DAYS(day) - TO_DAYS(NOW())) >= '0'
ORDER BY day, hour DESC
LIMIT 5
Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /home/teras/Works/Development/WebApps/eclass/modules/perso/agenda.php on line 103
1146: Table 'eclass.forum' doesn't exist
SELECT forum.id,
forum.name,
forum_topic.id,
forum_topic.title,
forum_topic.num_replies,
forum_post.post_time,
forum_post.poster_id,
forum_post.post_text
FROM forum, forum_topic, forum_post, course_module
WHERE CONCAT(forum_topic.title, forum_post.post_text) != ''
AND forum.id = forum_topic.forum_id
AND forum_post.topic_id = forum_topic.id
AND forum.course_id = 1
AND DATE_FORMAT(forum_post.post_time, '%Y %m %d') >= "2013 02 21"
AND course_module.visible = 1
AND course_module.module_id = 9
AND course_module.course_id = 1
ORDER BY forum_post.post_time LIMIT 15
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/teras/Works/Development/WebApps/eclass/modules/perso/forumPosts.php on line 63
Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /home/teras/Works/Development/WebApps/eclass/modules/perso/forumPosts.php on line 71
1146: Table 'eclass.forum' doesn't exist
SELECT forum.id,
forum.name,
forum_topic.id,
forum_topic.title,
forum_topic.num_replies,
forum_post.post_time,
forum_post.poster_id,
forum_post.post_text
FROM forum, forum_topic, forum_post, course_module
WHERE CONCAT(forum_topic.title, forum_post.post_text) != ''
AND forum.id = forum_topic.forum_id
AND forum_post.topic_id = forum_topic.id
AND forum.course_id = 2
AND DATE_FORMAT(forum_post.post_time, '%Y %m %d') >= "2013 02 21"
AND course_module.visible = 1
AND course_module.module_id = 9
AND course_module.course_id = 2
ORDER BY forum_post.post_time LIMIT 15
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/teras/Works/Development/WebApps/eclass/modules/perso/forumPosts.php on line 63
Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /home/teras/Works/Development/WebApps/eclass/modules/perso/forumPosts.php on line 71
</pre>
<p>Από το μήνυμα αυτό και κάτω εμφανίζεται η κεντρική σελίδα</p> Open eClass - Λειτουργίες #89 (Νέα): Drop-down menu για τις ενέργειες στα έγγραφα με jQueryhttps://dev.openeclass.org/issues/892013-02-22T10:27:14ZΑλέξανδρος Διαμαντίδηςadia@noc.uoa.gr
<p>Οι ενέργειες στα έγγραφα που τώρα εμφανίζονται σε μια σειρά εικονίδια δεξιά από το όνομα κάθε αρχείου, θα πρέπει να μπουν σε ένα drop-down menu (με jQuery) που να εμφανίζεται με κλικ σε ένα εικονίδιο (ίσως και με δεξί κλικ στο όνομα του αρχείου). Στο μενού μπορούμε να κρατήσουμε τα εικονίδια και να προσθέσουμε και ετικέτες.</p> Open eClass - Λειτουργίες #60 (Νέα): Pop-up με πληροφορίες για κλειστά και ανοιχτά μαθήματα στον ...https://dev.openeclass.org/issues/602012-09-17T11:44:18ZΑλέξανδρος Διαμαντίδηςadia@noc.uoa.gr
<p>Θα προστεθεί ένας σύνδεσμος (ή και περισσότεροι - πρέπει να δούμε τι θέλουμε ακριβώς) στη λίστα μαθημάτων όπου κάνοντας κλικ εμφανίζεται ένα pop-up (πχ. με το colorbox) με περισσότερες πληροφορίες για το μάθημα. Οι πληροφορίες αυτές θα μπορούσαν για παράδειγμα να είναι η περιγραφή του μαθήματος, ή ενδεχομένως μια νέα ενότητα των πληροφοριών μαθήματος ειδικά για το σκοπό αυτό.</p>
<p>Η ιδέα και ένα patch για το σκοπό αυτό μας έχει σταλεί από Interpedia το οποίο όμως θα πρέπει να ξαναγραφτεί με πιο γενικό τρόπο.</p> Open eClass - Λειτουργίες #55 (Νέα): Course restore: το αρχείο backup.php να γίνεται parse από το...https://dev.openeclass.org/issues/552012-09-03T08:07:11ZΑλέξανδρος Διαμαντίδηςadia@noc.uoa.gr
<p>Στην ανάκτηση αρχείου μαθήματος αυτή τη στιγμή το αρχείο backup.php που έχει γραφτεί κατά το archive γίνεται include, οπότε και καλούνται οι συναρτήσεις που περιέχονται εκεί και δημιουργούν το μάθημα, τους χρήστες, κλπ. Αυτό είναι πρόβλημα ασφαλείας και μειώνει την ευελιξία του κώδικα. Στην έκδοση 3.0 το backup.php θα καταργηθεί αλλά θα πρέπει να μπορούμε να κάνουμε restore αρχεία μαθημάτων από παλιότερες εκδόσεις, οπότε θα πρέπει να γράψουμε κώδικα για να κάνει parse τα περιεχόμενα του backup.php και να εκτελεί τις αντίστοιχες ενέργειες.</p> Open eClass - Λειτουργίες #40 (Νέα): Ebook: βελτίωση περιβάλλοντος αντιστοίχισης αρχείων σε κεφάλ...https://dev.openeclass.org/issues/402012-05-15T12:52:01ZΑλέξανδρος Διαμαντίδηςadia@noc.uoa.gr
<p>Στο ηλεκτρονικό βιβλίο η οθόνη αντιστοίχισης κεφαλαίων σε αρχεία δεν είναι και τόσο πρακτική. Μπορεί να γίνει κάποιος συνδυασμός του περιβάλλοντος διαχείρισης αρχείων (document) ή κάποιου tree widget με άμεσες αλλαγές με χρήση AJAX/jQuery.</p>