Announcement

Collapse
No announcement yet.

[SOLVED] Error with image multiupload when foreign key > 999

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • [SOLVED] Error with image multiupload when foreign key > 999

    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.

  • #2
    I fixed this bug. i disabled "digit grouping". so SC takes the number without separators.

    Comment

    Working...
    X