I'm on Moodle 2.0 and I'm having a problem with new users creating accounts. When they type in their information and click on "create new account" it kicks out a dml_write_exception error.
Can anyone tell me what might be causing that error (yes, I know it's having a problem writing to the database, but WHY?) and what I might be able to do to fix it?
Thanks!
Rob
I was able to get an error log of the problem. Does this make sense to anyone:
[Fri Feb 25 13:02:09 2011] [error] [client 12.119.156.178] PHP Notice: parent does not exist!<ul style="text-align: left"><li>line 873 of /lib/adminlib.php: call to debugging()</li><li>line 31 of /admin/settings/misc.php: call to admin_category->add()</li><li>line 5615 of /lib/adminlib.php: call to require()</li><li>line 2693 of /lib/navigationlib.php: call to admin_get_root()</li><li>line 2601 of /lib/navigationlib.php: call to settings_navigation->load_administration_settings()</li><li>line 583 of /lib/pagelib.php: call to settings_navigation->initialise()</li><li>line 599 of /lib/pagelib.php: call to moodle_page->magic_get_settingsnav()</li><li>line 132 of /blocks/settings/block_settings.php: call to moodle_page->__get()</li><li>line 280 of /blocks/moodleblock.class.php: call to block_settings->get_content()</li><li>line 232 of /blocks/moodleblock.class.php: call to block_base->formatted_contents()</li><li>line 895 of /lib/blocklib.php: call to block_base->get_content_for_output()</li><li>line 947 of /lib/blocklib.php: call to block_manager->create_block_contents()</li><li>li in /home/westw8/public_html/moodle/lib/weblib.php on line 2871, referer: http://www.westwoodasl.com/moodle/login/signup.php
[Fri Feb 25 13:02:09 2011] [error] [client 12.119.156.178] PHP Notice: parent does not exist!<ul style="text-align: left"><li>line 873 of /lib/adminlib.php: call to debugging()</li><li>line 30 of /admin/settings/misc.php: call to admin_category->add()</li><li>line 5615 of /lib/adminlib.php: call to require()</li><li>line 2693 of /lib/navigationlib.php: call to admin_get_root()</li><li>line 2601 of /lib/navigationlib.php: call to settings_navigation->load_administration_settings()</li><li>line 583 of /lib/pagelib.php: call to settings_navigation->initialise()</li><li>line 599 of /lib/pagelib.php: call to moodle_page->magic_get_settingsnav()</li><li>line 132 of /blocks/settings/block_settings.php: call to moodle_page->__get()</li><li>line 280 of /blocks/moodleblock.class.php: call to block_settings->get_content()</li><li>line 232 of /blocks/moodleblock.class.php: call to block_base->formatted_contents()</li><li>line 895 of /lib/blocklib.php: call to block_base->get_content_for_output()</li><li>line 947 of /lib/blocklib.php: call to block_manager->create_block_contents()</li><li>li in /home/westw8/public_html/moodle/lib/weblib.php on line 2871, referer: http://www.westwoodasl.com/moodle/login/signup.php
[Fri Feb 25 13:02:09 2011] [error] [client 12.119.156.178] PHP Notice: parent does not exist!<ul style="text-align: left"><li>line 873 of /lib/adminlib.php: call to debugging()</li><li>line 29 of /admin/settings/misc.php: call to admin_category->add()</li><li>line 5615 of /lib/adminlib.php: call to require()</li><li>line 2693 of /lib/navigationlib.php: call to admin_get_root()</li><li>line 2601 of /lib/navigationlib.php: call to settings_navigation->load_administration_settings()</li><li>line 583 of /lib/pagelib.php: call to settings_navigation->initialise()</li><li>line 599 of /lib/pagelib.php: call to moodle_page->magic_get_settingsnav()</li><li>line 132 of /blocks/settings/block_settings.php: call to moodle_page->__get()</li><li>line 280 of /blocks/moodleblock.class.php: call to block_settings->get_content()</li><li>line 232 of /blocks/moodleblock.class.php: call to block_base->formatted_contents()</li><li>line 895 of /lib/blocklib.php: call to block_base->get_content_for_output()</li><li>line 947 of /lib/blocklib.php: call to block_manager->create_block_contents()</li><li>li in /home/westw8/public_html/moodle/lib/weblib.php on line 2871, referer: http://www.westwoodasl.com/moodle/login/signup.php
[Fri Feb 25 13:02:09 2011] [error] [client 12.119.156.178] PHP Notice: parent does not exist!<ul style="text-align: left"><li>line 873 of /lib/adminlib.php: call to debugging()</li><li>line 28 of /admin/settings/misc.php: call to admin_category->add()</li><li>line 5615 of /lib/adminlib.php: call to require()</li><li>line 2693 of /lib/navigationlib.php: call to admin_get_root()</li><li>line 2601 of /lib/navigationlib.php: call to settings_navigation->load_administration_settings()</li><li>line 583 of /lib/pagelib.php: call to settings_navigation->initialise()</li><li>line 599 of /lib/pagelib.php: call to moodle_page->magic_get_settingsnav()</li><li>line 132 of /blocks/settings/block_settings.php: call to moodle_page->__get()</li><li>line 280 of /blocks/moodleblock.class.php: call to block_settings->get_content()</li><li>line 232 of /blocks/moodleblock.class.php: call to block_base->formatted_contents()</li><li>line 895 of /lib/blocklib.php: call to block_base->get_content_for_output()</li><li>line 947 of /lib/blocklib.php: call to block_manager->create_block_contents()</li><li>li in /home/westw8/public_html/moodle/lib/weblib.php on line 2871, referer: http://www.westwoodasl.com/moodle/login/signup.php
[Fri Feb 25 13:02:09 2011] [error] [client 12.119.156.178] PHP Notice: parent does not exist!<ul style="text-align: left"><li>line 873 of /lib/adminlib.php: call to debugging()</li><li>line 24 of /admin/settings/misc.php: call to admin_category->add()</li><li>line 5615 of /lib/adminlib.php: call to require()</li><li>line 2693 of /lib/navigationlib.php: call to admin_get_root()</li><li>line 2601 of /lib/navigationlib.php: call to settings_navigation->load_administration_settings()</li><li>line 583 of /lib/pagelib.php: call to settings_navigation->initialise()</li><li>line 599 of /lib/pagelib.php: call to moodle_page->magic_get_settingsnav()</li><li>line 132 of /blocks/settings/block_settings.php: call to moodle_page->__get()</li><li>line 280 of /blocks/moodleblock.class.php: call to block_settings->get_content()</li><li>line 232 of /blocks/moodleblock.class.php: call to block_base->formatted_contents()</li><li>line 895 of /lib/blocklib.php: call to block_base->get_content_for_output()</li><li>line 947 of /lib/blocklib.php: call to block_manager->create_block_contents()</li><li>li in /home/westw8/public_html/moodle/lib/weblib.php on line 2871, referer: http://www.westwoodasl.com/moodle/login/signup.php
[Fri Feb 25 13:02:09 2011] [error] [client 12.119.156.178] PHP Notice: parent does not exist!<ul style="text-align: left"><li>line 873 of /lib/adminlib.php: call to debugging()</li><li>line 21 of /admin/settings/misc.php: call to admin_category->add()</li><li>line 5615 of /lib/adminlib.php: call to require()</li><li>line 2693 of /lib/navigationlib.php: call to admin_get_root()</li><li>line 2601 of /lib/navigationlib.php: call to settings_navigation->load_administration_settings()</li><li>line 583 of /lib/pagelib.php: call to settings_navigation->initialise()</li><li>line 599 of /lib/pagelib.php: call to moodle_page->magic_get_settingsnav()</li><li>line 132 of /blocks/settings/block_settings.php: call to moodle_page->__get()</li><li>line 280 of /blocks/moodleblock.class.php: call to block_settings->get_content()</li><li>line 232 of /blocks/moodleblock.class.php: call to block_base->formatted_contents()</li><li>line 895 of /lib/blocklib.php: call to block_base->get_content_for_output()</li><li>line 947 of /lib/blocklib.php: call to block_manager->create_block_contents()</li><li>li in /home/westw8/public_html/moodle/lib/weblib.php on line 2871, referer: http://www.westwoodasl.com/moodle/login/signup.php
[Fri Feb 25 13:01:38 2011] [error] [client 209.188.89.132] File does not exist: /home/westw8/public_html/500.shtml
[Fri Feb 25 13:01:38 2011] [alert] [client 209.188.89.132] /home/westw8/public_html/moodle/uploaddata/.htaccess: AllowOverride not allowed here
[Fri Feb 25 13:01:37 2011] [error] [client 209.188.89.132] File does not exist: /home/westw8/public_html/500.shtml
[Fri Feb 25 13:01:37 2011] [alert] [client 209.188.89.132] /home/westw8/public_html/moodle/uploaddata/.htaccess: AllowOverride not allowed here
[Fri Feb 25 13:01:37 2011] [error] [client 209.188.89.132] File does not exist: /home/westw8/public_html/500.shtml
[Fri Feb 25 13:01:37 2011] [alert] [client 209.188.89.132] /home/westw8/public_html/moodle/uploaddata/.htaccess: AllowOverride not allowed here
[Fri Feb 25 13:01:36 2011] [error] [client 12.119.156.178] PHP Notice: parent does not exist!<ul style="text-align: left"><li>line 873 of /lib/adminlib.php: call to debugging()</li><li>line 31 of /admin/settings/misc.php: call to admin_category->add()</li><li>line 5615 of /lib/adminlib.php: call to require()</li><li>line 2693 of /lib/navigationlib.php: call to admin_get_root()</li><li>line 2601 of /lib/navigationlib.php: call to settings_navigation->load_administration_settings()</li><li>line 583 of /lib/pagelib.php: call to settings_navigation->initialise()</li><li>line 599 of /lib/pagelib.php: call to moodle_page->magic_get_settingsnav()</li><li>line 132 of /blocks/settings/block_settings.php: call to moodle_page->__get()</li><li>line 280 of /blocks/moodleblock.class.php: call to block_settings->get_content()</li><li>line 232 of /blocks/moodleblock.class.php: call to block_base->formatted_contents()</li><li>line 895 of /lib/blocklib.php: call to block_base->get_content_for_output()</li><li>line 947 of /lib/blocklib.php: call to block_manager->create_block_contents()</li><li>li in /home/westw8/public_html/moodle/lib/weblib.php on line 2871, referer: http://www.westwoodasl.com/moodle/login/index.php
[Fri Feb 25 13:01:36 2011] [error] [client 12.119.156.178] PHP Notice: parent does not exist!<ul style="text-align: left"><li>line 873 of /lib/adminlib.php: call to debugging()</li><li>line 30 of /admin/settings/misc.php: call to admin_category->add()</li><li>line 5615 of /lib/adminlib.php: call to require()</li><li>line 2693 of /lib/navigationlib.php: call to admin_get_root()</li><li>line 2601 of /lib/navigationlib.php: call to settings_navigation->load_administration_settings()</li><li>line 583 of /lib/pagelib.php: call to settings_navigation->initialise()</li><li>line 599 of /lib/pagelib.php: call to moodle_page->magic_get_settingsnav()</li><li>line 132 of /blocks/settings/block_settings.php: call to moodle_page->__get()</li><li>line 280 of /blocks/moodleblock.class.php: call to block_settings->get_content()</li><li>line 232 of /blocks/moodleblock.class.php: call to block_base->formatted_contents()</li><li>line 895 of /lib/blocklib.php: call to block_base->get_content_for_output()</li><li>line 947 of /lib/blocklib.php: call to block_manager->create_block_contents()</li><li>li in /home/westw8/public_html/moodle/lib/weblib.php on line 2871, referer: http://www.westwoodasl.com/moodle/login/index.php
[Fri Feb 25 13:01:36 2011] [error] [client 12.119.156.178] PHP Notice: parent does not exist!<ul style="text-align: left"><li>line 873 of /lib/adminlib.php: call to debugging()</li><li>line 29 of /admin/settings/misc.php: call to admin_category->add()</li><li>line 5615 of /lib/adminlib.php: call to require()</li><li>line 2693 of /lib/navigationlib.php: call to admin_get_root()</li><li>line 2601 of /lib/navigationlib.php: call to settings_navigation->load_administration_settings()</li><li>line 583 of /lib/pagelib.php: call to settings_navigation->initialise()</li><li>line 599 of /lib/pagelib.php: call to moodle_page->magic_get_settingsnav()</li><li>line 132 of /blocks/settings/block_settings.php: call to moodle_page->__get()</li><li>line 280 of /blocks/moodleblock.class.php: call to block_settings->get_content()</li><li>line 232 of /blocks/moodleblock.class.php: call to block_base->formatted_contents()</li><li>line 895 of /lib/blocklib.php: call to block_base->get_content_for_output()</li><li>line 947 of /lib/blocklib.php: call to block_manager->create_block_contents()</li><li>li in /home/westw8/public_html/moodle/lib/weblib.php on line 2871, referer: http://www.westwoodasl.com/moodle/login/index.php
[Fri Feb 25 13:01:36 2011] [error] [client 12.119.156.178] PHP Notice: parent does not exist!<ul style="text-align: left"><li>line 873 of /lib/adminlib.php: call to debugging()</li><li>line 28 of /admin/settings/misc.php: call to admin_category->add()</li><li>line 5615 of /lib/adminlib.php: call to require()</li><li>line 2693 of /lib/navigationlib.php: call to admin_get_root()</li><li>line 2601 of /lib/navigationlib.php: call to settings_navigation->load_administration_settings()</li><li>line 583 of /lib/pagelib.php: call to settings_navigation->initialise()</li><li>line 599 of /lib/pagelib.php: call to moodle_page->magic_get_settingsnav()</li><li>line 132 of /blocks/settings/block_settings.php: call to moodle_page->__get()</li><li>line 280 of /blocks/moodleblock.class.php: call to block_settings->get_content()</li><li>line 232 of /blocks/moodleblock.class.php: call to block_base->formatted_contents()</li><li>line 895 of /lib/blocklib.php: call to block_base->get_content_for_output()</li><li>line 947 of /lib/blocklib.php: call to block_manager->create_block_contents()</li><li>li in /home/westw8/public_html/moodle/lib/weblib.php on line 2871, referer: http://www.westwoodasl.com/moodle/login/index.php
[Fri Feb 25 13:01:36 2011] [error] [client 12.119.156.178] PHP Notice: parent does not exist!<ul style="text-align: left"><li>line 873 of /lib/adminlib.php: call to debugging()</li><li>line 24 of /admin/settings/misc.php: call to admin_category->add()</li><li>line 5615 of /lib/adminlib.php: call to require()</li><li>line 2693 of /lib/navigationlib.php: call to admin_get_root()</li><li>line 2601 of /lib/navigationlib.php: call to settings_navigation->load_administration_settings()</li><li>line 583 of /lib/pagelib.php: call to settings_navigation->initialise()</li><li>line 599 of /lib/pagelib.php: call to moodle_page->magic_get_settingsnav()</li><li>line 132 of /blocks/settings/block_settings.php: call to moodle_page->__get()</li><li>line 280 of /blocks/moodleblock.class.php: call to block_settings->get_content()</li><li>line 232 of /blocks/moodleblock.class.php: call to block_base->formatted_contents()</li><li>line 895 of /lib/blocklib.php: call to block_base->get_content_for_output()</li><li>line 947 of /lib/blocklib.php: call to block_manager->create_block_contents()</li><li>li in /home/westw8/public_html/moodle/lib/weblib.php on line 2871, referer: http://www.westwoodasl.com/moodle/login/index.php
[Fri Feb 25 13:01:36 2011] [error] [client 12.119.156.178] PHP Notice: parent does not exist!<ul style="text-align: left"><li>line 873 of /lib/adminlib.php: call to debugging()</li><li>line 21 of /admin/settings/misc.php: call to admin_category->add()</li><li>line 5615 of /lib/adminlib.php: call to require()</li><li>line 2693 of /lib/navigationlib.php: call to admin_get_root()</li><li>line 2601 of /lib/navigationlib.php: call to settings_navigation->load_administration_settings()</li><li>line 583 of /lib/pagelib.php: call to settings_navigation->initialise()</li><li>line 599 of /lib/pagelib.php: call to moodle_page->magic_get_settingsnav()</li><li>line 132 of /blocks/settings/block_settings.php: call to moodle_page->__get()</li><li>line 280 of /blocks/moodleblock.class.php: call to block_settings->get_content()</li><li>line 232 of /blocks/moodleblock.class.php: call to block_base->formatted_contents()</li><li>line 895 of /lib/blocklib.php: call to block_base->get_content_for_output()</li><li>line 947 of /lib/blocklib.php: call to block_manager->create_block_contents()</li><li>li in /home/westw8/public_html/moodle/lib/weblib.php on line 2871, referer: http://www.westwoodasl.com/moodle/login/index.php
In case anyone is interested (which I doubt, due to the lack of replies *grin*) - I solved the problem. The USER table had an extra field in it somehow called "providence." I don't know where it came from or how it got there. It was completely empty. So I simply deleted that field and the problem appears to be solved.
Rob
I think I have having the same problem with my upgrade. I get the dmlwriteexception. This is the debug information I received.
How do I access the area you did to see if I have the same empty field issue?
I am experiencing the same issue. Has anyone had any success with this?
Rob where were you able to get the error log from? We are having both read and write errors.
Hello,
I also got this dmlwriteexception Error when I create a page containg phonetical symbols like: /iː/
Solved this error by changing length of data to be imported and max length of each field in the table.
ie: departement was 35 characters in my CSV file and limited to 30 in the table.
Hope it helps...
