3242 replies to this topic

[surfalot]

nafri, on 21 December 2009, 14:32, said:

the total calculated is right..but the sort order is not.

known problem, no known fix.

[bhbilbao]

Quote

Im looking for a bit of help. When I am attempting to send a new order confirmation email, I am getting an error that reads
"1146 - Table 'XXXXXX.eorder_text' doesn't exist
SELECT * FROM eorder_text where eorder_text_id = '2' and language_id = '1'

The last version support it , but you must install Send HTML email V2- Otherwhise remove the buttom.

You must also to update database:

DROP TABLE IF EXISTS `eorder_text`;
CREATE TABLE `eorder_text` (
  `eorder_text_id` tinyint(3) unsigned NOT NULL default '0',
  `language_id` tinyint(3) unsigned NOT NULL default '1',
  `eorder_text_one` text,
  PRIMARY KEY  (`eorder_text_id, language_id`)
) ;

etc,etc,etc

I have other problem usin AJAX, the email forms return on blank.

Example:
Dear JOSE GARCIA
We would like to notify you that the status of your order has been update.

Order Number:
Date Ordered:: Wednesday 23 December, 2009
Detailed Invoice:

EMAIL_TEXT_COMMENTS_UPDATE_HTML

Thank you so much for your order with us!

The status of your order has been updated.

New status:


.......


Could anyone help me???

[bhbilbao]

I have other problem using without AJAX.

In editor screen apeared 2 checkboxes:
X Shipping same as billing address
X Billing same as customer address

I checked them and update. And now they are always minimized and dont kown how to came back them.

[bhbilbao]

<td valign="middle" class="dataTableContent"><input type="checkbox" name="shipping_same_as_billing"> <?php echo TEXT_SHIPPING_SAME_AS_BILLING; ?></td>

<td colspan="4" valign="middle" class="dataTableContent"><input type="checkbox" name="billing_same_as_customer"> <?php echo TEXT_BILLING_SAME_AS_CUSTOMER; ?></td>

anyone?

[surfalot]

bhbilbao, on 23 December 2009, 21:51, said:

I have other problem usin AJAX, the email forms return on blank.

Example:
Dear JOSE GARCIA
We would like to notify you that the status of your order has been update.

Order Number:
Date Ordered:: Wednesday 23 December, 2009
Detailed Invoice:

EMAIL_TEXT_COMMENTS_UPDATE_HTML

Thank you so much for your order with us!

The status of your order has been updated.

New status:


.......


Could anyone help me???

not sure what you tell you, "EMAIL_TEXT_COMMENTS_UPDATE_HTML" doesn't appear in my last version. Doesn't look like the last uploaders are supporting their stuff. Maybe try the version I uploaded before all the crazy contribution where added.

[Denkster]

Hi,
Can you please help me with this?

I installed contri 1435 OrderEditor version 5.0.9,
on a OsC rc2a with Super Download shop, iDeal, Paypal IPN.
My dialog for edit orders
1. Misses the 'submit' buttons
2. shows the next text 3 times:

Warning: number_format() expects parameter 1 to be double, string given in C:\Server\www\myserver.dev\public_html\winkel\admin\edit_orders.php on line 1737


This is the piece of code around line 1737 in edit_order.php

if (ORDER_EDITOR_USE_AJAX == 'true') { echo
'   <td align="right" class="dataTableContent">' . "\n" .
'     <input name="update_totals['.$i.'][title]" id="'.$id.'[title]" value="'
         . trim($order->totals[$i]['title'])
         . '" onChange="obtainTotals()"></td>' . "\n" .
'   <td align="right" class="dataTableContent">' . "\n" .
'     <input name="update_totals['.$i.'][value]" id="'.$id.'[value]" value="'
         . number_format($order->totals[$i]['value'], 2, '.', '')
         . '" size="6" onChange="obtainTotals()"></td>' . "\n" .
'   <td align="right" class="dataTableContent">' . "\n" .
'     <input name="update_totals['.$i.'][class]" type="hidden" value="'
         . $order->totals[$i]['class'] . '"></td>' . "\n" .
'   <td align="right" class="dataTableContent">' . "\n" .
'    <input name="update_totals['.$i.'][id]" type="hidden" value="'
         . $shipping_module_id . '" id="' . $id . '[id]"></td>' . "\n";
} else { echo
'   <td align="right" class="dataTableContent">' . "\n" .
'     <input name="update_totals['.$i.'][title]" id="'.$id.'[title]" value="'
         . trim($order->totals[$i]['title']) . '"></td>' . "\n" .
'   <td align="right" class="dataTableContent">' . "\n" .
'     <input name="update_totals['.$i.'][value]" id="'.$id.'[value]" value="'
         . number_format($order->totals[$i]['value'], 2, '.', '')
         . '" size="6">' . "\n" .
'     <input name="update_totals['.$i.'][class]" type="hidden" value="'
         . $order->totals[$i]['class'] . '">' . "\n" .
'     <input name="update_totals['.$i.'][id]" type="hidden" value="'
         . $shipping_module_id . '" id="' . $id . '[id]"></td>' . "\n";
}

AFAIK the warning means that number_format($order->totals[$i]['value'], 2, '.', '') in the if statement before else is wrong, because $order->totals[$i]['value'] seems to be a string, while a 'double numeric' is required.

What can I do to avoid the warnings?
These warnings completely destroy the lay out.

This is my development configuration:

MySQL

* Server: MySQL host info: 127.0.0.1 via TCP/IP
* Serverversie: 5.1.41-community
* Protocolversie: 10
* Gebruiker: XXXXXXXXX@localhost
* MySQL Karakterset: UTF-8 Unicode (utf8)

Web server

* Apache/2.2.14 (Win32) PHP/5.3.1
* MySQL-client versie: mysqlnd 5.0.5-dev - 081106 - $Revision: 289630 $
* PHP uitbreiding: mysql

Thanks in advance for your help!
Eveline

Edited by Denkster, 03 January 2010, 22:49.

[tarroz]

The state field was changed to a number 223 after adding a product. Has anyone encounter this problem?
For example the state filed shows California in Customer, Billing Address, and Shipping Address but then after adding a product, all 3 state fields are changed to number 223. see the picture here: [img]http://www.bootcraze.com/ordereditorStateError.jpg[/img]

Thanks in advance

Edited by tarroz, 06 January 2010, 21:56.

[kenz]

I'm reading through this forum but does anyone know if its possible to update the products ordered and cost of an "existing order" before its finally captured in authorize.net? There are a million reasons why a customer would want to call back after making an order and making a request to adjust it. Is there a guide, tutorial, link, web site that talks about this very issue? Is it possible to adjust the current order without reordering everything all over again from either the store front or admin????

Edited by kenz, 08 January 2010, 08:03.

[surfalot]

kenz, on 08 January 2010, 08:01, said:

I'm reading through this forum but does anyone know if its possible to update the products ordered and cost of an "existing order" before its finally captured in authorize.net? There are a million reasons why a customer would want to call back after making an order and making a request to adjust it. Is there a guide, tutorial, link, web site that talks about this very issue? Is it possible to adjust the current order without reordering everything all over again from either the store front or admin????

stock osCommerce charges the order at the time of placing an order. This contribution does not have a facility to make adjustments to the credit card payment after an order is edited. This contribution allows you to change the order after the charge has been made, so you must manually collect the customer's CC when you have them on the phone and make adjustments through the Authnet virtual terminal as needed by the order adjustment.

You would want to look for contribution that allows you to delay the processing of the CC until a time of your choosing. But then, how long to do wait for the customer to call about changes? 1 day? 2 days? Do you want to delay your order fulfillment to wait for those changes? Or maybe its better to simply get the card processed and the order shipped as quickly as possible.

You should also consider CC merchant agreements. If you are in the US, CC merchant policy is to not store the security code electronically. So if you use a contribution to delay processing the CC in order to allow for a phone call to change the order, then you are violating the merchant agreement. If someone were to break into your site while some of those card holders' info is still there, you could get a stiff penalty from Visa or MC.

[surfalot]

tarroz, on 06 January 2010, 21:49, said:

The state field was changed to a number 223 after adding a product. Has anyone encounter this problem?
For example the state filed shows California in Customer, Billing Address, and Shipping Address but then after adding a product, all 3 state fields are changed to number 223. see the picture here:

Thanks in advance

that's quite interesting. The version I'm working from (surfalot 18 Nov 2009) has a state dropdown list, it would not be possible for what you are describing.

[gremlin484]

I'm currently running Order Editor v5.0.5 in a production environment.

I want to upgrade to the most recent version.

Is it recommended to apply each update one by one up to the current, or can I jump straight to the current?

Thanks

[surfalot]

gremlin484, on 09 January 2010, 03:08, said:

I'm currently running Order Editor v5.0.5 in a production environment.

I want to upgrade to the most recent version.

Is it recommended to apply each update one by one up to the current, or can I jump straight to the current?

Thanks

if you understand how to work a file compare tool, jump. I've seen a couple strange comments since the v5.0.8 & 9, so if you have trouble with the latest, try the version I upped.

[tarroz]

surfalot, on 08 January 2010, 15:14, said:

that's quite interesting. The version I'm working from (surfalot 18 Nov 2009) has a state dropdown list, it would not be possible for what you are describing.

I was using the newest version: 5.0.9b Full and I also tried 5.0.7 both had the same problem. The problem actually lies in my old version of general.php which had an old version of function tep_get_zone_name as follows:

  function tep_get_zone_name($zone_id) {
    $zone_query = tep_db_query("select zone_name from " . TABLE_ZONES . " where zone_id = '" . $zone_id . "'");

    if (!tep_db_num_rows($zone_query)) {
      return $zone_id;
    } else {
      $zone = tep_db_fetch_array($zone_query);
      return $zone['zone_name'];
    }
  } 

which should be changed to the current function:

  function tep_get_zone_name($country_id, $zone_id, $default_zone) { 
    $zone_query = tep_db_query("select zone_name from " . TABLE_ZONES . " where zone_country_id = '" . (int)$country_id . "' and zone_id = '" . (int)$zone_id . "'");
    if (tep_db_num_rows($zone_query)) {
      $zone = tep_db_fetch_array($zone_query);
      return $zone['zone_name'];
    } else {
      return $default_zone;
    }
  }

[wvdbroek]

bhbilbao, on 23 December 2009, 21:51, said:

The last version support it , but you must install Send HTML email V2- Otherwhise remove the buttom.

You must also to update database:

DROP TABLE IF EXISTS `eorder_text`;
CREATE TABLE `eorder_text` (
  `eorder_text_id` tinyint(3) unsigned NOT NULL default '0',
  `language_id` tinyint(3) unsigned NOT NULL default '1',
  `eorder_text_one` text,
  PRIMARY KEY  (`eorder_text_id, language_id`)
) ;

etc,etc,etc

when i trie to run the above on DB then i get

Fout
SQL-query:

CREATE TABLE `eorder_text` (

`eorder_text_id` tinyint( 3 ) unsigned NOT NULL default '0',
`language_id` tinyint( 3 ) unsigned NOT NULL default '1',
`eorder_text_one` text,
PRIMARY KEY ( `eorder_text_id, language_id` )
);



MySQL retourneerde:

#1072 - Key column 'eorder_text_id, language_id' doesn't exist in table

someone any idea

tnxs

[surfalot]

wvdbroek, on 14 January 2010, 16:50, said:

someone any idea

tnxs

the error in that sql should be corrected as follows:

DROP TABLE IF EXISTS `eorder_text`;
CREATE TABLE `eorder_text` (
 `eorder_text_id` tinyint(3) unsigned NOT NULL default '0',
 `language_id` tinyint(3) unsigned NOT NULL default '1',
 `eorder_text_one` text,
 PRIMARY KEY (`eorder_text_id`, `anguage_id`)
) ;

but my guess is there is more to this then adding the table.

Edited by surfalot, 14 January 2010, 17:39.

[wvdbroek]

surfalot, on 14 January 2010, 17:38, said:

the error in that sql should be corrected as follows:

DROP TABLE IF EXISTS `eorder_text`;
CREATE TABLE `eorder_text` (
 `eorder_text_id` tinyint(3) unsigned NOT NULL default '0',
 `language_id` tinyint(3) unsigned NOT NULL default '1',
 `eorder_text_one` text,
 PRIMARY KEY (`eorder_text_id`, `anguage_id`)
) ;

but my guess is there is more to this then adding the table.

tnxs and yes there is now i added the table i get

Fatal error: Call to undefined function tep_add_base_ref() in edit_orders_ajax.php on line 1144

again any idea

[surfalot]

wvdbroek, on 14 January 2010, 18:01, said:

tnxs and yes there is now i added the table i get

Fatal error: Call to undefined function tep_add_base_ref() in edit_orders_ajax.php on line 1144

again any idea

sure, use the version I uploaded. It works fine.

[wvdbroek]

surfalot, on 14 January 2010, 18:07, said:

sure, use the version I uploaded. It works fine.

wich one is that ?

tnxs

[surfalot]

wvdbroek, on 15 January 2010, 11:30, said:

wich one is that ?

tnxs

there is only one that was uploaded under my id.

[wvdbroek]

surfalot, on 15 January 2010, 12:03, said:

there is only one that was uploaded under my id.

is there an difference between version 5.0.7 and the one i installed 5.0.9 ?

tnxs again