Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#75 sql syntax error when using customer card

v3.56
closed
uniCenta
sql syntax (1)
1
2014-07-31
2013-11-06
Lordrak
No

Hi,
I found bug when I want to use customer card. I'm getting error check sql syntax near 'where card = 'some_id_start_with_C' and visible = true order by name' at line 1
Could you check it please?

Discussion

  • uniCenta
    uniCenta
    2013-11-07

    • status: open --> accepted
    • assigned_to: uniCenta
    • Group: v3.55 --> v3.56
     
  • uniCenta
    uniCenta
    2013-12-01

    Lordrak

    Where are you getting this error. Detail please.

    Jack

     
  • uniCenta
    uniCenta
    2013-12-01

    • status: accepted --> pending
     
  • Lordrak
    Lordrak
    2013-12-02

    Hi Jack,

    I have setup new user and generate barcode for him.
    When i want scan user code (to buy something) this error occurs.

     
  • jlz
    jlz
    2014-01-01

    the fix in source is in DataLogicSales.java line 769.

               + "REGION, "
                + "COUNTRY, "
                + "IMAGE "
                + "FROM CUSTOMERS "
                + "WHERE CARD = ? AND VISIBLE = " + s.DB.TRUE() + " "
                + "ORDER BY NAME"
                , SerializerWriteString.INSTANCE
                , new CustomerExtRead()).find(card);
    
    • "IMAGE" needs to have a space after it to be + "IMAGE "
     
  • Lordrak
    Lordrak
    2014-01-10

    Or can I get access to source code please to repair it myself? I was try two times register for access to source code but mail dont arive yet(more that a month).

     
    Last edit: Lordrak 2014-01-10
  • uniCenta
    uniCenta
    2014-07-31

    • status: pending --> closed