Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.


  • Content count

  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Shawn Campbell
  1. My shopping cart box on right column accepts items I add to cart. Then if I click on an item in the box, it should take me to product, instead it comes up with description and pic, but then it has this error code.... 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 '{1}7 ORDER BY products_extra_fields_order' at line SELECT pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value FROM products_extra_fields pef LEFT JOIN products_to_products_extra_fields ptf ON ptf.products_extra_fields_id=pef.products_extra_fields_id WHERE ptf.products_id=44{1}7 ORDER BY products_extra_fields_order Any ideas what it may be? Assume it has something to do with product extra fields, but it didn't seem to do this before, and I haven't added anything since it worked before. Thanks Crystal www.vintagecityclothing.com
  2. shawn962650

    [Contribution] Extra Fields

    General board says its in product_info.php somewhere. I think I found an error, but I am not sure, since I am new to this. It is an error in instructions if it really is an error. Will let you know if I get anywhere with it today. Crystal
  3. shawn962650

    Product Extra Fields information not showing

    anybody this morning have any ideas!! Crystal
  4. shawn962650

    [Contribution] Extra Fields

    I did everything like the instructions.......This bites! I have a clothing store and am trying to put in the garment measurements, like Bust, Waist, etc.... and it looks fine in preview, but I don't know. If you figure it out, let me know. I have to go run some errands...... Will have hubby look when he comes home and see if he can find it. Crystal
  5. shawn962650

    [Contribution] Extra Fields

    I am having this problem too. I have tried all this and its still not working. any other thoughts or ideas? Crystal
  6. My new fields show up when listing a product, and I put in information and it shows in preview, but when I submit it to show on site, the new fields are nowhere! nothing, nada! I am not sure what else to look at.......I tried looking at php tables and not really sure what to look at, I have read alot of info on this board to try and figure it out and tried all of them, but nothing is working. HELP!!!!! Thanks! Let me know what you need to look at and I will post it, cause I am new and just learning all this php stuff! Crystal
  7. shawn962650

    UltraPics Problem SQL Error

    did that now it gives me this error..... Error SQL-query : INSERT INTO configuration( configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function ) VALUES ( '', 'Large Image Width (Pop-up)', 'LARGE_IMAGE_WIDTH', , 'The pixel width of large images (Pop-up)<br>(Use 0 for non-specific size)', 4, 32, now( ) , now( ) , NULL , NULL ) MySQL said: 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 ' 'The pixel width of large images (Pop-up)<br>(Use 0 for non-sp ahhhhh! Anybody else please?
  8. When I go in to do the Sql part, I get this error Error SQL-query : INSERT INTO configuration_group( configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible ) VALUES ( '112', 'WYSIWYG Editor 1.7', 'HTMLArea 1.7 Options', '15', '1' ) MySQL said: Duplicate entry '112' for key 1 What do I do????? Thanks!
  9. shawn962650

    Multiple Pics

    I have looked around and have not been able to find it , so maybe somebody can help. My wife runs a clothing store and I need to be able to put a few different views of each product on the info page. Does anybody know anyhting about this?