Hi guys, first great contribution this is much needed.

I'm having some trouble importing even the basic test csv file that comes with the package.

I get the "This website encourntered an error" message.

Log error:

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'bqr4_file_managed.uri' in 'field list': SELECT {file_managed.uri} FROM {file_managed} ORDER BY {file_managed.fid} DESC limit 1; Array ( ) in Drupal\taxonomy_import\Form\create_taxonomy() (line 85 of /home/SITE/SITEURL/modules/taxonomy_import/src/Form/ImportForm.php).

Drupal Version
9.1.4

CommentFileSizeAuthor
#8 3200709-file-managed-select-query.patch701 bytesAshM

Comments

dx1 created an issue. See original summary.

0ledge’s picture

Hi,

Issue remains for 9.1.5 and getting error when trying to uninstall;

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S02]: Base table or view not found: 1146 Table '[DBTABLE].file_managed' doesn't exist: SELECT file_managed.fid FROM file_managed WHERE uri LIKE :fid; Array ( [:fid] => public://taxonomy_files/% ) in taxonomy_import_uninstall() (line 15 of modules/taxonomy_import/taxonomy_import.install).

I've looked for log entries or other indicators - but haven't found anything further I can contribute with I'm afraid.

Cheers
Marck

vuil’s picture

Version: 2.0.0-alpha3 » 2.x-dev
Status: Active » Postponed (maintainer needs more info)

Could you try the same on 2.x-dev branch. Let us know how to reproduce the same issue. Thank you.

0ledge’s picture

Hi,
I removed the module ( the hard way in directory - since it still won't uninstall ), and installed 2.x-dev branch.

I'm getting this error:
The website encountered an unexpected error. Please try again later.

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'file_managed.uri' in 'field list': SELECT {file_managed.uri} FROM {file_managed} ORDER BY {file_managed.fid} DESC limit 1; Array ( ) in Drupal\taxonomy_import\Form\create_taxonomy() (line 85 of modules/taxonomy_import/src/Form/ImportForm.php).

I have imported the data with a different module in the meantime - so not sure if the error could be caused by that. I don't have a staging system I can clear and test on for that.

Cheers

vincent_jo’s picture

Hi,

same error here with the latest version (taxonomy_import:^2.0.1).

@Oledge:

I have imported the data with a different module in the meantime ....

Which module worked for you?

regards
Vincent

pabliz’s picture

Hi there,

I'm experiencing the same issue.
I'm very new to Drupal so I waited to see if it was me doing something wrong. Hope someone can help.

Thanks,
Paolo

pabliz’s picture

Hi again,
I ended up using a different module called term_csv_export_import.

I'm going to re-test the taxonomy_import module to double check if the error was due to how I was structuring the data within the .csv file.

AshM’s picture

StatusFileSize
new701 bytes

The problem was the structure of the Static database query. Removing the curly braces where the columns were referred, fixed the issue for me.

vuil’s picture

Status: Postponed (maintainer needs more info) » Needs review

  • vuil committed fdd3245 on 2.x authored by AshM
    Issue #3200709 by AshM, vuil: Error when trying to load the test csv
    
vuil’s picture

Status: Needs review » Fixed

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.