Jump to content

sircuss

Members
  • Content count

    19
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Sir Cuss
  1. If anyone else has this issue, here's the fix: Change catalog/shopping_cart.php FROM: $gift_query = tep_db_query("SELECT fg.*, p.products_id, p.products_model, p.products_price, p.products_image, p.products_status, pd.products_name FROM free_gifts fg, products p LEFT JOIN products_description pd ON (pd.products_id=fg.products_id) WHERE pd.language_id = '".$languages_id."' AND p.products_id = fg.products_id ORDER BY fg.threshold ASC"); TO: $gift_query = tep_db_query("SELECT fg.*, p.products_id, p.products_model, p.products_price, p.products_image, p.products_status, pd.products_name FROM (free_gifts fg, products p) LEFT JOIN products_description pd ON (pd.products_id=fg.products_id) WHERE pd.language_id = '".$languages_id."' AND p.products_id = fg.products_id ORDER BY fg.threshold ASC");
  2. Actually - Is it a MYSQL 5 copmpatability issue?
  3. I am using v1.9 of dangling carrot in and moved to a server with mysql 5. (It is from a MS2-Max build from a few years ago) Now I'm getting that error: I realize it's a mysql 5 error. V1.9 doesn't have Carrot Table so I can't apply the code change Wendy suggests without an upgrade. gift_add.php contains the following: $gift_list_query = tep_db_query("SELECT p.products_id, p.products_carrot, pd.products_id, pd.products_name FROM products p, products_description pd WHERE pd.language_id = '".$languages_id."' AND p.products_id = pd.products_id AND p.products_carrot = '1' ORDER BY pd.products_name ASC"); while ($gift_list = tep_db_fetch_array($gift_list_query)) $freeGifts[] = array('id' => $gift_list['products_name'], 'text' => $gift_list['products_name']); shopping_cart contains the following: $gift_query = tep_db_query("SELECT fg.*, p.products_id, p.products_model, p.products_price, p.products_image, p.products_status, pd.products_name FROM free_gifts fg, products p LEFT JOIN products_description pd ON (pd.products_id=fg.products_id) WHERE pd.language_id = '".$languages_id."' AND p.products_id = fg.products_id ORDER BY fg.threshold ASC"); Can anyone help me do one of 2 things - Either point me to an upgrade path to a version that works with Mysql 5+ or preferably - do you know what change to the code I should make to compensate.? My shopping cart page does not come up at all right now when you add an item.
  4. sircuss

    What is Paypal IPN?

    I have Paypal Pro and Express installed with the option that customers don't have to sign up selected. When paypal sends emails to me with orders from customers that didn't create accounts, the emails are missing what items were ordered and what the customer's phone number is. It does send the total amount, Name and address. How do I control what passes back and forth for Paypal Pro/Express? How can I also have the orders show up in oscommerce. They aren't there at all.
  5. Has anyone used both of these contribs and prefered one or the other?
  6. Kudos to you choosealogin! :) I just moved the functions file to the admin section and that worked. I used a VB macro to combine columns in Excel instead of using extra product fields. I would love to know if anyone knows a successful way of combining these contribs together - EasyPopulate, More_pics 6v1.2 and Category Fields v_1.01. Has anyone successfully integrated them?
  7. Hi Choosealogin, I replaced my easypopulate.php with the one in your last post and now I get the folowing 2 errors when trying to upload a file. http://thehappiestmanalive.com/temp/error_line164.jpg
  8. It would be great if OSCommerce had EP, mopics & extra fields as options in the program. Since they're not, I'm trying to combine them. I'm stuck at extra fields. My php knowhow is lacking and the script contribs keep bumpin up against eachother. And so I forsake extra fields and will be happy with mopics and EP. I enter the url for the extra pics but they don't seem to upload even though the contrib is installed. The fields seem to be: Products Image Products Image1 Products Image2 etc. so I add in my EP header: v_products_image v_products_image1 etc. but the images aren't added? Why not?
  9. What version of EP should I be using if all I need is - multiple pictures(more_pics_6_v1.2) and automatic thumbnail. Bercause even after commenting out a few sections, I still get the same error and can't get beyond: File uploaded. Temporary filename: /tmp/phpiMLxfa User filename: upload_test.txt Size: 4472 1054 - Unknown column 'p.products_price1_qty' in 'field list' SELECT p.products_id as v_products_id, p.products_model as v_products_model, p.products_image as v_products_image, p.products_price as v_products_price, p.products_price1_qty as v_products_price1_qty, p.products_price1 as v_products_price1, p.products_price2_qty as v_products_price2_qty, p.products_price2 as v_products_price2, p.products_price3_qty as v_products_price3_qty, p.products_price3 as v_products_price3, p.products_price4_qty as v_products_price4_qty, p.products_price4 as v_products_price4, p.products_price5_qty as v_products_price5_qty, p.products_price5 as v_products_price5, p.products_price6_qty as v_products_price6_qty, p.products_price6 as v_products_price6, p.products_price7_qty as v_products_price7_qty, p.products_price7 as v_products_price7, p.products_price8_qty as v_products_price8_qty, p.products_price8 as v_products_price8, p.products_qty_blocks as v_products_qty_blocks, p.products_weight as v_products_weight, p.products_date_added as v_date_avail, p.products_tax_class_id as v_tax_class_id, p.products_quantity as v_products_quantity, p.manufacturers_id as v_manufacturers_id, subc.categories_id as v_categories_id FROM products as p, categories as subc, products_to_categories as ptoc WHERE p.products_id = ptoc.products_id AND p.products_model = 'HMA0001' AND ptoc.categories_id = subc.categories_id [TEP STOP]
  10. Pardon me, but what section do I have to comment out? Is it from here: $filelayout_sql = "SELECT p.products_id as v_products_id, p.products_model as v_products_model, p.products_image as v_products_image, p.products_price as v_products_price, to where? Also is this the way to correctly comment out the code: //* *// ?
  11. You are quite right - I hadn't put in the msql code. After trying a few false start installs, I forgot to do it. So now file paths seem ok, but I'm getting an error. Are my header wrong? Is there a definitive guide other than the manual in the zip file? File uploaded. Temporary filename: /tmp/php4L66Mf User filename: upload_test.txt Size: 4472 1054 - Unknown column 'p.products_price1_qty' in 'field list' SELECT p.products_id as v_products_id, p.products_model as v_products_model, p.products_image as v_products_image, p.products_price as v_products_price, p.products_price1_qty as v_products_price1_qty, p.products_price1 as v_products_price1, p.products_price2_qty as v_products_price2_qty, p.products_price2 as v_products_price2, p.products_price3_qty as v_products_price3_qty, p.products_price3 as v_products_price3, p.products_price4_qty as v_products_price4_qty, p.products_price4 as v_products_price4, p.products_price5_qty as v_products_price5_qty, p.products_price5 as v_products_price5, p.products_price6_qty as v_products_price6_qty, p.products_price6 as v_products_price6, p.products_price7_qty as v_products_price7_qty, p.products_price7 as v_products_price7, p.products_price8_qty as v_products_price8_qty, p.products_price8 as v_products_price8, p.products_qty_blocks as v_products_qty_blocks, p.products_weight as v_products_weight, p.products_date_added as v_date_avail, p.products_tax_class_id as v_tax_class_id, p.products_quantity as v_products_quantity, p.manufacturers_id as v_manufacturers_id, subc.categories_id as v_categories_id FROM products as p, categories as subc, products_to_categories as ptoc WHERE p.products_id = ptoc.products_id AND p.products_model = 'HMA0001' AND ptoc.categories_id = subc.categories_id
  12. Just in case, I created a temp file in the catalog (shopping cart is root of website - ie there is no "catalog" directory) and one above the website in the root (I have multiple websites "addon domains" on my account). Both are CHMOD 777. I tried changing the path (and then changed it back) in the admin/includes configure.php file. Then I also tried adding a / to the end of the path in that file and got this error: Warning: move_uploaded_file(/home/bey12/public_html/EP_TEMP_DIR/upload_test.txt): failed to open stream: No such file or directory in /home/bey12/public_html/thehappiestmanalive/admin/includes/functions/easypopulate_functions.php on line 32 Warning: move_uploaded_file(): Unable to move '/tmp/phpFXhSuN' to '/home/bey12/public_html/EP_TEMP_DIR/upload_test.txt' in /home/bey12/public_html/thehappiestmanalive/admin/includes/functions/easypopulate_functions.php on line 32 File uploaded. Temporary filename: /tmp/phpFXhSuN User filename: upload_test.txt Size: 4415 Warning: file(/home/bey12/public_html/EP_TEMP_DIRupload_test.txt): failed to open stream: No such file or directory in /home/bey12/public_html/thehappiestmanalive/admin/easypopulate.php on line 719 Warning: Invalid argument supplied for foreach() in /home/bey12/public_html/thehappiestmanalive/admin/easypopulate.php on line 741
  13. I just installed EP v2.90b on a clean install. I am getting this error when I upload a txt file and nothing is being imported: Warning: move_uploaded_file(/home/bey12/public_htmlEP_TEMP_DIR/upload_test2.txt): failed to open stream: No such file or directory in /home/bey12/public_html/thehappiestmanalive/admin/includes/functions/easypopulate_functions.php on line 32
×