Moodle Upgrade Error Reading From Database
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 moodle error reading from database after upgrade WordPress FAQ WordPress Services Joomla Services Joomla Hosting Superior Joomla Performance Learn More moodle error writing to database Joomla Templates Best Free Joomla Designs Learn More Joomla Tutorial Step-by-step Joomla Guide Learn More More Links: Joomla Extensions About Joomla moodle error code: dmlreadexception Joomla FAQ Joomla Services Our Technology 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: moodle installation error reading from database Instantly Contact Us Chat Reply Time: Instantly Start 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 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 res
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 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 6.2 million programmers, just like you, helping each other. Join 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 https://www.siteground.com/kb/i_just_upgraded_moodle_to_v18_and_now_get_the_following_mess/ 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 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 http://stackoverflow.com/questions/34550808/error-installing-moodle-3-0 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 database in config.php has ALL PRIVILEGES set on that database. Moving on... If this is a fresh install and you have no data to lose, your best bet is to start with a clean database. You can either delete your existing database and set up a new one, or you can drop all tables from your existing database. Option 1. Delete your existing database. Delete your config.php file Jump to phpMyAdmin (from the 'actions' tab on the MySQL process page) Click on "Databases" Delete your existing database Hit "Create database"
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 Business Learn more about hiring developers or posting ads http://stackoverflow.com/questions/26583634/moodle-database-upgrade with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the http://forum.centos-webpanel.com/mysql/error-reading-from-database/ Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Moodle database upgrade up vote -2 down vote favorite I want to upgrade moodle databse from 1.9.5 to moodle 2.7.2. I have one site in moodle 1.9.5 and another in moodle 2.7.2. I want my whole database of moodle 1.9.5 error reading in moodle 2.7.2. I read various docs but all in vain. Please help. moodle share|improve this question edited Oct 27 '14 at 8:40 asked Oct 27 '14 at 8:34 user2978605 32 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote accepted The steps to upgrade from 1.9x to 2.7.2 is an easy process. But before you start the process , please make sure you first do the following Read the release notes for moodle 2.2 and the latest error reading from plugins in it. Backup the full Database. Backup full moodledata. Check the backups carefully. Purge all PHP caches Also check for updated versions of the plugins in moodle 1.9x and download the updated versions before upgrading. Uninstall the plugins not supported by the updated version. Download the latest version of moodle 2.2 from - https://download.moodle.org/releases/legacy/ You should put your site into Maintenance Mode to stop any non-admin users from logging in. Once done, Replace the old code with the newer version code Login to your moodle site , you will get a page to upgrade moodle database or else go to Settings > Site Adminstration > Notifications which will trigger moodle to self-update. Now once the process is completed , you have moodle version 2.2 installed. Download the latest moodle 2.7.2 from - https://download.moodle.org/releases/latest/ Now change the moodle 2.2 code with new moodle 2.7.2 code and continue the process as above. Once the process is over , you will have the moodle upgraded from 1.9x to 2.7.2 Now the Database you have for moodle 2.7.2 is what you need. Backup the database and use it for moodle2.7.2 . If in case you want to use this in your moodle 2.7.2 site after renaming it , just replace the name of your database with this renamed database name in config.php file. Please make sure you import the database back for your moodle 1.9x site and replace the old moodle 1.9x code with new one. share|improve this answer answ
Pages: [1] Author Topic: Error reading from database (Read 621 times) 0 Members and 2 Guests are viewing this topic. squaremedia Newbie Posts: 1 Error reading from database « on: April 20, 2016, 02:17:36 PM » I created db and tried to install website moodle scriptwhen I install it give me Error:Error reading from databaseDML exceptionsplease help me Logged Sandeep Sr. Member Posts: 470 Re: Error reading from database « Reply #1 on: April 20, 2016, 03:53:39 PM » check if mysqli is enabled? (By default it should be enabled)run php -m through ssh it will give you a list of installed modulesyou need to contact the moodle script developers/support. « Last Edit: April 20, 2016, 04:14:23 PM by Sandeep » Logged My Services1- CWP Installation2- Solve PHP issue/upgrade3- Maintenance/Optimization of Server4- Website/Web-Script Installation5- SEO Print Pages: [1] « previous next » CentOS Web Panel » WebPanel » MySQL » Error reading from database SMF 2.0.6 | SMF © 2013, Simple Machines centos-webpanel.com Copyright by 2014 CentOS Web Panel