Latest News: (loading..)

jonlai9

Members
  • Content count

    98
  • Joined

  • Last visited

About jonlai9

Profile Information

  • Real Name
    Jon
  1. I just installed this, and my URLs are coming up weird. My html links are all output as such: domain.com/-p-[productid].html There's no product name. Does anyone know why? Thanks.
  2. I need some help guys! I'm getting the right (discounted) subtotal, but the line total shows the regular price. When you checkout, the line totals are used, so right now the customer is not getting any discount. What's the solution to this problem?
  3. Some more information.. bump Lately, some of my orders have been acting wierd. After I changed their order status to processing or shipped, these wierd orders will bounce back to pending every few hours. If I put them back to their correct status, they'll go back to pending a few hours later - it's very annoying. Does anyone know what's making it do this? FYI, all the wierd orders I'm talking about were paid via Paypal. The problem started with orders coming in from July 10th, but strangely, one of the orders on the 11th do not act this way. Does anyone also know which PHP page has code that might be affecting this? Please help, thanks!
  4. Hey guys, something wierd's going on. I use Paypal solely for my osCommerce website. Lately, some orders have been acting up in the sense that when I chnaged the order status to either processing or delivered, it goes back to pending within a few hours. I know it has something to do with the Paypal IPN because everytime it goes back to pending it gives me that Paypal payment notice, something like "PayPal IPN Verified [Completed (Unverified; $xxx.xx)] " Anyone know what's wrong?
  5. Hey guys, please advise! I've been using this contrib for a year now, and it's been working great, but today, I just listed new products on my catalog and when I tried making the feeder file, I got this error: : SQL error The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay| sql = SELECT concat( 'http://www.emvee.ca/product_info.php?currency=USD&products_id=' ,products.products_id) AS product_url, products_model AS prodModel, products_weight, manufacturers.manufacturers_name AS mfgName, manufacturers.manufacturers_id, products.products_id AS id, products_description.products_name AS name, products_description.products_description AS description, products.products_quantity AS quantity, products.products_status AS prodStatus, FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * 1,2) AS price, CONCAT( 'http://www.emvee.ca/images/' ,products.products_image) AS image_url, products_to_categories.categories_id AS prodCatID, categories.parent_id AS catParentID, categories_description.categories_name AS catName FROM (categories, categories_description, products, products_description, products_to_categories) left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id ) left join specials on ( specials.products_id = products.products_id AND ( ( (specials.expires_date > CURRENT_DATE) OR (specials.expires_date = 0) ) AND ( specials.status = 1 ) ) ) WHERE products.products_id=products_description.products_id AND products.products_id=products_to_categories.products_id AND products_to_categories.categories_id=categories.categories_id AND categories.categories_id=categories_description.categories_id ORDER BY products.products_id ASC Anyone know what's wrong and how I can fix it?
  6. Is there a "find" and "replace" file available for v1.10? I can't figure out what to dow tih the .diff file..
  7. How can I get this working with Paypal?
  8. Does anyone know how to get this working with the NEWSLETTER PRODUCTS contrib?
  9. Anyone know how to integrate a checkbox to add 1% for insurance?
  10. I'm using that code. The image is not appearing, it's X-ed out. When I check the properties, it just links to my /images/ directory, it doesn't link to the name of the file.jpg
  11. Thanks! The prices and slashed prices where special price is evident is now appearing, however, the product's picture is appearing as it's caption in words, so now instead of pic+product name, I simply have the product name appear twice. How would you fix this?
  12. Okay, now it works, but I get a screen with each product being $0.00... no product name, no product image... something wrong?