Results 1 to 10 of 11

Hybrid View

  1. #1
    Join Date
    Jun 2011
    Posts
    63
    Plugin Contributions
    0

    Default Is this a bug in v1.50? orders_total doesn't output "text" but "value"

    i use zen cart 1.39 for some sites, they work well
    but for the sites which use zen cart 1.50, i find an issue

    in admin orders page,

    Sub-Total: $30.00
    Shipping cost: $2.00
    Total: $32.00

    for zen1.39, the "$32.00" is from the column "text" of sql table zen_orders_total
    but for zen150, it is the record of the column "value" and plus "$" before it

    from phpmyadmin, i tried modifying the column "text" from "$32.00" to "hello", it changes nothing in admin orders page, then i tried modifying the column "value" from "32.00" to "111.00", it shows "$111.00" in admin orders page

    i guess this not correct, is there anything i missed?
    Last edited by inception; 4 Sep 2012 at 07:27 AM.

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,755
    Plugin Contributions
    9

    Default Re: Is this a bug of zen cart 1.50? orders_total doesn't output "text" but "value"

    Why are you trying to edit through phpmyadmin??
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Jun 2011
    Posts
    63
    Plugin Contributions
    0

    Default Re: Is this a bug of zen cart 1.50? orders_total doesn't output "text" but "value"

    i am not trying to edit,
    i edited it only for make sure that the record on admin orders page is from column "text" or "value" of table zen_orders_total

    in zen_orders_tatal, the record of column "text" is $32.00, of column ''value" is "32.00",
    it displays "Total: $32.00" on admin orders page
    in fact, in zen1.50, this "$32.00" is from the column "value" and plus the "$"

    but in zen 1.39, it is from the column "text", it is "$32.00"
    Last edited by inception; 4 Sep 2012 at 08:24 AM.

  4. #4
    Join Date
    Jun 2011
    Posts
    63
    Plugin Contributions
    0

    Default Re: Is this a bug of zen cart 1.50? orders_total doesn't output "text" but "value"

    i have more than one currency,
    1.50, it always displays "Total: $32.00" on admin orders page wherever this order is placed from USD or GBP
    1.39, it displays "Total: $32.00" or "Total: £20.12" depends on which currency the customer chose

    another problem is that i use mod reward points full suit, that mod needs to output the records from column "text" cause all records of the column "value" are 0, this thread http://www.zen-cart.com/showthread.p...55#post1147655

  5. #5
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,755
    Plugin Contributions
    9

    Default Re: Is this a bug of zen cart 1.50? orders_total doesn't output "text" but "value"

    From your other thread
    Quote Originally Posted by inception
    i guess it is a bug of reward point full suite 2.1b on zen cart 1.50
    Why are you reposting this same issue?
    Zen-Venom Get Bitten

  6. #6
    Join Date
    Jun 2011
    Posts
    63
    Plugin Contributions
    0

    Default Re: Is this a bug of zen cart 1.50? orders_total doesn't output "text" but "value"

    firstly i thought its the problem of the mod reward points, i did many test, i was looking for help from the thread of that mod, untill one hour ago, after so many tests, i finally found that is not the reward point issue, its the issue of zen cart 1.50, so i posted here, cause i don't think i could find the solution from that thread, since its not cause by that mod

  7. #7
    Join Date
    Jun 2011
    Posts
    63
    Plugin Contributions
    0

    Default Re: Is this a bug of zen cart 1.50? orders_total doesn't output "text" but "value"

    i use some sites 1.39 and some sites 1.50, they work well on 1.39 sites, but all sites 1.50 get the same issue
    it outputs record of column "value" of table zen_orders_order on admin orders page

    if the default currency is USD, the customer place order from GDP, then the record of column "text" is "£20.12", of column "value" is "32.00",
    1.50 it displays "Total: $32.00" on admin orders page,
    1.39 it displays "Total: £20.12" on admin orders page

    is this the issue of zen cart 1.50? cause all my sites 1.50 get this issue, but i'm not sure, perhaps i missed something?
    any help?

  8. #8
    Join Date
    Jun 2011
    Posts
    63
    Plugin Contributions
    0

    Default Re: Is this a bug of zen cart 1.50? orders_total doesn't output "text" but "value"

    any idea?

  9. #9
    Join Date
    Jun 2003
    Location
    Newcastle UK
    Posts
    2,925
    Plugin Contributions
    4

    Default Re: Is this a bug of zen cart 1.50? orders_total doesn't output "text" but "value"

    Hi,

    Yes, it does look as though there was a bug introducd into v1.5 in the admin/orders.php file

    at approximately line 600 you will have a line like this

    Code:
              '                <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $currencies->format($order->totals[$i]['value'], false) . '</td>' . "\n" .

    try changing it to

    Code:
               '                <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $currencies->format($order->totals[$i]['value'], true, $order->info['currency'], $order->info['currency_value']) . '</td>' . "\n" .
    Last edited by wilt; 5 Sep 2012 at 11:21 AM.

 

 

Similar Threads

  1. v154 Deleting an Option with a "TEXT" or "FILE" value for ALL products
    By kcb410 in forum Setting Up Categories, Products, Attributes
    Replies: 26
    Last Post: 3 Feb 2015, 08:18 PM
  2. v138a SQL to change "master_categories_id" value based on "products_name"
    By WayneStephens in forum General Questions
    Replies: 3
    Last Post: 5 Apr 2013, 05:21 AM
  3. Cant change the value "true" and "False" everywhere!
    By smartboy in forum Templates, Stylesheets, Page Layout
    Replies: 0
    Last Post: 22 Nov 2010, 02:22 PM
  4. Replies: 3
    Last Post: 3 Jun 2008, 11:41 AM
  5. Ability to get a list of "option value" by "customer"?
    By Banhi in forum Setting Up Categories, Products, Attributes
    Replies: 4
    Last Post: 26 Jan 2008, 07:57 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg