CiviCRM Community Forums (archive)

When I am trying to import a list of contacts, I get the following error during the last step:

DB Error: no such table

Database foutcode: Table 'debxxxxx_drupal.civicrm_import_job_d89ae83277db2864a07e4ba729b27d4e' doesn't exist, 1146

Array
(
    [callback] => Array
        (
            

• => CRM_Core_Error
[1] => handle
        )

    

=> -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => SELECT * FROM civicrm_import_job_d89ae83277db2864a07e4ba729b27d4e WHERE _status = 'NEW' [nativecode=1146 ** Table 'debxxxxx_drupal.civicrm_import_job_d89ae83277db2864a07e4ba729b27d4e' doesn't exist]
    [type] => DB_Error
    [user_info] => SELECT * FROM civicrm_import_job_d89ae83277db2864a07e4ba729b27d4e WHERE _status = 'NEW' [nativecode=1146 ** Table 'debxxxxx_drupal.civicrm_import_job_d89ae83277db2864a07e4ba729b27d4e' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT * FROM civicrm_import_job_d89ae83277db2864a07e4ba729b27d4e WHERE _status = 'NEW' [nativecode=1146 ** Table 'debxxxxx_drupal.civicrm_import_job_d89ae83277db2864a07e4ba729b27d4e' doesn't exist]"]
)

I have imported several times before without this kind of problem. Please help.


Ok, when I try to import a smaller file, the error is not shown. Could this have anything to do with execution time settings? If so, which?

I have done some tests:

Settings used:

[.htaccess]
php_value max_input_time 1800

[settings.php]
ini_set('memory_limit',             '64M');
ini_set('max_execution_time',       1800);

Importing csv with 5997 records is stopped in step 3 after 4050 records with an 'MySQL is gone away' error.
Importing the first part of the csv with 3000 records is stopped after about 95% in the last step with the error mentioned above.
Importing the second part of the csv with the rest is stopped after 6 minutes with no descriptive error.
Importing only the first row of the csv completes succesfully.

I'll try to split the file up into smaller parts and look what results I have.