Moodle Import Error Writing To Database
Contents |
workstation in separate directories. When logging into the site with the root account, I receive Error writing to database. I believe the permissions are correctly set within phpMyAdmin and I also have full administrative rights
Error Writing To Database In Moodle
to the local machine. Lastly, if I attempt to connect to http://*localhost*/admin/settings.php/section=debugging, I receive This moodle 3 error writing to database page can't be displayed. Any suggestions would be appreciated. Thank you in advance. jota 2015-08-03 10:10:21 UTC #2 Hi @Foxnbvr, Did you follow our guide about how to migrate your Moodle? https://wiki.bitnami.com/Applications/BitNami_Moodle#How_to_migrate_your_Moodle_installation.3f I followed it and everything is working fine. I didn't get any "Error writing to database" error. Let us know if it works for you. Jota Foxnbvr 2015-08-03 13:16:51 UTC #3 Yes, I followed the migration guide and the data appears to be there. We attempted both phpMyAdmin and manual steps for importing and exporting the database. Each step was also attempted for versions 2.8.5 and 2.9.1 in addition to multiple fresh installations. jota 2015-08-04 07:29:34 UTC #4 Hi @Foxnbvr, Could you please answer this questions? Did you follow the steps to remove the database, create a new one and grant the privileges to the bitnami user? Did you set the password that is in the htdocs/config.php file? Did you get any issue if you recover the backup manually? Could you please create a new backup (start all the process again) and try to recover the new backup? I don't know if you got any issues when you create the other backup. I hope it helps. Jota Foxnbvr 2015-08-05 14:47:04 UTC #5 I followed all the steps again and everything appears to be working now. It seemed to be a combination of a bad back backup and performing the export and import manually, as opposed through phpMyAdmin. One step that was not in the migration documentation was copying the salt option from the old version to the new. Thanks again for you assistance. jota 2015-08-06 07:08:02 UTC #6 Hi @Foxnbvr, I'm glad to hear that your problem was solved. Thanks for letting us know that info for the migration, we'll review the wiki. Don't hesitate to contact us if you have any more questions. Jota Home Categories FAQ/Guidelines Terms of Service Privacy Policy Powered by Discourse, best viewed with JavaScript enabled Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!
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 writing to database in moodle https://community.bitnami.com/t/error-writing-to-database-version-2-8-5/35987 up vote -1 down vote favorite I want to customize some strings into moodle. so when i clicked on open language pack for editing it will run till 69% and thowing an error "Error writing to database" Error/moodle/dmlwriteexception This indicates that a general error occurred when Moodle tried to write to the database. If you turn on Debugging you will get more detailed information about what http://stackoverflow.com/questions/28605080/error-writing-to-database-in-moodle the problem is. MySQL If you're using a MySQL database for your Moodle installation, this error can be caused by the server's max_allowed_packet size being configured incorrectly. Increasing this value may resolve the issue. I have tried to increase the value of max_allowed_packet 1M to 100M but still getting the same error. Please help me moodle share|improve this question edited Feb 19 '15 at 11:49 asked Feb 19 '15 at 11:22 user3395812 613 Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. –jurgemaister Feb 19 '15 at 11:24 Edit your question. –jurgemaister Feb 19 '15 at 11:33 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote Its probably a custom plugin with an incorrect string id in the language file - https://moodle.org/mod/forum/discuss.php?d=222815 Try uninstalling any custom modules then trying again with the language customisation until you can identify which custom plugin is causing the issue. share|improve this answer answered Feb 19 '15 at 15:07 Russell England 5,1851926
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 http://stackoverflow.com/questions/26583634/moodle-database-upgrade 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 Moodle database upgrade up vote -2 down vote favorite error writing 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 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 error writing to 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 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 ove