CiviCRM Community Forums (archive)

Hello everyone.
CiviCRM has been working great, but all of the sudden, I couldn't save any changes to my contacts, though I could open contacts, and save in other areas like changing items in the Admin section. When I tried to save contacts information (individuals or businesses) I just got a server unavailable message. So I upgraded to 4.3.5. All went semi-smoothly as soon as I figured out how to add trigger privileges to my login. At any rate, I got some errors when I finally got the update script to go. And here's the errors. Any help would be appreciated.

Type   DB_Error
Code   -1
Message   DB Error: unknown error
Mode   16
UserInfo   SELECT DELETE_RULE FROM information_schema.REFERENTIAL_CONSTRAINTS WHERE CONSTRAINT_NAME = 'FK_civicrm_financial_item_contact_id' AND CONSTRAINT_SCHEMA = 'mylogin_myDBname' [nativecode=1109 ** Unknown table 'REFERENTIAL_CONSTRAINTS' in information_schema]
DebugInfo   SELECT DELETE_RULE FROM information_schema.REFERENTIAL_CONSTRAINTS WHERE CONSTRAINT_NAME = 'FK_civicrm_financial_item_contact_id' AND CONSTRAINT_SCHEMA = 'mylogin_myDBname' [nativecode=1109 ** Unknown table 'REFERENTIAL_CONSTRAINTS' in information_schema]

***below that information I got table of all the functions and locations. Across the table top in red were the following errors***
PEAR_Exception: DB Error: unknown error in unknown on line unknown
- DB_Error: DB Error: unknown error in unknown on line unknown

****In the table were three fuctions that the location was unknown****:

• #0 CRM_Core_Error::exceptionHandler(Object(DB_Error)) The location on this was unknown:unknown
• #14 CRM_Upgrade_Form::doIncrementalUpgradeStep(Object(CRM_Queue_TaskContext), '4.3.5', '4.3.4', '4.3.5', '/tmp/civicrm-pos…') The location on this was "unknown:unknown"
• #30 {main} The location on this was totally blank.

Updating did allow me to save contacts again. But should I be worried/concerned about these errors?
Cheers, and thanks for any input.

Ummm... Thanks. I missed that. I'll update MySQL to 5.1. and see what happens.