Checkout issue, taxes, email

Fair enough, but that url is always going to be appended to the order number unless I get the business edition?

Where is this box coming from (circled in red)? How do I get rid of it?

Hi,

I wanted to try on firefox 4 but your website seems to be down. I'm getting the error below when trying to display it:
Database Error: Unable to connect to the database:Could not connect to MySQL

If you want to remove the URL, you can change completely the translation string and remove all the parameters.
So the line:
ORDER_CREATION_SUCCESS_ON_WEBSITE_AT_DATE="We are pleased to confirm the creation of your order No. %s at %s on the %s at %s"
could be:
ORDER_CREATION_SUCCESS_ON_WEBSITE_AT_DATE="We are pleased to confirm the creation of your order on our website."
for example in the translation file that you can edit via the interface we provide in the config under the tab languages.
But you won't be able to keep the order number while removing the URL as they are both given as one parameter to the translation system.


Concerning the box next to the button, that's a problem in the version 1.4.7 of HikaShop. If you update to the latest version, you should not get the problem anymore.

Hi-
According to the backend, I'm running 1.4.8 which it claims is the latest stable version. I just downloaded it 2 or 3 days ago. So is that url married to every instance of order number so that I have to eliminate the order number wherever it appears? What is the purpose of the url?
My site is loading now.
Thank you.

Then maybe the file cart of the view product was customized via the menu Display->Views and that's why you didn't get the fix. If you remove the customization, the problem should disappear.
That URL enables the user to access to his order details on your website. In the commercial versions, you can display a print button so that he can print his invoice. That's also where the user can download the files attached to the products he bought.

We'll look at the firefox thing tomorrow, it's getting late here.

Okay. Here is a screen cap of the error. Not that it helps much. It only happens when I hit the back button or cmd+back arrow. First it goes to this:

Then when I can actually get it to load it goes to this. Note that the original cart only contained the item circled in red:

Hi,

I tried just now to reproduce the problem with the new version of firefox but I'm not able to proceed to the next step of the checkout on your website. Did you change something since yesterday ?

I see what you mean. I just cleaned up the formatting for the login/registration page by giving it it's own div in the views dialog. Could this be a problem?

That sounds different. What checkout workflow do you use ?

You're right. I did mess with the checkout flow yesterday. Let me fix it. In the meantime, is there a changelog or something for the cart so I can insert or delete the code that makes the little box next to the checkout button without wiping out my customization?

If you change the line:
$this->params->set('show_quantity_field', -1);
to:
$this->params->set('show_quantity_field', 0);
in the cart file of the view product, that should solve the problem.

Thanks. The checkout workflow is should be working now. I'm not getting the server error anymore, just random stuff added to the cart. I will post a series of screen caps.

I'm not able to login anymore on your checkout so I still can't proceed to the testing.
It thinks that I want to register when I click on login. I see that you changed the login file of the view checkout. Could that be linked ?

For the error, I saw that post: forums.powweb.com/showthread.php?t=78849
Do you use that hosting ? Could you try the recommendations on that thread (activate CGI...) ?

Also, could you get your PHP error logs ? That should help us understand what this error is about.

Interesting. I will look into these things over the weekend. Thanks for all your help.

I am trying to locate my error logs. That is not the hosting I use. I use ipage. I'm not sure what you mean by I changed the login file of the view checkout. I had no problem logging in. The error disappeared for a while but it's back since the weekend. Also, I tried that code for the shopping cart but it didn't appear to do anything.

I was able to reproduce the problem, the login is working now

So, it's hard to say why that error happen. As written in the error message, you should look at the error logs. There should be written the cause of the 500 error and that will help us understand why it fails there.

I'm still getting this box despite replacing the code. The problem is, I'm not sure how to re-create the customizations I have applied to my cart so I don't want to just download an update.
How do I get rid of the VAT line on invoices?
The other error doesn't seem to be happening anymore for the moment.
Thanks for your help!

The line change I posted should work as it worked for everyone else. Could you post the code of the cart file ?

For the invoice, you need to edit the file invoice of the view order and remove the code you don't want.

<?php
/**
* @package HikaShop for Joomla!
* @version 1.4.3
* @author hikashop.com
* @copyright (C) 2010 HIKARI SOFTWARE. All rights reserved.
* @license GNU/GPLv3 www.gnu.org/licenses/gpl-3.0.html
*/
defined('_JEXEC') or die('Restricted access');
?>
<?php
$this->setLayout('listing_price');
$this->params->set('show_quantity_field', 0);
$comp_description = $this->params->get('comp_description');
if(empty($comp_description)){
$this->params->set('comp_description',JText::_('CART_EMPTY'));
}
?>
<div id="hikashop_checkout_cart" class="hikashop_checkout_cart">
<?php
if(empty($this->rows)){
echo $this->params->get('comp_description');
}else{
?>
<br/>
<table width="100%">
<thead>
<tr>
<th id="hikashop_cart_product_name_title" class="hikashop_cart_title">
<?php echo JText::_('CART_PRODUCT_NAME'); ?>
</th>
<th id="hikashop_cart_product_price_title" class="hikashop_cart_title">
<?php echo JText::_('CART_PRODUCT_UNIT_PRICE'); ?>
</th>
<th id="hikashop_cart_product_quantity_title" class="hikashop_cart_title">
<?php echo JText::_('PRODUCT_QUANTITY'); ?>
</th>
<th id="hikashop_cart_product_total_title" class="hikashop_cart_title">
<?php echo JText::_('CART_PRODUCT_TOTAL_PRICE'); ?>
</th>
</tr>
</thead>
<tbody>
<?php
$k = 0;
foreach($this->rows as $i => $row){
if(empty($row->cart_product_quantity)) continue;
?>
<tr class="<?php echo "row$k"; ?>">
<td style="width:40%">
<p class="hikashop_cart_product_name">
<a href="<?php echo hikashop::completeLink('product&task=show&cid='.$row->product_id);?>" ><?php echo $row->product_name; ?></a>
</p>
</td>
<td>
<?php
$this->row=&$row;
$this->unit=true;
echo $this->loadTemplate();
?>
</td>
<td>
<input id="hikashop_checkout_quantity_<?php echo $row->product_id;?>" type="text" name="data[<?php echo $row->product_id;?>]" class="hikashop_product_quantity_field" value="<?php echo $row->cart_product_quantity; ?>" onchange="this.form.submit(); return false;" />
<?php if($this->params->get('show_delete',1)){ ?>
<a href="<?php echo hikashop::completeLink('product&task=updatecart&product_id='.$row->product_id.'&quantity=0&url='.$this->params->get('url')); ?>" onclick="var qty_field = document.getElementById('hikashop_checkout_quantity_<?php echo $row->product_id;?>'); qty_field.value=0; qty_field.form.submit(); return false;" ><img src="<?php echo HIKASHOP_IMAGES . 'delete2.png';?>" border="0" alt="remove product" /></a>
<?php } ?>
</td>
<td>
<?php
$this->row=&$row;
$this->unit=false;
echo $this->loadTemplate();
?>
</td>
</tr>
<?php
$k = 1-$k;
}
?>
</tbody>
<tfoot>
<tr>
<td colspan="4">
<hr></hr>
</td>
</tr>
<?php if(!empty($this->coupon) || !empty($this->shipping)){
?>
<tr>
<td>
</td>
<td>
</td>
<td id="hikashop_checkout_cart_total2_title" class="hikashop_cart_title">
<?php echo JText::_('HIKASHOP_TOTAL'); ?>
</td>
<td>
<?php
$this->row=$this->total;
echo $this->loadTemplate();
?>
</td>
</tr>
<?php }
if(!empty($this->coupon)){
?>
<tr>
<td>
</td>
<td>
</td>
<td id="hikashop_checkout_cart_coupon_title" class="hikashop_cart_title">
<?php echo JText::_('HIKASHOP_COUPON'); ?>
</td>
<td>
<span class="hikashop_checkout_cart_coupon">
<?php
echo $this->currencyHelper->format(@$this->coupon->discount_value*-1,@$this->coupon->discount_currency_id);
?>
</span>
</td>
</tr>
<?php
}
$taxes = round($this->full_total->prices[0]->price_value_with_tax-$this->full_total->prices[0]->price_value,$this->currencyHelper->getRounding($this->full_total->prices[0]->price_currency_id));
if(!empty($this->shipping)){
?>
<tr>
<td>
</td>
<td>
</td>
<td id="hikashop_checkout_cart_shipping_title" class="hikashop_cart_title">
<?php echo JText::_('HIKASHOP_SHIPPING'); ?>
</td>
<td>
<span class="hikashop_checkout_cart_shipping">
<?php
if(bccomp($taxes,0,5)){
echo $this->currencyHelper->format(@$this->shipping->shipping_price,$this->shipping->shipping_currency_id);
}else{
echo $this->currencyHelper->format(@$this->shipping->shipping_price_with_tax,$this->shipping->shipping_currency_id);
}
?>
</span>
</td>
</tr>
<?php
}
if(bccomp($taxes,0,5)){ ?>
<tr>
<td>
</td>
<td>
</td>
<td id="hikashop_checkout_cart_tax_title" class="hikashop_cart_title">
<?php echo JText::_('TAXES'); ?>
</td>
<td>
<span class="hikashop_checkout_cart_taxes">
<?php
echo $this->currencyHelper->format($taxes,$this->full_total->prices[0]->price_currency_id);
?>
</span>
</td>
</tr>
<?php }?>
<tr>
<td>
</td>
<td>
</td>
<td id="hikashop_checkout_cart_final_total_title" class="hikashop_cart_title">
<?php echo JText::_('HIKASHOP_FINAL_TOTAL'); ?>
</td>
<td>
<span class="hikashop_checkout_cart_final_total">
<?php
echo $this->currencyHelper->format($this->full_total->prices[0]->price_value_with_tax,$this->full_total->prices[0]->price_currency_id);
?>
</span>
</td>
</tr>
</tfoot>
</table>
<?php
if($this->params->get('show_quantity')){ ?>
<noscript>
<input id="hikashop_checkout_cart_quantity_button" class="button" type="submit" name="refresh" value="<?php echo JText::_('REFRESH_CART');?>"/>
</noscript>
<?php }
} ?>
</div>