Comments

• 

  Frankie Kam

  Sun, 14 Apr 2013, 6:39 PM

  Hiya. I've installed Quickmail on my Moodle 2.4 site. On the block. when I click the link "Compose new message", I get this error message: "Error reading from database". Please help. Any pointers to how to solve this is much appreciated. Quickmail is an essential communication tool for my Moodle site. I used it extensively on my Moodle 1.9.16 site, and so I am sorely missing this functionality in Moodle 2.4. Help!?
• 

  Peter Jonker

  Wed, 17 Apr 2013, 6:50 PM

  Also installed on 2.4.3 and having the same message as Frankie. When can we expect an updated version for 2.4 / 2.5 maybe. Thanks again for the good work! Debug info: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
  SELECT * FROM mdl_role WHERE id IN ()
  [array (
  )]
  Error code: dmlreadexception
  Stack trace:
  • line 426 of /lib/dml/moodle_database.php: dml_read_exception thrown
  • line 1023 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
  • line 1211 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
  • line 69 of /blocks/quickmail/email.php: call to moodle_database->get_records_select()
  
• 

  Amanda Doughty

  Tue, 23 Apr 2013, 7:38 PM

  Role names are not showing up in Role Filter (Compose an email). If a role has an alias then it shows, otherwise you get a blank value.
• 

  Amanda Doughty

  Thu, 25 Apr 2013, 6:35 PM

  Patch for the above is here: https://tracker.moodle.org/browse/CONTRIB-4278
• 

  Shwu-Fen Kuo

  Tue, 14 May 2013, 2:36 PM

  Dear,
  Our moodle is v2.4.3, I download the quickmail v1.2.8 (2012061112) for Moodle 2.1, 2.2, 2.3.
  Debugging mode is turn on, after install it, the message is shown:
  -------------------
  The block quickmail does not define the standard capability block/quickmail:addinstance
  line 598 of /blocks/moodleblock.class.php: call to debugging()
  line 576 of /blocks/moodleblock.class.php: call to block_base->has_add_block_capability()
  line 1088 of /lib/blocklib.php: call to block_base->user_can_addto()
  line 1045 of /lib/blocklib.php: call to block_manager->user_can_delete_block()
  line 248 of /blocks/moodleblock.class.php: call to block_manager->edit_controls()
  line 953 of /lib/blocklib.php: call to block_base->get_content_for_output()
  line 1005 of /lib/blocklib.php: call to block_manager->create_block_contents()
  line 353 of /lib/blocklib.php: call to block_manager->ensure_content_created()
  line 6 of /theme/canvas/layout/general.php: call to block_manager->region_has_content()
  line 804 of /lib/outputrenderers.php: call to include()
  line 734 of /lib/outputrenderers.php: call to core_renderer->render_page_layout()
  line 240 of /course/view.php: call to core_renderer->header()
  -------------------
  And I have patched CONTRIB-4278 above, the error message is still displaied when I click "Compose New Email"
  Debug info: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
  SELECT * FROM mdl_role WHERE id IN ()
  [array (
  )]
  Error code: dmlreadexception
  
  how to solve?
  
  Thanks.
  
• 

  Chris Lewis

  Wed, 15 May 2013, 11:52 PM

  We have been using the dev version (https://github.com/lsuits/quickmail/tree/2.4_DEV) of this block on Moodle 2.4.3 for a little while with very few problems. I am not sure that I'd use it in production, but it might work in a pinch to get you through.
• 

  Owen Grubbs

  Fri, 17 May 2013, 8:33 PM

  I got the "Error reading from database" message today. We are just beginning to pilot Moodle 2.3, but I don't remember having any issues with Quickmail when I installed and tested back in February.
  
  Moodle version 2.3.3+ (Build: 20121123)
  Quickmail $plugin->version = 2012061112;
  
  Debug info: SQLState: 42000
  
  Error Code: 102
  
  Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near ')'.
  
  
  SELECT * FROM mdl_role WHERE id IN ()
  [array (
  )]
  Error code: dmlreadexception
  Stack trace:
  
  line 407 of \lib\dml\moodle_database.php: dml_read_exception thrown
  line 258 of \lib\dml\sqlsrv_native_moodle_database.php: call to moodle_database->query_end()
  line 365 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->query_end()
  line 777 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->do_query()
  line 812 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->get_recordset_sql()
  line 1189 of \lib\dml\moodle_database.php: call to sqlsrv_native_moodle_database->get_records_sql()
  line 69 of \blocks\quickmail\email.php: call to moodle_database->get_records_select()
  
  I seemed to have fixed the problem by going to Site Administration > Plugins > Blocks > Quickmail. I noticed that "Roles to filter by" had no roles selected, so I selected the three that are listed as default under the box (Teacher; Non-editing tearcher, Student), and saved changes.
  
  The "Error reading from database" message went away. Hopefully my problem is fixed.
  
• 

  Owen Grubbs

  Fri, 17 May 2013, 10:12 PM

  Quickmail $plugin->version = 2012061112;
  
  Is there a fix for the problem where the Potential boxes on the compose screen are chopped off on the right side of the screen?
  
• 

  Daniel Kaelin

  Thu, 30 May 2013, 3:21 AM

  The 2.4 dev build from github fixes the error reading from database for me.
  
  I didn't have any option but to push it to production.
  
  I'll be looking forward to the official release for 2.4 and 2.5
• 

  Owen Grubbs

  Thu, 30 May 2013, 9:42 PM

  Moodle version 2.3.3+ (Build: 20121123)
  Quickmail $plugin->version = 2012061112
  
  File attachments aren't being sent with email. Is this a config issue? They are not being blocked on the receiving end.
• 

  Daniel Méthot

  Wed, 12 June 2013, 4:43 PM

  Hello,
  When will we have the version for Moodle 2.4 and 2.5?
  thank you
  Daniel
• 

  Donna Hrynkiw

  Thu, 13 June 2013, 1:35 AM

  I found this, posted at github a couple of months ago by someone with LSU listed in his/her organizations: "we are about to switch into upgrade mode here, eying a move to 2.4 or 2.5 late in summer. That means that everything we maintain, including QM, will be made up to date soon."
  
  https://github.com/lsuits/quickmail/issues/84
• 

  Buddy Ethridge

  Tue, 25 June 2013, 11:13 PM

  Hi all,
  
  I'm sorry for the lack of response from LSU on this thread recently. Philip Cali, the former lead developer on the Quickmail project, no longer works for LSU. While he has valiantly tried to keep up with the emails that he receives regarding Quickmail, it does not and should not fall to him to continue to maintain a page for a block which he no longer works on. I have updated the maintainers for this block and we will be more active in responding to posts and questions.
  
  We are indeed in the midst of upgrading to 2.5. Jason Peak did quite a bit of updating Quickmail yesterday and is in the process of pushing the newest version to Moodle.org. While wevwill do our best to be responsive on this thread, the easiest way to report issues and to follow Quickmail development is by accessing our github repository, found here: https://github.com/lsuits/quickmail.
  
  Best regards,
  Buddy
• 

  Donna Hrynkiw

  Thu, 27 June 2013, 12:28 AM

  Thanks for the update (both informational and software release), and also thanks for the link to more information. Much appreciated.
• 

  Donna Hrynkiw

  Sat, 13 July 2013, 3:20 AM

  Quickmail FERPA Mode / Separate Groups setup in Moodle Forums https://moodle.org/mod/forum/discuss.php?d=232431