Skip to content

This issue was moved to a discussion.

You can continue the conversation there. Go to discussion →

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Uploading Data to Collection #398

Closed
Kantoborgy opened this issue Oct 2, 2023 · 0 comments
Closed

Uploading Data to Collection #398

Kantoborgy opened this issue Oct 2, 2023 · 0 comments

Comments

@Kantoborgy
Copy link

Hi all,
I have the following error when trying to upload new data in a new collection (full text file import). Before the last code update(2023-09-08) , data uploading was working perfectly . My server, Ubuntu 22, MariaDB 15, PHP 8.

Thank you in advance
All the best

Data Upload Module
JARDIN BOTANICO DE LOJA
Last Upload Date: not recorded
Upload Status:
Initiating import from: occurrence-jb.csv
Clearing staging tables
Beginning to load records...
Count: 1000
Data cleaning:
Cleaning event dates...

[Mon Oct 02 08:57:01.155692 2023] [php:error] [pid 108960] [client 72.90.175.164:49705] PHP Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IN(31))' at line 1 in /var/www/html/l/classes/SpecUploadBase.php:635\nStack trace:\n#0 /var/www/html/l/classes/SpecUploadBase.php(635): mysqli->query()\n#1 /var/www/html/l/classes/SpecUploadBase.php(594): SpecUploadBase->recordCleaningStage1()\n#2 /var/www/html/l/classes/SpecUploadFile.php(144): SpecUploadBase->cleanUpload()\n#3 /var/www/html/l/collections/admin/specuploadprocessor.php(132): SpecUploadFile->uploadData()\n#4 {main}\n thrown in /var/www/html/l/classes/SpecUploadBase.php on line 635, referer: http://www.bioloja.org/l/collections/admin/specuploadmap.php

@themerekat themerekat transferred this issue from BioKIC/Symbiota Oct 2, 2023
@BioKIC BioKIC locked and limited conversation to collaborators Oct 2, 2023
@themerekat themerekat converted this issue into discussion #399 Oct 2, 2023

This issue was moved to a discussion.

You can continue the conversation there. Go to discussion →

Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant