notcrack

Turns out I can't add it as solved. I should also mention that the carrier list search doesn't work, but that isn't a problem for me.

I hope no-one minds me doing this, but I have just struggled to find this information and thought I'd share it. I have several carriers on offer and it is a benefit to have that information at a quick glance. After having a little search of Vekia's fantastic site (mypresta) I found he had whipped up a tutorial on getting the tracking numbers displayed. This was a good start, but finding the code to add the carriers was a little more difficult. I searched a number of threads until I found someone who had posted the info. All info is from Vekia and a forum user called adam4x4 I am running 1.5.6.2 Find this code in AdminOrdersController $this->_join = ' LEFT JOIN `'._DB_PREFIX_.'customer` c ON (c.`id_customer` = a.`id_customer`) LEFT JOIN `'._DB_PREFIX_.'order_state` os ON (os.`id_order_state` = a.`current_state`) LEFT JOIN `'._DB_PREFIX_.'order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = '.(int)$this->context->language->id.')'; $this->_orderBy = 'id_order'; $this->_orderWay = 'DESC';Add these lines $this->_join = ' LEFT JOIN `'._DB_PREFIX_.'carrier` ca ON (ca.`id_carrier` = a.`id_carrier`) LEFT JOIN `'._DB_PREFIX_.'order_carrier` oc ON a.`id_order` = oc.`id_order` LEFT JOIN `'._DB_PREFIX_.'customer` c ON (c.`id_customer` = a.`id_customer`) LEFT JOIN `'._DB_PREFIX_.'order_state` os ON (os.`id_order_state` = a.`current_state`) LEFT JOIN `'._DB_PREFIX_.'order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = '.(int)$this->context->language->id.')'; $this->_orderBy = 'id_order'; $this->_orderWay = 'DESC';Then lower down in the same file find$this->fields_list = array( 'id_order' => array( 'title' => $this->l('ID'), 'align' => 'center', 'width' => 25 ), 'reference' => array( 'title' => $this->l('Reference'), 'align' => 'center', 'width' => 65 ), 'new' => array( 'title' => $this->l('New'), 'width' => 25, 'align' => 'center', 'type' => 'bool', 'tmpTableFilter' => true, 'icon' => array( 0 => 'blank.gif', 1 => array( 'src' => 'note.png', 'alt' => $this->l('First customer order'), )And add$this->fields_list = array( 'id_order' => array( 'title' => $this->l('ID'), 'align' => 'center', 'width' => 25 ), 'reference' => array( 'title' => $this->l('Reference'), 'align' => 'center', 'width' => 65 ), 'carrier' => array( 'title' => $this->l('Carrier'), 'width' => 100, 'type' => 'select', 'list' => $cariers_array, 'filter_key' => 'ca!name', 'filter_type' => 'int' ), 'tracking_number' => array( 'title' => $this->l('Tracking Number'), 'havingFilter' => true, ), 'new' => array( 'title' => $this->l('New'), 'width' => 25, 'align' => 'center', 'type' => 'bool', 'tmpTableFilter' => true, 'icon' => array( 0 => 'blank.gif', 1 => array( 'src' => 'note.png', 'alt' => $this->l('First customer order'), )This will give you the name of the carrier and tracking number in your orders list. I hope this helps someone, but I usually come back to these little things for my own future use. Cheers Marking it as solved

I'm not one for bumping, but does anyone have any idea on what I should be doing with this issue. Cheers

Hey everyone, I have been setting up a new store and have been pulling my hair out over the variables used in the mailalert modules. I have modified the templates for account.html - This template works perfectly as I haven't added any new variables to the html. Variables used {email} - Works {passwd} - Works {shop_name} - Works order_conf.html {firstname} - Works {lastname} - Works {email} - Works {date} - Works {payment} - Works {products} - Changed from {items} and now works {total_products} - Works {total_discounts} - Works {total_wrapping} - Works {total_shipping} - Works {total_tax_paid} - Works {total_paid} - Works {carrier} - Works {delivery_block_html} - Works {invoice_block_html} - Works {message} - Not working {shop_name} - Works payment.html {payment} - Not working {order_name} - Working {date} - Not working {payment} - Not working {total_paid} - Working {delivery_block_html} - Not working {invoice_block_html} - Not working preparartion.html {firstname} - Working {lastname} - Working {order_name} - Working {date} - Not working {delivery_block_html} - Not working {invoice_block_html} - Not working refund.html {firstname} - Working {lastname} - Working {order_name} - Working {date} - Not working {payment} - Not working {total_paid} - Working shipped.html {firstname} - Works {lastname} - Works {order_name} - Works {date} - Not working {payment} - Not working {total_paid} - Working {items} - Not working {total_products} - Not working {total_discounts} - Not working {total_wrapping} - Not working {total_shipping} - Not working {total_tax_paid} - Not working {total_paid} - Works {carrier} - Not working {shipping_number} - Not working {followup} - Not working {delivery_block_html} - Not working {invoice_block_html} - Not working {message} - Not working {shop_name} - Works When I went to test I found the above results, so I've done a lot of searching, but the only real result I have come up with is creating a mail.php override, but then I have no idea how to add all the above variables to it. I know it's a tall order, but if someone could help me out that would be amazing. I'm using 1.5.6.2 Thank you.

I have completely forgotten to update this thread. The problem was caused by me using a back up of an old database that had not been upgraded. If you are suffering this issue after an upgrade you must Re-install the first prestashop version you were using. Apply your backed up database Use the one click update process This will change your backup to be compatible with the newer version. Hope this helps someone. Cheers everyone

Hey El Patron, Thanks for the help. Your advice has sorted this situation. For anyone who might have the same problems here is the process I went through to get this sorted First of all you need to have a backup of your old config/settings.inc.php In that file you will find some code that looks like this <?php define('_DB_SERVER_', 'localhost'); define('_DB_NAME_', 'pruspa_YourDBName'); define('_DB_USER_', 'pruspa_YourDBName'); define('_DB_PASSWD_', 'S7P]4-JU77'); define('_DB_PREFIX_', 'ps_'); define('_MYSQL_ENGINE_', 'InnoDB'); define('_PS_CACHING_SYSTEM_', 'CacheMemcache'); define('_PS_CACHE_ENABLED_', '0'); define('_MEDIA_SERVER_1_', ''); define('_MEDIA_SERVER_2_', ''); define('_MEDIA_SERVER_3_', ''); define('_COOKIE_KEY_', 'n1v4q4q4kchz4zjv1jn1st2wdshw2qc9uxz3r8vam1ownuqsdotjvvmc'); define('_COOKIE_IV_', '6etby8h3'); define('_PS_CREATION_DATE_', '2014-02-26'); define('_PS_VERSION_', '1.5.6.2'); define('_RIJNDAEL_KEY_', 'WVxy1OLbv3sID4aHbfjhgNM05OZpZCBf'); define('_RIJNDAEL_IV_', 'BJ1B545iTmjFRrxQ2rhadw=='); You then want to copy define('_COOKIE_KEY_', 'n1v4q4q4kchz4zjv1jn1st2wdshw2qc9uxz3r8vam1ownuqsdotjvvmc'); define('_COOKIE_IV_', '6etby8h3'); define('_RIJNDAEL_KEY_', 'WVxy1OLbv3sID4aHbfjhgNM05OZpZCBf'); define('_RIJNDAEL_IV_', 'BJ1B545iTmjFRrxQ2rhadw=='); Over to your new config/settings.inc.php When you have done this you will need to redo your admin password so you can log in to the backoffice. Take your _COOKIE_KEY_ over to http://www.md5.cz/ and put it into the box provided. Then add your password on the end I.E n1v4q4q4kchz4zjv1jn1st2wdshw2qc9uxz3r8vam1ownuqsdotjvvmcbackofficepassword and then hit the hash darling, hash button. Take the new md5 checksum and open your phpMyAdmin and select your database (If you don't know which is which it's the one named in your new settings.inc.php file under _DB_NAME_ Find the employee table and change the existing passwd entry with your new md5 checksum. Save the entry and the retry logging in. Hope this helps someone

Last question I promise Do I need to modify the RIJNDAEL_KEY and RIJNDAEL_IV as well. Some people say yes and some say no. Sorry for this, but I do really appreciate the help.

Hey El Patron, I think I've found what I need to change, but is it really as simple as putting the orignial cookie key and cookie iv into the setting.inc.php? Would it harm it being on two separate sites?? Cheers boss.

I did move the database to a new installaion. Is there a way to resolve this? Thanks boss

Hey all, I have recently moved my database to a new site and the existing customers can't log in. Can someone please tell me what I need to change because this is causing problems all over. Thanks I went from 1.5.3.1 > 1.5.6.2 Everything else seems to work. I have also changed the URL slightly if that makes a difference.

Hi Vekia, As always thank you. I'll PM the details to you. Kind Regards

I've just had a major crash on my old install, so had to upgrade everything and then add the old database. Everything seems to working well apart from my inability to add anything to the cart. The animation works, but nothing goes into the cart. Does anyone have any ideas on what I can change? Kind Regards pureleaf.co.uk

Hi Mepis, Thanks for your suggestion. I gave that a try, but I couldn't get it to work, but this was down to my hosting service. I did messa round with the code on the order-carrier.tpl and got a passable verification check box so this will have to do. If anyone wants to know what I did. Just go to the order-carrier.tpl and find {if $conditions AND $cms_id} <h3 class="condition_title">{l s='Terms of service'}</h3> <p class="checkbox"> <input type="checkbox" name="cgv" id="cgv" value="1" {if $checkedTOS}checked="checked"{/if} /> <label for="cgv">{l s='I agree to the Terms of Service and will adhere to them unconditionally.'}</label> <a href="{$link_conditions}" class="iframe">{l s='(Read Terms of Service)'}</a> </p> <script type="text/javascript">$('a.iframe').fancybox();</script> {/if} and change it to this {if $conditions AND $cms_id} <h3 class="condition_title">{l s='Terms of service & Age verification'}</h3> <p class="checkbox"> <input type="checkbox" name="cgv" id="cgv" value="1" {if $checkedTOS}checked="checked"{/if} /> <label for="cgv">{l s='I confirm that I am aged 18 or over.'}</label></br> <input type="checkbox" name="cgv" id="cgv" value="1" {if $checkedTOS}checked="checked"{/if} /> <label for="cgv">{l s='I agree to the Terms of Service and will adhere to them unconditionally.'}</label> <a href="{$link_conditions}" class="iframe">{l s='(Read Terms of Service)'}</a> </p> <script type="text/javascript">$('a.iframe').fancybox();</script> {/if} It seems to work fine and should stop any underage buyers. Hope ti helps

I am in the process of signing up with Allied Wallet and they are requesting an age verification on checkout. I can't seem to find anything that will do this. Anyone got any ideas??

I was a bit premature posting this problem. There was already a fix posted. I can't find the post at the moment, but what you need to do to fix this issue is modify the googleshipping.php from function GoogleFlatRateShipping($name, $price) { $this->name = $name; $this->price = $price; } To this function GoogleFlatRateShipping($name, $price) { $this->name = 'Shipping'; $this->price = $price; }