Several versions ago I could perform a data import by simply loading data into the company_data_1 table. Now when I try to do that I get the following error:
Type: E_USER_ERROR (256)
Message: There is no such record as 110 in table company
File: /var/www/html/epesi-1.6.5-20150324/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php
Line=1887
error backtrace:
[PHP core called function]
function called: handle_epesi_error(256, "There is no such record as 110 in table company", "/var/www/html/epesi-1.6.5-20150324/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php", 1887, Array ("company", "110", Array (#4), Array (#2)))
File: /var/www/html/epesi-1.6.5-20150324/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php
line 1887
function called: trigger_error("There is no such record as 110 in table company", 256)
File: /var/www/html/epesi-1.6.5-20150324/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php
line 1920
function called: get_record_info("company", "110")
File: /var/www/html/epesi-1.6.5-20150324/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 1048
function called: get_html_record_info("company", "110")
File: /var/www/html/epesi-1.6.5-20150324/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 299
function called: show_data(Array (), Array (), Array ("ASC"))
[PHP core called function]
function called: body()
File: /var/www/html/epesi-1.6.5-20150324/include/module.php
line 853
function called: call_user_func_array(Array (Object (Utils_RecordBrowser), "body"), Array ())
File: /var/www/html/epesi-1.6.5-20150324/include/module.php
line 773
function called: get_html_of_module(Object (Utils_RecordBrowser), null, null)
File: /var/www/html/epesi-1.6.5-20150324/modules/CRM/Contacts/Contacts_0.php
line 74
function called: display_module("Object (Utils_RecordBrowser)")
[PHP core called function]
function called: body()
File: /var/www/html/epesi-1.6.5-20150324/include/module.php
line 853
function called: call_user_func_array(Array (Object (CRM_Contacts), "body"), Array ())
File: /var/www/html/epesi-1.6.5-20150324/include/module.php
line 773
function called: get_html_of_module(Object (CRM_Contacts), null, null)
File: /var/www/html/epesi-1.6.5-20150324/modules/Base/Box/Box_0.php
line 151
function called: display_module("Object (CRM_Contacts)")
File: /var/www/html/epesi-1.6.5-20150324/include/epesi.php
line 241
function called: body()
File: /var/www/html/epesi-1.6.5-20150324/include/epesi.php
line 286
function called: go(Object (Base_Box))
File: /var/www/html/epesi-1.6.5-20150324/process.php
line 35
function called: process("parent_module=CRM_Contacts&mode=company&__icon__=companies.png&__icon_small__=companies-small.png&box_main_href=66c94dc0dfefcd94e354f310690d4dbc", "")
I am trying to upload test data (generated from www.mockaroo.com) into the company table using phpmyadmin.
I presume I must have violated some database integrity by doing it that way. Can you advise me what other tables I need to take into account?
Regards
Glenn @ Printec