Jump to content


  • Content count

  • Joined

  • Last visited

Everything posted by caspire

  1. Hi, I am installing Free shipping per product 1.1, link: http://www.oscommerce.com/community/contributions,2517 After I installed, when looking at the product info I get this error message: "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 ' p.products_free_shipping from products p, products_description select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_retail_price, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from, p.products_free_shipping from products p, products_description pd where p.products_status = '1' and p.products_id = '619' and pd.products_id = p.products_id and pd.language_id = '1' [TEP STOP]" I also have the contribution "EZier New Fields 5.0" which shows amount customer is saving "retail price: 89.99 our price: 45.00 you save: 44.99 or 50%" I am not sure if this contribution is messing with the Free shipping one or if I have made an error. Any suggestions? If I did make a mistake, what file is it likely to be in? Product_info.php? Thank you...
  2. caspire

    Automatically send data feed to Froogle

    I am trying to figure out what you mean by "putting in your feed file under the product url config line" I believe your talking about editing the froogle.php so the first part of the code looks like this: $imageURL = 'http://www.mysite.com/catalog/images/'; $productURL = 'http://www.mysite.com/catalog/product_info.php?products_id='; $OutFile = "../feeds/frooglefeed.txt"; //"CHANGEME-full-path-to-file-with-777-dir-and-file-permissions.fr-outfile.txt"; $destination_file = "frooglefeed.txt"; //"CHANGEME-filename-to-upload-to-froogle.txt" ; $source_file = $OutFile; $already_sent = array(); Is this correct? I still get the "stock" osCommerce URL's in my .txt file.
  3. I just posted the message below and then looked at the post that was done while I was writing this (above mine) and it almost looks like it has the same question , but if it answers mine then you obviously dont need to reply to me as well. Thanks. Jack, thanks that worked great. Also, when I view a folder (category) it lists the subfolders or products and I added the "Header Tags Category Title" and I saw it adds it just above the product or subfolders, but how can I have that title also be shown in the browsers title bar? Sorry if this is explained somehwere else, but I am having a hard time finding it. Thanks again! Your awesome!
  4. Ok, now that i have it working I have a really quick and simple question: When viewing product, it shows the title as the product name and then my default title which is awesome. But there is no space between the product title and my default title. Is there a simple fix for this? It looks like: Product NameStore Name Want it to look like: Product Name - Store Name
  5. You know what, I got it working...ahhh I hate myself sometimes. Simple mistake. Jack, thank you again. I am sorry I am such an idiot. We all appreciate your help! :) :) :) :)
  6. Hmmm ok thanks for your time...I will try installing it from the start again. If I want to delete the changes to my database made by the header.sql can i just run: ALTER TABLE products_description DROP products_head_title_tag VARCHAR(80) NULL; ALTER TABLE products_description DROP products_head_desc_tag LONGTEXT NULL; ALTER TABLE products_description DROP products_head_keywords_tag LONGTEXT NULL; ALTER TABLE categories_description DROP categories_htc_title_tag VARCHAR(80) NULL; ALTER TABLE categories_description DROP categories_htc_desc_tag LONGTEXT NULL; ALTER TABLE categories_description DROP categories_htc_keywords_tag LONGTEXT NULL; ALTER TABLE categories_description DROP categories_htc_description LONGTEXT NULL;
  7. Everything else works fine. I see the Header Tags section in my admin menu and when I click on text control, my default info is there... My regular store index is working fine...It shows the header tags, (title, description, keyworks, etc) correctly. its just when I try to add product.
  8. Header Tags Controller v2.5.3 Can I somehow delete the changes the header.sql made to my database and then run it again? I never ran the files that are named like: Update_header_categories.sql Update_header_categories_description.sql Update_header_language.sql I didnt think I was supposed to was I?
  9. I ran this on my database becuase I saw that you posted it on the last page...not sure if this could generate the error message that I am getting.
  10. Ok, i uploaded your categories.php from the "catalog_for_new_shop_only" directory and then reloaded the page...and I still get the same error. Any other suggestions? hehe thanks! :)
  11. My database is showing the products_head_title_tag field and its set to this: Field: Type: Null: Default: products_head_title_tag varchar(80) Yes NULL So I am not sure why its saying "1054 - Unknown column 'products_head_title_tag' in 'field list'" because it is there...hmmm ?? :huh:
  12. Hello, I get this error message when adding/editing product: Meta Tag Information Products Page Title: English 1054 - Unknown column 'products_head_title_tag' in 'field list' select products_head_title_tag from products_description where products_id = '0' and language_id = '1' [TEP STOP] If you can tell me which page this error is from I can paste the code or sections of the code so you can help me. Or if you know what is wrong, please help me fix it. Thank you. :D
  13. caspire

    Free shipping per product 1.0

    Anyone? :)
  14. caspire

    Free shipping per product 1.0

    I am facing the same problem... Anyone find a fix for this?
  15. caspire

    Free shipping per product 1.1

    I got it...thanks
  16. Is this contrib. stable? And do you think we will ever see v3.0 available now that Chemo is gone?
  17. caspire

    Ultimate SEO URLs v3.0 Features

    I cant wait until its out...! :)
  18. Do I still need to install 301 header redirects with the new version of SEO URL to keep my page ranking? Or does the new version include something like it?
  19. caspire

    Official PayPal IPN Support Thread

    Hey I have some quick questions... I installed the osCommerce PayPal IPN Module and I am getting orders showing up in the "Preparing [PayPal IPN]:" order stage. Question #1:How do I know if the customer actually tried to purchase the product, but just didnt return to the page after confirmation or if they just went through the checkout process and didnt want to actually pay for the item? Would it make sense by looking in my paypal account to see if any money was sent from that user? And if there isnt any money from that person that means that they didnt complete the checkout process? Question #2:Is there anyway that I can make it so they are automatically returned to my webpage? I have an autoreturn option turned on in my paypal account > profile settings...is that the only way? Thanks guys...
  20. caspire

    UPS XML Dimensional Support

    I am about to install this contribution....So should I not install it if there are errors with it? Hmmm...does this only happen when multiple items are purchased? If so...is it only with the same prod being purchased or does it also mess up when multiple (different) items are purchased at the same time? :(