Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

spyrotsk

Pioneers
  • Posts

    7
  • Joined

  • Last visited

Everything posted by spyrotsk

  1. Please, i need help! Does anyone know how to do? Thanks! SpyroTSK
  2. Hi All, I need to change one features, I need to update the price of products with this module, alredy has implemented this function, but I need change include the special price, even if possibile with one variable (true or false, in the admin panel) for enable this feature. I don't have great experience with php and mysql, for this I need your help! Thanks for your time and have a nice day! spyrotsk.
  3. no, doesn't work with this option, my hoster offers an shit service. if you wanna have a good life, don't choise Aruba for your hoster.
  4. I have fix my previews problem, but i have other problem now... if i make a pdf catalog by admin area it's work, but if i make pdf catalog of single or multiple categories by catalog area (public) it's return this error: 1054 - Unknown column 'p.products_id' in 'on clause' select p.products_id, pd.products_name, pd.products_description, p.products_image, p.products_model, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id='1' order by pd.products_name, p.products_date_added DESC [TEP STOP] i have rewrite line 705 of pdf_catalogue_info2.php: $requete_prod="select p.products_id, pd.products_name, pd.products_description, p.products_image, p.products_model, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id='".$current_category_id."' order by pd.products_name, p.products_date_added DESC"; with this: $requete_prod="select p.products_id, pd.products_name, pd.products_description, p.products_image, p.products_model, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from (" . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id='".$current_category_id."' order by pd.products_name, p.products_date_added DESC"; it's work, but it's don't create a pdf files and don't return any errors...why?
  5. no, i don't have mysql 5, i have 4.0.27-standard-log i have fix this problem...there were gif image that not read, but i have other problem now...this error: Fatal error: Allowed memory size of 25165824 bytes exhausted (tried to allocate 4097 bytes) in /web/htdocs/www.3code.it/home/catalog/admin/pdf_fpdf.php on line 1508 This error is to use too much of memory on that memory available, how do I fix it? I can not increase the memory on my hosting ...
  6. Hi, i have one problem, if i make pdf catalog with tools in admin section the script return to me this error: Fatal error: Call to a member function on a non-object in /web/htdocs/www.3code.it/home/catalog/admin/pdf_fpdf.php on line 1613 in line 1613 have this: $bgColor = $this->m_img->m_gih->m_colorTable->colorIndex($bgColor); i don't have experience with php...please help :'(
×
×
  • Create New...