Slideshow

Slideshow

per SEBASTIAN CUADRAS JAUME -
Nombre de respostes: 7
He intentat actualitzar al Moodle per activar el mòdul Slideshow des de l'apartat Notificacions del menú d'administració i m'ha aparegut aquest missatge:


Slideshow tables could not be set up succesfully


i el mòdul no m'apareix com una activitat.
En resposta a SEBASTIAN CUADRAS JAUME

Re: Slideshow

per LLUIS VALENCIA LOPEZ -
Al moodle http://agora.xtec.cat/iesmontalt/moodle ha passat igual. Us adjunto els errors que ha comunicat el sistema abans de donar el missatge.
En resposta a LLUIS VALENCIA LOPEZ

Re: Slideshow

per ANTONIO GARCIA RODRIGUEZ -

Al moodle http://agora.xtec.cat/iescanvilumara ens ha passat algo semblant que al Lluís però amb 2 warnings, ens surt el següent missatge:


This script generated 2 warnings - Scroll to the first warning

slideshow


(oci8po): SELECT constraint_name FROM user_constraints WHERE lower(constraint_name) = 'mlslid_id_pk'

(oci8po): SELECT constraint_name FROM user_constraints WHERE lower(constraint_name) = 'mlslid_id2_pk'

(oci8po): SELECT object_name FROM user_objects WHERE lower(object_name) = 'mlslid_id_seq'

(oci8po): SELECT object_name FROM user_objects WHERE lower(object_name) = 'mlslid_id2_seq'

(oci8po): SELECT object_name FROM user_objects WHERE lower(object_name) = 'mlslid_id_trg'

(oci8po): SELECT object_name FROM user_objects WHERE lower(object_name) = 'mlslid_id2_trg'

(oci8po): SELECT constraint_name FROM user_constraints WHERE lower(constraint_name) = 'mlslidcapt_id_pk'

(oci8po): SELECT constraint_name FROM user_constraints WHERE lower(constraint_name) = 'mlslidcapt_id2_pk'

(oci8po): SELECT object_name FROM user_objects WHERE lower(object_name) = 'mlslidcapt_id_seq'

(oci8po): SELECT object_name FROM user_objects WHERE lower(object_name) = 'mlslidcapt_id2_seq'

(oci8po): SELECT object_name FROM user_objects WHERE lower(object_name) = 'mlslidcapt_id_trg'

(oci8po): SELECT object_name FROM user_objects WHERE lower(object_name) = 'mlslidcapt_id2_trg'

(oci8po): CREATE TABLE mlslideshow ( id NUMBER(10) NOT NULL , course NUMBER(10) DEFAULT 0 NOT NULL, name VARCHAR2(255) DEFAULT ' ' NOT NULL, location CLOB NOT NULL, layout NUMBER(10) DEFAULT 0 NOT NULL, filename NUMBER(10) DEFAULT 0 NOT NULL, delaytime NUMBER(10) DEFAULT 7 NOT NULL, centred NUMBER(10) DEFAULT 0 NOT NULL, autobgcolor NUMBER(10) DEFAULT 0 NOT NULL, timemodified NUMBER(10) DEFAULT 0 NOT NULL, htmlcaptions NUMBER(10) DEFAULT 1 NOT NULL, CONSTRAINT mlslid_id2_pk PRIMARY KEY (id) )
955: ORA-00955: name is already used by an existing object
      

(oci8po): COMMENT ON TABLE mlslideshow IS 'Defines slideshow instance'
Èxit

(oci8po): CREATE SEQUENCE mlslid_id2_seq START WITH 1 INCREMENT BY 1 NOMAXVALUE
Èxit

(oci8po): CREATE TRIGGER mlslid_id2_trg BEFORE INSERT ON mlslideshow FOR EACH ROW BEGIN IF :new.id IS NULL THEN SELECT mlslid_id2_seq.nextval INTO :new.id FROM dual; END IF; END;
Èxit

(oci8po): CREATE TABLE mlslideshow_captions ( id NUMBER(10) NOT NULL , slideshow NUMBER(10) DEFAULT 0 NOT NULL, image CLOB NOT NULL, title CLOB NOT NULL, caption CLOB NOT NULL, CONSTRAINT mlslidcapt_id2_pk PRIMARY KEY (id) )
955: ORA-00955: name is already used by an existing object
      

(oci8po): COMMENT ON TABLE mlslideshow_captions IS 'stores slideshow captions'
Èxit

(oci8po): CREATE SEQUENCE mlslidcapt_id2_seq START WITH 1 INCREMENT BY 1 NOMAXVALUE
Èxit

(oci8po): CREATE TRIGGER mlslidcapt_id2_trg BEFORE INSERT ON mlslideshow_captions FOR EACH ROW BEGIN IF :new.id IS NULL THEN SELECT mlslidcapt_id2_seq.nextval INTO :new.id FROM dual; END IF; END;
Èxit

(oci8po): INSERT INTO mllog_display(module, action, mtable, field) VALUES ('slideshow', 'add', 'slideshow', 'name')
Èxit

(oci8po): INSERT INTO mllog_display(module, action, mtable, field) VALUES ('slideshow', 'update', 'slideshow', 'name')
Èxit

slideshow tables could NOT be set up successfully!
En resposta a LLUIS VALENCIA LOPEZ

Re: Slideshow

per SEBASTIAN CUADRAS JAUME -