Kristoff

Hi Al, have just tried changing it to AES and still no joy. Do I need to clear the cache?

Still no error showing up. Transactions are showing up in the Transaction log: Order Number Sort by Total descending Sort by Total ascendingTotal Sort by Gateway descending Sort by Gateway ascendingGateway Sort by Date descending Sort by Date ascendingDate 131031-*** £0.50 SagePay Today, 19:49 131031-*** £0.50 SagePay Today, 17:38 131031-*** £0.50 SagePay Today, 16:53 But when you go in to them it shows: Transaction ID Status Amount Gateway Date/Time Notes Not Available £0.50 SagePay Today, 19:49

Yep, here is what I had before: public function process() { trigger_error('From SagePay: QueryString: ' . print_r($_SERVER['QUERY_STRING'] , true)); $Decoded = $this->_decodeAndDecrypt($_REQUEST['crypt']); Will try that now. Cheers

Still no error

Yep, obviously an issue with unhiding the categories or something with the database?

No error is showing after doing another transaction.

In mysagepay when viewing the transaction details it is represented as: https://www.fullurl.com/index.php?_g=rm&type=gateway&cmd=process&module=SagePay&cart_order_id=*ORDERNUMBER*A After paying for an item I ended up back on the store with the order page saying "pending" here: https://www.fullurl.com/index.php?cart_order_id=*ORDERNUMBER*&_a=complete

That and a clear of the cache has worked. Cheers!

Ok, it's still returning as Status "Not Available" in orders, and no transaction ID, however, this is the URL it returned me to: *storeURL*/index.php?cart_order_id=1**0*1-1**2*4-9**6&_a=complete ?? Line 363 of gateway.class: if($values['Status']=="OK"){ $order->orderStatus(Order::ORDER_PROCESS, $cart_order_id); $order->paymentStatus(Order::PAYMENT_SUCCESS, $cart_order_id); $transData['notes'] = $values['StatusDetail']; } else { $order->orderStatus(Order::ORDER_PENDING, $cart_order_id); $order->paymentStatus(Order::PAYMENT_PENDING, $cart_order_id); $transData['notes'] = $values['StatusDetail']; } $order->logTransaction($transData); httpredir(currentPage(array('_g', 'type', 'cmd', 'module'), array('_a' => 'complete'))); return false; } public function form() { return false; } } Mean anything?!

In the sagepay transactions area of MySagePay Have just put another transaction through to confirm that in sagepay it does say the correct order number next to "To pay for:" there is no A following the number. I have asked one of my colleagues if they can get me the callback URL for a previously successful payment.

I'm no expert but i'm guessing you could maybe import them via phpMyAdmin in some way. Or in phpMyAdmin run a script such as "Insert into cubecart_categories ". There might be an easier way.

."&SuccessURL=".$GLOBALS['storeURL'].'/index.php?_g=rm&type=gateway&cmd=process&module=SagePay&cart_order_id='.$this->_basket['cart_order_id'] ."&FailureURL=".$GLOBALS['storeURL'].'/index.php?_g=rm&type=gateway&cmd=process&module=SagePay&cart_order_id='.$this->_basket['cart_order_id'] That's those lines. The thing that struck me as strange was the fact they were both the same. Does the A stand for authenticated or something? Added on by Sagepay?

Have done, again, and again, and again

These are in the admin area: Dashboard » Orders » 13**1-15***33-59** Then on the transaction log page. Callback URL in sagepay is: **storeurl***/index.php?_g=rm&type=gateway&cmd=process&module=SagePay&cart_order_id=13**1-15***33-59**A I note an additional A at the end of the URL there, could that be an issue?

Ok think this may be the problem: Status - Amount - Gateway - Date/Time Not Available - £0.50 - SagePay - Today, 15:50 ??? Anybody any idea why the status of the order is unavailable?! No, gone to pending also.

That works perfectly thanks my friend. The only issue i've got now (I think it may be a bug?) is that after hiding and unhiding the category called "Hidden" we now can't add any products to it? On Dashboard » Products » Item » Categories, it doesn't even show our category, yet the category is there and active in Categories...

Hi again guys, just ran in to a bit of an issue, with our old store (4.4.4) digital products were set as completed as soon as payment was made from sagepay, but now when we pay it's going to the order and the status is "Pending" has something changed? Or have I missed something I should change? Thanks in advance!

Is there a way of me hiding a category ID from the navigation?

For what it's worth, is there a way of me hiding a category ID from the navigation?

Afraid not as the store is currently offline to public. We're not using a featured product box, so we're ok there. I found this in catalogue.class, but removing and changing the hide=0 (for all instances) hasn't resulted in any joy. $query = sprintf("SELECT I.*, %2$s AS Relevance FROM %1$sCubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM %1$sCubeCart_pricing_group $group_id GROUP BY product_id) as G ON G.product_id = I.product_id $joinString WHERE I.product_id IN (SELECT product_id FROM `%1$sCubeCart_category_index` as CI INNER JOIN %1$sCubeCart_category as C where CI.cat_id = C.cat_id AND C.hide = 0) AND I.status = 1 AND (%2$s) >= %4$f %3$s %5$s %6$s", $GLOBALS['config']->get('config', 'dbprefix'), $match, $whereString, $match_val, $order_string, $limit); if (($search = $GLOBALS['db']->query($query)) !== false) { $q2 = sprintf("SELECT COUNT(I.product_id) as count, %2$s AS Relevance FROM %1$sCubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM %1$sCubeCart_pricing_group $group_id GROUP BY product_id) as G ON G.product_id = I.product_id $joinString WHERE I.product_id IN (SELECT product_id FROM `%1$sCubeCart_category_index` as CI INNER JOIN %1$sCubeCart_category as C where CI.cat_id = C.cat_id AND C.hide = 0) AND I.status = 1 AND (%2$s) >= %4$f %3$s GROUP BY I.product_id %5$s", $GLOBALS['config']->get('config', 'dbprefix'), $match, $whereString, $match_val, $order_string);

I've just tried kurouto and still nothing showing up. I've just noticed I need to update my sig, we're now on 5.2.4 Thanks for this Al, for me it makes no sense to show items in a search, but not to be able to link to them directly. Surely it makes more sense to have them hidden on a search whether or not the item is available to view?

A custom skin, can't even remember which we used as a base skin. I will take a look at kurouto and see if I can see anything as a give away. Cheers

That's what we get, but we actually want to be able to see the item. I will take a look in catalog class

We've just updated our store and on 4.4.4 (I think it was) we had a hidden category, but we could link directly to products for people to buy (think things like tickets that only certain clients are invited to. The problem is though, since updating, when you view a product in a hidden file now, it is just a plain blank page. Anyone know how to sort it? It doesn't make much sense seeing as the items show up in search results, but then when you click them, it's just blank?! Any help appreciated! Many thanks

That worked perfectly thank you. I had a bit of a shuffle, as I don't use buy buttons on the homepage, but a More Info button, I added the code to the product page itself and as i'm not sure if there would be any issue with it, but I only needed to use the <input onclick="this.name='stay';submit();" value="Add &amp; Remain" class="button_white" /> button, I found it added a load of extra space to the button for some reason, but the original <input type="submit" value="{$LANG.catalogue.buy}"> button works fine for going direct to the basket upon adding. Many thanks again!