Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

cheeroke

Pioneers
  • Posts

    25
  • Joined

  • Last visited

Posts posted by cheeroke

  1. Hello,

     

    My question is: shall we do somethink with database? As I could not find any instruction to amend it and I am getting this 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 ' p.products_status from products p, products_description pd where p.products_id ' at line 1

     

    select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, p.products_image_med, p.products_image_pop, p.products_image_description, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from, p.products_status from products p, products_description pd where p.products_id = '174' and pd.products_id = p.products_id and pd.language_id = '1'

     

    [TEP STOP]

     

    when I want to display detailed informations about any product.

     

    Any ideas what is wrong? I will be appreciated if anyone could help me with it.

  2. HAHAHAHA Great.... Glad to hear you got it working. Yes, is strange but who cares so long as it works...

    Wish thy had good support on this mod, is very useful but it just has flaws and I am not a php proframmer.

     

    Well, yes but what if suddenly it will stop working? I will not know where is the problem. Sad that such a good contrib is without support.

    Me too, aren't php programmer, at least on level which would allowed me play around with code.

    Anyway, you right, as long as it is working :D

    Thx for some clues.

  3. ....well, I do not understand it at all. I checked those files, everything was according to installation proces. I did not changed anything and what? Suddenly it is working!

     

    ....

     

    Thanks for help.

     

    I am really sorry that I can not lead anyone close with reason/solution more than @beanzy done.

  4. Had the same problem when I first installed and never found out why because of time, but solved it

    by taking fresh copy of catalog/checkout_confirmation.php and checkout_process.php and re-merged all of

    my contribs and WALAAaaaaaaaa displayed no problem. Sorry I cannot tell you why but this worked for me.

     

    Good luck

    I will paste parts from my files, if you could do me a favour and paste relevant code from yours files so I could compare it. I will be appreciated.

     

    checkout_confirmation

     

      //kgt - discount coupons
     if (!tep_session_is_registered('coupon')) tep_session_register('coupon');
     //this needs to be set before the order object is created, but we must process it after
     $coupon = tep_db_prepare_input($HTTP_POST_VARS['coupon']);
     //end kgt - discount coupons 
    
    ............
    
     //kgt - discount coupons
     if( tep_not_null( $coupon ) && is_object( $order->coupon ) ) { //if they have entered something in the coupon field
       $order->coupon->verify_code();
       if( MODULE_ORDER_TOTAL_DISCOUNT_COUPON_DEBUG != 'true' ) {
    	  if( !$order->coupon->is_errors() ) { //if we have passed all tests (no error message), make sure we still meet free shipping requirements, if any
    		  if( $order->coupon->is_recalc_shipping() ) tep_redirect( tep_href_link( FILENAME_CHECKOUT_SHIPPING, 'error_message=' . urlencode( ENTRY_DISCOUNT_COUPON_SHIPPING_CALC_ERROR ), 'SSL' ) ); //redirect to the shipping page to reselect the shipping method
    	  } else {
    		  if( tep_session_is_registered('coupon') ) tep_session_unregister('coupon'); //remove the coupon from the session
    		  tep_redirect( tep_href_link( FILENAME_CHECKOUT_PAYMENT, 'error_message=' . urlencode( implode( ' ', $order->coupon->get_messages() ) ), 'SSL' ) ); //redirect to the payment page
    	  }
       }
    } else { //if the coupon field is empty, unregister the coupon from the session
    	if( tep_session_is_registered('coupon') ) { //we had a coupon entered before, so we need to unregister it
         tep_session_unregister('coupon');
         //now check to see if we need to recalculate shipping:
         require_once( DIR_WS_CLASSES.'discount_coupon.php' );
         if( discount_coupon::is_recalc_shipping() ) tep_redirect( tep_href_link( FILENAME_CHECKOUT_SHIPPING, 'error_message=' . urlencode( ENTRY_DISCOUNT_COUPON_SHIPPING_CALC_ERROR ), 'SSL' ) ); //redirect to the shipping page to reselect the shipping method
       }
    }
    //end kgt - discount coupons
    
    

     

    checkout_process

     

    //kgt - discount coupons
     if( tep_session_is_registered( 'coupon' ) && is_object( $order->coupon ) ) {
      $sql_data_array = array( 'coupons_id' => $order->coupon->coupon['coupons_id'],
                                'orders_id' => $insert_id );
      tep_db_perform( TABLE_DISCOUNT_COUPONS_TO_ORDERS, $sql_data_array );
     }
     //end kgt - discount coupons  
    
    .......
    
    
    //kgt - discount coupons
     tep_session_unregister('coupon');
     //end kgt - discount coupons
    
    

  5. Need some more information. What visable line are you talking about? Do you mean the discount is

    not showing on the confirmation page? Be more specific for a response.... Too much guess work!

     

    Yes, my mistake, sorry. Well I mean at Order Confirmation page there is section called: Billing Information. In this section on right side there are informations like vat, sub total, shipping method and total, depending what has been choseen to be shown in admin pannel. I would like to know is there any option to see another line with coupon information like this or simillar: Coupon code discount -$30 or something like that.

     

    My Discount coupon settings are as follows:

     

    Enable discount coupon?
    true
    
    Sort Order
    2
    
    Display discount with minus (-) sign?
    true
    
    Display subtotal with applied discount?
    true
    
    Display tax in discount line?
    None
    
    Exclude product specials?
    true
    
    Random Code Length
    8
    
    Display discount total lines for each tax group?
    false
    
    Allow negative order total?
    false
    
    Use the language file to format display string?
    false
    
    Display Format for Order Total Line
    Discount Coupon [code] applied
    
    Debug Mode
    false
    

     

    ...I was changing those settings without any wanted result.

  6. Hi,

     

    well let remind my problem.

     

    When I am choosing any category in my shop to be displayed it is showing above category Name

     ?>

    when I will choose any subcategory it dispay correct way (without ?> above subcategory name)

     

    I turned off Ulitmate seo url to chcek which file is displaying when error occured. It pointed on index.php

    It looks like in one line there is one ?> to much but I can't find which line as when I founded few which could cause it and commenting them it did not change anything.

     

    Have you got any idea where should I try to find?

     

     

    ------------------------------------------

     

    ok, founded! uff, this nasty thing came from comment in index.php file. By my mistake I wrongly commented one line.

     

    Thanks for your time Jack_mcs

  7. I cant get this to work, its just displaying the image in a new window (target="_blank"), and I dont know why.

     

    I have made all the settings from "install.txt" in the right way.

     

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

    <script type="text/javascript" src="lightbox/prototype.js"></script>

    <script type="text/javascript" src="lightbox/scriptaculous.js?load=effects"></script>

    <script type="text/javascript" src="lightbox/builder.js"></script>

    <script type="text/javascript" src="lightbox/lightbox.js"></script>

     

    And I have tried to add the "lightbox.css" into my own "stylesheet.css", but its the same thing. Can I run .js files with Wamp-server? (normal settings) I cant find another problem... :-/

     

    Please help me out! :-)

     

    /Robin

    with additional images contrib it never worked for me, images opening in new window. I have no clue what to do to push it working.

    Anyone got same issue with installed Additional Images contrib?

  8. It depends on the file. Turn off Ultimate SEO and refresh the page.

     

    Jack

     

    I turned off Ultimate seo and it pointing on index.php unfortunately I can't find which part of code is incorrect as it seems all "?>" are closed corectly. I tried to chase all "?>" and comment them without any result.

     

    Any sugestions?

     

    I will be appreciated.

  9. In the one that is displaying the error. Look in the url.

     

    Jack

     

    well, actually I have installed ultimate tag seo so in address box it showing me

     

    productcategoryname-c-21.html

     

    If you could tell me which file is responsible for displaying category content maybe it will lead me where to look for solution.

     

    regards

    che

  10. Hi all,

     

    I have installed this contribution and now I got small problem.

     

    When I am choosing in shop any subcategory it showing me

     

    ?>

     

    Category name

     

    when I will go to subcategory everything looks fine.

     

     

    which file I should start looking for this error to rid off "?>" ?

     

    regards

    che

  11. Hi all,

     

    in overall this is very nice contibution. I have installed it using auto install script for DCC 3.32

     

    I am suffering one problem with minimum order value and to sort it out I followed by

    problem with Min Order Min Order Type: Price Total
    
    if you use: DISPLAY_PRICE_WITH_TAX == true
    
    Example:
    - if you have in shopping cart one item: that has a price without tax: 10$ and a tax 50% that is added to the initial price and the min order is 13 it won't let use the discount coupon because it compare the initial price of the product with the min order
    
    
    
    
    catalog/includes/classes/discount_coupon.php
    
    to add the tax to the product search for function:
    
    function total_valid_products( $products = array() )
    
    
    there u will find this line:
    
    $price = ( $products[$i]['price'] + $cart->attributes_price( $products[$i]['id'] ) ) * $products[$i]['quantity'];
    
    
    replace with
    
    if (DISPLAY_PRICE_WITH_TAX == "true"){
    $product_tax = tep_get_tax_rate($products[$i]['tax_class_id'], $tax_address['entry_country_id'], $tax_address['entry_zone_id']);
    $price = ( tep_add_tax($products[$i]['price'], $product_tax) + $cart->attributes_price( $products[$i]['id'] ) ) * $products[$i]['quantity'];
    
    }else{
    $price = ( $products[$i]['price'] + $cart->attributes_price( $products[$i]['id'] ) ) * $products[$i]['quantity'];
    }

     

    unfortunately after amendment it stil not working as it mean to. Has anyone got idea what shall be done to fix it?

     

    Regards

    che

  12. Hello Again,

     

    now i got bigger problem as after instalation this contributions pound and euro symbols are displayed wrongly, pound is as Ł and euro is as ?

    .... so fare as i change product_info.php in main directiory this addons not working but those symbols are displayed correctly but if i will replace it with this one with chnages according this contribution - it's work but symbols are wrong...

     

    ...has anybody got any idea where should I looking for bug?

     

    I would be appreciate if somebody answered.

     

    Thanks.

×
×
  • Create New...