Error Reading From Database Moodle 2.3
GNU General Public License, unless otherwise stated. Moodle™ is a registered trademark. Site policy | Contact Help JIRA Core help Keyboard Shortcuts About JIRA JIRA Credits Log In Personal Calendar for Gantt-Charts Download JIRA Client Export Tools MoodleMDL-34676error reading from database (vers 2.3)Log In ExportXMLWordPrintable Details Type: Bug Status: Closed Priority: Minor Resolution: Deferred Affects Version/s: 2.3.1 Fix Version/s: None Component/s: Backup Labels: None Affected Branches: MOODLE_23_STABLE Description We have just upgraded from 1.9 thru 2.2 to 2.3.1 and after that cron was hanging like described http://moodle.org/mod/forum/discuss.php?d=207273. Our Moodle version was 2.3.1 build 2012-07-06. We upgraded to the latest 2.3.1+ weekly build (2012-07-26). Site administration/Registration and Cron command /usr/bin/php /usr/moodle2back/admin/cli/cron.php end now with error (Error reading from database). === Software versions: mysql Ver 14.14 Distrib 5.5.25a, for Linux (x86_64) using readline 5.1 PHP 5.3.15 (cli) (built: Jul 20 2012 13:23:50) Copyright (c) 1997-2012 The PHP Group Zend Engine v2.3.0, Copyright (c) 1998-2012 Zend Technologies Red Hat Enterprise Linux Server release 6.3 (Santiago) === In Debugging mode: [root@ceres moodle23latest]# /usr/bin/php /usr/moodle2back/admin/cli/cron.php Server Time: Tue, 31 Jul 2012 16:04:09 +0300 Created missing context instances Cleaned up stale user sessions Running auth crons if required... Running enrol crons if required... Running cron for enrol_self... Starting activity modules Processing module function assignment_cron ...... used 2 dbqueries ... used 0.009260892868042 seconds done. Processing module function chat_cron ...... used 5 dbqueries ... used 0.0016460418701172 seconds done. Processing module function forum_cron ...Starting digest processing... Cleaned old digest records ... used 3 dbqueries ... used 0.0019478797912598 seconds done. Processing module function
GNU General Public License, unless otherwise stated. Moodle™ is a registered trademark. Site policy | Contact Help JIRA Core help Keyboard Shortcuts About JIRA JIRA Credits Log In Personal Calendar for Gantt-Charts Download JIRA Client Export Tools MoodleMDL-35909Error Reading From DatabaseLog In ExportXMLWordPrintable Details Type: Bug Status: Closed Priority: Major Resolution: Incomplete Affects Version/s: https://tracker.moodle.org/browse/MDL-34676 2.3.2 Fix Version/s: None Component/s: Assignment (2.2) Labels: None Affected Branches: MOODLE_23_STABLE Description This moodle is used as a VLE at a school. All of the work that has been uploaded cannot be accessed by myself. I get the https://tracker.moodle.org/browse/MDL-35909 same 'Error Reading from Database' message each time I try. Debug info: Unknown column 'status' in 'order clause' SELECT u.id,u.picture,u.firstname,u.lastname,u.imagealt,u.email, s.id AS submissionid, s.grade, s.submissioncomment, s.timemodified, s.timemarked FROM mdl_user u LEFT JOIN mdl_assignment_submissions s ON u.id = s.userid AND s.assignment = 1 WHERE u.id IN (84,103,78,88,105,71,70,74,73,75,85,110,109,99,95,100,112,113) ORDER BY status ASC, lastname ASC [array ( )] Stack trace: line 394 of /lib/dml/moodle_database.php: dml_read_exception thrown line 794 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end() line 1321 of /mod/assignment/lib.php: call to mysqli_native_moodle_database->get_records_sql() line 645 of /mod/assignment/lib.php: call to assignment_base->display_submissions() line 369 of /mod/assignment/type/upload/assignment.class.php: call to assignment_base->submissions() line 57 of /mod/assignment/submissions.php: call to assignment_upload->submissions() Gliffy Diagrams Sort Name Modify Date Ascending Descending AttachmentsIssue Links duplicates MDL-29529 Error reading from database - Unkn
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company http://stackoverflow.com/questions/22027840/error-reading-from-database-in-moodle Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, https://community.bitnami.com/t/cannot-upgrade-moodle-database-to-2-5/13771 just like you, helping each other. Join them; it only takes a minute: Sign up 'Error reading from database' in moodle up vote 0 down vote favorite I am restoring a course 26.2MB in size in error reading moodle 2.5 and am getting an 'Error reading from database' error. I am able to successfully restore a course 1.8MB in size. I have been searching around for solutions to my problem and the closest I came to solving it is this thread https://moodle.org/mod/forum/discuss.php?d=230681 but I haven't been able to work out how to set parameters for MySQL as it appears it is related to max_allowed_packet setting in my.cnf file. any help would be error reading from greatly appreciated. The version of PHP I am running is 4.0.8, latest stable version: 4.1.8 and I have access from WHM as well as CP Many thanks. ruth@whitewitch.ie parameters my.cnf share|improve this question asked Feb 25 '14 at 22:44 user3353411 111 Add some code to your question showing exactly where you have problems. –Verdolino Feb 25 '14 at 23:02 add a comment| 2 Answers 2 active oldest votes up vote 1 down vote Just update MySQL :) and run install script again :) share|improve this answer answered May 25 at 13:33 Mohammed Ansari 111 add a comment| up vote 0 down vote I had a similar error ("error reading from database") and after long day unsuccessful search I realised that the drive on which MySql was running had ran out of space. When I freed up space it went back to normal. You have mentioned that you managed to restore a 1.8MB course but failing to restore the 26.2MB. It is most probable that you have limited storage space on your drive. share|improve this answer answered Jun 19 '15 at 12:21 kampangala 12 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Emai
like to update the Moodle version and migrate the site to the new 2.5-1 version (ultimately as a WAMP Moodle module). I've been through the migration process many times in the past, so I've created the following backup files: moodledata backup.sql (and I have the correct password salt for config.php) Now the upgrade process I've been following is: Stop current servers Uninstall current installation version (e.g. 2.3.3-0) Install new version (2.5-1) Replace new moodledata with backup moodledata folder Restore the database using backup.sql Restore the correct password salt in the new config.php file Restart servers With that done, I then access Moodle via the address "localhost/moodle". The first page I land at prompts me to update the Moodle database from 2.x to 2.5. I follow the upgrade prompts until I reach the "Plugins check" page which shows all the plugins to be upgraded. At the bottom of the page I select "Upgrade Moodle database now". The plugins begin updating, but they reach an error which reads: qtype_match
Table "question_match" already exists
More information about this error
Debug info: can not rename table
Error code: ddltablealreadyexists
Stack trace:
line 505 of \lib\ddl\database_manager.php: ddl_exception thrown line 53 of \question\type\match\db\upgrade.php: call to database_manager->rename_table() line 501 of \lib\upgradelib.php: call to xmldb_qtype_match_upgrade() line 1586 of \lib\upgradelib.php: call to upgrade_plugins() line 386 of \admin\index.php: call to upgrade_noncore() My only option is "Continue", which lands me at the front page of my Moodle site. If I attempt to login (with the admin account), it sends me back to the "Plugins check" page and the erroneous loop begins again. Instead of going straight to 2.5-1, I've attempted to upgrade from 2.3.3-0 to 2.4.3-0 and it was completely successful. I even created a database backup file with 2.4.3-0 and attempted to upgrade to 2.5-1 from that and I still received the error detailed above. I've also tried this whole update process using a WAMP Moodle module, instead of a stack, with the very same problem. I even re-downloaded my installers. Tried everything at least twice - can't get past it. This problem is killing me! Any ideas?? (As a workaround for the moment, does anyone have a download link to a Moodle module (not stack) for version 2.3.3-0 or 2.4.3-0?) ctsmoodle 2013-06-06 13:24:00 UTC #2 I also just tried downloading the official Moodle code and extracting it to the BitNami "htdocs" folder and then restarted the servers and attempted to access Moodle in my browser. I received the same error as above, again. victor 2013-06-06 16: