Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

AndreD

Pioneers
  • Posts

    149
  • Joined

  • Last visited

Profile Information

  • Real Name
    André Kjellstrup
  • Website

AndreD's Achievements

  1. uploaded a dirty fix to http://addons.oscommerce.com/info/5491 - still hoping for somebody that is competent (with PHP) to fix it properly.
  2. additional info: reviews.php is only giving error messages when user is in /index.php , it works fine when user is displaying a category/product ! so "index.php?cPath=31" displays reviews & works fine, . strange ? whats_new.php is does not display errors like I claimed before ("whats_new" is the small box on side, that displays one item) the problem i related to another contribution that displays 6 new/latest products in "index.php" only (only when at "home" or "top" level). So, where's the problem ?
  3. ok I rechecked everything - the above problem was wrong genaral.php file. Everything works, but I get these errors in "whats_new.php" "reviews.php" boxes: Notice: Undefined variable: text_watermark in /home/helihob/public_html/includes/classes/oscthumb.php on line 230 Notice: Undefined variable: image_watermark in /home/helihob/public_html/includes/classes/oscthumb.php on line 235 Notice: Undefined variable: bevel in /home/helihob/public_html/includes/classes/oscthumb.php on line 238 Notice: Undefined variable: frame in /home/helihob/public_html/includes/classes/oscthumb.php on line 241 Notice: Undefined variable: params in /home/helihob/public_html/includes/classes/oscthumb.php on line 255
  4. Thanks for this great contribution. Whenever I click edit [admin/oscThumb/watermark image file] I get: Fatal error: Call to undefined function tep_cfg_pull_down_installed_watermarks() in /home/aaaaaaa/public_html/admin/configuration.php(125) : eval()'d code on line 1 Why ? - please help.
  5. Anyone knows what causes this? - same browser on another computer can load just fine, but I'd rather not have my customers see this !
  6. Products are still not sorted in alphabetic order .. update 2: "ORDER BY pd.products_name, p2c.categories_id");" fixed that. Thank you *very* much. I'll upload the complete fix to the contribution's page. It's most likely very useful to others should I credit you as "steve_s" - or maybe you prefer to do it yourself ? The complete, nice result is here: $products_query = tep_db_query("SELECT distinct pd.products_name, p.products_id, p.products_quantity, p.products_price_cost, p.products_price FROM " .TABLE_PRODUCTS." p LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN specials sp ON p.products_id = sp.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id WHERE p.products_status = 1 AND pd.language_id = FLOOR($languages_id) AND p2c.categories_id not in (" . implode(",", $exc_cat_id) . ") ORDER BY pd.products_name, p2c.categories_id");
  7. Thanks, you are good at this :) I see that you are solving this in theory only, and that's impressive. I've been fooling with the while.. routines to try to achive this result. now it works, but the product name column is empty, so it's a little hard to verify what's what. - maybe it's just a minor typo somewhere ? (it did work before this change) Update: adding "pd.products_name," to teh SELECT command solved it.. Will re-check everything now, as it does not seem to be all sorted alphabetic ..
  8. actually, I suspected the comma too, and tried to remove it, I got another error, so I did not mention it as I thought it was wrong. So here's the error I get without the comma: Array1054 - Unknown column 'p.products_cost' in 'field list' SELECT distinct p.products_id, p.products_quantity, p.products_cost, p.products_price FROM products p LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN specials sp ON p.products_id = sp.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id WHERE p.products_status = 1 AND pd.language_id = FLOOR(4) AND p2c.categories_id not in (65,66) ORDER BY p2c.categories_id, pd.products_name
  9. Thank you, I got an error: Array1064 - 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 'FROM products p LEFT JOIN products_description pd ON p.products_id = pd.prod' at line 1 SELECT distinct p.products_id, p.products_quantity, p.products_cost, p.products_price, FROM products p LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN specials sp ON p.products_id = sp.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id WHERE p.products_status = 1 AND pd.language_id = FLOOR(4) AND p2c.categories_id not in (65,66) ORDER BY p2c.categories_id, pd.products_name Old query was (complete) $products_query = tep_db_query("SELECT * FROM " .TABLE_PRODUCTS." p LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN specials sp ON p.products_id = sp.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id WHERE p.products_status = 1 AND pd.language_id = FLOOR($languages_id) AND p2c.categories_id not in (" . implode(",", $exc_cat_id) . ") ORDER BY p2c.categories_id, pd.products_name"); The one that resulted in error; $products_query = tep_db_query("SELECT distinct p.products_id, p.products_quantity, p.products_cost, p.products_price, FROM " .TABLE_PRODUCTS." p LEFT JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN specials sp ON p.products_id = sp.products_id LEFT JOIN products_to_categories p2c ON p.products_id = p2c.products_id WHERE p.products_status = 1 AND pd.language_id = FLOOR($languages_id) AND p2c.categories_id not in (" . implode(",", $exc_cat_id) . ") ORDER BY p2c.categories_id, pd.products_name"); Thank you
  10. The name was both in the subject and the post. but sure; here's the link http://www.oscommerce.com/community/contributions,3161/page,6 :) For somebody that knows PHP well it's surely a minor fix - to remove the treatment of categories, and just process all products in stock. Thanks for looking at this case.
  11. I have a working staocktaking cost contribution installed. The most important output, is the sum. The problem is, that it sums each category, and one product may be inside 2 or even three categories. - so the value of that product is summed 2 or 3 times. I'd like a fix that ignores categories, and just lists products - or at least does not add a product more than once to the total.
  12. Anyone found a way to add shipping_method to the packaging slip ? I would like to see the selected shipping method there..
  13. ok, solved it myself, contribution updated with CURL - the secure way to do it..
  14. All I get is: Warning: file_get_contents() [function.file-get-contents]: URL file-access is disabled in the server configuration in /xxxxxxxxxxxxxx/whos_online.php on line 125 As my host said told me, this uses a well known, well exploited security issue, and CURL should be used instead to fetch data. Is there any plan to upgrade this contribution to use curl instead ?
×
×
  • Create New...