My SC Version 7.01.0021
Hi, i am got an error with image multiupload. i was working fine.
I already uploaded some images
My Table products: PRO_PRDCTO (master - primary key pro_cdgo)
My Table for multiupload: anp_anxos_prdctos (has foreing key pro_cdgo)
My Primary key for products is autonumeric , when the code of table products (the foreign key for table multi upload) is greater than 999 cause this error.
Message error of SC
Error in insert:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘190 ORDER BY ANP_CDGO ASC’ at line 1
View SQL
In mode debug i can see select statement is adding a separator to sql.
For table products this is sql.
SELECT PRO_CDGO, NEG_CDGO, … FROM PRO_PRDCTO
WHERE (PRO_CDGO = 6190) order by PRO_CDGO
For table multiupload this is sql.
(pdo-mysql): SELECT ANP_CDGO, ANP_BLOB FROM anp_anxos_prdctos
WHERE NEG_CDGO = 1
AND PRO_CDGO = 6,190 ORDER BY ANP_CDGO ASC
I can see 6,190 with separator comma. This is error when SC try retrieve images.