Re: [WebERP-developers] Error on DeliveryDetails.php

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

Tim Schofield and Ing Marcos R Garcia Trejo:

Thanks for your help.


Web-erp-developers mailing list:

Now, I use webERP version 4.11.0; I updated to it last week-end. Previous
version was 4.10.0 and no similar problem was observed. My results:

1. Yes, "$sql = mb_substr($sql, 0, strrpos($sql,' OR')) . ')';" is the line
64 of includes/FreightCalculation.inc.

2. I added in table "freightcosts" a line with kgrate=0 for shipper "N/A"
("do not apply shipper"), and I got the same problem.

3. I tried to "Place Order" (.../weberp/DeliveryDetails.php) for
"Service/Labour" items, and I got the same problem.

4. I tried to "Place Order" (.../weberp/DeliveryDetails.php) for
"Service/Labour" items with Marcos Garcia Trejos' quick solution (but not
the definitive), and I got SUCCESS Report : Order Number 113 has been
entered.

5. I tried to "Place Order" (.../weberp/DeliveryDetails.php) for
"Manufactured" and "Purchased" items with Marcos Garcia Trejos' quick
solution (but not the definitive), and I got SUCCESS Report : Order Number
114 has been entered.

Regards,

Rafael Chacón
Verdorama


2013/10/5 Marcos Garcia Trejo <ad...@gm...>

> I don't know which version you have, but the last in the sourceforge, the
> file includes/FreightCalculation.inc has the ofender code:
> ===========  CODE ==================
>         // if there is some details of the address besides the country
>         $sql .= " AND (";
>         if ($BrAddCountry !=
> $CountriesArray[$_SESSION['CountryOfOperation']]){
>                     /* For international shipments empty destination (ANY)
> is allowed */
>                     $sql = $sql . " destination = '' OR";
>
>                 }
>                 $sql = mb_substr($sql, 0, strrpos($sql,' OR')) . ')';
>             }
>
>     $CalcFreightCostResult = DB_query($sql,$db);
> =========== \CODE ===============
>
> I guess a quick solution (but not the definitive) was to replace this part
> by:
>                 // if there is some details of the address besides the
> country
>                 $sql .= " AND (";
>                 $OR="";
>                 foreach ($FindCity as $City) {
>                     $sql = $sql . $OR ." destination LIKE '" .
> ucwords($City) . "%'";
>                     $OR= " OR";
>                 }
>                 if ($BrAddCountry !=
> $CountriesArray[$_SESSION['CountryOfOperation']]){
>                     /* For international shipments empty destination (ANY)
> is allowed */
>                     $sql = $sql . $OR. " destination = ''";
>                 }
> //                $sql = mb_substr($sql, 0, strrpos($sql,' OR')) . ')';
>                 $sql .=")";
>             }
>
>     $CalcFreightCostResult = DB_query($sql,$db);
> ================= /code =============
> This form avoids the las " OR"  in the sql
>
>
> 2013/10/5 Rafael Chacón <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.
>>
>>
>> ------------------------------------------------------------------------------
>> October Webinars: Code for Performance
>> Free Intel webinars can help you accelerate application performance.
>> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
>> from
>> the latest Intel processors and coprocessors. See abstracts and register >
>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>
>
> --
> Ing Marcos R Garcia Trejo
> (52) 9991-513412
> Laboratorio de Ingeniería y Procesos Costeros (LIPC)
> Unidad Académica Sisal, UNAM
> MGa...@ii...
> Tel 52 988 931 1000
>
>
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
> from
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>