Jump to content

Annie Dragon

Members
  • Content count

    31
  • Joined

  • Last visited

Profile Information

  • Real Name
    Ann
  • Location
    Willamette Valley, Oregon
  • Website
  1. Annie Dragon

    New UPS XML Shipping Module available

    John - Very belated, but much appreciated THANK YOU! I found my error by comparing our codes. In case anyone else has made my small, but frustrating mistake, here's the exact code that I ended up using. // begin ups xml mod // added following to tep_db_query: "products_length, products_width, products_height, products_ready_to_ship," // added following to tep_db_input: " $product['products_length'] . "', '" . $product['products_width'] . "', '" . $product['products_height']. "', '" . $product['products_ready_to_ship'] . "', '" . tep_db_query("insert into " . TABLE_PRODUCTS . " (products_quantity, products_model,products_image, products_price, products_date_added, products_date_available, products_weight, products_length, products_width, products_height, products_ready_to_ship, products_status, products_tax_class_id, manufacturers_id) values ('" . tep_db_input($product['products_quantity']) . "', '" . tep_db_input($product['products_model']) . "', '" . tep_db_input($product['products_image']) . "', '" . tep_db_input($product['products_price']) . "', now(), " . (empty($product['products_date_available']) ? "null" : "'" . tep_db_input($product['products_date_available']) . "'") . ", '" . tep_db_input($product['products_weight']) . "', '0', '" . $product['products_length'] . "', '" . $product['products_width'] . "', '" . $product['products_height']. "', '" . $product['products_ready_to_ship'] . "', '" . (int)$product['products_tax_class_id'] . "', '" . (int)$product['manufacturers_id'] . "')"); Muchimas Gracias! Annie o:)
  2. Annie Dragon

    New UPS XML Shipping Module available

    1136 - Column count doesn't match value count at row 1 insert into products (products_quantity, products_model,products_image, products_price, products_date_added, products_date_available, products_weight, products_length, products_width, products_height, products_ready_to_ship, products_status, products_tax_class_id, manufacturers_id) values ('1', 'modelnumber', 'image.jpg', '10.0000', now(), '', '1.00', '0', '0', '10') This is the error message that I got from admin/categories.php Any suggestions would be appreciated - I'm trying to tease out where I need to make adjustments. The area that I though may have been the issue (right around line 300) was already adjusted with this mod. Annie
  3. Annie Dragon

    New UPS XML Shipping Module available

    Yes. Copy and duplicate product - not copy and link product to put it into another category (I do that quite a bit too). If I have a similar item in stock (same size and weight etc..) and all that I have to change is the image and a few words, I love to use the duplicate function in the products - makes my life easier. Annie
  4. Annie Dragon

    New UPS XML Shipping Module available

    The mod is working great, but there is a side effect of having the extra fields: There is an error when I try to duplicate a product (which I do quite frequently). Has anyone else run into this (and fixed it?)? I'm trying to figure out the PHP to fix the error, but if it's already been done, it would be nice to update the mod with that information. Thanks! Annie o:)
  5. Annie Dragon

    [Contribution] STS v4

    I'm getting the double headers on a clean installation (v. 4.1 with the two corrections dated 4/14/06). It's wierd since I didn't upload things quite in order (I didn't install the first patch until the end), but the double headers didn't appear until the very end. At first I had that green bar, and then I had a standard bar above it. This is the first mod that I am loading into a new, clean install of OSC. Any suggestions of which file I should be looking at to clean up the error would be appreciated. :wacko: Ah fun! Annie
  6. Annie Dragon

    NEW! Complete Order Editing Tool!

    I found it - operator error (I replaced a line that I should have kept and added to) now on to the next challenge. :blush:
  7. Annie Dragon

    NEW! Complete Order Editing Tool!

    Oh, I had that error when I tried to into orders (any method). Thanks
  8. Annie Dragon

    NEW! Complete Order Editing Tool!

    Ok, I feel like a real numbskull - I tried to install the mod (vers 1.6) & realized that not all of the directions are there, so I followed the directions in 1.59 - now I have a 404 error: The requested URL /~mysite/catalog/admin/FILENAME_ORDERS was not found on this server I know nothing of PHP & the answer is probably right under my nose, but I just can't see it. Any Suggestions?
×