[WebERP-developers] Error on DeliveryDetails.php

[Rafael C. <raf...@gm...>]

Hi,

Someone has an idea of where to look for to correct this problem?


on: http://www..../weberp/DeliveryDetails.php?identifier=1380990638


Error de Base de Datos 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 ')' at line 10

Fallo de SQL : El SQL que falló fue
SELECT shipperid, kgrate * 4 AS kgcost, cubrate * 0 AS cubcost, fixedprice,
minimumchg FROM freightcosts WHERE locationfrom = 'CURRI' AND
destinationcountry = 'Costa Rica' AND maxkgs > 4 AND maxcub >0 AND (
destination LIKE '400m%' OR destination LIKE 'Oeste%' OR destination LIKE
'Y%' OR destination LIKE '400m%' OR destination LIKE 'Norte%' OR
destination LIKE 'Urbanización%' OR destination LIKE 'La%' OR destination
LIKE 'Favorita%' OR destination LIKE 'San%' OR destination LIKE 'José,%' OR
destination LIKE 'San%' OR destination LIKE 'José,%' OR destination LIKE
'Pavas%' OR destination LIKE '10109%' OR destination = '' OR)

Regards, Rafael.