Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

lhps

Pioneers
  • Posts

    17
  • Joined

  • Last visited

Posts posted by lhps

  1. Hi Code Red,

     

    Try this:

     

    Line 67 in catalog/includes/classes/split_page_results.php must be changed from:

    $this->sql_query .= " limit " . $offset . ", " . $this->number_of_rows_per_page;

    to:

    $this->sql_query .= " limit " . max($offset, 0) . ", " . $this->number_of_rows_per_page;

    Line 38 in catalog/admin/includes/classes/split_page_results.php must be changed from:

    $sql_query .= " limit " . $offset . ", " . $max_rows_per_page;

    to:

    $sql_query .= " limit " . max($offset, 0) . ", " . $max_rows_per_page;

    Hi,

     

    I've just installed this contrib but I'm getting the following error in admin/customers.php -

     

    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 '-20, 20' at line 1

     

    select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, c.customers_group_id, c.customers_group_ra, a.entry_country_id, a.entry_company, cg.customers_group_name from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id left join customers_groups cg on c.customers_group_id = cg.customers_group_id order by c.customers_id DESC limit -20, 20

     

    Any ideas?

    Hi,

     

    I've just installed this contrib but I'm getting the following error in admin/customers.php -

     

    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 '-20, 20' at line 1

     

    select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, c.customers_group_id, c.customers_group_ra, a.entry_country_id, a.entry_company, cg.customers_group_name from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id left join customers_groups cg on c.customers_group_id = cg.customers_group_id order by c.customers_id DESC limit -20, 20

     

    Any ideas?

     

    My 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 'where c.customers_lastname like '%lucas%' or c.customers_firstname like '%lucas%' at line 1
    select count(*) as total from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id, customers_groups cg where c.customers_group_id = cg.customers_group_id where c.customers_lastname like '%lucas%' or c.customers_firstname like '%lucas%' or c.customers_email_address like '%lucas%'
    

  2. Hello, I have problem in instaltion.

     

    No access admin/index.php

     

    is problem

     

    Fatal error: Call to undefined function qtpro_sick_product_count() in /home/osc/public_html/admin/index.php on line 37

     

    Cod Origem.:

     

     <?php //++++ QT Pro: Begin added code
    $qtpro_sick_count = qtpro_sick_product_count();
    if($qtpro_sick_count != 0){
    ?>
    <table border="0" width="100%" cellspacing="0" cellpadding="0"><tr><td class="messageStackWarning"><?php echo 'Warning: There are '. $qtpro_sick_count . ' sick products in the database. Please visit <a href="' . tep_href_link(FILENAME_QTPRODOCTOR) . '" class="headerLink">the QTPro doctor</a>.'; ?></td></tr></table>
    <?php
    }
    //++++ QT Pro: End added code ?>

     

     

    Help-me rsrs :) Gracias

  3. I need help in shopping_cart.php

     

       <td align="right" class="main"><b><?php echo SUB_TITLE_SUB_TOTAL; ?> <?php echo $currencies->format($cart->show_total()); ?></b>
                     <?php 
    if ($together_offer_ok) { 
     echo '<tr><td class="smalltext" align="center"><img src="images/save-icon_sm.gif" border="0" style="vertical-align:middle" alt="2gether discount" title="2gether discount"> ' . TOGETHER_TEXT_RECEIVE_CHECKOUT . ' <img src="images/save-icon_sm.gif" border="0" style="vertical-align:middle" alt="2gether discount" title="2gether discount"></td></tr>';
     echo '<tr><td>'.tep_draw_separator('pixel_trans.gif', '100%', '10').'</td></tr>';
    } 
    ?>

     

    Sub-total discount does not appear in shopping cart, what should I have done wrong ??

     

    Thank's for help.

  4. I have problem in admin/recover_cart_sales.php on line 503.

     

    Fatal error: Call to undefined function tep_get_products_special_price() in /home/webz/public_html/admin/recover_cart_sales.php on line 503

     

    is line

    $sprice = tep_get_products_special_price( $inrec['pid'] );
    		if( $sprice < 1 )
    			$sprice = $inrec2['price']; 

     

    I need help please rsrs Thank's

  5. This is the forum for the Contrib Stock Inventory report with export function.

     

     

    HI , have problem this....

     

    1054 - Unknown column 'p.products_cost' in 'field list'

     

    select p.products_id, p.products_quantity, p.manufacturers_id, pd.products_name, p.products_model, p.products_weight, p.products_cost, p.products_price, p.products_status, pr.manufacturers_name from products p inner join products_description pd on p.products_id = pd.products_id left outer join manufacturers pr ON (p.manufacturers_id = pr.manufacturers_id) where pd.language_id = '4' group by pd.products_id order by pd.products_name ASC limit 0, 200

     

     

    to solve?

     

    Thank's

  6. Hello Lucas,

     

    Check your files using a file comparison tool such as Beyond Compare or WinMerge against the files from the contribution.

     

    You may also be missing the testimonials folder in your image directory.

     

    Note: This contribution uploads an additional upload.php file that is seaparate from the original stock upload.php file that is in the admin side. The new upload.php file is in the catalog side to allow customers to upload an image from the frontend.

     

    Hi Thank's for respot,

     

    The archive upload.php in this folder classes in direcotry catalog/includes/classes/ .

     

    The folder image/testimonials is creat .

     

     

    I do not understand this information

    "Check your files using a file comparison tool such as Beyond Compare or WinMerge against the files from the contribution."

     

    I check what(wich) files?? upload.php ??

  7. My problem is.

     

    Fatal error: Class 'upload' not found in /home/web/public_html/customer_testimonials_write.php on line 28

     

     

    is line

     

    if(!is_dir(DIR_WS_IMAGES . 'testimonials'))mkdir(DIR_WS_IMAGES . 'testimonials', '777');

     

    $testimonial_image = new upload('testimonial_image');

    $testimonial_image->set_destination(DIR_WS_IMAGES . 'testimonials/');

    if ($testimonial_image->parse() && $testimonial_image->save()) {

    $testimonial_image_name = $testimonial_image->filename;

    }

     

    The archive upload.php is in the folder.

     

    Than'ks for help.

  8. 1054 - Unknown column 'p.products_cost' in 'field list'

     

    select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image,p.products_price,p.products_cost, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from products p, products_description pd where p.products_id = '36' and p.products_id = pd.products_id and pd.language_id = '4'

     

    [TEP STOP]

     

     

    I am having the same problem. At the time to edit a product appears this error.

     

    We did the upgrade and remains the same mistake.

     

    What should I do?

  9. As I make pra to leave the prices thus

     

    $ 939.00

    to the sight or

    12x $ 78.25

    without interests in the card

     

    assimyt5.th.gif

     

    as I make pra to leave the visualization of the products thus

     

    d2xx7.th.gif

     

     

    thanks

×
×
  • Create New...