An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /batch?render=overlay&id=13&op=do StatusText: Service unavailable (with message) ResponseText: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'support_t.vid' in 'where clause': SELECT t.tid FROM {taxonomy_term_data} t INNER JOIN {taxonomy_term_hierarchy} h ON t.tid = h.tid WHERE :name LIKE LOWER(t.name) AND {t.vid} = :vid ORDER BY {t.tid} ASC LIMIT 1; Array ( [:name] => canvec [:vid] => 5 ) in taxonomy_csv_term_find() (line 92 of /home/wikisharedmaporg/community.sharedmap.org/sites/all/modules/taxonomy_csv/taxonomy_csv.term.api.inc).

CommentFileSizeAuthor
#2 taxonomy_csv-node1209216-comment2.patch740 bytesrickmanelius
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

h4ck3rm1k3’s picture

h4ck3rm1k3 CreditAttribution: h4ck3rm1k3 commented

The basic import of a single column csv with names list not working.

the file looks like this:

Canvec
Amusement park
Auto wrecker

Importation failed. Import process was successful until the line 1 of a total of 92. You can first check your file on this line and check file uploading.
This issue is related to import process or to size import and probably not to content. You can disable hierarchy check and reduce log level. You can divide your import file into lighter files. You can increase php and sql memory. If problem does not disappear, you can reinstall module from a fresh release or submit an issue on Taxonomy CSV import/export module.

rickmanelius’s picture

rickmanelius CreditAttribution: rickmanelius commented
FileSize
taxonomy_csv-node1209216-comment2.patch740 bytes

This is a SQL syntax error. Lines like

$sql .= ' AND {h.parent} = :parent';

should not be wrapped in {} because they have already been aliased. h.parent is sufficient.

Here's a patch.

Daniel_KM’s picture

Daniel_KM CreditAttribution: Daniel_KM commented
Status: Active » Closed (duplicate)

Hi,

Thanks for your patch. This issue is a duplicate of this one. I've just committed it.

Sincerely,

Daniel Berthereau
Infodoc & knowledge management

hermitsinister’s picture

hermitsinister CreditAttribution: hermitsinister commented
Issue summary: View changes

the patch has not been applied fully into the new module source file.. i found it that way...

$result = db_query($sql, $args);

this should be updated in the file.. instead of "fetch" in the end..
worked for me that way.

I am new here so if this does not help accept apologies :)