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 - Λειτουργίες #299 (Νέα): Ενημέρωση της βιβλιοθήκης Querypathhttps://dev.openeclass.org/issues/2992020-05-26T13:07:34ZYannis Exidaridisjexi@noc.uoa.gr
Στις ασκήσεις το import / export μιας ερώτησης σε qti μορφή γίνεται μέσω της βιβλιοθήκης Query path έκδοσης 2. (χειρίζεται τα παραγόμενα xml αρχεία)<br />Πρέπει
<ul>
<li>να αντικατασταθεί από την έκδοση 3 <a class="external" href="https://github.com/technosophos/querypath">https://github.com/technosophos/querypath</a> (και να εγκαθίσταται μέσω composer).</li>
<li>να βεβαιωθούμε ότι λειτουργεί σωστά. Κάποιες functions της QueryPath πιθανον να είναι λίγο διαφορετικές.</li>
</ul> 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 - Λειτουργίες #297 (Νέα): Υποστήριξη τηλεσυνεργασίας στο παρουσιολόγιοhttps://dev.openeclass.org/issues/2972017-02-10T13:30:32ZΑλέξανδρος Διαμαντίδηςadia@noc.uoa.gr
<p>Θα πρέπει να προστεθεί η «τηλεσυνεργασία» στις δραστηριότητες που υποστηρίζει το παρουσιολόγιο, και να καταγράφεται αυτόματα η παρουσία αν ο χρήστης συνδεθεί στην αντίστοιχη τηλεσυνεργασία.</p> Open eClass - Σφάλματα #296 (Νέα): Ταξινόμηση στις εργασίεςhttps://dev.openeclass.org/issues/2962017-01-26T12:38:44ZYannis Exidaridisjexi@noc.uoa.gr
<p>Καλύτερη ταξινόμηση στις εργασίες. Θα πρέπει να εμφανίζονται πρώτα αυτές με την κοντινότερη ημερομηνία λήξης, μετά αυτές που δεν έχουν ημερομηνία λήξης και μετά αυτές που έχουν λήξει.</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 - Λειτουργίες #293 (Νέα): Τηλεσυνεργασίαhttps://dev.openeclass.org/issues/2932016-07-27T12:36:46ZYannis Exidaridisjexi@noc.uoa.gr
<p>1. Στην τηλεσυνεργασία, θα εξυπηρετούσε να υπάρχει επιλογή λήξης της τηλεσυνεργασίας, που αμέσως μετά θα "κλείνει" το δωμάτιο. Αντίστοιχα, θα εξυπηρετούσε να υπάρχει και η επιλογή του "ανοικτού" δωματίου, ώστε να μην "υπόκειται" σε χρονικούς περιορισμούς.<br />2. Καταγραφή του χρόνου πρόσβασης των χρηστών σε δωμάτιο/τηλεσυνεργασία.</p> Open eClass - Λειτουργίες #286 (Νέα): Υποσύστημα "Μηνύματα"https://dev.openeclass.org/issues/2862015-11-19T11:24:50ZYannis Exidaridisjexi@noc.uoa.gr
<p>Θα πρέπει η λειτουργία "Μηνύματα" να φύγει από τα μενού αριστερά έτσι ώστε να μην ενεργοποιείται / απενεργοποιείται κατά λάθος. <br />Πιθανόν να φαίνεται με τη μορφή κάποιου εικονιδίου στην αρχική σελίδα του μαθήματος (όπως π.χ. παλιότερα υπήρχε το "επικοινωνία με τον καθηγητή") και η απενεργοποίηση της να γίνεται μέσα από τη διαχείριση του μαθήματος.</p> Open eClass - Λειτουργίες #285 (Νέα): Δημιουργία λογαριασμών που δεν λήγουν ποτέhttps://dev.openeclass.org/issues/2852015-10-19T13:03:04ZYannis Exidaridisjexi@noc.uoa.gr
<p>Θα πρέπει να μπορεί να οριστεί / αλλαχτεί (από τον admin ίσως?) λογαριασμός χρήστη που να μην λήγει ποτέ.</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 - Λειτουργίες #45 (Νέα): Ένδειξη απομείνοντα χρόνου στις ασκήσειςhttps://dev.openeclass.org/issues/452012-05-21T09:05:49ZΑλέξανδρος Διαμαντίδηςadia@noc.uoa.gr
<p>Στις ασκήσεις με χρονικό περιορισμό, θα ήταν χρήσιμο να προσθέσουμε μια ένδειξη σε πραγματικό χρόνο (με Javascript) που να δείχνει πόση ώρα απομένει. Ειδικά λίγο πριν τελειώσει ο χρόνος (πχ. στο 10% πριν και στο 5% πριν) θα μπορούσε στιγμιαία να βγαίνει και ένα pop-up σε μια γωνιά της οθόνης με την ένδειξη: προσοχή, έχετε μόνο x λεπτά / y δευτερόλεπτα για την ολοκλήρωση της άσκησης.</p>