Error Reading From Database In Moodle
Contents |
General help /► Error reading from database Moodle 2.3.1 Moodle in English General helpError reading from database Moodle 2.3.1Restoring Course in 2.4 without User DataMenus - Balance of functionalityDisplay modeDisplay replies flat, with oldest firstDisplay replies flat, with newest firstDisplay replies in threaded moodle error reading from database after upgrade formDisplay replies in nested formError reading from database Moodle 2.3.1Tracey CollinsWednesday, 8 August 2012,
Error Writing To Database In Moodle
12:44 PMHi, I am running Moodle 2.3.1 (Build: 20120726) and have received the following error when trying to restore a course from a moodle error database connection failed backup. When I click on the More information link, I get the following message: I have purged all caches and the problem has persisted. I have been able to successfully restore another backup file in the same create database moodle install of Moodle. The backup file that is causing the problem has also been used successfully on a number of previous occassions. The same error message also appears if I select Site Administration/Registration: Does anyone know why this error is appearing and what I can do to overcome it? Thanks, TraceyAverage of ratings: - Permalink | ReplyRe: Error reading from database Moodle 2.3.1Ken TaskWednesday, 8 August 2012, 2:04 PMBy chance, are you restoring
Moodle 3 Error Reading From Database
and changing course name/details in order to replicate? At what point in the restore process does this happen? Might turn on debug. 'spirit of sharing', KenAverage of ratings: - Permalink | Show parent | ReplyRe: Error reading from database Moodle 2.3.1Tracey CollinsWednesday, 8 August 2012, 4:39 PMHi Ken, Yes, I am changing the course name and details in order to replicate the file (ie we are using it as a template). I get all the way through the restore process and then the 'error reading from database' message comes up when you would normally see the message saying you have been succesful. I did turn on debug and our tech person had a look at the messages, but he checked all of the settings etc that were identified and couldn't find any problems in our database setup. Thanks TraceyAverage of ratings: - Permalink | Show parent | ReplyRe: Error reading from database Moodle 2.3.1Ken TaskWednesday, 8 August 2012, 8:51 PMCheck the moodle data folder/temp/backup/ for .log files. Files with 0 bytes means successful backup/restores. Dot log files greater than 0 bytes might give hints as to issue. Might find a hashed named folder or files also contained therein. Look through them via 'head' via command line (if you have one of those flavored boxen with the ability). Example: head 26054d2fda7ae23656e3ab
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the moodle error code: dmlreadexception workings and policies of this site About Us Learn more about Stack moodle installation error reading from database Overflow the company 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, just like you, helping each other. Join https://moodle.org/mod/forum/discuss.php?d=208642 them; it only takes a minute: Sign up Error installing Moodle 3.0 up vote 0 down vote favorite I am unable to complete Moodle installation. I am hosting the site on NearlyFreeSpeech and using PHP 5.6. Moodle doesnt seem to be able to connect to the database and write any tables. I created the moodledata folder in /protected/moodledata and moodle http://stackoverflow.com/questions/34550808/error-installing-moodle-3-0 is in /public/moodle I receive this error after accepting the terms and conditions. Error reading from database More information about this error It is usually not possible to recover from errors triggered during installation, you may need to create a new database or use a different database prefix if you want to retry the installation. moodle php-5.6 share|improve this question asked Dec 31 '15 at 19:23 Matt P 206149 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote Normally my first instinct would point to the config.php file but if it's getting as far as telling you that a connection is established with the database but there's a read error ("Error reading from database"), then that generally means your config.php file is probably healthy, but your database is not. Firstly, check that you're using one of the following database servers that Moodle is compatible with (minimum version) PostgreSQL 9.1 MySQL 5.5.31 MariaDB 5.5.31 Microsoft SQL Server 2008 Oracle Database 10.2 source. Secondly, ensure that the user assigned to access your da
Management Learn More WordPress Services WordPress Hosting Superior WordPress Performance Learn More WordPress Themes Best Free WordPress Designs Learn More WordPress Tutorial Step-by-step WordPress Guide Learn More More Links: WordPress Plugins About WordPress WordPress FAQ WordPress Services https://www.siteground.com/kb/i_just_upgraded_moodle_to_v18_and_now_get_the_following_mess/ Joomla Services Joomla Hosting Superior Joomla Performance Learn More Joomla Templates Best Free Joomla Designs Learn More Joomla Tutorial Step-by-step Joomla Guide Learn More More Links: Joomla Extensions About Joomla Joomla FAQ Joomla Services Our Technology https://github.com/arael/moodle_notifications_20/issues/20 Datacenters Data Centers Top Speed Solutions Speed Technology Total Uptime 99.99% Monthly Uptime 99.999% Yearly Uptime 99.996% Uptime Technology Our Support 24/7 Amazingly Fast Support Phone Reply Time: Instantly Contact Us Chat Reply Time: Instantly Start error reading Chat Tickets First Reply: 10 Minutes Post Ticket Support Team Devotion 100% Advanced Expertise Always Ready To Help Our Support About Us See Our Faces Meet the SiteGround People! Learn More See Our Values Get to know our guiding principles! Learn More Read Our Blog Learn what's cooking! Learn More Read Client Reviews What our clients think of us. Learn More Affiliates Home / Other Applications / Moodle FAQ / After Moodle error reading from upgrade there is an error After Moodle upgrade there is an error In this case first check if the database details have been correctly specified in config.php. For this purpose Open the File Manager in your cPanel and navigate to the config.php file. The file should reside in the main Moodle folder. Once you find it, click on it and from the top menu choose Edit. Look through it and find the directives that describe the database details: $CFG->dbtype = 'mysql' ; $CFG->dbhost = 'localhost' ; $CFG->dbname = 'database' ; $CFG->dbuser = 'username' ; $CFG->dbpass = 'password' ; Make sure they are correct. You can add a new user to your database through the MySQL Databases section in the cPanel. Please click here to find more information on how to manage your databases. If this solution does not help, perhaps the database got corrupted during the upgrade process. In case you upgraded the Moodle through Fantastico, please click here to see how to restore a Fantastico backup. Otherwise, you have to restore the Moodle from your local backup (if any) or open a "backup restore" ticket. To do so, go to: Customers' Area --> Get Support --> Report a hosting related issue --> Back-up restore Note that additional
Sign in Pricing Blog Support Search GitHub This repository Watch 5 Star 11 Fork 7 arael/moodle_notifications_20 Code Issues 4 Pull requests 0 Projects 0 Pulse Graphs New issue 'Error reading from database' #20 Open jojoob opened this Issue Jun 5, 2015 · 2 comments Projects None yet Labels None yet Milestone No milestone Assignees No one assigned 2 participants jojoob commented Jun 5, 2015 I've installed the latest version (2015052800) from github under Moodle 2.9. When executing the cron task I got the error message Task failed: Error reading from database. After troubleshooting I found out the error was produced by the SQL query executed in https://github.com/arael/moodle_notifications_20/blob/master/classes/Course.php#L384: invalid input syntax for integer: "pending" I changed pending to 0 but however no notifications are send. The return result of the query is empty... Owner arael commented Jul 29, 2015 I have tested the last version on the Moodle 2.9 and it seems to me that everything is working fine. Have you solved this problem? Any additional info on how can replicate the bug? jojoob commented Aug 20, 2015 Just tested again with Moodle 2.9.0 and head of master branch of this plugin. Cron task fails: ****** notifications :: begin ****** Number of courses using the block: 1 --> Processing course: Test Course 1... used 25 dbqueries ... used 0.031059980392456 seconds Scheduled task failed: Block Notifications Task,Error reading from database I'm using PostgreSQL version 9.3+154 Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment Contact GitHub API Training Shop Blog About © 2016 GitHub, Inc. Terms Privacy Security Status Help You can't perform that action at this time. You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.