Im trying to import a cvs file, but i got the next msg
SQLSTATE[42000]: Syntax error or access violation: 1065 Query was empty

I dont Know where is the error. I dont found any related to the FEED module with that msg.

----THIS IS MY FEED CONFIG---
feeds_importer = new stdClass();
$feeds_importer->disabled = FALSE; /* Edit this to true to make a default feeds_importer disabled initially */
$feeds_importer->api_version = 1;
$feeds_importer->id = 'negocios';
$feeds_importer->config = array(
'name' => 'Negocios',
'description' => 'Importador de Establecimientos para el Directorio de Negocios',
'fetcher' => array(
'plugin_key' => 'FeedsFileFetcher',
'config' => array(
'allowed_extensions' => 'txt csv tsv xml opml',
'direct' => FALSE,
'directory' => 'private://feeds',
'allowed_schemes' => array(
0 => 'public',
1 => 'private',
),
),
),
'parser' => array(
'plugin_key' => 'FeedsCSVParser',
'config' => array(
'delimiter' => ',',
'encoding' => 'UTF-8',
'no_headers' => 0,
),
),
'processor' => array(
'plugin_key' => 'FeedsNodeProcessor',
'config' => array(
'expire' => '-1',
'author' => '303',
'authorize' => 1,
'mappings' => array(
0 => array(
'source' => 'GUID',
'target' => 'guid',
'unique' => 1,
),
1 => array(
'source' => 'Nombre del Negocios',
'target' => 'title',
'unique' => 1,
),
2 => array(
'source' => 'Categoria',
'target' => 'field_categoria_negocio',
'unique' => FALSE,
),
3 => array(
'source' => 'Calle y Numero',
'target' => 'field_ubicacion_negocio:street',
'unique' => FALSE,
),
4 => array(
'source' => 'Municipio/Delegacion',
'target' => 'field_ubicacion_negocio:additional',
'unique' => FALSE,
),
5 => array(
'source' => 'Ciudad',
'target' => 'field_ubicacion_negocio:city',
'unique' => FALSE,
),
6 => array(
'source' => 'Estado',
'target' => 'field_ubicacion_negocio:province',
'unique' => FALSE,
),
7 => array(
'source' => 'Codigo Postal',
'target' => 'field_ubicacion_negocio:postal_code',
'unique' => FALSE,
),
8 => array(
'source' => 'Pais',
'target' => 'field_ubicacion_negocio:country',
'unique' => FALSE,
),
9 => array(
'source' => 'Telefono',
'target' => 'field_telefono_negocio',
'unique' => FALSE,
),
),
'update_existing' => '1',
'input_format' => 'plain_text',
'skip_hash_check' => 0,
'bundle' => 'negocio',
),
),
'content_type' => '',
'update' => 0,
'import_period' => '-1',
'expire_period' => 3600,
'import_on_create' => 1,
'process_in_background' => 0,
);

CommentFileSizeAuthor
#1 negocios_template(2).csv_.zip2.59 KBrojesaga

Comments

rojesaga’s picture

Title: SQLSTATE[42000]: Syntax error or access violation: 1065 Query was empty » SQLSTATE[42000]: Syntax error or access violation: 1065 Query was empty
StatusFileSize
new2.59 KB

Sorry, i forgot to attach the cvs file im trying to import

bluegeek9’s picture

Status: Active » Closed (outdated)

Drupal 7 reached end of life and the D7 version of Feeds is no longer being developed. To keep the issue queue focused on supported versions, we’re closing older D7 issues.

If you still have questions about using Feeds on Drupal 7, feel free to ask. While we won’t fix D7 bugs anymore, we’re happy to offer guidance to help you move forward. You can do so by opening (or reopening) a D7 issue, or by reaching out in the #feeds channel on Drupal Slack.

If this issue is still relevant for Drupal 10+, please open a follow-up issue or merge request with proposed changes. Contributions are always welcome!

Now that this issue is closed, review the contribution record.

As a contributor, attribute any organization that helped you, or if you volunteered your own time.

Maintainers, credit people who helped resolve this issue.