"Fail to Retrieve Data" on Dropdowns after Migration

SuiteCRM Forum - English Language Installation & Upgrade Help
#1

I just completed a fresh Migration from SugarCE 6.5.x to SuiteCRM 7.1.2. I am now getting “Fail to Retrieve Data” when editing or creating new dropdowns.

Firebug reveals:

“NetworkError: 500 Internal Server Error - http://domain.com/index.php?to_pdf=1&sugar_body_only=1”

Chrome Dev Tools Indicates:
POST http://mydomain.com/index.php?to_pdf=1&sugar_body_only=1 500 (Internal Server Error) sugar_grp1_yui.js?v=vZ4Mmo5WtY8vRaMSjVIm3A:55
YAHOO.util.Connect.asyncRequest sugar_grp1_yui.js?v=vZ4Mmo5WtY8vRaMSjVIm3A:55
ModuleBuilder.submitForm ModuleBuilder.js?v=vZ4Mmo5WtY8vRaMSjVIm3A:632
ModuleBuilder.handleSave ModuleBuilder.js?v=vZ4Mmo5WtY8vRaMSjVIm3A:787
handleSave SimpleList.js?v=vZ4Mmo5WtY8vRaMSjVIm3A:244
onclick index.php?module=ModuleBuilder&action=index&type=dropdowns:1

Error log has the following, though I don’t know if it’s related.

Thu Jul 24 08:42:26 2014 [19656][1][FATAL] Query Failed: UPDATE aos_pdf_templates SET type = ‘AOS_Quotes’ WHERE type = ‘Quotes’: MySQL error 1146: Table ‘mycontac_suga571.aos_pdf_templates’ doesn’t exist
Thu Jul 24 08:42:26 2014 [19656][1][FATAL] Query Failed: UPDATE aos_pdf_templates SET type = ‘AOS_Invoices’ WHERE type = ‘Invoices’: MySQL error 1146: Table ‘mycontac_suga571.aos_pdf_templates’ doesn’t exist
Thu Jul 24 08:42:28 2014 [19656][1][FATAL] Query Failed: ALTER TABLE aor_fields DISABLE KEYS: MySQL error 1146: Table ‘mycontac_suga571.aor_fields’ doesn’t exist
Thu Jul 24 08:42:28 2014 [19656][1][FATAL] Query Failed: ALTER TABLE aor_fields CHANGE function field_function VARCHAR( 100 ): MySQL error 1146: Table ‘mycontac_suga571.aor_fields’ doesn’t exist
Thu Jul 24 08:42:28 2014 [19656][1][FATAL] Query Failed: ALTER TABLE aor_fields ENABLE KEYS: MySQL error 1146: Table ‘mycontac_suga571.aor_fields’ doesn’t exist
Thu Jul 24 08:42:28 2014 [19656][1][FATAL] MySQL error 1146: Table ‘mycontac_suga571.aor_fields’ doesn’t exist
Thu Jul 24 08:43:23 2014 [19797][1][FATAL] Missing relationship definition securitygroups_users. skipping securitygroups subpanel

PHP Version 5.4.27
Linux

#2

looks like it may have failed to create some additional tables, try doing a quick repair and rebuild(in admin->repair), and see if it detects any missing tables, if so execute the required db changes

#3

I don’t received any kind of error, but if I change or add more information in my drop down, it’s not working.

Pls Help. URGENT!!!

WINDOWS 8.1 PRO AND XAMPP 1.8.3

#4

I fixed that!!

Just, go to admin>languages in that place, you have to move the russian laguages to disabled.

after that make a quick repair and done!!.. dropdowns is working again. :slight_smile: