Jump to content
Sign in to follow this  
spoiledRHOtten

Problem with RMA Return contribution

Recommended Posts

The line in account_history_info is actually:

 

  for ($i=0, $n=sizeof($order->products); $i<$n; $i++) {

 

around line 143


I only do what my Rice Krispies tell me to do!

Share this post


Link to post
Share on other sites

Here's a problem I just encounter.

 

When refunding a payment via gift voucher, I'm gettng the following errer message:

1146 - Table 'flamemak_candlestore.gv_tracking' doesn't exist

 

insert into gv_tracking (gv_number, date_created, customer_id_sent, sent_firstname, sent_surname, emailed_to, gv_amount) values ('b5b1da95f4aced26', NOW(),'0','Sent by','Admin','greg@disneywarehouse.com','6.0000')

 

[TEP STOP]

 

I've got the lates version of Ian's Gift Voucher mod installed. I would like to make these 2 mods play well with each other. In the returns.php file, I think if we ditch the random number generator, and have that portion call Ian's gv_send.php file and pass all appropriate variables, theoretically, it should work properly, writing all data to the correct tables, email, etc....Unfortunatelly, I haven't got a clue as to how to accomplish this as I'm no wiz in php like many of you here are.

 

Any ideas or help would be greatly appreciated!! :o

 

Thanks,

Greg


I only do what my Rice Krispies tell me to do!

Share this post


Link to post
Share on other sites

I have been working with osCommerce for about a week now and when adding the RMA System addon I also encountered the same problem.

 

I have done the following as I believe what this text should say and should be put in the following places.

 

remove any changes you added to your english.php file for this problem and do the following.

 

In your /admin/language/english/ directory

 

File returns_reason.php

add the following line in the area where TEXT is getting defined.

 

define('TEXT_DISPLAY_NUMBER_OF_TICKET_STATUS', 'Number of RMA requests with selected reason.');

 

 

File returns_status.php

add the following line in the area where TEXT is getting defined.

 

define('TEXT_DISPLAY_NUMBER_OF_TICKET_STATUS', 'Number of RMA requests with selected status.');

 

 

File returns_method.php

add the following line in the area where TEXT is getting defined.

 

define('TEXT_DISPLAY_NUMBER_OF_TICKET_STATUS', 'Number of RMA requests with selected payment method.');

 

 

This however only takes care of the text display. When I add the sql to count the number of requests for each of these pages I will post. If someone else does it first then please post.

 

 

8)

Share this post


Link to post
Share on other sites

when i go to my account in the catalog and lcik on previous order i get the following error:

Parse error: parse error, unexpected '<' in /home/virtual/site296/fst/var/www/html/catalog/account_history_info.php on line 146

 

before this i was getting

 

the code for the file specfied is:

for ($i=0, $n=sizeof($order->products); $i<$n; $i++) {if ($order->products[$i]['return'] == '1') {

$rma_query_one = tep_db_query("SELECT returns_id FROM " . TABLE_RETURNS_PRODUCTS_DATA . " where products_id = '" . $order->products[$i]['id'] . "' and order_id = '" . $HTTP_GET_VARS['order_id'] . "'");

$rma_query = tep_db_fetch_array($rma_query_one);

$rma_number_query = tep_db_query("SELECT rma_value FROM " . TABLE_RETURNS . " where returns_id = '" . $rma_query['returns_id'] . "'");

$rma_result = tep_db_fetch_array($rma_number_query);

 

$return_link = '<font color=blue><b>Return # <a href="returns_track.php?action=returns_show&rma=' . $rma_result['rma_value'] . '">' . $rma_result['rma_value'] . '</a>';

 

 

} else {

$return_link = '<a href="' . tep_href_link(FILENAME_RETURN, 'order_id=' . $HTTP_GET_VARS['order_id'] . '&products_id=' . ($order->products[$i]['id']), 'SSL') . '"><font color=red><b>Return this product</a></b></font>';

}

 

full file details:

 

<?php

/*

$Id: account_history_info.php,v 1.100 2003/06/09 23:03:52 hpdl Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

 

require('includes/application_top.php');

 

if (!tep_session_is_registered('customer_id')) {

$navigation->set_snapshot();

tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL'));

}

 

if (!isset($HTTP_GET_VARS['order_id']) || (isset($HTTP_GET_VARS['order_id']) && !is_numeric($HTTP_GET_VARS['order_id']))) {

tep_redirect(tep_href_link(FILENAME_ACCOUNT_HISTORY, '', 'SSL'));

}

 

$customer_info_query = tep_db_query("select customers_id from " . TABLE_ORDERS . " where orders_id = '". (int)$HTTP_GET_VARS['order_id'] . "'");

$customer_info = tep_db_fetch_array($customer_info_query);

if ($customer_info['customers_id'] != $customer_id) {

tep_redirect(tep_href_link(FILENAME_ACCOUNT_HISTORY, '', 'SSL'));

}

 

require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_ACCOUNT_HISTORY_INFO);

 

$breadcrumb->add(NAVBAR_TITLE_1, tep_href_link(FILENAME_ACCOUNT, '', 'SSL'));

$breadcrumb->add(NAVBAR_TITLE_2, tep_href_link(FILENAME_ACCOUNT_HISTORY, '', 'SSL'));

$breadcrumb->add(sprintf(NAVBAR_TITLE_3, $HTTP_GET_VARS['order_id']), tep_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'order_id=' . $HTTP_GET_VARS['order_id'], 'SSL'));

 

require(DIR_WS_CLASSES . 'order.php');

$order = new order($HTTP_GET_VARS['order_id']);

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<html <?php echo HTML_PARAMS; ?>>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">

<title><?php echo TITLE; ?></title>

<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">

<link rel="stylesheet" type="text/css" href="stylesheet.css">

</head>

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">

<!-- header //-->

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

<!-- header_eof //-->

 

<!-- body //-->

<table border="0" width="100%" cellspacing="3" cellpadding="3">

<tr>

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<!-- left_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

<!-- left_navigation_eof //-->

</table></td>

<!-- body_text //-->

<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>

<td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_history.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>

</tr>

</table></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="2">

<tr>

<td class="main" colspan="2"><b><?php echo sprintf(HEADING_ORDER_NUMBER, $HTTP_GET_VARS['order_id']) . ' <small>(' . $order->info['orders_status'] . ')</small>'; ?></b></td>

</tr>

<tr>

<td class="smallText"><?php echo HEADING_ORDER_DATE . ' ' . tep_date_long($order->info['date_purchased']); ?></td>

<td class="smallText" align="right"><?php echo HEADING_ORDER_TOTAL . ' ' . $order->info['total']; ?></td>

</tr>

</table></td>

</tr>

<tr>

<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">

<tr class="infoBoxContents">

<?php

if ($order->delivery != false) {

?>

<td width="30%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">

<tr>

<td class="main"><b><?php echo HEADING_DELIVERY_ADDRESS; ?></b></td>

</tr>

<tr>

<td class="main"><?php echo tep_address_format($order->delivery['format_id'], $order->delivery, 1, ' ', '<br>'); ?></td>

</tr>

<?php

if (tep_not_null($order->info['shipping_method'])) {

?>

<tr>

<td class="main"><b><?php echo HEADING_SHIPPING_METHOD; ?></b></td>

</tr>

<tr>

<td class="main"><?php echo $order->info['shipping_method']; ?></td>

</tr>

<?php

}

?>

</table></td>

<?php

}

?>

<td width="<?php echo (($order->delivery != false) ? '70%' : '100%'); ?>" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="2">

<?php

if (sizeof($order->info['tax_groups']) > 1) {

?>

<tr>

<td class="main" colspan="2"><b><?php echo HEADING_PRODUCTS; ?></b></td>

<td class="smallText" align="right"><b><?php echo HEADING_TAX; ?></b></td>

<td class="smallText" align="right"><b><?php echo HEADING_TOTAL; ?></b></td>

</tr>

<?php

} else {

?>

<tr>

<td class="main" colspan="3"><b><?php echo HEADING_PRODUCTS; ?></b></td>

</tr>

<?php

}

 

for ($i=0, $n=sizeof($order->products); $i<$n; $i++) {if ($order->products[$i]['return'] == '1') {

$rma_query_one = tep_db_query("SELECT returns_id FROM " . TABLE_RETURNS_PRODUCTS_DATA . " where products_id = '" . $order->products[$i]['id'] . "' and order_id = '" . $HTTP_GET_VARS['order_id'] . "'");

$rma_query = tep_db_fetch_array($rma_query_one);

$rma_number_query = tep_db_query("SELECT rma_value FROM " . TABLE_RETURNS . " where returns_id = '" . $rma_query['returns_id'] . "'");

$rma_result = tep_db_fetch_array($rma_number_query);

 

$return_link = '<font color=blue><b>Return # <a href="returns_track.php?action=returns_show&rma=' . $rma_result['rma_value'] . '">' . $rma_result['rma_value'] . '</a>';

 

 

} else {

$return_link = '<a href="' . tep_href_link(FILENAME_RETURN, 'order_id=' . $HTTP_GET_VARS['order_id'] . '&products_id=' . ($order->products[$i]['id']), 'SSL') . '"><font color=red><b>Return this product</a></b></font>';

}

 

<td class="main" valign="top">' . $order->products[$i]['name'] . '   ' . $return_link. .'<br><small><i>' . $desc['products_description'] . '</i></small>';

echo ' <tr>' . "n" .

' <td class="main" align="right" valign="top" width="30">' . $order->products[$i]['qty'] . ' x</td>' . "n" .

' <td class="main" valign="top">' . $order->products[$i]['name'];

 

if ( (isset($order->products[$i]['attributes'])) && (sizeof($order->products[$i]['attributes']) > 0) ) {

for ($j=0, $n2=sizeof($order->products[$i]['attributes']); $j<$n2; $j++) {

echo '<br><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'] . '</i></small></nobr>';

}

}

 

echo '</td>' . "n";

 

if (sizeof($order->info['tax_groups']) > 1) {

echo ' <td class="main" valign="top" align="right">' . tep_display_tax_value($order->products[$i]['tax']) . '%</td>' . "n";

}

 

echo ' <td class="main" align="right" valign="top">' . $currencies->format(tep_add_tax($order->products[$i]['final_price'], $order->products[$i]['tax']) * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . '</td>' . "n" .

' </tr>' . "n";

}

?>

</table></td>

</tr>

</table></td>

</tr>

</table></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td class="main"><b><?php echo HEADING_BILLING_INFORMATION; ?></b></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">

<tr class="infoBoxContents">

<td width="30%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">

<tr>

<td class="main"><b><?php echo HEADING_BILLING_ADDRESS; ?></b></td>

</tr>

<tr>

<td class="main"><?php echo tep_address_format($order->billing['format_id'], $order->billing, 1, ' ', '<br>'); ?></td>

</tr>

<tr>

<td class="main"><b><?php echo HEADING_PAYMENT_METHOD; ?></b></td>

</tr>

<tr>

<td class="main"><?php echo $order->info['payment_method']; ?></td>

</tr>

</table></td>

<td width="70%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">

<?php

for ($i=0, $n=sizeof($order->totals); $i<$n; $i++) {

echo ' <tr>' . "n" .

' <td class="main" align="right" width="100%">' . $order->totals[$i]['title'] . '</td>' . "n" .

' <td class="main" align="right">' . $order->totals[$i]['text'] . '</td>' . "n" .

' </tr>' . "n";

}

?>

</table></td>

</tr>

</table></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td class="main"><b><?php echo HEADING_ORDER_HISTORY; ?></b></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">

<tr class="infoBoxContents">

<td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">

<?php

$statuses_query = tep_db_query("select os.orders_status_name, osh.date_added, osh.comments from " . TABLE_ORDERS_STATUS . " os, " . TABLE_ORDERS_STATUS_HISTORY . " osh where osh.orders_id = '" . (int)$HTTP_GET_VARS['order_id'] . "' and osh.orders_status_id = os.orders_status_id and os.language_id = '" . (int)$languages_id . "' order by osh.date_added");

while ($statuses = tep_db_fetch_array($statuses_query)) {

echo ' <tr>' . "n" .

' <td class="main" valign="top" width="70">' . tep_date_short($statuses['date_added']) . '</td>' . "n" .

' <td class="main" valign="top" width="70">' . $statuses['orders_status_name'] . '</td>' . "n" .

' <td class="main" valign="top">' . (empty($statuses['comments']) ? ' ' : nl2br(tep_output_string_protected($statuses['comments']))) . '</td>' . "n" .

' </tr>' . "n";

}

?>

</table></td>

</tr>

</table></td>

</tr>

<?php

if (DOWNLOAD_ENABLED == 'true') include(DIR_WS_MODULES . 'downloads.php');

?>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">

<tr class="infoBoxContents">

<td><table border="0" width="100%" cellspacing="0" cellpadding="2">

<tr>

<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

<td><?php echo '<a href="' . tep_href_link(FILENAME_ACCOUNT_HISTORY, tep_get_all_get_params(array('order_id')), 'SSL') . '">' . tep_image_button('button_back.gif', IMAGE_BUTTON_BACK) . '</a>'; ?></td>

<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

</tr>

</table></td>

</tr>

</table></td>

</tr>

</table></td>

<!-- body_text_eof //-->

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<!-- right_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>

<!-- right_navigation_eof //-->

</table></td>

</tr>

</table>

<!-- body_eof //-->

 

<!-- footer //-->

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<!-- footer_eof //-->

<br>

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Share this post


Link to post
Share on other sites

looks like this subject died or moved but i'll ask anyway

this is what i run into @ return_product.php

Warning: htmlspecialchars() expects parameter 1 to be string, array given in /includes/functions/general.php on line 42

This is on MS2 and the lines are:

// Parse the data used in the html tags to ensure the tags will not break

 function tep_parse_input_field_data($data, $parse) {

   return strtr(trim($data), $parse);

 }



 function tep_output_string($string, $translate = false, $protected = false) {

   if ($protected == true) {

     return htmlspecialchars($string);

   } else {

     if ($translate == false) {

       return tep_parse_input_field_data($string, array('"' => '"'));

     } else {

       return tep_parse_input_field_data($string, $translate);

     }

   }

 }



 function tep_output_string_protected($string) {

   return tep_output_string($string, false, true);

 }



 function tep_sanitize_string($string) {

   $string = ereg_replace(' +', ' ', trim($string));



   return preg_replace("/[<>]/", '_', $string);

 }



////

// Return a random row from a database query

 function tep_random_select($query) {

   $random_product = '';

   $random_query = tep_db_query($query);

   $num_rows = tep_db_num_rows($random_query);

   if ($num_rows > 0) {

     $random_row = tep_rand(0, ($num_rows - 1));

     tep_db_data_seek($random_query, $random_row);

     $random_product = tep_db_fetch_array($random_query);

   }



   return $random_product;

 }



////


The more you do, the more you learn

Share this post


Link to post
Share on other sites

I found a problem in the account_history_info file at row 36

$order = new order($HTTP_GET_VARS['order_id']);

 

It seems there is some need to updte the php system platform

to get this to function properly, or can you go around the problem

with some fix? Please advice.

 

 

The line in account_history_info is actually:

 

  for ($i=0, $n=sizeof($order->products); $i<$n; $i++) {

 

around line 143

Share this post


Link to post
Share on other sites

Hi..

I have the same problem under MS2 if I return_product.php to run.

This error appears :

 

 Warning: htmlspecialchars() expects parameter 1 to be string, array given in /includes/functions/general.php on line 42

 

Please help me.

 

cu

billi


My English is unfortunately bad. Excused ask.

Share this post


Link to post
Share on other sites

Parse error: parse error, expecting `')'' in /home/dynamic2/public_html/cart/catalog/includes/classes/order.php on line 122

 

Fatal error: Cannot instantiate non-existent class: order in /home/dynamic2/public_html/cart/catalog/return_product.php on line 22

Share this post


Link to post
Share on other sites

Nice mod!

 

Can any one help me change the percentage charge to a fixed price charged for each return.

 

Also in the Returns Admin under each section it says "TEXT_DISPLAY_NUMBER_OF_TICKET_STATUS" where the path to the module should be, any ideas?

 

All help apreciated!

Share this post


Link to post
Share on other sites

hiya all

This sounds like a wonderful mod,, I just got a few ,, uhm,, random features to work out yet,, LOL

I downloaded the v2.1 and installed it,,, and when I am on the customer side, place an item in the cart and click on checkout, it starts to load the checkout_shipping.php and I am getting the following Error's

 

Parse error: parse error, unexpected ';', expecting ')' in /var/www/html/includes/classes/order.php on line 121

 

Fatal error: Cannot instantiate non-existent class: order in /var/www/html/checkout_shipping.php on line 43

 

now,, the first one,, in orders.php

 

here is lines 115 through 128

 

115 'return' => $orders_products['products_returned'],

116 'exchange' => $orders_products['products_exchanged'],

117 'exchange_id' => $orders_products['products_exchanged_id'],

118

119

120

 

121 $subindex = 0;

 

122 $attributes_query = tep_db_query("select products_options, products_options_values, options_values_price, price_prefix from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_id = '" . (int)$order_id . "' and orders_products_id = '" . (int)$orders_products['orders_products_id'] . "'");

123 if (tep_db_num_rows($attributes_query)) {

124 while ($attributes = tep_db_fetch_array($attributes_query)) {

125 $this->products[$index]['attributes'][$subindex] = array('option' => $attributes['products_options'],

 

 

now for checkout_shipping.php

here is lines 41 through 44

 

41

42 require(DIR_WS_CLASSES . 'order.php');

43 $order = new order;

44

 

anyone have any thoughts as to fixing this?

Thanks all for the help

Tom


no bugs in my stuff,,, just random features ;)

Share this post


Link to post
Share on other sites

Awesome mod btw guys and thanks to all who contributed in here!

 

I have a question (if anyone has it fixed) - a few posts ago, I saw something where people had a problem with the amount showing as $0 after an RMA is processed by the client. The last I saw was to change a few instances of final_price to price. Doing so did not fix this unless I missed something, somewhere? Were fixes maybe sent through PM's instead of on the forum?

 

 

Help please anyone...


Don't go around saying the world owes you a living. The world owes you

nothing. It was here first.

-- Mark Twain

Share this post


Link to post
Share on other sites
I did the changes mentioned above to fix returning a quantity greater then one, and having the correct total show up.

 

The files edited were:

 

/catalog/return_product.php

/catalog/include/modules/return_track.php

/admin/returns_invoice.php

 

The problem still persists in the following areas:

 

1.  Customer tracks an order and now the total price in the return is $0.00

 

2.  In Admin - Returned Products - Edit - Both "Total (ex)" and "Total (inc)" are way off as before.

 

3.  In Admin - Returned Products - Invoice - "Total (ex)" is way off.  Then again maybe it is suppose to be, as I am not sure what the difference is in Total(ex) and Total(inc)

 

Any ideas?

 

This is the problem I'm currently experiencing - everything else works great from what I can see.

 

Did anyone find a fix for this? Pretty please.. someone please help


Don't go around saying the world owes you a living. The world owes you

nothing. It was here first.

-- Mark Twain

Share this post


Link to post
Share on other sites

Thanks David!! It's working 110% now, with 0 bugs, nags and whatever bites ;)

 

You Da Man!!

 

Jess.

 

btw, for other folks going to use this mod, don't forget about the author (let's not let him starve) !!!


Don't go around saying the world owes you a living. The world owes you

nothing. It was here first.

-- Mark Twain

Share this post


Link to post
Share on other sites

this would be a wonderful mod,, but for me,, it wouldnt work,, and i got no response to my post here,,, Thanks anyway,, and David,, thanks for all the hard work on the mod,, just wish i could use it

Tom


no bugs in my stuff,,, just random features ;)

Share this post


Link to post
Share on other sites
Thanks David!! It's working 110% now, with 0 bugs, nags and whatever bites ;)

 

You Da Man!!

 

Jess.

 

btw, for other folks going to use this mod, don't forget about the author (let's not let him starve) !!!

I can't follow this - I am assuming that somebody pm'd the solution - please post to the forums for the benefit of others.

 

Thankyou,

 

Matti


Matti Ressler

 

We were all once expert at...... nothing

_____

Share this post


Link to post
Share on other sites

anyone have any luck with this on MS2?

 

Thanks in advance.

Tom


no bugs in my stuff,,, just random features ;)

Share this post


Link to post
Share on other sites

I have installed this contribution and all is going well phew...!

 

Wehn i try to admin a return and add the product back into stock then i try to refund the item using a gv and i get this error

 

1146 - Table 'db86081255.gv_tracking' doesn't exist

 

insert into gv_tracking (gv_number, date_created, customer_id_sent, sent_firstname, sent_surname, emailed_to, gv_amount) values ('836dd1c6bca85d05', NOW(),'0','Sent by','Admin','mark@goodvibrations.me.uk','78.7500')

 

[TEP STOP]

 

I have looked at the sql and the database but the table has not been created??

 

any ideas how to rectify this pls appreciated

 

thnaks

 

mark


Regards

 

Mark A Reynolds

Share this post


Link to post
Share on other sites

I have installed rma on ms2 2.2.

All is ok but when i try to "track a return" and i insert my number i can' t find anything...

Why?

What can i do?

 

Thank you.

Share this post


Link to post
Share on other sites

got the basic operation going.

but have some problems

first,, with RMA Tracker.

it brings up the page to put the RMA number in,, when clicked it goes to a login screen,, <even though was logged in to begin with> put in login information, click,, and it goes back to the login screen, put in login info, and then it goes on but gives an error msg saying details do not match records.

 

then,, when requesting a RMA number.

the page with the info comes up, but has a $0 amount.

when u put in the details, and click to continue, it goes to a login page,

<even though they were logged in to begin with>

then procedes on to give a RMA number.

 

then,, the last problem,, is on the admin side,,,

when you open a RMA request,, there are like 4 preset message buttons, when clicked, they do not show the correct msg,,

 

Any thoughts on any of this.

 

I did find where someone else had said to replace two lines to fix the tracker login issue, but when I tried this, I got a parse error,

 

Anyone have a fix for these issues please

 

 

Thanks in advance

Regards

Tom


no bugs in my stuff,,, just random features ;)

Share this post


Link to post
Share on other sites
Thanks David!! It's working 110% now, with 0 bugs, nags and whatever bites ;)

 

You Da Man!!

 

Jess.

 

btw, for other folks going to use this mod, don't forget about the author (let's not let him starve) !!!

I can't follow this - I am assuming that somebody pm'd the solution - please post to the forums for the benefit of others.

 

Thankyou,

 

Matti

:P Sorry - there's not much to report back since we got it fixed with an alternative solution (but still based on this contribution). But posting it here would probably confuse the heck out of others and would require quite a few changes. Almost a whole new contribution.

 

I'm sure David would gladly help out if you asked him "properly" :)


Don't go around saying the world owes you a living. The world owes you

nothing. It was here first.

-- Mark Twain

Share this post


Link to post
Share on other sites

Matti

 

I never could get a solution either and ended up just having to remove it,

maybe someone will either post a ms2 compatable,, or even an ms3 compatable when it breaks,,

 

would love to have had this, but never could get all the problems fixed and no one seemed to have a solution.

 

Regards

Tom


no bugs in my stuff,,, just random features ;)

Share this post


Link to post
Share on other sites

Linda,

 

So this will work with ms2 as it is now? or will i still have a lot of trouble installing it with many problems?

 

Thanks for the work and any info ,,

 

Regards

Tom


no bugs in my stuff,,, just random features ;)

Share this post


Link to post
Share on other sites

This is the "out of the box" file from the contribution with my HTML modifications. This should work for anyone's OSC running this.

 

Just rename your old file to a .bak extension and upload this new one. Should be fine and dandy.

 

FYI I am running Linda McGrath's OSC/SEC/GV MS.S2 flalvor.

Edited by MsGIF

Share this post


Link to post
Share on other sites

I also added to catalog/return_product.php the following code. When the RMA number is returned to the customer, it gives them instructions on how to return their product. Perhaps I missed something, but I didn't see this anywhere in the mod.

 

<tr>
	 <td><?php echo tep_draw_separator('pixel_trans.gif', '20', '20'); ?></td>
         </tr>
         <tr>
           <td class="main"><B>Follow these instructions for returning your item.</B> <OL><LI>Package item in origjnal shipping container, if possible. If not, carefully package in a cardboard box with sufficient padding.<LI>Include copy of original invoice.<LI>If item had product packaging, documentation, cables, power cords, manuals, software, etc. They are to be returned with the product. Incomplete product returns will be returned to you and your refund denied.<LI>On outside of package add RMA number shown above. Packages not displaying a valid RMA number are refused and returned back to the sender.<LI>Address your package to <BR><B>BUSINEAME Returns<BR>BUSINESS STREET ADDRESS<BR>BUSINESS CITY STATE ZIPCODE</B>.<LI>Insure your package. We are not responsible for additional damage or loss of package during shipping.</td>
         </tr>

 

I place this at line 288. On my page the code above is placed AFTER

 

<?php
if ($HTTP_GET_VARS['action'] == 'sent'){
          $text_query = tep_db_query("SELECT * FROM " . TABLE_RETURNS_TEXT . " where return_text_id = '1' and language_id = '" . $languages_id . "'");
          $text = tep_db_fetch_array($text_query);

       //   tep_db_query("INSERT into " . TABLE_RETURN_PAYMENTS . " values ('', '" . $HTTP_GET_VARS['id'] . "', '', '', '', '', '')");
            ?>
         <tr>
       <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
         <tr>
           <td class="main"><?php new infoBox(array(array('text' => '<center><font color=blue size=4px><b>Your RMA number :- '. $HTTP_GET_VARS['rma_value'] . '</b></font></center>'))); ?></td>
         </tr>
          <tr>
	 <td><?php echo tep_draw_separator('pixel_trans.gif', '20', '20'); ?></td>
         </tr>
         <tr>
           <td class="main"><?php new infoBox(array(array('text' => nl2br($text['return_text_one'])))); ?></td>
         </tr>

 

I am know there is a way to set this up to automatically take text from an english file after setting up something like

 

infoBox(array(array('text' => nl2br($text['return_text_one']

 

I just don't know how to do it to automate it to insert the info (business address).

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×