Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

angrycat

Archived
  • Posts

    11
  • Joined

  • Last visited

Profile Information

  • Real Name
    Jeremy

angrycat's Achievements

  1. Hello again, I have the other modules installed, and they are available, along with the ?0 price shipping options. Is this how it is supposed to work? i.e. the customer is presented with courier options for ?x along with ?0 options where the weight is exceeded, with a warning that the price for this option cannot be calculated? I ask, as I only saw this behaviour when I was testing with a hight tare weight and low product weight. When using a high product weight, the options where the weight was exceeded dissapeared alltogether. Thanks Very usefuld contrib BTW, cheers :thumbsup:
  2. Hi, I think there is a bug within this contrib. If the tare weight is high, say 3kg, but the product weight is low, 0.1, then at checkout the Royal mail options with a 3kg cap display with a message along the lines of "price cannot be confirmed over 3kg". Although the message displays saying the costs cannot be calculated, it is still possible to select these items and checkout with ?0.0 shipping charges. I know this is an unlikely to occur in a live shop, but it is a weakness. AC
  3. Thought I may as well post my changes to configure.php: At the end of the file I added // define froogle parameters define('FR_SERVER', 'hedwig.google.com'); define('FR_USERNAME', 'CHANGEME-froogle-username'); define('FR_PASSWORD', 'CHANGEME-froogle-password'); Then in froogle.php, assuming you already have added the line: require('includes/application_top.php'); you can use: $ftp_server = FR_SERVER; $ftp_user_name = FR_USERNAME; $ftp_user_pass = FR_PASSWORD;
  4. Hi, Sorry if this has been suggested before, but this is now a very long thread :-) Instead of defining the file and database variables separately in froogle.php why not: 1) At the top of the page add: require('includes/application_top.php'); 2) Change froogle.php to use constants from configure php $home = DB_SERVER; $user= DB_SERVER_USERNAME; $pass= DB_SERVER_PASSWORD; $base= DB_DATABASE; 3) Add to admin/includes/filenames.php define('FILENAME_FROOGLE', 'froogle.php'); define('FILENAME_FROOGLE_OUT', '../feeds/your-fr-outfile.txt'); define('FILENAME_FROOGLE_DEST', 'your-fr-outfile.txt'); 4) Change froogle.php to use above filenames: $OutFile = FILENAME_FROOGLE_OUT; $destination_file = FILENAME_FROOGLE_DEST; ----------------------------------------------------------------- It does not make sense to add separate definintions for database constants, or depart from the osComm method of declaring file names, in my humble opinion :-) For my own implementation I will add additional constants to configure.php to replace: $ftp_server = "hedwig.google.com" ; $ftp_user_name = "CHANGEME-froogle-username"; $ftp_user_pass = "CHANGEME-froogle-password";
  5. Sorry for the delay in replying, Yes the fix for MySQL 5 worked well, Thanks,
  6. Thanks for that, I thought Id searched the thread properly..... :-) I thought it may be MySQL v 5, Ive had a couple of other issues with it. Ill let you know how I get on with the fix.
  7. Hello, I have a problem with my Froogle. I just install it and I got this message when running admin -> froogle.php CODE Notice: Undefined variable: FunctionName in D:\Web\usedkidsbooks\admin\froogle.php on line 205 : SQL error Unknown column 'products.manufacturers_id' in 'on clause'| sql = SELECT concat( 'http://www.usedkidsbooks.com/product_info.php?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.usedkidsbooks.com/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 Hello all, I have the same problems described above. 1) Undefined variable: FunctionName FunctionName is not defined anywhere in Froogle.php, and I cannot find it in dependant files. Is FunctionName some kind of system variable?? How and where do I set it? 2) : SQL error Unknown column 'products.manufacturers_id' in 'on clause' I have checked my database and products.manufacturers_id is present and correct. I can run queries on it ok, but not this one!! Does anyone know why this error occurs? I am using MySQL Server 5.0 Any help appreciated.
×
×
  • Create New...