Databases: Database issues after upgrading from 1.9 to 2.0

Databases: Database issues after upgrading from 1.9 to 2.0

by Rob Nielson -
Number of replies: 9

Hello everyone!

I've recently upgraded to 2.0 and I'm having some problems. New users are unable to create an account (they get an "error writing to database") and when I click on "get more information" I get the error documentation for "dmlwriteexception."

When I run the Functional Database Test I get the following:

 

Fail: lib/dml/simpletest/testdml.php / ► dml_test / ► test_diagnose
Database self diagnostics failed [String: Database tables are using MyISAM database engine, it is recommended to use ACID compliant engine with full transaction support such as InnoDB.] should be null at [/home/westw8/public_html/moodle/lib/dml/simpletest/testdml.php line 112]
Fail: lib/dml/simpletest/testdml.php / ► dml_test / ► test_unique_index_collation_trouble
Unique index is accent insensitive, this may cause problems for non-ascii languages. This is usually caused by accent insensitive default collation. at [/home/westw8/public_html/moodle/lib/dml/simpletest/testdml.php line 2769]
Exception: lib/dml/simpletest/testdml.php / ► dml_test / ► test_unique_index_collation_trouble
Unexpected exception of type [dml_write_exception] with message [Error writing to database] in [/home/westw8/public_html/moodle/lib/dml/moodle_database.php line 394] 
Debug info:
Duplicate entry 'aäa' for key 2
INSERT INTO mdl_unit_table (name) VALUES(?)
[array (
  0 => 'aäa',
)]
  • line 843 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
  • line 885 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
  • line 2763 of /lib/dml/simpletest/testdml.php: call to mysqli_native_moodle_database->insert_record()
  • line ... of ...
Fail: lib/dml/simpletest/testdml.php / ► dml_test / ► test_sql_binary_equal
SQL operator "=" is expected to be accent sensitive at [/home/westw8/public_html/moodle/lib/dml/simpletest/testdml.php line 2797]
Fail: lib/dml/simpletest/testdml.php / ► dml_test / ► test_sql_binary_equal
SQL operator "=" is expected to be case sensitive at [/home/westw8/public_html/moodle/lib/dml/simpletest/testdml.php line 2800]
Fail: lib/dml/simpletest/testdml.php / ► dml_test / ► test_onelevel_rollback
Equal expectation fails because [Integer: 0] differs from [String: 1] by 1 at [/home/westw8/public_html/moodle/lib/dml/simpletest/testdml.php line 3292]
Fail: lib/dml/simpletest/testdml.php / ► dml_test / ► test_nested_transactions
Equal expectation fails because [Integer: 0] differs from [String: 2] by 2 at [/home/westw8/public_html/moodle/lib/dml/simpletest/testdml.php line 3338]
Fail: lib/dml/simpletest/testdml.php / ► dml_test / ► test_nested_transactions
Equal expectation fails because [Integer: 0] differs from [String: 2] by 2 at [/home/westw8/public_html/moodle/lib/dml/simpletest/testdml.php line 3367]
Fail: lib/dml/simpletest/testdml.php / ► dml_test / ► test_wrong_transactions
Equal expectation fails because [Integer: 0] differs from [String: 2] by 2 at [/home/westw8/public_html/moodle/lib/dml/simpletest/testdml.php line 3435]
Fail: lib/dml/simpletest/testdml.php / ► dml_test / ► test_concurent_transactions
Equal expectation fails because [Integer: 0] differs from [String: 1] by 1 at [/home/westw8/public_html/moodle/lib/dml/simpletest/testdml.php line 3521]
Fail: lib/dml/simpletest/testdml.php / ► dml_test / ► test_concurent_transactions
Equal expectation fails because [Integer: 1] differs from [String: 2] by 1 at [/home/westw8/public_html/moodle/lib/dml/simpletest/testdml.php line 3524]
2/2 test cases complete: 955 passes, 10 fails and 1 exceptions.
Run at Thursday, 24 February 2011, 10:16 AM. Time taken: 5 secs. Using SimpleTest version 1.0.1.
Any help is GREATLY appreciated!
Rob
Average of ratings: -
In reply to Rob Nielson

Re: Databases: Database issues after upgrading from 1.9 to 2.0

by Rob Nielson -

Can anyone at least give me some suggestions?

Anything at all?

Thanks.

Average of ratings: -
In reply to Rob Nielson

Re: Databases: Database issues after upgrading from 1.9 to 2.0

by Tim Hunt -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

Well, read the first 'failure' message: "Database tables are using MyISAM database engine, it is recommended to use ACID compliant engine with full transaction support such as InnoDB"

That is explaining why you are strongly recommended not to run Moodle 2.0 on MySQL + MyISAM table engine. It simply cannot do some of the things you would expect a relational database to do, and this can be seen in the following more specific test failures.

Now, in practice, these things that MySQL cannot do only affect edge-cases. You will find almost all of your Moodle site runs fine on MyISAM. It is just in edge cases, or when an error occurs and Moodle has to clean up (roll-back a transaction) that things will go subtly wrong.

Average of ratings: Useful (1)
In reply to Tim Hunt

Re: Databases: Database issues after upgrading from 1.9 to 2.0

by Rob Nielson -

Thanks for the feedback.

The database has now been changed to InnoDB.

New users are still unable to create accounts. I'm getting a dmlwriteexception error.

Any idea which table it's having a problem writing to and what I can check for? I'm guessing it's a corrupted or missing table or something?

Rob

Average of ratings: -
In reply to Rob Nielson

Re: Databases: Database issues after upgrading from 1.9 to 2.0

by Tim Hunt -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

If you turn Debugging to DEVELOPER level (briefly) it should show you the full error from the databsae.

Average of ratings: Useful (1)
In reply to Tim Hunt

Re: Databases: Database issues after upgrading from 1.9 to 2.0

by Rob Nielson -

This is what the error log shows. I have to admit, I don't know much of what it is telling me though. Ha. Does it make sense to you?

 

 

 

[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

Average of ratings: -
In reply to Rob Nielson

Re: Databases: Database issues after upgrading from 1.9 to 2.0

by Rob Nielson -

Ahhh...  this is what the DEVELOPER error level displays:

I'm guessing that the "providence" field is the culprit. And in 1.9 it had a default but in 2.0 it doesn't, and so I need to set one?

 

Debug info: Field 'providence' doesn't have a default value
INSERT INTO mdl_user (username,password,email,firstname,lastname,city,country,confirmed,lang,firstaccess,timecreated,mnethostid,secret,auth) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?)
[array (
0 => 'testing',
1 => '5f88afecf6dcb027f49051c75f999216',
2 => 'test@test.com',
3 => 'test',
4 => 'test',
5 => 'test',
6 => 'TW',
7 => 0,
8 => 'en',
9 => 1298702139,
10 => 1298702139,
11 => '1',
12 => 'd0xOg5czTGMyX63',
13 => 'email',
)]
Stack trace:
  • line 394 of /lib/dml/moodle_database.php: dml_write_exception thrown
  • line 874 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
  • line 916 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
  • line 82 of /auth/email/auth.php: call to mysqli_native_moodle_database->insert_record()
  • line 60 of /login/signup.php: call to auth_plugin_email->user_signup()
Average of ratings: -
In reply to Rob Nielson

Re: Databases: Database issues after upgrading from 1.9 to 2.0

by Tim Hunt -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

I don't think Moodle has ever had a providence field in the database. Might this be something you added locally to your Moodle system by customising the code?

If so, you either need to make the same customisation in Moodle 2.0, or you need to create a propert custom user profile field through the admin interface, then transfer the data that is currently in the database, then delete your extra column.

Average of ratings: Useful (1)
In reply to Tim Hunt

Re: Databases: Database issues after upgrading from 1.9 to 2.0

by Rob Nielson -

I don't remember adding providence. I'm in the US and we don't use providence here, just city and state. I'm going to delete that field and see if that fixes the problem.

Average of ratings: -
In reply to Rob Nielson

Re: Databases: Database issues after upgrading from 1.9 to 2.0

by Rob Nielson -

I'm happy to report that removing the "providence" field from the table has apparently done the trick!

Happy me! *smile*

Thanks for your help!

Rob

Average of ratings: -