You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@openmeetings.apache.org by Michael Wuttke <mi...@beuth-hochschule.de> on 2016/05/09 12:20:18 UTC

two issues with the openmeetings moodle plugin (2.0.0.1)

Hello Maxim,

I have found two issues installing the new openmeetings moodle plugin
(version 2.0.0.1). I tested to upgrade from version 1.7.5 of the plugin
on moodle 2.9 and moodle 3.0.

1. the change of the plugin settings strings: the renaming of the
settings strings during the update cause that the settings are set to
default and not taken from the previous local/costum installation.

2. the change of the field typ called 'typ' on mdl_openmeetings from int 
to character varying(16): creating new rooms after the upgrade will end 
up with the
following error:

Debug info: FEHLER: ung�ltige Eingabesyntax f�r ganze Zahl: \u201econference\u201c
INSERT INTO mdl_openmeetings
(name,room_id,type,max_user,language,is_moderated_room,allow_recording,whole_window,room_recording_id,course,intro)
VALUES($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11) RETURNING id
[array (
'name' => 'test room moodle29 conference inframe',
'room_id' => 54,
'type' => 'conference',
'max_user' => '2',
'language' => '1',
'is_moderated_room' => '1',
'allow_recording' => '1',
'whole_window' => '0',
'room_recording_id' => '9',
'course' => '2',
'intro' => '<p>test room moodle29 conference inframe<br></p>',
)]
Error code: dmlwriteexception
Stack trace:

     line 446 of /lib/dml/moodle_database.php: dml_write_exception thrown
     line 244 of /lib/dml/pgsql_native_moodle_database.php: call to
moodle_database->query_end()
     line 868 of /lib/dml/pgsql_native_moodle_database.php: call to
pgsql_native_moodle_database->query_end()
     line 924 of /lib/dml/pgsql_native_moodle_database.php: call to
pgsql_native_moodle_database->insert_record_raw()
     line 132 of /mod/openmeetings/lib.php: call to
pgsql_native_moodle_database->insert_record()
     line 121 of /course/modlib.php: call to openmeetings_add_instance()
     line 274 of /course/modedit.php: call to add_moduleinfo()

Could you have a look at the plugin again, please?

Thanks & Greetings,
Michael

Re: two issues with the openmeetings moodle plugin (2.0.0.1)

Posted by Michael Wuttke <mw...@beuth-hochschule.de>.
Hello Maxim,

thankls a lot. I wll test the latest version of the plugin ASP.

Greetings,
Michael

Am 18.05.2016 um 17:01 schrieb Maxim Solodovnik:
> It seems I have fixed part 1 of this issue
> fixed, closed :)
> 
> On Mon, May 9, 2016 at 7:13 PM, Maxim Solodovnik <solomax666@gmail.com
> <ma...@gmail.com>> wrote:
> 
>     Hello Michael,
> 
>     will try to take a look at these issues, it seems some additional
>     update script need to be written
> 
>     On Mon, May 9, 2016 at 6:20 PM, Michael Wuttke
>     <michael.wuttke@beuth-hochschule.de
>     <ma...@beuth-hochschule.de>> wrote:
> 
>         Hello Maxim,
> 
>         I have found two issues installing the new openmeetings moodle
>         plugin
>         (version 2.0.0.1). I tested to upgrade from version 1.7.5 of the
>         plugin
>         on moodle 2.9 and moodle 3.0.
> 
>         1. the change of the plugin settings strings: the renaming of the
>         settings strings during the update cause that the settings are
>         set to
>         default and not taken from the previous local/costum installation.
> 
>         2. the change of the field typ called 'typ' on mdl_openmeetings
>         from int to character varying(16): creating new rooms after the
>         upgrade will end up with the
>         following error:
> 
>         Debug info: FEHLER: ung�ltige Eingabesyntax f�r ganze Zahl:
>         \u201econference\u201c
>         INSERT INTO mdl_openmeetings
>         (name,room_id,type,max_user,language,is_moderated_room,allow_recording,whole_window,room_recording_id,course,intro)
>         VALUES($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11) RETURNING id
>         [array (
>         'name' => 'test room moodle29 conference inframe',
>         'room_id' => 54,
>         'type' => 'conference',
>         'max_user' => '2',
>         'language' => '1',
>         'is_moderated_room' => '1',
>         'allow_recording' => '1',
>         'whole_window' => '0',
>         'room_recording_id' => '9',
>         'course' => '2',
>         'intro' => '<p>test room moodle29 conference inframe<br></p>',
>         )]
>         Error code: dmlwriteexception
>         Stack trace:
> 
>             line 446 of /lib/dml/moodle_database.php:
>         dml_write_exception thrown
>             line 244 of /lib/dml/pgsql_native_moodle_database.php: call to
>         moodle_database->query_end()
>             line 868 of /lib/dml/pgsql_native_moodle_database.php: call to
>         pgsql_native_moodle_database->query_end()
>             line 924 of /lib/dml/pgsql_native_moodle_database.php: call to
>         pgsql_native_moodle_database->insert_record_raw()
>             line 132 of /mod/openmeetings/lib.php: call to
>         pgsql_native_moodle_database->insert_record()
>             line 121 of /course/modlib.php: call to
>         openmeetings_add_instance()
>             line 274 of /course/modedit.php: call to add_moduleinfo()
> 
>         Could you have a look at the plugin again, please?
> 
>         Thanks & Greetings,
>         Michael
> 
> 
> 
> 
>     -- 
>     WBR
>     Maxim aka solomax
> 
> 
> 
> 
> -- 
> WBR
> Maxim aka solomax

Re: two issues with the openmeetings moodle plugin (2.0.0.1)

Posted by Maxim Solodovnik <so...@gmail.com>.
Great!
Thanks for the testing!

WBR, Maxim
(from mobile, sorry for the typos)
On May 19, 2016 15:35, "Michael Wuttke" <mw...@beuth-hochschule.de> wrote:

> Hello Maxim,
>
> I've tested the latest version of the plugin (2.0.0.3) and (comming from
> version 1.7.5) the upgrade process works as expected with the moodle
> versions 2.9, 3.0 & the upcoming 3.1 (rc-1) on postgresql 9.5. ;-)
>
> Thanks a lot & Greetings,
> Michael
>
> Am 18.05.2016 um 17:01 schrieb Maxim Solodovnik:
> > It seems I have fixed part 1 of this issue
> > fixed, closed :)
> >
> > On Mon, May 9, 2016 at 7:13 PM, Maxim Solodovnik <solomax666@gmail.com
> > <ma...@gmail.com>> wrote:
> >
> >     Hello Michael,
> >
> >     will try to take a look at these issues, it seems some additional
> >     update script need to be written
> >
> >     On Mon, May 9, 2016 at 6:20 PM, Michael Wuttke
> >     <michael.wuttke@beuth-hochschule.de
> >     <ma...@beuth-hochschule.de>> wrote:
> >
> >         Hello Maxim,
> >
> >         I have found two issues installing the new openmeetings moodle
> >         plugin
> >         (version 2.0.0.1). I tested to upgrade from version 1.7.5 of the
> >         plugin
> >         on moodle 2.9 and moodle 3.0.
> >
> >         1. the change of the plugin settings strings: the renaming of the
> >         settings strings during the update cause that the settings are
> >         set to
> >         default and not taken from the previous local/costum
> installation.
> >
> >         2. the change of the field typ called 'typ' on mdl_openmeetings
> >         from int to character varying(16): creating new rooms after the
> >         upgrade will end up with the
> >         following error:
> >
> >         Debug info: FEHLER: ungültige Eingabesyntax für ganze Zahl:
> >         „conference“
> >         INSERT INTO mdl_openmeetings
> >
>  (name,room_id,type,max_user,language,is_moderated_room,allow_recording,whole_window,room_recording_id,course,intro)
> >         VALUES($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11) RETURNING id
> >         [array (
> >         'name' => 'test room moodle29 conference inframe',
> >         'room_id' => 54,
> >         'type' => 'conference',
> >         'max_user' => '2',
> >         'language' => '1',
> >         'is_moderated_room' => '1',
> >         'allow_recording' => '1',
> >         'whole_window' => '0',
> >         'room_recording_id' => '9',
> >         'course' => '2',
> >         'intro' => '<p>test room moodle29 conference inframe<br></p>',
> >         )]
> >         Error code: dmlwriteexception
> >         Stack trace:
> >
> >             line 446 of /lib/dml/moodle_database.php:
> >         dml_write_exception thrown
> >             line 244 of /lib/dml/pgsql_native_moodle_database.php: call
> to
> >         moodle_database->query_end()
> >             line 868 of /lib/dml/pgsql_native_moodle_database.php: call
> to
> >         pgsql_native_moodle_database->query_end()
> >             line 924 of /lib/dml/pgsql_native_moodle_database.php: call
> to
> >         pgsql_native_moodle_database->insert_record_raw()
> >             line 132 of /mod/openmeetings/lib.php: call to
> >         pgsql_native_moodle_database->insert_record()
> >             line 121 of /course/modlib.php: call to
> >         openmeetings_add_instance()
> >             line 274 of /course/modedit.php: call to add_moduleinfo()
> >
> >         Could you have a look at the plugin again, please?
> >
> >         Thanks & Greetings,
> >         Michael
> >
> >
> >
> >
> >     --
> >     WBR
> >     Maxim aka solomax
> >
> >
> >
> >
> > --
> > WBR
> > Maxim aka solomax
>

Re: two issues with the openmeetings moodle plugin (2.0.0.1)

Posted by Michael Wuttke <mw...@beuth-hochschule.de>.
Hello Maxim,

I've tested the latest version of the plugin (2.0.0.3) and (comming from
version 1.7.5) the upgrade process works as expected with the moodle
versions 2.9, 3.0 & the upcoming 3.1 (rc-1) on postgresql 9.5. ;-)

Thanks a lot & Greetings,
Michael

Am 18.05.2016 um 17:01 schrieb Maxim Solodovnik:
> It seems I have fixed part 1 of this issue
> fixed, closed :)
> 
> On Mon, May 9, 2016 at 7:13 PM, Maxim Solodovnik <solomax666@gmail.com
> <ma...@gmail.com>> wrote:
> 
>     Hello Michael,
> 
>     will try to take a look at these issues, it seems some additional
>     update script need to be written
> 
>     On Mon, May 9, 2016 at 6:20 PM, Michael Wuttke
>     <michael.wuttke@beuth-hochschule.de
>     <ma...@beuth-hochschule.de>> wrote:
> 
>         Hello Maxim,
> 
>         I have found two issues installing the new openmeetings moodle
>         plugin
>         (version 2.0.0.1). I tested to upgrade from version 1.7.5 of the
>         plugin
>         on moodle 2.9 and moodle 3.0.
> 
>         1. the change of the plugin settings strings: the renaming of the
>         settings strings during the update cause that the settings are
>         set to
>         default and not taken from the previous local/costum installation.
> 
>         2. the change of the field typ called 'typ' on mdl_openmeetings
>         from int to character varying(16): creating new rooms after the
>         upgrade will end up with the
>         following error:
> 
>         Debug info: FEHLER: ung�ltige Eingabesyntax f�r ganze Zahl:
>         \u201econference\u201c
>         INSERT INTO mdl_openmeetings
>         (name,room_id,type,max_user,language,is_moderated_room,allow_recording,whole_window,room_recording_id,course,intro)
>         VALUES($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11) RETURNING id
>         [array (
>         'name' => 'test room moodle29 conference inframe',
>         'room_id' => 54,
>         'type' => 'conference',
>         'max_user' => '2',
>         'language' => '1',
>         'is_moderated_room' => '1',
>         'allow_recording' => '1',
>         'whole_window' => '0',
>         'room_recording_id' => '9',
>         'course' => '2',
>         'intro' => '<p>test room moodle29 conference inframe<br></p>',
>         )]
>         Error code: dmlwriteexception
>         Stack trace:
> 
>             line 446 of /lib/dml/moodle_database.php:
>         dml_write_exception thrown
>             line 244 of /lib/dml/pgsql_native_moodle_database.php: call to
>         moodle_database->query_end()
>             line 868 of /lib/dml/pgsql_native_moodle_database.php: call to
>         pgsql_native_moodle_database->query_end()
>             line 924 of /lib/dml/pgsql_native_moodle_database.php: call to
>         pgsql_native_moodle_database->insert_record_raw()
>             line 132 of /mod/openmeetings/lib.php: call to
>         pgsql_native_moodle_database->insert_record()
>             line 121 of /course/modlib.php: call to
>         openmeetings_add_instance()
>             line 274 of /course/modedit.php: call to add_moduleinfo()
> 
>         Could you have a look at the plugin again, please?
> 
>         Thanks & Greetings,
>         Michael
> 
> 
> 
> 
>     -- 
>     WBR
>     Maxim aka solomax
> 
> 
> 
> 
> -- 
> WBR
> Maxim aka solomax

Re: two issues with the openmeetings moodle plugin (2.0.0.1)

Posted by Maxim Solodovnik <so...@gmail.com>.
It seems I have fixed part 1 of this issue
fixed, closed :)

On Mon, May 9, 2016 at 7:13 PM, Maxim Solodovnik <so...@gmail.com>
wrote:

> Hello Michael,
>
> will try to take a look at these issues, it seems some additional update
> script need to be written
>
> On Mon, May 9, 2016 at 6:20 PM, Michael Wuttke <
> michael.wuttke@beuth-hochschule.de> wrote:
>
>> Hello Maxim,
>>
>> I have found two issues installing the new openmeetings moodle plugin
>> (version 2.0.0.1). I tested to upgrade from version 1.7.5 of the plugin
>> on moodle 2.9 and moodle 3.0.
>>
>> 1. the change of the plugin settings strings: the renaming of the
>> settings strings during the update cause that the settings are set to
>> default and not taken from the previous local/costum installation.
>>
>> 2. the change of the field typ called 'typ' on mdl_openmeetings from int
>> to character varying(16): creating new rooms after the upgrade will end up
>> with the
>> following error:
>>
>> Debug info: FEHLER: ungültige Eingabesyntax für ganze Zahl: „conference“
>> INSERT INTO mdl_openmeetings
>>
>> (name,room_id,type,max_user,language,is_moderated_room,allow_recording,whole_window,room_recording_id,course,intro)
>> VALUES($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11) RETURNING id
>> [array (
>> 'name' => 'test room moodle29 conference inframe',
>> 'room_id' => 54,
>> 'type' => 'conference',
>> 'max_user' => '2',
>> 'language' => '1',
>> 'is_moderated_room' => '1',
>> 'allow_recording' => '1',
>> 'whole_window' => '0',
>> 'room_recording_id' => '9',
>> 'course' => '2',
>> 'intro' => '<p>test room moodle29 conference inframe<br></p>',
>> )]
>> Error code: dmlwriteexception
>> Stack trace:
>>
>>     line 446 of /lib/dml/moodle_database.php: dml_write_exception thrown
>>     line 244 of /lib/dml/pgsql_native_moodle_database.php: call to
>> moodle_database->query_end()
>>     line 868 of /lib/dml/pgsql_native_moodle_database.php: call to
>> pgsql_native_moodle_database->query_end()
>>     line 924 of /lib/dml/pgsql_native_moodle_database.php: call to
>> pgsql_native_moodle_database->insert_record_raw()
>>     line 132 of /mod/openmeetings/lib.php: call to
>> pgsql_native_moodle_database->insert_record()
>>     line 121 of /course/modlib.php: call to openmeetings_add_instance()
>>     line 274 of /course/modedit.php: call to add_moduleinfo()
>>
>> Could you have a look at the plugin again, please?
>>
>> Thanks & Greetings,
>> Michael
>>
>
>
>
> --
> WBR
> Maxim aka solomax
>



-- 
WBR
Maxim aka solomax

Re: two issues with the openmeetings moodle plugin (2.0.0.1)

Posted by Maxim Solodovnik <so...@gmail.com>.
Hello Michael,

will try to take a look at these issues, it seems some additional update
script need to be written

On Mon, May 9, 2016 at 6:20 PM, Michael Wuttke <
michael.wuttke@beuth-hochschule.de> wrote:

> Hello Maxim,
>
> I have found two issues installing the new openmeetings moodle plugin
> (version 2.0.0.1). I tested to upgrade from version 1.7.5 of the plugin
> on moodle 2.9 and moodle 3.0.
>
> 1. the change of the plugin settings strings: the renaming of the
> settings strings during the update cause that the settings are set to
> default and not taken from the previous local/costum installation.
>
> 2. the change of the field typ called 'typ' on mdl_openmeetings from int
> to character varying(16): creating new rooms after the upgrade will end up
> with the
> following error:
>
> Debug info: FEHLER: ungültige Eingabesyntax für ganze Zahl: „conference“
> INSERT INTO mdl_openmeetings
>
> (name,room_id,type,max_user,language,is_moderated_room,allow_recording,whole_window,room_recording_id,course,intro)
> VALUES($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11) RETURNING id
> [array (
> 'name' => 'test room moodle29 conference inframe',
> 'room_id' => 54,
> 'type' => 'conference',
> 'max_user' => '2',
> 'language' => '1',
> 'is_moderated_room' => '1',
> 'allow_recording' => '1',
> 'whole_window' => '0',
> 'room_recording_id' => '9',
> 'course' => '2',
> 'intro' => '<p>test room moodle29 conference inframe<br></p>',
> )]
> Error code: dmlwriteexception
> Stack trace:
>
>     line 446 of /lib/dml/moodle_database.php: dml_write_exception thrown
>     line 244 of /lib/dml/pgsql_native_moodle_database.php: call to
> moodle_database->query_end()
>     line 868 of /lib/dml/pgsql_native_moodle_database.php: call to
> pgsql_native_moodle_database->query_end()
>     line 924 of /lib/dml/pgsql_native_moodle_database.php: call to
> pgsql_native_moodle_database->insert_record_raw()
>     line 132 of /mod/openmeetings/lib.php: call to
> pgsql_native_moodle_database->insert_record()
>     line 121 of /course/modlib.php: call to openmeetings_add_instance()
>     line 274 of /course/modedit.php: call to add_moduleinfo()
>
> Could you have a look at the plugin again, please?
>
> Thanks & Greetings,
> Michael
>



-- 
WBR
Maxim aka solomax