Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

ianric

Pioneers
  • Posts

    373
  • Joined

  • Last visited

  • Days Won

    1

Posts posted by ianric

  1. Hi

     

    Sorry to hijack another post but my prob is similar with the same contrib. Did anyone have an answer to this??

     

    I've got it all working except for the specials and new_products pages (boxes seem to be OK). If I have a hidden category, when I pick on the arrow in the box heading I get a 1064 error

     

    1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*) as total from products p, products_description pd, specials s, products_to_c' at line 1

     

    select count(distinct *) as total from products p, products_description pd, specials s, products_to_categories p2c where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and p.products_id = p2c.products_id and (not p2c.categories_id in (26,53)) and pd.language_id = '1' and s.status = '1'

     

    26 & 53 are my hidden category id's. I'm also using the default specials.php from RC2.2a, PHP 5.3 and mysql 5.1.37

     

    I can't find that SQL anywhere in my files. This is what the contrib install says for the specials page

     

    Around line 54 find the line that reads as follows:

     

    $specials_query_raw = "select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by s.specials_date_added DESC";

     

    and REPLACE it with the following:

     

    if (!empty($hiddencats)) {

    $specials_query_raw = "select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and p.products_id = p2c.products_id and (not p2c.categories_id in (" . implode(',', $hiddencats) . ")) and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' group by p.products_id order by s.specials_date_added DESC";

    } else {

    $specials_query_raw = "select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by s.specials_date_added DESC";

    }

     

    If I var_dump() the contents of the new SQL, I get

     

    string(488) "select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s, products_to_categories p2c where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and p.products_id = p2c.products_id and (not p2c.categories_id in (26,53)) and pd.language_id = '1' and s.status = '1' group by p.products_id order by s.specials_date_added DESC"

     

    Pasting that into phpmyadmin works, no errors. I've tried the various fixes on the contrib page but non have worked.

     

    It's probably something easy. Any help would be appreciated.

     

    Many thanks

     

    Ian

  2. Hi

     

    A very easy question which has probably been asked and answered over and over but I can't find the answer. I am using Paypal 1.3 with MS2.2 and all is well with the live shop. I am also upgrading to RC2.2a and PHP 5.3 which I'm using xampp, if that makes a difference. I'm hosted on a Windows server but will be moving to Linux.

     

    There's so many versions, which one do I install? :'( I'm happy with 1.3, if it works, don't fix it, but will it work with RC2.2a?

     

    Hope someone could answer

     

    Thanks

     

    Ian

  3. <!--quoteo(post=1444652:date=Oct 4 2009, 01:23 AM:name=Jack_mcs)--><div class='quotetop'>QUOTE (Jack_mcs @ Oct 4 2009, 01:23 AM) <a href="index.php?act=findpost&pid=1444652"><{POST_SNAPBACK}></a></div><div class='quotemain'><!--quotec-->There's nothing in the code to show the product id like that. It would have to be altered. If you are using my last version and the manufacturers is not showing up, my guess is that one of the manufacturer tables is not filled in. This is a fairly common problem. Try adding a new manufacturer in admin and then freshing your shop and going to that manufacturer. If it works, then the tables are your problem.

     

    Jack<!--QuoteEnd--></div><!--QuoteEEnd-->

    Hi Jack

     

    Thanks for the reply. Unfortunatly, adding a new manufacturer didn't work. I've had a look at the contrib download page and tried the fixes suggested but none worked. I then decided to overwrite your Ultimate SEO 2-2.2d-5 seo_class with the version from Shadowrider, 10 Feb 2009. I got a few depreciated errors because I'm using PHP 5.3 but that version worked. I couldn't get the suggested SQL fix in the install instructions to work tho.

     

    I tried replacing code from the Shadowrider seo_class into yours but it still failed. Any ideas where I should look?

     

    Thanks

     

    Ian

     

    Panic over. It's fixed. It was me :blush: Took the files into the office today and it worked?? :'( Found I had turned all the cache off in admin. Need to do a bit more work for my original problem of custom field in URL

     

    Cheers

     

    Ian

  4. There's nothing in the code to show the product id like that. It would have to be altered. If you are using my last version and the manufacturers is not showing up, my guess is that one of the manufacturer tables is not filled in. This is a fairly common problem. Try adding a new manufacturer in admin and then freshing your shop and going to that manufacturer. If it works, then the tables are your problem.

     

    Jack

    Hi Jack

     

    Thanks for the reply. Unfortunatly, adding a new manufacturer didn't work. I've had a look at the contrib download page and tried the fixes suggested but none worked. I then decided to overwrite your Ultimate SEO 2-2.2d-5 seo_class with the version from Shadowrider, 10 Feb 2009. I got a few depreciated errors because I'm using PHP 5.3 but that version worked. I couldn't get the suggested SQL fix in the install instructions to work tho.

     

    I tried replacing code from the Shadowrider seo_class into yours but it still failed. Any ideas where I should look?

     

    Thanks

     

    Ian

  5. You will need to alter includes/classes/seo.class.php

     

    you will see code like this

    $sql = "SELECT products_name as pName 
    
    											FROM ".TABLE_PRODUCTS_DESCRIPTION." 
    
    											WHERE products_id='".(int)$pID."' 
    
    											AND language_id='".(int)$this->languages_id."' 
    
    											LIMIT 1";

     

    and will have to alter it think is 2 places as for other code if any that needs altering im not sure

     

    Steve

     

    Hi Steve

     

    Many thanks for getting back to me. That code was slightly different from mine but I found the right place and my custom title field now shows in the URL. Yessss!!

     

    Two more tweaks for someone to help me with. The first is very minor. How do I make the URL so that the product_id is at the beginning of the URL instead of the category name? As in mysite.com/artists-a-z-p-101-product_name.html. I think this is in the .htaccess file??

     

    And the other is my manufacturer name doesn't appear in the URL, its just mysite.com/-m-12.html. I'm a music site and my categories set up as Artists A-F, Artists G-L etc and my manufacturers are genres, pop, rock, hip hop etc.

     

    Categories show up fine and are displayed first

     

    Any ideas anyone?

     

    Thanks again

     

    Ian

  6. Hi

     

    I've installed Ultimate SEO 2-2.2d-4 and just 2 slight problems.

     

    The first is the ampersand. How do I get it to show in the URL? I've tried the char=> and set to different combinations of &amp but can't get it to show. I've also set the filter short words to 0, 1, 2, 3, -1 but that didn't work either.

     

    The second is the product_name in the URL. My site is a music site and at the moment, my product_name is the artist. Thats all thats showing. I need to have the title in there aswell. I've added new fields in products and products_description to the database and in most of the SQL in OSC, I can add to and get my new fields out. I can't work out the code in this contrib so just need a pointer as to where to look

     

    I'm guessing its here

     

    		function get_product_name($pID){
    	   $result = array();
    	   if ($this->attributes['SEO_ADD_CPATH_TO_PRODUCT_URLS']) {
    		  $cName = $this->get_all_category_parents($pID, $cName);
    	   }
    			switch(true){
    					case ($this->attributes['USE_SEO_CACHE_GLOBAL'] == 'true' && defined('PRODUCT_NAME_' . $pID)):
    							$this->performance['CACHE_QUERY_SAVINGS']++;
    							$return = (tep_not_null($cName) ? $cName . '-'. constant('PRODUCT_NAME_' . $pID) : constant('PRODUCT_NAME_' . $pID));
    							$this->cache['PRODUCTS'][$pID] = $return;
    							break;
    					case ($this->attributes['USE_SEO_CACHE_GLOBAL'] == 'true' && isset($this->cache['PRODUCTS'][$pID])):
    							$this->performance['CACHE_QUERY_SAVINGS']++;
    							$return = (tep_not_null($cName) ? $cName . '-'. $this->cache['PRODUCTS'][$pID] : $this->cache['PRODUCTS'][$pID]);
    							break;
    					default:
    							$this->performance['NUMBER_QUERIES']++;
    							$sqlCmd = $this->attributes['USE_SEO_HEADER_TAGS'] == 'true' ? 'products_name as pName' : 'products_name as pName';
    							$sql = "SELECT " . $sqlCmd . " . 
    
    ** Do I add "select field1, field2 here?? ** 
    
    								  FROM ".TABLE_PRODUCTS_DESCRIPTION."
    									  WHERE products_id='".(int)$pID."'
    									  AND language_id='".(int)$this->languages_id."'
    									  LIMIT 1";
    							$result = $this->DB->FetchArray( $this->DB->Query( $sql ) );
    
    							$pName = $this->strip( $result['pName'] ); 
    
    [b]** Do I add to $result here? **[/b]
    							$this->cache['PRODUCTS'][$pID] = $pName;
    							$this->performance['QUERIES']['PRODUCTS'][] = $sql;
    							$return = (tep_not_null($cName) ? $cName . '-'.  $pName : $pName);
    							break;
    			} # end switch
    			return $return;
    	} # end function

     

    Thanks in advance

     

    Sorry, the colours and bold don't work for me

     

    Ian

     

    Still no answer?? It must be possible. Anyway, solved the ampersand problem by replacing them with and in the database. Just noticed a fix in the contrib download area.

     

    Please someone, anyone, is there a way of adding a custom field to the URL. I can't solve it

     

    TIA

     

    Ian

  7. Hi

     

    I've installed Ultimate SEO 2-2.2d-4 and just 2 slight problems.

     

    The first is the ampersand. How do I get it to show in the URL? I've tried the char=> and set to different combinations of &amp but can't get it to show. I've also set the filter short words to 0, 1, 2, 3, -1 but that didn't work either.

     

    The second is the product_name in the URL. My site is a music site and at the moment, my product_name is the artist. Thats all thats showing. I need to have the title in there aswell. I've added new fields in products and products_description to the database and in most of the SQL in OSC, I can add to and get my new fields out. I can't work out the code in this contrib so just need a pointer as to where to look

     

    I'm guessing its here

     

    		function get_product_name($pID){
    	   $result = array();
    	   if ($this->attributes['SEO_ADD_CPATH_TO_PRODUCT_URLS']) {
    		  $cName = $this->get_all_category_parents($pID, $cName);
    	   }
    			switch(true){
    					case ($this->attributes['USE_SEO_CACHE_GLOBAL'] == 'true' && defined('PRODUCT_NAME_' . $pID)):
    							$this->performance['CACHE_QUERY_SAVINGS']++;
    							$return = (tep_not_null($cName) ? $cName . '-'. constant('PRODUCT_NAME_' . $pID) : constant('PRODUCT_NAME_' . $pID));
    							$this->cache['PRODUCTS'][$pID] = $return;
    							break;
    					case ($this->attributes['USE_SEO_CACHE_GLOBAL'] == 'true' && isset($this->cache['PRODUCTS'][$pID])):
    							$this->performance['CACHE_QUERY_SAVINGS']++;
    							$return = (tep_not_null($cName) ? $cName . '-'. $this->cache['PRODUCTS'][$pID] : $this->cache['PRODUCTS'][$pID]);
    							break;
    					default:
    							$this->performance['NUMBER_QUERIES']++;
    							$sqlCmd = $this->attributes['USE_SEO_HEADER_TAGS'] == 'true' ? 'products_name as pName' : 'products_name as pName';
    							$sql = "SELECT " . $sqlCmd . " . 
    
    ** Do I add "select field1, field2 here?? ** 
    
    								  FROM ".TABLE_PRODUCTS_DESCRIPTION."
    									  WHERE products_id='".(int)$pID."'
    									  AND language_id='".(int)$this->languages_id."'
    									  LIMIT 1";
    							$result = $this->DB->FetchArray( $this->DB->Query( $sql ) );
    
    							$pName = $this->strip( $result['pName'] ); 
    
    [b]** Do I add to $result here? **[/b]
    							$this->cache['PRODUCTS'][$pID] = $pName;
    							$this->performance['QUERIES']['PRODUCTS'][] = $sql;
    							$return = (tep_not_null($cName) ? $cName . '-'.  $pName : $pName);
    							break;
    			} # end switch
    			return $return;
    	} # end function

     

    Thanks in advance

     

    Sorry, the colours and bold don't work for me

     

    Ian

  8. Hi

     

    I installed the contrib and all is OK. I managed to solve the &$links code but I am now getting the "Unable to determine page link error".

     

    I'm running local with wampserver2.0 and all is well until I add the information box in Admin. I refresh the catalog sitemap page and the error happens. It's NOT the Search Engine Friendly option being set. Any ideas??

     

    Also, to have the page look like the screenshot, do I need to install the 3 contribs mentioned?? Sorry if someone has answered.

     

    Many thanks

     

    Ian

  9. Hi

     

    I've modded my specials page to display in a list like the main product listing. Is it possible to add the sort order and results per page to the specials page?

     

    If you have a look at My Website you'll see sthe styling. Specials.php looks the same

     

    Hope that makes sense

     

    Cheers

     

    Ian

     

    Hi

     

    Me again, Just searched for my post and found a few others asking the same about the specials listing. Thought I'd let everyone know that it can be done.

     

    All I did was open products_new.php and save it as specials.php (backup original first of course). then I merged the specials and new_products SQL. This is MY SQL with MY EXTRA FIELDS. The important bit is the $sort_sql

     

    $products_new_query_raw = "select p.products_date_added, p.products_id, pd.products_name, pd.products_title, p.products_media, p.products_model, p.products_category, p.products_label, p.products_catno, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price, m.manufacturers_name, p.manufacturers_id  from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_quantity = '1' and p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and s.status = '1' and pd.language_id = '" . (int)$languages_id . "'" . $sort_sql;

     

    Change the breadcrumb and language file at the top and leave everything as is. I THINK thats all I did and it works for me. I can't guarentee it working for anyone else but it's a start for anyone who wants to try

     

    Thanks for a great contrib

     

    Ian

  10. Hi

     

    I have installed the contrib and have a question about the results per page option that maybe someone else has come across and fixed. Its defaulted to 20 per page, you change to another value, say 40, and the dropdown list value goes back to 20. I can't find a way to go back to 20 results per page.

     

    Maybe the value should stay at 40 per page and then you can select 20 from the dropdown and go back to 20 per page

     

    Many thanks

     

    Ian

  11. Hi

     

    Thanks to everyone who "helped" but I managed to get it working on my self. I forgot to add the css info. :blush: The image still spins anti-clockwise but I can live with that.

     

    Is it possible to collapse the div? At the moment it is leaving a gap the height of the image on the page

     

    Cheers

     

    ian

     

    Me again. Solved this too. I googled ajax images and found some that rotate anti clockwise, I've only seen clockwise versions. Anyway, solved, I downloaded a horiz bar and all is OK

     

    Cheers

     

    Ian

  12. Hi

     

    I have installed the contrib but I get the login page errors. In account_histoty_info I click the return link, make the changes, submit and I get logged out and go back to the front page with no sign of RMA number. I do get the email with RMA info in tho.

     

    The next prob is with track return. I copy and paste the RMA number from the email into the form and pick track. I get asked to login twice and then the error "The details you entered do not match any of our records. Please try again or contact us for further assistance."

     

    I have searched this forum and tried several suggested fixes but non have worked.

     

    Is there anyone that can help me.

     

    Cheers

     

    Ian

     

    Still no answers?? I still can't get this bit to work properly. The admin side still works tho. I am redesigning starting from scratch with 2.2rc2a and installing same contribs. I found 1.3 wishlist contrib gave a parse error but couldn't see what was wrong, I am using it on my live store and it all works. Anyway, when I looked closer the contrib coder used a mix of PHP short open tags ie some were <? and others were <?php

     

    I even enabled short open tags in my php.ini file but it still didn't work so I replaced all the <? in each file and it worked.

     

    This contrib has been written the same. Stacks of short tags mixed with normal tags. I thought I'd cracked it but unfortunatly it still didn't work when I corrected all the <? although I haven't used the fix suggested earlier in the forum. Not really expecting it to work :blink:

     

    Maybe that's a clue to solving this prob.

     

    Hope some one can solve.

     

    @ newbieonekenobie - I found the same. I replaced the code anyway and it seemed to work. Not sure if it's 100% because of this login error but try it, can't hurt

     

    Cheers

     

    Ian

  13. Hi

     

    Just wondering if the size of the borders and the top heading tab can be changed. Reading through the thread, the colours etc can be changed, in Photoshop or Paintshop Pro, I assume. That is OK, I think I can work that out but is there any code to the mws.?? styles I need to change?

     

    Cheers

     

    Ian

  14. Hi

     

    I've installed the 1.5.5 ajax version but when I go to create an account or any address page I get the spinning image in the left corner just under the breadcrumb and it spins forever. I then change my country, that works and the state is populated then the image disappears. Isn't that back to front??

     

    Edit: I'm on version rc2a and copied the included files over as it's an empty development store

     

    Hope someone can point me in the right direction

     

    Cheers

     

    Ian

    Hi

     

    Thanks to everyone who "helped" but I managed to get it working on my self. I forgot to add the css info. :blush: The image still spins anti-clockwise but I can live with that.

     

    Is it possible to collapse the div? At the moment it is leaving a gap the height of the image on the page

     

    Cheers

     

    ian

  15. I found the problem.. kinda stupid but ah well..

     

    open catalog/includes/functions/html_output.php

     

    find the function tep_draw_pull_down_menu(...)

     

    find the code

    	  if ($default == $values[$i]['id']) {
    	$field .= ' SELECTED';
      }

     

    change it to

     

    	  if ($default === $values[$i]['id']) {
    	$field .= ' SELECTED';
      }

     

    notice the === operator instead of the == operator.. thats it ..

     

    J

     

    Hi

     

    Just thought I'd say thanks for the above fix. It worked for me

     

    Cheers

     

    ian

  16. Hi

     

    I've installed the 1.5.5 ajax version but when I go to create an account or any address page I get the spinning image in the left corner just under the breadcrumb and it spins forever. I then change my country, that works and the state is populated then the image disappears. Isn't that back to front??

     

    Edit: I'm on version rc2a and copied the included files over as it's an empty development store

     

    Hope someone can point me in the right direction

     

    Cheers

     

    Ian

  17. Hi ski2bbad,

     

     

     

    All that I have done is modifying the tep_db_insert_id() function in both the admin and catalog side ( ie: in catalog/includes/function/database.php and in admin/includes/function/database.php)

     

    Replace :

     

    function tep_db_insert_id() {
    return mysql_insert_id();
    }

     

    by

     

    function tep_db_insert_id($link = 'db_link') {
    global $$link;
    return mysql_insert_id( $$link );
    }

     

     

    That's it

     

    Nicolas

     

    Hi

     

    This has happend to me today. No changes made since Nov '07. Just installed HTML emails so testing. Everything works, it all goes thru to Paypal, even the discount module works, I get the email in nice HTML but no order number either in the email title or the email subject. I also have a letter in front of my order numbers and this comes thru in both email subject and content but no order number.

     

    The order number complete with the order letter prefix DOES gets printed on the checkout_confirmation page.

     

    I have tried the fix above but it didn't work.

     

    I am using Paypal IPN 1.3, PHP ver 4.4.7, MySQL 5.0.45, oscommerce-2.2ms2-060817

     

    Any ideas anyone

     

    Cheers

     

    Ian

  18. Hi, Me again

     

    It's been almost 2 months, I think I've been patient. Is this the wishlist support thread??? I am in the right thread?? Can someone kindly sort this out for me. All I want is for a message to show when an excluded item is added to the cart. My debug info is attached. Why did that product fail??

     

    Cheers

     

    Ian

    Solved this one too. I am just too good.

     

    Ian

  19. Hi

     

    I have installed the contrib and the bits I've tested are working OK.

     

    Can anyone help me with a button that clears the complete wishlist. There's a contrib called "clear cart" and you don't have to select each checkbox. Just press a button and the wishlist is gone.

     

    Cheers

     

    Ian

    Solved. Thanks to whoever read my post

  20. Hi

     

    I've installed the contrib and after adding the sub-total fix, all is OK apart from a few little probs. The first is probaby easy, after the coupon expires I get the standard "Not valid" message and not the "No longer valid" message.

     

    For the second I have excluded 1 product as a test and no error or warning message show. The debug info is below. Product [0] with id 383 is the excluded one.

     

    The last prob is the way that error messages are displayed. The ones included in this contrib don't match the design of my site so I have changed them. The error messages are now in the main body of my page and are based on a table layout similar to Amazon. Exclaimation mark, colored background etc. Will this cause any probs or is it the reason prob 2 is happening.

     

    Sorry to lump them all into 1 post

     

    Hope someone can help

     

    Ian

     

    <!-- Discount Coupons DEBUG
    order Object
    (
    [info] => Array
    	(
    		[order_status] => 1
    		[currency] => GBP
    		[currency_value] => 1.00000000
    		[payment_method] => Pay by Cheque
    		[cc_type] => 
    		[cc_owner] => 
    		[cc_number] => 
    		[cc_expires] => 
    		[shipping_method] => Royal Mail International Airmail   (Ships normally within 5 to 7 days)
    		[shipping_cost] => 5.95
    		[subtotal] => 44.0025
    		[tax] => 0
    		[tax_groups] => Array
    			(
    				[Unknown tax rate] => 0
    			)
    
    		[comments] => 
    		[total] => 46.285
    	)
    
    [totals] => Array
    	(
    	)
    
    [products] => Array
    	(
    		[0] => Array
    			(
    				[qty] => 1
    				[name] => Franke Pharoah
    				[title] => Understand This Groove
    				[media] => 12"
    				[label] => Cheeky Records
    				[catno] => CHEEKY 01
    				[model] => ICR28098
    				[tax] => 0
    				[tax_description] => Unknown tax rate
    				[price] => 33.00
    				[final_price] => 33
    				[weight] => 0.190
    				[id] => 383
    			)
    
    		[1] => Array
    			(
    				[qty] => 1
    				[name] => DJ Alan X
    				[title] => Lost
    				[media] => 12"
    				[label] => Xtrax
    				[catno] => XTRAX 010
    				[model] => ICR27543
    				[tax] => 0
    				[tax_description] => Unknown tax rate
    				[price] => 3.67
    				[final_price] => 3.67
    				[weight] => 0.190
    				[id] => 322
    			)
    
    		[2] => Array
    			(
    				[qty] => 1
    				[name] => Gina Go Go
    				[title] => I Can't Face The Fact
    				[media] => 12"
    				[label] => Capitol Records
    				[catno] => V 15396
    				[model] => ICR27803
    				[tax] => 0
    				[tax_description] => Unknown tax rate
    				[price] => 11.00
    				[final_price] => 11
    				[weight] => 0.190
    				[id] => 387
    			)
    
    	)
    
    [customer] => Array
    	(
    		[firstname] => 1st Name
    		[lastname] => 2nd name
    		[company] => 
    		[street_address] => 28 Billing Road
    		[suburb] => Manchester
    		[city] => tertee
    		[postcode] => M12 9DJ
    		[state] => Adana
    		[zone_id] => 3380
    		[country] => Array
    			(
    				[id] => 215
    				[title] => Turkey
    				[iso_code_2] => TR
    				[iso_code_3] => TUR
    			)
    
    		[format_id] => 1
    		[telephone] => 
    		[email_address] => [email protected]
    	)
    
    [delivery] => Array
    	(
    		[firstname] => 1st Name
    		[lastname] => 2nd name
    		[company] => 
    		[street_address] => 28 Billing Road
    		[suburb] => Manchester
    		[city] => tertee
    		[postcode] => M12 9DJ
    		[state] => Adana
    		[zone_id] => 3380
    		[country] => Array
    			(
    				[id] => 215
    				[title] => Turkey
    				[iso_code_2] => TR
    				[iso_code_3] => TUR
    			)
    
    		[country_id] => 215
    		[format_id] => 1
    	)
    
    [content_type] => physical
    [coupon] => discount_coupon Object
    	(
    		[messages] => Array
    			(
    				[debug] => Array
    					(
    						[0] => INFO: DISPLAY_PRICE_WITH_TAX = false
    						[1] => INFO: MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING = false
    						[2] => INFO: MODULE_ORDER_TOTAL_DISCOUNT_COUPON_STATUS = true
    						[3] => INFO: MODULE_ORDER_TOTAL_DISCOUNT_COUPON_SORT_ORDER = 5
    						[4] => INFO: MODULE_ORDER_TOTAL_DISCOUNT_COUPON_DISPLAY_TYPE = true
    						[5] => INFO: MODULE_ORDER_TOTAL_DISCOUNT_COUPON_DISPLAY_SUBTOTAL = false
    						[6] => INFO: MODULE_ORDER_TOTAL_DISCOUNT_COUPON_DISPLAY_TAX = None
    						[7] => INFO: MODULE_ORDER_TOTAL_DISCOUNT_COUPON_EXCLUDE_SPECIALS = true
    						[8] => INFO: MODULE_ORDER_TOTAL_DISCOUNT_COUPON_RANDOM_CODE_LENGTH = 6
    						[9] => INFO: MODULE_ORDER_TOTAL_DISCOUNT_COUPON_DISPLAY_LINES = false
    						[10] => INFO: MODULE_ORDER_TOTAL_DISCOUNT_COUPON_ALLOW_NEGATIVE = false
    						[11] => INFO: MODULE_ORDER_TOTAL_DISCOUNT_COUPON_USE_LANGUAGE_FILE = false
    						[12] => INFO: MODULE_ORDER_TOTAL_DISCOUNT_COUPON_DISPLAY_CONFIG = Discount Coupon [code] applied
    						[13] => INFO: MODULE_ORDER_TOTAL_DISCOUNT_COUPON_DEBUG = true
    						[14] => INFO: Product 383 failed product exclusion check
    						[15] => INFO: Product 383 failed product exclusion check
    						[16] => INFO: Excluded product 383. Discount of 0 not applied.
    						[17] => INFO: Discount of 0 applied to product 383 ($33).
    						[18] => INFO: Calculating tax on 33.  Displayed price 33.
    						[19] => INFO: Product 322 passed exclusion check.  Discount 0.9175 applied. (percent)
    						[20] => INFO: Discount of 0.9175 applied to product 322 ($3.67).
    						[21] => INFO: Calculating tax on 2.7525.  Displayed price 2.7525.
    						[22] => INFO: Product 387 passed exclusion check.  Discount 2.75 applied. (percent)
    						[23] => INFO: Discount of 2.75 applied to product 387 ($11).
    						[24] => INFO: Calculating tax on 8.25.  Displayed price 8.25.
    						[25] => INFO: Discount of 3.6675 applied to order total.
    					)
    
    			)
    
    		[coupon] => Array
    			(
    				[coupons_id] => test123
    				[coupons_description] => Sale now on
    				[coupons_discount_amount] => 0.250000000000
    				[coupons_discount_type] => percent
    				[coupons_date_start] => 2008-07-26 00:00:00
    				[coupons_date_end] => 2008-08-01 00:00:00
    				[coupons_max_use] => 0
    				[coupons_min_order] => 5.0000
    				[coupons_min_order_type] => price
    				[coupons_number_available] => 0
    			)
    
    		[applied_discount] => Array
    			(
    				[Unknown tax rate] => 3.6675
    			)
    
    		[cart_info] => Array
    			(
    				[valid_products] => Array
    					(
    						[count] => 2
    						[line_items] => 2
    						[total] => 14.67
    					)
    
    				[total_products] => Array
    					(
    						[count] => 3
    						[line_items] => 3
    						[total] => 47.67
    					)
    
    				[exclusions] => Array
    					(
    						[categories] => Array
    							(
    							)
    
    						[products] => Array
    							(
    								[0] => 28
    								[1] => 383
    							)
    
    						[manufacturers] => Array
    							(
    								[0] => 13
    							)
    
    					)
    
    			)
    
    		[discount_tax] => Array
    			(
    				[Unknown tax rate] => 0
    			)
    
    	)
    
    [billing] => Array
    	(
    		[firstname] => 1st Name
    		[lastname] => 2nd name
    		[company] => 
    		[street_address] => 28 Billing Road
    		[suburb] => Manchester
    		[city] => tertee
    		[postcode] => M12 9DJ
    		[state] => Adana
    		[zone_id] => 3380
    		[country] => Array
    			(
    				[id] => 215
    				[title] => Turkey
    				[iso_code_2] => TR
    				[iso_code_3] => TUR
    			)
    
    		[country_id] => 215
    		[format_id] => 1
    	)
    
    )
    
    End Discount Coupons DEBUG-->

    Hi, Me again

     

    It's been almost 2 months, I think I've been patient. Is this the wishlist support thread??? I am in the right thread?? Can someone kindly sort this out for me. All I want is for a message to show when an excluded item is added to the cart. My debug info is attached. Why did that product fail??

     

    Cheers

     

    Ian

  21. Maybe I'm missing something but I installed this. Step 1 and 2a in admin / categories and did the changes in languages but I don't see instruction on putting anything in product_info.php??

     

    How does the customer get notified?

     

    Hi

     

    I, too, installed but don't see anything. My question is as above, how does the customer get notified

     

    Cheers

     

    Ian

  22. This is a very "light" contrib meaning it doesn't modify the code much so I don't know what could have gone wrong. Did you install any other contribs at the same time that could have caused the problem? Did you revert to your backup and you are still experiencing problems? If so that would indicate something prior to installing this contrib caused the problem or maybe prior contribs are incompatible with this contrib so you cannot use them in conjuction.

    hi, me again

     

    Was it really in Jan I posted? Wow, doesn't time fly. Anyway, solved it thanks to the Graphic borders contrib. Why? Because that contrib mentioned adding borders to cross sell, product listings etc. So I looked at the Xsell products contrib (installed but didn't like it) and there was an update to the files as below, hope I don't get into trouble :)

     

    On my installation, with SEO URLS, the Buy It Now button was showing the parent product's ID and not its own.
    
    In catalog/includes/modules/xsell_products.php
    
    //Cache
    $text = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $xsell['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $xsell['products_image'], $xsell['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $xsell['products_id']) . '">' . $xsell['products_name'] .'</a><br>' . $xsell_price. '<br><a href="' . tep_href_link(FILENAME_DEFAULT, 'action=buy_now&products_id=' . $xsell['products_id'], 'NONSSL') . '">' . tep_image_button('button_buy_now.gif', TEXT_BUY . $xsell['products_name'] . TEXT_NOW) .'</a>';
    
    I stripped out the 
    
    tep_get_all_get_params(array('action')) . 
    
    and it seems to work.
    
    As I am not a great expert at this, do please test the heck out of it before you go anywhere near a production system!
    
    This zip contains only the updated includes/modules/xsell_products.php file.

     

    If you replace the $xsell with $matching it works and has passed a few tests locally. Hopefully a working module will be up on my site over the weekend. I'm still testing & formatting a wishlist contrib.

     

    This is my line of code that displays to products

     

    		  $info_box_contents[$row][$col] = array('align' => 'center',
    									   'params' => 'class="smallText" width="33%" valign="top" style="border-style: solid; border-width: 2" bordercolor="#EBEDF1"',
    									   'text' => strtoupper($matching_products['products_name']) . '<br><br>' . '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $matching_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $matching_products['products_image'], $matching_products['products_name'] . ' - ' . $matching_products['products_title'] . ' Label Side A', SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><br><a STYLE="text-decoration:underline" href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $matching_products['products_id']) . '">' . $matching_products['products_title'] . '</a> (' . $matching_products['products_media'] . ')<br><br>' . $products_price . '<br><br><a href="' . tep_href_link(FILENAME_DEFAULT, 'action=buy_now&products_id=' . $matching_products['products_id'], 'NONSSL') . '">' . tep_image_submit('button_buy_now.gif', IMAGE_BUTTON_IN_CART) .'</a>' . '   <a href="' . tep_href_link(FILENAME_DEFAULT, 'action=add_wishlist&products_id=' . $matching_products['products_id']) . '">' . tep_image_button('button_wishlist_small.gif', IMAGE_BUTTON_ADD_WISHLIST_SMALL) . '</a>');

     

    Many thanks for a great contrib

     

    Ian

×
×
  • Create New...