Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

El_Heso

Pioneers
  • Posts

    150
  • Joined

  • Last visited

Posts posted by El_Heso

  1. The issue is related to your modifications of the EP file. You have changed a SQL insert statement, but only changed the first half. As you can see in the INSERT you posted, a structure like this "() VALUES ()". The fields you specify in the first half, must match the data you specify in the second half. Currently, as the error states, you have a mismatch in the number of fields vs. the number of data pieces. hope that helps.

    Thank you!

     

    I fixed it now i had forgotten to change a line.

  2. Now i got this error:

     

    1136 - Column count doesn't match value count at row 1

     

    INSERT INTO products ( products_image, products_mediumimage, products_largeimage, products_fileupload, products_pdfupload, manufacturers2_id, products_model, products_price, products_status, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, manufacturers_id ) VALUES ( '300201.png', '21', '1', '2000', '1', '2008-06-23 20:32:39', '2008-05-28 10:38:00', '0000-00-00 00:00:00', '1', '0.00', '10', 2)

     

     

    Someone have a qlue??

  3. 1. Open file EasyPopulate_Manual.txt (you will find it in Docs folder after you unpack the contribution)

    2. Put in the search "Lets say you have added a field to your "products" table called"

    3. Read

    In my file that text is not within it

     

     

    Found it i had wrong version.

    I found it on the v2_76g i had v2_7c installed

  4. Hi!

    I tryed to copy the code for manufacturer and change it to manufacturer2 and it works to export but when i use that file to import this happens:

     

    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 '21)' at line 32

     

    INSERT INTO products ( products_image, products_mediumimage, products_largeimage, products_fileupload, products_pdfupload, products_model, products_price, products_status, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, manufacturers_id, manufacturers2_id ) VALUES ( '300201.png', '1', '2000', '1', '2008-06-23 17:10:23', '2008-05-28 10:38:00', '1970-01-01 01:00:00', '1', '0.00', '10', 2) 21)

     

    [TEP STOP]

     

    Hope someone now what i have done wrong!!

  5. Hi!

    I have some big trouble to manage the product_info to look like this:

    anyone got a qlue how i should code to fix it.

     

     

     

    product_info.jpg

    here is the code product_info.php:

    <?php
    /*
     $Id: product_info.php,v 1.97 2003/07/01 14:34:54 hpdl Exp $
    
     osCommerce, Open Source E-Commerce Solutions
     [url="http://www.oscommerce.com"]http://www.oscommerce.com[/url]
    
     Copyright © 2003 osCommerce
    
     Released under the GNU General Public License
    */
    
     require('includes/application_top.php');
    
     require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO);
    
     $product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");
     $product_check = tep_db_fetch_array($product_check_query);
    ?>
    <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
    <html <?php echo HTML_PARAMS; ?>>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
    <title><?php echo TITLE; ?></title>
    <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
    <link rel="stylesheet" type="text/css" href="stylesheet.css">
    <link rel="stylesheet" href="lightbox.css" type="text/css" media="screen" />
    <script type="text/javascript" src="includes/js/prototype.js"></script>
    <script type="text/javascript" src="includes/js/scriptaculous.js?load=effects"></script>
    <script type="text/javascript" src="includes/js/lightbox.js"></script>
    <script language="javascript"><!--
    function popupWindow(url) {
     window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res
    izable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,le
    ft=150')
    }
    //--></script>
    </head>
    <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
    <!-- header //-->
    <?php require(DIR_WS_INCLUDES . 'header.php'); ?>
    <!-- header_eof //-->
    
    <!-- body //-->
    <table border="0" width="100%" cellspacing="3" cellpadding="3">
     <tr>
       <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
    <!-- left_navigation //-->
    <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
    <!-- left_navigation_eof //-->
       </table></td>
    <!-- body_text //-->
       <td width="100%" valign="top"><?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')); ?><table border="0" width="100%" cellspacing="0" cellpadding="0">
    <?php
     if ($product_check['total'] < 1) {
    ?>
         <tr>
           <td><?php new infoBox(array(array('text' => TEXT_PRODUCT_NOT_FOUND))); ?></td>
         </tr>
         <tr>
           <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
         </tr>
         <tr>
           <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
             <tr class="infoBoxContents">
               <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
                 <tr>
                   <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
                   <td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td>
                   <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
                 </tr>
               </table></td>
             </tr>
           </table></td>
         </tr>
    <?php
     } else {
       $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");
       $product_info = tep_db_fetch_array($product_info_query);
    
       tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'");
    
       if ($new_price = tep_get_products_special_price($product_info['products_id'])) {
         $products_price = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>';
       } else {
         $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']));
       }
    
       if (tep_not_null($product_info['products_model'])) {
         $products_name = $product_info['products_name'] . '<br><span class="smallText">[' . $product_info['products_model'] . ']</span>';
       } else {
         $products_name = $product_info['products_name'];
       }
    ?>
         <tr>
           <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
             <tr>
               <td class="pageHeading" valign="top"><?php echo $products_name; ?></td>
    
             </tr>
           </table></td>
         </tr>
         <tr>
           <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
         </tr>
         <tr>
           <td class="main">
    <?php
       if (tep_not_null($product_info['products_image'])) {
    ?>
             <table border="0" cellspacing="0" cellpadding="2" align="left">
               <tr>
                 <td align="center" class="smallText">
    <?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" target="_blank" rel="lightbox">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], $product_info['products_name'], SMALL_IMAGE_WIDTH*3, SMALL_IMAGE_HEIGHT*3, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>
    
                 </td>
               </tr>
             </table>
    <?php
       }
    ?>
    <p><?php echo $products_price; ?></p>
    <?php 
     $prod_quantity = tep_get_products_stock($products_id); 
     switch ($prod_quantity) { 
         case 0: 
         print '<img src="images/stock_soldout.gif" border="0">'; 
         break; 
         case 1: 
         print '<img src="images/stock_limitedstock.gif" border="0">'; 
         break; 
         case 2: 
         print '<img src="images/stock_limitedstock.gif" border="0">'; 
         break; 
         case 3: 
         print '<img src="images/stock_instock.gif" border="0">'; 
         break; 
         case 4: 
         print '<img src="images/stock_instock.gif" border="0">'; 
         break; 
         default: 
         print '<img src="images/stock_instock.gif" border="0">'; 
     } 
     ?>
     <p><?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?></p>
             <p><?php echo stripslashes($product_info['products_description']); ?></p>
    <?php
       $products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'");
       $products_attributes = tep_db_fetch_array($products_attributes_query);
       if ($products_attributes['total'] > 0) {
    ?>
    
    
             <table border="0" cellspacing="0" cellpadding="2">
               <tr>
                 <td class="main" colspan="2"><?php echo TEXT_PRODUCT_OPTIONS; ?></td>
    
               </tr>
    <?php
         $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_name");
         while ($products_options_name = tep_db_fetch_array($products_options_name_query)) {
           $products_options_array = array();
           $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'");
           while ($products_options = tep_db_fetch_array($products_options_query)) {
             $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']);
             if ($products_options['options_values_price'] != '0') {
               $products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') ';
             }
           }
    
           if (isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) {
             $selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']];
           } else {
             $selected_attribute = false;
           }
    ?>
               <tr>
                 <td class="main"><?php echo $products_options_name['products_options_name'] . ':'; ?></td>
                 <td class="main"><?php echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute); ?></td>
               </tr>
    <?php
         }
    ?>
             </table>
    <?php
       }
    ?>
           </td>
         </tr>
         <tr>
           <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
         </tr>
    <?php
       $reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'");
       $reviews = tep_db_fetch_array($reviews_query);
       if ($reviews['count'] > 0) {
    ?>
         <tr>
           <td class="main"><?php echo TEXT_CURRENT_REVIEWS . ' ' . $reviews['count']; ?></td>
         </tr>
         <tr>
           <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
         </tr>
    
    <?php
       }
    
       if (tep_not_null($product_info['products_url'])) {
    ?>
         <tr>
           <td class="main"><?php echo sprintf(TEXT_MORE_INFORMATION, tep_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($product_info['products_url']), 'NONSSL', true, false)); ?></td>
         </tr>
         <tr>
           <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
         </tr>
    <?php
       }
    
       if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) {
    ?>
         <tr>
           <td align="center" class="smallText"><?php echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($product_info['products_date_available'])); ?></td>
         </tr>
    <?php
       } else {
    ?>
         <tr>
           <td align="center" class="smallText"><?php echo sprintf(TEXT_DATE_ADDED, tep_date_long($product_info['products_date_added'])); ?></td>
         </tr>
    <?php
       }
    ?>
         <tr>
           <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
         </tr>
         <tr>
           <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
             <tr class="infoBoxContents">
               <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
                 <tr>
                   <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
                   <td class="main"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params()) . '">' . tep_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS) . '</a>'; ?></td>
                   <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
                 </tr>
               </table></td>
             </tr>
           </table></td>
         </tr>
         <tr>
           <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
         </tr>
         <tr>
           <td>
    <?php
       if ((USE_CACHE == 'true') && empty($SID)) {
         echo tep_cache_also_purchased(3600);
       } else {
         include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);
       }
     }
    ?>
           </td>
         </tr>
       </table></form></td>
    <!-- body_text_eof //-->
       <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
    <!-- right_navigation //-->
    <?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>
    <!-- right_navigation_eof //-->
       </table></td>
     </tr>
    </table>
    <!-- body_eof //-->
    
    <!-- footer //-->
    <?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
    <!-- footer_eof //-->
    <br>
    </body>
    </html>
    <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
    

    Regards Tony

  6. Hi!

    I have some problem suddenly this happens when i want to import the file.

     

    1136 - Column count doesn't match value count at row 1

     

    INSERT INTO products ( products_image, products_mediumimage, products_largeimage, products_fileupload, products_pdfupload, products_model, products_price, products_status, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, manufacturers_id ) VALUES ( '100201v2.png', 'PT101202', '2000', '1', '2008-06-14 21:04:32', '2008-05-28 10:38:00', '0000-00-00 00:00:00', '1', '0.00', '10', 1)

     

    [TEP STOP]

     

    Any one have a qlue what the problem can be??

     

    /Tony

     

    I have fixed my problems.

     

    But now i wonder if its possible to change the EP not to take the model number to identify the product as i use the same model number on a lot of my products i saw it when i used my file to upload new products that EP overwrite all products who have the same model number beacuse EP takes that as one product ( EP translate model number as product id number i guess ) but how can i change that so i can use the same model number on my products without EP overwrite them??

     

    Hope someone have some qlue how to manage that.

     

    Regards Tony

  7. Hi!

    can i use this contrib to make it working in product_listing with a second dropdown were i can sort/filter the products after gender if i make manufacturers2 to gender??

     

    I have tryed to install this contib but i always get 2 tables one for the ordinary dropdown and one for the manufacturers2 dropdown

     

    Regards Tony

  8. Hi!

    I have some problem suddenly this happens when i want to import the file.

     

    1136 - Column count doesn't match value count at row 1

     

    INSERT INTO products ( products_image, products_mediumimage, products_largeimage, products_fileupload, products_pdfupload, products_model, products_price, products_status, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, manufacturers_id ) VALUES ( '100201v2.png', 'PT101202', '2000', '1', '2008-06-14 21:04:32', '2008-05-28 10:38:00', '0000-00-00 00:00:00', '1', '0.00', '10', 1)

     

    [TEP STOP]

     

    Any one have a qlue what the problem can be??

     

    /Tony

  9. Hi!

    I have some problem with my EP.

    This happens when i try to export to EP from admin.

    <b>Fatal error</b>: Call to undefined function tep_get_tax_class_rate() in <b>C:\wamp\www\xxx\admin\easypopulate.php</b> on line <b>761</b><br />

     

    and here is the row 761

    $row_tax_multiplier = tep_get_tax_class_rate($row['v_tax_class_id']);

     

    then i wonder if someone know how to implement this contrib into EP ( pdf_upload_v_1_5 ) http://addons.oscommerce.com/info/2807

     

    Hope someone have a qlue how to fix this problems

     

    Regards Tony

    I have fixed the problems

  10. Hi!

    I have some problem with my EP.

    This happens when i try to export to EP from admin.

    <b>Fatal error</b>: Call to undefined function tep_get_tax_class_rate() in <b>C:\wamp\www\xxx\admin\easypopulate.php</b> on line <b>761</b><br />

     

    and here is the row 761

    $row_tax_multiplier = tep_get_tax_class_rate($row['v_tax_class_id']);

     

    then i wonder if someone know how to implement this contrib into EP ( pdf_upload_v_1_5 ) http://addons.oscommerce.com/info/2807

     

    Hope someone have a qlue how to fix this problems

     

    Regards Tony

  11. Hi!

    I have a big problem with the contrib Header Tags SEO V3.0.1

    This is what happen when i go to edit a product in admin:

     

    Fatal error: Call to undefined function tep_get_products_head_title_tag() in /usr/home/web29892/domains/customfit.eu/public_html/admin/categories.php on line 1025

     

     

    and here is the line:

    <td class="main"><?php echo tep_draw_textarea_field('products_head_title_tag[' . $languages[$i]['id'] . ']', 'soft', '70', '5', (isset($products_head_title_tag[$languages[$i]['id']]) ? stripslashes($products_head_title_tag[$languages[$i]['id']]) : tep_get_products_head_title_tag($pInfo->products_id, $languages[$i]['id']))); ?></td>

     

     

     

     

    please can someone help me

     

    regards Tony

  12. Tony are you running your own server or are you on a hosting plan?

    I'll start by saying that I know nothing about IIS other than what I have read.

    The consensus of my reading mostly said get another host and get off of IIS.

    Yes, it has something to do with the htaccess file.

     

    Do a search on Google for this

    site:www.oscommerce.com/forums IISPassword for Internet Information Services

    and see what you think you need to do according to others responses

     

    Google Junky

    Hi!

    I have tryed both my own server by wamp: apache server doesn´t work and also my hosting site, it´s the same errors

     

    /Tony

  13. Hi!

    Again now i tryed to install Search Engine Friendly URL 1.13 on a clean oscommerce 2.2RC2a

    i have done everything and this happens:

    IISPassword

    The page cannot be displayed

    There is a problem with the page you are trying to reach and it cannot be displayed. It is most likely that configuration files for this url are corrupted.

     

    HTTP Error 500

    IISPassword for Internet Information Services

     

    Anyone know what is going wrong?

     

    When i remove the htaccess from the root the site starts but when i click on a category

    this happens:

    The page cannot be found

    The page you are looking for might have been removed, had its name changed, or is temporarily unavailable.

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

     

    Please try the following:

     

    Make sure that the Web site address displayed in the address bar of your browser is spelled and formatted correctly.

    If you reached this page by clicking a link, contact the Web site administrator to alert them that the link is incorrectly formatted.

    Click the Back button to try another link.

    HTTP Error 404 - File or directory not found.

    Internet Information Services (IIS)

     

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

     

    Technical Information (for support personnel)

     

    Go to Microsoft Product Support Services and perform a title search for the words HTTP and 404.

    Open IIS Help, which is accessible in IIS Manager (inetmgr), and search for topics titled Web Site Setup, Common Administrative Tasks, and About Custom Error Messages.

     

    so i think the problem is in the .htaccess file

     

    /Tony

  14. Hi!

    I have tryed to install Search Engine Friendly URL 1.13

    but it dont seem to work when i place the .htaccess file in the root the site is closed and also admin

    this happens:

    Internal Server Error

    The server encountered an internal error or misconfiguration and was unable to complete your request.

     

    Please contact the server administrator, webmaster@localhost and inform them of the time the error occurred, and anything you might have done that may have caused the error.

     

    More information about this error may be available in the server error log.

     

    is this problem beacuse i have an old version of oscommerce and not the new one?

     

    and this problem also occur when i have tryed on my website ( not my server )

     

    Hope someone have a qlue?

     

    Regards Tony

  15. I am working many hours on combining the results of manufacturer + manufacturer2 + manufacturer3 ...... with a go button at the header or index page.

     

    For example :o

    MANUFACTURERS=BRAND

    MANUFACTURERS2=GENDER

    MANUFACTURERS3=STLYE

    MANUFACTURERS4=PRICE RANGE

    Then choose 1 and 2 and 3 and 4 .......(or choose 2 and 3 and 4, or choose 1 and 4 etc...) and display the combined results.

    I guess there should be constructed a new boxe file eg. manufacturers_all.php that will include the combined code of all 1,2,3,4,.......

    Can anyone help me in this?

    Tell me if you manage to get that to work

     

    Regards Tony

×
×
  • Create New...