Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.


  • Content count

  • Joined

  • Last visited

Everything posted by sitandspin

  1. Hello, I've installed X-Sell v2.3 for MS2 on RC2 modded with STS. That's a lot of acronyms. Everything went fine, installation seemed simple enough, but when I clicked on the Cross Sell Products in my admin, I was treated with this error. "1146 - Table 'xxxxxxx_osc.TABLE_PRODUCTS_XSELL' doesn't exist select p.products_id, p.products_model, pd.products_name, p.products_id, x.products_id, x.xsell_id, x.sort_order, x.ID from products p, products_description pd, TABLE_PRODUCTS_XSELL x where x.xsell_id = p.products_id and x.products_id = "5" and p.products_id = pd.products_id and pd.language_id = "1" order by x.sort_order asc" I've run the SQL file several times and still this error pops up. It always shows a product and gives that error even though I have not set any products up to cross sell. I have verified that the table does in fact exist. The table is empty. I'm stuck. Anyone else have this problem? If I delete the product associated with the error, it just populates with another product. I haven't tried removing all of my products, but it may come to that. It's a default installation and they're going sooner or later. Thanks!
  2. I'm running EP 2.76, but it doesn't seem to be working, and I'm not sure why. I've read a lot of stuff, tried many things, but EP tells me that it has uploaded the file and inserted it into the DB, but does not actually insert anything into the DB. I set up my file correctly, I have EOREOR at the end of every line, and it is not working. Any ideas? I can't look through all 235 pages of the other thread, so if you have experience with this problem, please reply. Your response is appreciated in advance.
  3. sitandspin

    STS and Ultrapics

    They definitely work together. The additional pictures will show up in the $content tag. You don't have to do any additional work to your template. Just follow the installation instructions included with Ultrapics and the changes will be passed through to the template via the $content tag. You can see it in action on the site I'm developing. I used the Ultrapics/Lightbox mod to give a nice blackout effect to the popup.
  4. I just installed the Ship in Cart mod to estimate USPS shipping via USPS methods before customer checkout. The mod looks great, but works very slow. I ran a query debug on my shop and the parse time for an unmodified cart is very short - 0.3 s or less usually with about 47 queries. When I run the Ship in Cart mod, the parse time for the page increases from anywhere between 20 seconds to 85 seconds! I think the issue is the USPS server. Is anyone else seeing a major slowdown today? Even my checkout page took 25 seconds to load and it works independent of the Ship in Cart contribution.
  5. sitandspin

    [Contribution] Ship In Cart

    Okay, I patched the Ship in Cart mod to work with RC2.2a. I'll put it up as a fix under addons later today. Works like a charm, but kind of slow.
  6. sitandspin

    [Contribution] STS v4

    Use this contribution. Search Box Anywhere I've used it on the site I'm building and this will do what you want. You can see it on my site. You should be able to change the text on the button from "Search" to "Go" by editing the code in the search box tag. I think the installation instructions show you how to do it.
  7. sitandspin

    [Contribution] Ship In Cart

    I just tried installing this mod on RC2a. No luck. I have the same problem you're having, unless you figured out a way to fix it. If the nimble fingered maintainers of this contribution could figure out a way for this to work with RC2a, I'd really appreciate it! Thanks! NOTE: this doesn't break the shopping cart - just the shipping_estimator mod does not show up!
  8. I hope someone can answer my question. It seems simple, yet I can't figure it out. I have a small shop so I'm manually inserting products. I'm not using EasyPopulate. I've used it in the past, but this shop is smaller, so I'm doing everything by hand which is pretty time consuming, but it's giving me the results I want. Anyway, I've got ultrapics installed on this shop and I really like it. I'm using it in conjunction with the On the Fly GD autothumbnailer contribution to generate my thumbnails. Basically, I upload the same three images for products_image, products_image_med, and products_image_lrg. I then upload the same two pictures for products_sm_1, products_xl_1, etc. for each additional image. To save time, I'd like to upload one picture and have it populate each field for the database for each one of the additional image fields because the autothumbnailer is making my thumbnails for me. I've looked at my admin/categories.php and that's just way beyond my meager PHP hacking skills to figure out what I need to do to accomplish my goals. Should I be looking elsewhere? Should I just keep clicking on 'Choose File' like 7-10 times for each product and deal with the 30 sec. I'm losing by doing that? Should I use easypopulate? Argh. It seems like there should be a simple workaround, but I've read these threads and searched the forums and I can't quite find the answer to this burning question. Thanks!
  9. sitandspin


    I have not had any compatibility issues with the MS2.2 mods I've been putting into my RC2 shop. I don't think the codebase has changed very much between the releases, but I definitely like the look/feel of RC2 over MS2.2 at the moment. I'd make a list of all the mods I've installed, but it would be really, really long. So far, so good. If you have any specific mods you're interested in installing, reply and I'll let you know if I've got them working on my shop.
  10. sitandspin

    [Contribution] STS v4

    Yeah, I didn't realize until right now that the Show: on the product_info page already filters the results by category or manufacturer. So forget this post! I'll just customize the layout to get it looking the way I want.
  11. I had no problem installing UltraPics/Lightbox on RC2. It integrates easily with the STS template system if you're interested in that contribution.
  12. sitandspin

    [Contribution] STS v4

    Thanks, this did help! Now I just have to style it and set it up the way I want it. However, I have another question. It may not be STS related, but you seem like a knowledgeable guy and you might know the answer. Is there anyway to link the categories and manufacturers pulldown menus so they work together like a filter? Say someone pulls down the "Software" category in a default osC install, it shows all of the products under "Software." After that, the manufacturers' dropdown is pulled to "Sierra" and it shows just the Sierra products under the "Software" category. Ideally, my setup looks like this. search box | category drop down menu | manufacturer drop down menu I've used the Search Box Anywhere contribution to improve the default search and move it out of an infobox. I've got $catmenu for the drop down and the $manufacturerbox (unboxed like your reply) as the next drop down. So, if a customer wants to quickly browse through categories or manufacturers, the dropdown takes care of that. But if they try to refine their category browsing and limit it by manufacturer, the category resets to all categories. I want it to stay on the selected category to allow further refinement by the manufacturer box. Sorry for the long question! I hope it has a simple answer!
  13. sitandspin

    [Contribution] STS v4

    Thanks for the tip on the product dropdown, but I'm looking for a dynamic manufacturer dropdown that generates the list all on its own, just like the $catmenu.
  14. sitandspin

    [Contribution] STS v4

    Is there a way to create a manufacturers drop down menu like the $catmenu tag? If so, could someone help a php novice with a little coding help. I thought of copying the $catmenu code and replacing every instance of 'categories' with 'manufacturers' but I'm pretty sure that won't work.
  15. I used my brain and fixed the problem. Seems that the installation instructions included with the package omit one very important piece of information. If you have this problem, make sure you add the following line to /admin/includes/database_tables.php define('TABLE_PRODUCTS_XSELL', 'products_xsell'); Yep, that fixed it.
  16. sitandspin

    [Contribution] STS v4

    I just installed it on a fresh copy of RC2, no problems. Make sure you copy all the files included with STS into the right place. Follow the installation instructions for RC1 and you shouldn't have any problems.
  17. sitandspin

    [Contribution] - USPS Methods

    I switched to PayPal IPN 2.3.3 and USPS Methods seems to be working. If anyone has an answer to that question above, I'd still like to hear it!
  18. sitandspin

    [Contribution] - USPS Methods

    I'm having trouble with the contribution and would appreciate any help you can give. I'm using PayPal Express Checkout, and when returning to my site from PayPal, I get the following error: "Fatal error: Cannot instantiate non-existent class: httpclient in /home/endpape/public_html/includes/modules/shipping/usps.php on line 269" I've updated the SQL, reinstalled the module several times, still, no luck!
  19. sitandspin

    [Contribution] Extra Fields

    I haven't found an adequate answer to my question. Maybe someone can help? I want the Extra Fields to show up like this: ITEM NAME - ITEM PRICE EXTRA FIELD ITEM EXTRA FIELD PICTURE EXTRA FIELD ITEM DESCRIPTION I've read through this thread and I can't figure out how to do it. I have everything installed and my fields show up, but they show up on top of everything and skew the layout in a weird way.
  20. This contribution was working fine for me until yesterday. I installed it about a month ago and it worked flawlessly. Unlike many of the contributions I installed during my OsC setup, this one required no debugging/hacking to get it to work right. I completely forgot about it and took Image Magic for granted. Until yesterday, that is, when all of my thumbnails/images became little white boxes that said "Error Database Connection." I contacted my server, asked if they had changed something on their end. No, they said, it's something in your script. I uploaded a backup copy of imagemagic.php. Problem persisted. I switched off the master switch to the Image Magic contribution in admin configuration - my images came back! I switched Image Magic back on, and truly, the contribution lived up to its name and did some more Criss Angel action on my images. Not cool. I thought that maybe all of my image magic files were corrupted. I downloaded a new copy of Image Magic 1.15 and uploaded those files - problem persisted. I read through this thread. Went to phpmyadmin and deleted all references in the configuration tables to Image Magic. I re-ran the SQL file. I turned on Image Magic. I went to my website - "Error Database Connection" on all of my images. What else can I try? I've got the contribution switched off right now to allow the reappearance of my images. I want this contribution to work, but if this persists, I may have to junk it for a more reliable package. Sit and Spin - the Image Magic conundrum
  21. sitandspin


    Has anyone figured out how to use this with Google's geocoder in their API documentation? I'm looking for a nicer way of putting the address into the map.
  22. I just setup and edited all these files as they are described in the contribution, but I don't have the SEO menu in my admin menu. Any ideas why that might be happening?
  23. Yes, thank you for the link! I poked around a little, and it seems that it is not fully implemented in Safari yet. I will use Firefox for WYSIWYG editing until Safari compatibility is 100%.
  24. I installed this contribution, but I can't seem to get it to work in the Safari browser. It works in Firefox, but I prefer to use Safari (Mac) because I know it well. Any ideas on how to make it compatible with Safari? Thanks.