New 
Dangeo1
-
Posts
44 -
Joined
-
Last visited
Posts posted by Dangeo1
-
-
Bump for love.
Anybody?
-
I've got a problem with my UPS rates and I'm trying to get UPS to help me solve them.
Basically, their XML rates are lower than the rates actually charged. I'm a small store and take my UPS deliveries to the retail outlet for shipment. So, I sent them an e-mail complaining about it.
We've checked all the "usual" suspects and now they want a capture of the XML string that was sent requesting the rate, and the response received. (along with other information).
It'll be easy enough to re-create the order, but how can I go about grabbing the XML data stream?
-
Also, I recommed a program like Editplus to use for editing your php files.
It does a good job of color-coding the text to tell what things are comments, functions, HTML, etc...
-
Ok, here's what I did.
I used the readme.txt to manually update the admincategories.php. It appears to be working fine.
But, I did notice one of the changes asks to change code that has already been replaced.
"Header Tag Controller Admin MS 2.2.TXT"
Find the following (approx line 603) $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'"); $product = tep_db_fetch_array($product_query); Replace with the following $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'"); $product = tep_db_fetch_array($product_query);The only place that code exists in the categories.php is already replaced with the following instruction from "Header Tag Controller Admin MS 2.2.TXT"
Find the following (approx line 743) <?php } elseif ($action == 'new_product_preview') { if (tep_not_null($HTTP_POST_VARS)) { $pInfo = new objectInfo($HTTP_POST_VARS); $products_name = $HTTP_POST_VARS['products_name']; $products_description = $HTTP_POST_VARS['products_description']; $products_url = $HTTP_POST_VARS['products_url']; } else { $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . $HTTP_GET_VARS['pID'] . "'"); $product = tep_db_fetch_array($product_query); } Replace with the following <?php } elseif ($action == 'new_product_preview') { if (tep_not_null($HTTP_POST_VARS)) { $pInfo = new objectInfo($HTTP_POST_VARS); $products_name = $HTTP_POST_VARS['products_name']; $products_description = $HTTP_POST_VARS['products_description']; $products_head_title_tag = $HTTP_POST_VARS['products_head_title_tag']; $products_head_desc_tag = $HTTP_POST_VARS['products_head_desc_tag']; $products_head_keywords_tag = $HTTP_POST_VARS['products_head_keywords_tag']; $products_url = $HTTP_POST_VARS['products_url']; } else { $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . $HTTP_GET_VARS['pID'] . "'"); $product = tep_db_fetch_array($product_query);I dunno, maybe I hacked it and turned it into a timebomb.
-
That error is from admincategories.php
-
I have attempted to install the admin portion of the header tag controller, and get the following error:
1054 - Unknown column 'c.categories_status' in 'field list'
select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, c.categories_status from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '1' order by c.sort_order, cd.categories_name
There was no mention of adding fields for the admin portion. I have added all required by Linda's part.
Any help would be great.
-
Thanks for pointing that out.
:D
I've been in such a rush to get the site up, I missed the standard gif.
:?
-
I am implementing the UPS XML shipping price contribution, and have discovered that "shipping_upsxml.gif" is missing.
Does anybody have a valid UPS gif I can use, or should I go steal one from UPS website?
UPS XML Contribution (debugging)
in General Add-Ons Support
Posted
Thanks!
Re-created order contents/address, and made a /tmp/upsxml.log file.
It's not working yet, but I haven't given up.