Moodle Upgrade Error Writing To 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 moodle 3 error writing to database developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question error/moodle/dmlwriteexception 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; mysql max_packet_size it only takes a minute: Sign up Error writing to database in moodle 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 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 add a comment| up vote 0 down vote Try putting the following settings in your config.php: @ini_set('display_errors', '1'); // NOT FOR PRODUCTION SERVERS! $CFG->debug = 32767; // NOT FOR PRODUCTION SERVERS! // for Moodle 2.0 - 2.2, use: $CFG->debug = 38911; $CFG->debugdisplay = true; // NOT FOR PRODUCTION SERVERS! That should tell you more about the query that is causing the error, and help resolve your problem. When your'e done with debugging please remove these lines, since they may cause a se
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 http://stackoverflow.com/questions/28605080/error-writing-to-database-in-moodle 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Error writing to database-Moodle up vote 0 down vote favorite I have a page in Moodle where a user can add consecutive rows through JQuery and each time the Save button is clicked, the data entered http://stackoverflow.com/questions/31276065/error-writing-to-database-moodle in the form will be written to the database but i'm getting these error messages: 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 order) VALUES('1','Introduction Audio 1','1')' at line 1 INSERT INTO mobile (week,title,order) VALUES(?,?,?) [array ( 0 => 1, 1 => 'Introduction Audio 1', 2 => '1', )] The form to which consecutive rows is being appended:
The JQuery codes: script jQuery(function(){ var counter = 1; jQuery('span.add-row').click(function(event){ event.preventDefault(); counter++; var newRow = jQuery('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 https://community.bitnami.com/t/error-writing-to-database-version-2-8-5/35987 to the local machine. Lastly, if I attempt to connect to http://*localhost*/admin/settings.php/section=debugging, I receive This https://github.com/arael/moodle_notifications_20/issues/25 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. error writing 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 error writing to 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!
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 writing to database on a PostgreSQL installation while upgrading to Moodle 3.0 #25 Open oelker opened this Issue Jun 13, 2016 · 0 comments Projects None yet Labels None yet Milestone No milestone Assignees No one assigned 1 participant oelker commented Jun 13, 2016 Below are the error we saw, the stack trace, and a diff of changes we made that got it to work under PostgreSQL. Please let us know if you have further questions. Thanks! Sarah Oelker Mount Holyoke College Upgrading to new version block_notifications Error writing to database More information about this error Debug info: ERROR: syntax error at or near "modify" LINE 1: alter table mdl_block_notifications_log modify action varcha... ^ alter table mdl_block_notifications_log modify action varchar(50) [array ( )] Error code: dmlwriteexception Stack trace: line 446 of /lib/dml/moodle_database.php: dml_write_exception thrown line 244 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end() line 682 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end() line 18 of /blocks/notifications/db/upgrade.php: call to pgsql_native_moodle_database->execute() line 899 of /lib/upgradelib.php: call to xmldb_block_notifications_upgrade() line 424 of /lib/upgradelib.php: call to upgrade_plugins_blocks() line 1628 of /lib/upgradelib.php: call to upgrade_plugins() line 434 of /admin/index.php: call to upgrade_noncore() A diff which made it work with PostgreSQL, but we don't know if it'll still work with MySQL: --- old-upgrade.php 2016-03-01 15:58:33.125057245 -0500 +++ upgrade.php 2016-03-01 16:02:44.386080422 -0500 @@ -15,28 +15,28 @@ if ($oldversion < 2014040404) { // change the size of the action column inside the block_notifications_log $DB->execute( "alter table {$CFG->prefix}block_notifications_log modify action varchar(50)"); $DB->execute( "alter table {$CFG->prefix}block_notifications_log alter action type varchar(50)"); // add the url column $DB->execute( "alter table {$CFG->prefix}block_notifications_log add column url varchar(100) after type"); $DB->execute( "alter table {$CFG->prefix}block_