Hello.
I'm trying to import a CSV file containing contact records. I can upload the file, go through all the steps (mapping, manual fields, etc.), and queue it for import. When I hit the "Import queue" button, it processes for a while, and then errors out. A message pops up saying "There was an error in one of the epesi modules. Details are displayed at the bottom of the page, please send this information to system administrator." The output of the error is as follows:
Type: E_USER_ERROR (256)
Message: postgres7 error: [-1: ERROR: value too long for type character varying(64)] in EXECUTE("INSERT INTO contact_data_1 (created_on,created_by,active,f_last_name,f_first_name,f_work_phone,f_fax,f_email,f_address_1,f_city,f_country,f_postal_code,f_permission) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)")
File: /var/www/html/libs/adodb/adodb-errorhandler.inc.php
Line=77
error backtrace:
[PHP core called function]
function called: handle_epesi_error(256, "postgres7 error: [-1: ERROR: value too long for type character varying(64)] in EXECUTE(\"INSERT INTO contact_data_1 (created_on,created_by,active,f_last_name,f_first_name,f_work_phone,f_fax,f_email,f_address_1,f_city,f_country,f_postal_code,f_permission) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)\") ", "/var/www/html/libs/adodb/adodb-errorhandler.inc.php", 77, Array ("postgres7", "EXECUTE", -1, "ERROR: value too long for type character varying(64)", "INSERT INTO contact_data_1 (created_on,created_by,active,f_last_name,f_first_name,f_work_phone,f_fax,f_email,f_address_1,f_city,f_country,f_postal_code,f_permission) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)", Array (#13), Object (ADODB_postgres7), "INSERT INTO contact_data_1 (created_on,created_by,active,f_last_name,f_first_name,f_work_phone,f_fax,f_email,f_address_1,f_city,f_country,f_postal_code,f_permission) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)", Array (#13), "postgres7 error: [-1: ERROR: value too long for type character varying(64)] in EXECUTE(\"INSERT INTO contact_data_1 (created_on,created_by,active,f_last_name,f_first_name,f_work_phone,f_fax,f_email,f_address_1,f_city,f_country,f_postal_code,f_permission) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)\") "))
File: /var/www/html/libs/adodb/adodb-errorhandler.inc.php
line 77
function called: trigger_error("postgres7 error: [-1: ERROR: value too long for type character varying(64)] in EXECUTE(\"INSERT INTO contact_data_1 (created_on,created_by,active,f_last_name,f_first_name,f_work_phone,f_fax,f_email,f_address_1,f_city,f_country,f_postal_code,f_permission) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)\") ", 256)
File: /var/www/html/libs/adodb/adodb.inc.php
line 1074
function called: ADODB_Error_Handler("postgres7", "EXECUTE", -1, "ERROR: value too long for type character varying(64)", "INSERT INTO contact_data_1 (created_on,created_by,active,f_last_name,f_first_name,f_work_phone,f_fax,f_email,f_address_1,f_city,f_country,f_postal_code,f_permission) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)", Array (#13), "Object (ADODB_postgres7)")
File: /var/www/html/libs/adodb/adodb.inc.php
line 1045
function called: _Execute("INSERT INTO contact_data_1 (created_on,created_by,active,f_last_name,f_first_name,f_work_phone,f_fax,f_email,f_address_1,f_city,f_country,f_postal_code,f_permission) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)", Array (#13))
[PHP core called function]
function called: Execute("INSERT INTO contact_data_1 (created_on,created_by,active,f_last_name,f_first_name,f_work_phone,f_fax,f_email,f_address_1,f_city,f_country,f_postal_code,f_permission) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)", Array (#13))
File: /var/www/html/include/database.php
line 344
function called: call_user_func_array(Array (Object (ADODB_postgres7), "Execute"), Array ("INSERT INTO contact_data_1 (created_on,created_by,active,f_last_name,f_first_name,f_work_phone,f_fax,f_email,f_address_1,f_city,f_country,f_postal_code,f_permission) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)", Array (#13)))
File: /var/www/html/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php
line 956
function called: Execute("INSERT INTO contact_data_1 (created_on,created_by,active,f_last_name,f_first_name,f_work_phone,f_fax,f_email,f_address_1,f_city,f_country,f_postal_code,f_permission) VALUES (%T,%d,%d,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)", Array (#13))
File: /var/www/html/modules/Utils/RecordBrowser/object_wrapper/Recordset.php
line 258
function called: new_record("contact", Array (#15))
File: /var/www/html/modules/Premium/Import/Temp/Worksheet.php
line 467
function called: new_record(Array (#15))
File: /var/www/html/modules/Premium/Import/Import_0.php
line 159
function called: import()
[PHP core called function]
function called: worksheets()
File: /var/www/html/include/module.php
line 782
function called: call_user_func_array(Array (Object (Premium_Import), "worksheets"), Array ())
File: /var/www/html/include/module.php
line 713
function called: get_html_of_module("Object (Premium_Import)", null, "admin")
File: /var/www/html/include/module.php
line 886
function called: display_module("\"Object (Premium_Import)\"", null, "admin")
File: /var/www/html/modules/Base/Admin/Admin_0.php
line 31
function called: pack_module("Premium_Import", null, "admin")
[PHP core called function]
function called: body()
File: /var/www/html/include/module.php
line 793
function called: call_user_func_array(Array (Object (Base_Admin), "body"), Array ())
File: /var/www/html/include/module.php
line 713
function called: get_html_of_module(Object (Base_Admin), null, null)
File: /var/www/html/modules/Base/Box/Box_0.php
line 146
function called: display_module("Object (Base_Admin)")
File: /var/www/html/include/epesi.php
line 241
function called: body()
File: /var/www/html/include/epesi.php
line 286
function called: go(Object (Base_Box))
File: /var/www/html/process.php
line 35
function called: process("__action_module__=%2FBase_Box%7C0%2FBase_Admin%7Cmain_0%2FPremium_Import%7C0&%2FBase_Box%7C0%2FBase_Admin%7Cmain_0%2FPremium_Import%7C0_action=process_queue", false)
I have tried numerous strategies to alleviate this error. I've removed numerous unneeded fields, ran the CSV file through a LINT application, and uploaded the file as an XLSX. None of those strategies have worked. I'd greatly appreciate it if someone could shed some insight or suggest a solution. If you need additional logs/system specs/other information, let me know.
Thanks!
