Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

chuntse

Members
  • Posts

    153
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by chuntse

  1. Hi Jack, I have installed Links Manager VII 1.29 on oscommerce 2.3.3, I tried to make a new link from the administration area, but the new link couldn't be linked to the category when I selected the category from the drop down menu, I don't know how to fix it, could you please help me? Thanks in advanced. chuntse
  2. Hi All, I installed STS v4.6 and UltraPics on oscommerce-2.2rc2a. when I disable the STS, I can open the shop with Internet Explorer 8.0 properly. if I enable the STS v4.6 and the images cannot be displayed and makes the website in a mass when I open the website with Internet Explorer 8.0. There are no issue if I use Firefox to open my site. it reported pharse error of the first line and first row of following files: builder.js lightbox.js prototype.js scriptaculous.js if there is anyone know how to solve this problem? Should I post it in the thread of Ultrpics or here? Please help me. Thanks in advanced. ChunTse
  3. HI, I just installed the Ultimate SEO URLS 5 on osCommerce Online Merchant v2.2 RC2a But there are something happened, the report of Firefox explorer: The page isn't redirecting properly Firefox has detected that the server is redirecting the request for this address in a way that will never complete. And the Apache2 log report: [Tue Jul 05 09:18:25 2011] [error] [client 127.0.0.1] PHP Deprecated: Function eregi() is deprecated in /var/www/testsite/includes/classes/language.php on line 87 The code of language.php on line 87 is if (eregi('^(' . $value . ')(;q=[0-9]\\.[0-9])?$', $this->browser_languages[$i]) && isset($this->catalog_languages[$key])) { How can I solve this problem? Thanks in advance. ChunTse
  4. Hi All, The Calculate Image Size doesn't work in Product Info page. How can we thumbnail the image in Product Info page? I tried to search solution on internet or forum, there are no answer, I always see the discussion. Developper of Oscommerce 2.3.1 has not noticed this problem?? What had happened to the Oscommerce Development? There are no news about the final production verion of Oscommerce 3.0 and no one fixes the problems of oscommerce 2.3.1.... is any development freezed? OMG...Who can help us? chuntse
  5. Hi All, I want to show the language box or other boxes to the footer, I tried put this code to the footer: include('includes/modules/boxes/bm_languages.php') But it does not work, is possible to do it or....? Please help me!!! Thanks. ChunTse
  6. Hi All, I have sucessfully disable the new products list in the frontpage by index.php But each category still has the new product list. Where should I disable the code? I also want to disable the left and right column. how can I do it? The code of oscommerce 2.3.1 is much more complicated than 2.2. Please help me. Thanks
  7. Hi, Is possible to modify the following code of easypopulate.php to update or insert the price of attribute without "+" and "-"? maybe we can add an option of admin of easypopulate to select the price of attribute is being added or reduced from product's price. Is anyone know how to modify it? // options_values price update begin $v_attribute_values_price_var = 'v_attribute_values_price_' . $attribute_options_count . '_' . $attribute_values_count; if (isset($$v_attribute_values_price_var) && ($$v_attribute_values_price_var != '')) { $attribute_prices_query = "select options_values_price, price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . (int)$v_products_id . "' and options_id ='" . (int)$$v_attribute_options_id_var . "' and options_values_id = '" . (int)$$v_attribute_values_id_var . "'"; $attribute_prices_values = tep_db_query($attribute_prices_query); $attribute_values_price_prefix = ($$v_attribute_values_price_var < 0) ? '-' : '+'; // if negative, remove the negative sign for storing since the prefix is stored in another field. if ( $$v_attribute_values_price_var < 0 ) $$v_attribute_values_price_var = strval(-((int)$$v_attribute_values_price_var)); // options_values_prices table update begin // insert into options_values_prices table if no price exists if (tep_db_num_rows($attribute_prices_values) <= 0) { $attribute_prices_insert_query = "insert into " . TABLE_PRODUCTS_ATTRIBUTES . " (products_id, options_id, options_values_id, options_values_price, price_prefix) values ('" . (int)$v_products_id . "', '" . (int)$$v_attribute_options_id_var . "', '" . (int)$$v_attribute_values_id_var . "', '" . (float)$$v_attribute_values_price_var . "', '" . $attribute_values_price_prefix . "')"; $attribute_prices_insert = tep_db_query($attribute_prices_insert_query); } else { // update options table, if options already exists $attribute_prices_update_query = "update " . TABLE_PRODUCTS_ATTRIBUTES . " set options_values_price = '" . $$v_attribute_values_price_var . "', price_prefix = '" . $attribute_values_price_prefix . "' where products_id = '" . (int)$v_products_id . "' and options_id = '" . (int)$$v_attribute_options_id_var . "' and options_values_id ='" . (int)$$v_attribute_values_id_var . "'"; $attribute_prices_update = tep_db_query($attribute_prices_update_query); } } // options_values price update end Thanks in advance!!
  8. Thanks a lot for the contribution of Easy Populate & Products Attributes. I am using the Easy Populate 2.76i-MS2. I tried to import the products with attributes, but it did work. This is an example of the .cvs I have of header and one line: v_products_model 11-100014 v_status Active v_products_name_1 Outerwear A&F 201 v_products_image product/apparel/Mens/Hoodies/AF/Outerwear-A&F-201.jpg v_products_price 120 v_date_added 2010-8-5 20:58 v_categories_name_1_1 Apparel v_categories_name_2_1 Men's Clothing v_categories_name_3_1 Hoodies v_categories_name_4_1 A&F v_attribute_options_id_1 1 v_attribute_options_name_1_1 Size v_attribute_values_id_1_1 1 v_attribute_values_name_1_1_1 X v_attribute_values_id_1_2 2 v_attribute_values_name_1_2_1 M v_attribute_values_id_1_3 3 v_attribute_values_name_1_3_1 L v_attribute_values_id_1_4 4 v_attribute_values_name_1_4_1 XL EOREOR EOREOR I made something wrong? Plesse help!
  9. Sorry, i didn't describe it properly, the .csv run on IPOWER hosting provider is fine, The problem I met is my local computer, because the IPOWER restricts the MYSQL Queries to 75,000/per user/per hour, I have a lot of products. I am updating the prices and attributes, so I just want to test the .csv on local computer and import to hosting. I tried once, but the attributes didn't be imported when I ran the "Easy Populate". This is an example of the .cvs I have of header and one line: v_products_model 11-100014 v_status Active v_products_name_1 Outerwear A&F 201 v_products_image product/apparel/Mens/Hoodies/AF/Outerwear-A&F-201.jpg v_products_price 120 v_date_added 2010-8-5 20:58 v_categories_name_1_1 Apparel v_categories_name_2_1 Men's Clothing v_categories_name_3_1 Hoodies v_categories_name_4_1 A&F v_attribute_options_id_1 1 v_attribute_options_name_1_1 Size v_attribute_values_id_1_1 1 v_attribute_values_name_1_1_1 X v_attribute_values_id_1_2 2 v_attribute_values_name_1_2_1 M v_attribute_values_id_1_3 3 v_attribute_values_name_1_3_1 L v_attribute_values_id_1_4 4 v_attribute_values_name_1_4_1 XL EOREOR EOREOR I made something wrong?
  10. Hi, I met a serious problem when I import .cvs with Easy Populate v2_76i_MS2_1, The file I download with Easy Populate, and I added price and product's attribute,then I want to re-import to the categories( I have remove all products from categories and just left the categories) I am confused that the data I initially import to the shop with Easy Populate v2_76i_MS2_1, there were not any error...why I download the .cvs,edit it and re-import it...this problem happens.. The error report is: Filename: mens_apparel.csv | 11-100014 | Active | Outerwear | product/ap | 68 | 2010-8-5 2 | Apparel | Men's Clot | | Hoodies | A&F | 1 | Size | 1 | X | 2 | M | 3 | L | 4 | XL !New Product! 1264 - Out of range value adjusted for column 'products_tax_class_id' at row 1 INSERT INTO products ( products_image, 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 ( 'product/apparel/Mens/Hoodies/AF/Outerwear-A&F-201.jpg', '11-100014', '68', '1', '2010-09-16 11:12:38', '2010-08-05 20:58:00', NULL, '', '', '1', NULL) [TEP STOP] There is no 'products_tax_class_id' in the .cvs
  11. Hi, Thanks a lot for your great contribution and help me a lot. I uploaded atound 40,000 products with Easypopulate program. But now I want to update the products attributes, I want to download the .cvs file from Easypopulate program, it seems that it couldn't do it. Although I have .csv file which made by myself, but some folders or products I have renamned by cpanel, there are a lot of works to modify the .csv I have. Please tell me how to download this massive informations from easypopulate. I tried to download a category with sub-categories which contains 5,000 products, but it only can make a .cvs file with 2190 products. Thanks in advance!!!!!!!
  12. Yes, I did. I will try to reinstall it to see whether it works. Thanks!
  13. I have installed the latest full package(New Installation) of Purchase Without Account. I have following the instruction to install it. But I try to create a new account it reports 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 '= '[email protected]'' at line 1 select count(*) as total from customerswhere customers_email_address = '[email protected]' [TEP STOP] How can I solove this problem? Thanks in advance!!!
×
×
  • Create New...