Jump to content

huggettm

Member
  • Posts

    294
  • Joined

  • Last visited

Posts posted by huggettm

  1. Thanks, but it didnt like that :)

     

    Error

    Static analysis:

    5 errors were found during analysis.

     

    1. Unexpected token. (near "`price`" at position 36)
    2. Unexpected beginning of statement. (near "`price`" at position 36)
    3. Unexpected beginning of statement. (near "`product_id`" at position 45)
    4. A new statement was found, but no delimiter between it and the previous one. (near "UPDATE" at position 119)
    5. This type of clause was previously parsed. (near "UPDATE" at position 178)

     

    SQL query: Documentation

    INSERT `CubeCart_pricing_quantity` (`price`, `product_id`) SELECT `price`, `product_id` FROM `CubeCart_inventory` UPDATE `CubeCart_pricing_quantity` SET `quantity` = 2 UPDATE `CubeCart_pricing_quantity` SET `price` = `price` * 0.95

    MySQL said: Documentation

    #1064 - 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 'UPDATE `CubeCart_pricing_quantity` SET `quantity` = 2

    UPDATE `CubeCart_pric' at line 4

  2. anyone else set this up?

    I have conversion tracking working in analytics, but it is not being imported properly into adwords (I have followed the steps and imported the transaction goals)

    for each store I have two analytics numbers, one the starts UA-XXXXXXX and another numerical code for a store view, I have always used the UA-XXXXXX code in cubecart?

     

  3. Hi, somehow customers are able to add blank products to the shipping basket

     

    for example

     

    1 x Police Helmet. Hard Plastic (Hats) - Male - One Size - BH031 ($2.68) $2.68
    1 x Glitter Black Toppers, Plastic (Hats) - Unisex - One Size - BH084 ($1.47) $1.47
    1 x - ($0.00) $0.00
    1 x - ($0.00) $0.00
    Subtotal:$4.15
    Total Discount :$0.00
    Shipping:$8.55
    Total Tax:$0.00
    Total:$12.70

     

     

     

    any ideas how? Looking at the db they have a product id of "0"

     

     

     

     

     

×
×
  • Create New...