Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

RS Designs

Pioneers
  • Posts

    33
  • Joined

  • Last visited

Posts posted by RS Designs

  1. Hello,

     

    Just installed your add-on (V2.8.13) in my store (V:2.3.4) and it is working great. Except one error (But it does not stop it from working)

     

    -It is on the product page just below the attribute manager

     

    1054 - Unknown column 'products_options.products_options_track_stock' in 'where clause'

    select products_name, products_options_name as _option, products_attributes.options_id as _option_id, products_options_values_name as _value, products_attributes.options_values_id as _value_id from products_description, products_attributes, products_options, products_options_values where products_attributes.products_id = products_description.products_id and products_attributes.products_id = '79' and products_attributes.options_id = products_options.products_options_id and products_attributes.options_values_id = products_options_values.products_options_values_id and products_description.language_id = 1 and products_options_values.language_id = 1 and products_options.products_options_track_stock = 1 and products_options.language_id = 1 order by products_attributes.options_id, products_attributes.options_values_id

    [TEP STOP]

     

     

    Any idea how to fix it ?

     

    Thanks, 

  2. Hello @@joli1811 or @@greasemonkey ,

     

    I was wondering if one of you could help me as I don't no a lot about code yet.

     

    I previous had this add-on working great on my store (V: 2.3.3.4) but I recently upgraded to (2.3.4) and when I re-installed the add-on my " Checkout payment " page return Internal server error.

     

    Here is what the code looks like: (it seems like something is acting weird but not sure what.

     

      <h2><?php echo TABLE_HEADING_COMMENTS; ?></h2>
    
    
      <div class="contentText">
        <?php echo tep_draw_textarea_field('comments', 'soft', '60', '5', $comments); ?>
      </div>
      
    /* kgt - discount coupons */
    if( MODULE_ORDER_TOTAL_DISCOUNT_COUPON_STATUS == 'true' ) {
    ?>
    <h2><?php echo TABLE_HEADING_COUPON; ?></h2>
    
    
      <div class="contentText">
        </div>
       
            <div class="contentText">
            <?php echo ENTRY_DISCOUNT_COUPON.' '.tep_draw_input_field('coupon', '', 'size="32"', $coupon); ?>
        </div>
    
    
    <?php
    }
    /* end kgt - discount coupons */  

    Any help would be great :)

     

    Thanks in advance.

  3. Just to add to all the fun I listed above ^

     

    I just notice something else that is acting up. 

     

    -After creating a custom product and hit "add to cart" I get another "Internal server error" with this link:

     

    ....../catalog/builder_main.php/action/add_products

     

    -But if I go back to the main store the custom product has been built and is in my cart correctly.

     

    Any ideas?

  4. @@Nefandous

     

    I forgot to thank you for fixing all the errors for me. Everything worked great on my store (version 2.3.3.4)

     

    But I have run into another little error after updating to (2.3.4) and added some more add-ons.

     

    I think I know what is causing the issue but don't know how to fix it. This is what is happening:

     

    -Everything is working great the only issue is I get "internal server error" after I hit the update button on the dependences page (and only that page, all other update fine) and this is the link in browser:

     

    ..../catalog/admin/builder_dependences.php?action=update&page=&sort_by=&cID=&row_by_page=80&manufacturer=&d_manufacturer=

     

    -Now after  looking at the code I am pretty sure the problem in my canada post sell online add-on because it change the manufacturers file a little.

     

    Here is what it changed in the manufacturer file

     

    Open admin/manufacturers.php

     

    Find:

    if ($manufacturers_image->parse() && $manufacturers_image->save()) {
    tep_db_query("update " . TABLE_MANUFACTURERS . " set manufacturers_image = '" . tep_db_input($manufacturers_image->filename) . "' where manufacturers_id = '" . (int)$manufacturers_id . "'");
    }

    ADD AFTER:              

     // Canada Post OST Start
                    $countries_id = $HTTP_POST_VARS['countries_id'];
    tep_db_query("update " . TABLE_MANUFACTURERS . " set countries_id = '" . (int)$countries_id . "' where manufacturers_id = '" . (int)$manufacturers_id . "'");
                    // Canada Post OST End

    Find:

    $manufacturers_query_raw = "select manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified from " . TABLE_MANUFACTURERS . " order by manufacturers_name";

    In the same line after 'last_modified' ADD:

    , countries_id

    Find The FIRST occurance of:

    $contents[] = array('text' => '<br />' . TEXT_MANUFACTURERS_URL . $manufacturer_inputs_string);

    ADD AFTER:

    // Canada Post OST start
    $contents[] = array('text' => '<br />' . tep_draw_pull_down_menu('countries_id', tep_get_countries('Select Country')));
    // Canada Post OST End

    Find the SECOND occurance of:

    $contents[] = array('text' => '<br />' . TEXT_MANUFACTURERS_URL . $manufacturer_inputs_string);

    ADD AFTER:

    // Canada Post OST start
    $contents[] = array('text' => '<br />' . tep_draw_pull_down_menu('countries_id', tep_get_countries('Select Country'), $mInfo->countries_id));
    // Canada Post OST End 
  5. Hello,

     

    I was wondering if you would be able to help me. I am having the same problem. But my situation is a little different.

     

    -I had to running perfectly on my store (2.3.3.4)

     

    -Just upgrade to (2.3.4) and re-installed

     

    -Everything works and values are being stored in SQL BUT they are not showing up in my product page....

     

    Here is a link to the pastebin of my categories file.

     

    http://pastebin.com/FXeSnULb

     

    And help would be great :)

     

    EDIT: Got it working. So if anyone else has problem the attached categories file works correctly now :)

  6. Hello,

     

    I am not the creator of this add-on but just looking for some help to get it working because the original maker has not answered my email.

     

    Here is what I know:

     

    - It was created in english but has german descriptions in the language file. (I just translated it back to english) 

     

    - I installed as per the instructions and everything seems to be working expect of one the pages "catalog/admin/new_attributes.php" which is the page that manages with product gets which attribute. The page for creating each attribute works fine.

     

    - The error I get from the page is: Internal server error

     

    - I am running this on version 2.3.3.4

     

    Any help is appreciated.

  7. @@Nefandous

     

    Thank you for the response but it does not work either. All 5 errors are still there and now they have a second line. (See picture)

     

    Here is a pastebin of the builders categories file: http://pastebin.com/m0Zhb6gE

     

    Here is a pastebin of the builders option file: http://pastebin.com/h3xkw5cp

     

    I don't understand why I isn't working and do not know enough about the code to be able to fix it. any help is greatly appreciated.

    post-329241-0-98883900-1401871138_thumb.jpg

  8. @@Nefandous

     

    Hello,

     

    I have done everything you have listed above and it seems to be starting to work now but still got a few errors, Could you help me out.

     

    I will attach the error and the code from the file (Also will highlight the line of code which is causing the problem.

     

    Here they are:

     

    #1

    ( ! ) Deprecated: Function split() is deprecated in C:\wamp\www\store\catalog\admin\builder_options.php on line 813 Call Stack # Time Memory Function Location 1 0.0020 703808 {main}( ) ..\builder_options.php:0

     

     

    <?php
    $the_files_array = Array();
    $handle = opendir(DIR_FS_CATALOG . DIR_WS_IMAGES);
    while (false!== ($file = readdir($handle))) {
    if ($file!= "." && $file!= ".." &&!is_dir($file)) {
    $namearr = split('\.',$file);
    if (($namearr[count($namearr)-1] == 'gif') || ($namearr[count($namearr)-1] == 'jpg') || ($namearr[count($namearr)-1] == 'png')) {
     $the_files_array[] = array( 'text' => $file, 'id' => $file);
    }
    }
    }
    

     

    #2

    ( ! ) Deprecated: Function split() is deprecated in C:\wamp\www\store\catalog\admin\builder_options.php on line 937 Call Stack # Time Memory Function Location 1 0.0020 703808 {main}( ) ..\builder_options.php:0

     

     

    <?php
    $the_files_array = Array();
    $handle = opendir(DIR_FS_CATALOG . DIR_WS_IMAGES . $cpb_category_images_folder);
    while (false!== ($file = readdir($handle))) {
    if ($file!= "." && $file!= ".." &&!is_dir($file)) {
    $namearr = split('\.',$file);
    if (($namearr[count($namearr)-1] == 'gif') || ($namearr[count($namearr)-1] == 'jpg') || ($namearr[count($namearr)-1] == 'png')) {
     $the_files_array[] = array( 'text' => $file, 'id' => $file);
    }
    }
    }
    

     

    #3

    ( ! ) Deprecated: Function split() is deprecated in C:\wamp\www\store\catalog\admin\builder_options.php on line 1463 Call Stack # Time Memory Function Location 1 0.0020 703808 {main}( ) ..\builder_options.php:0

     

     

     

    <?php
    $the_files_array = Array();
    $handle = opendir(DIR_FS_CATALOG . DIR_WS_IMAGES . $cpb_product_images_folder);
    while (false!== ($file = readdir($handle))) {
     if ($file!= "." && $file!= ".." &&!is_dir($file)) {
       $namearr = split('\.',$file);
       if (($namearr[count($namearr)-1] == 'gif') || ($namearr[count($namearr)-1] == 'jpg') || ($namearr[count($namearr)-1] == 'png')) {
         $the_files_array[] = array( 'text' => $file, 'id' => $file);
       }
     }
    }
    

     

    I noticed that is seems to be the same line but do not know how to fix it. Line: $namearr = split('\.',$file);

×
×
  • Create New...