Jump to content

UniqueDesign

Members
  • Content count

    36
  • Joined

  • Last visited

  1. UniqueDesign

    QBI Quickbooks Import

    Yeah. The latest patch changed the way that attributes were being handled. It is a nightmare getting everything running with CRE esp. since they are releasing a new patch so often. It seems to almost be under control though. I assume if I just add that line it may not pull the attributes properly but I will soon find out. Thanks for breaking it down for me :)
  2. UniqueDesign

    QBI Quickbooks Import

    1054 - Unknown column 'po2.products_options_name' in 'field list' SELECT po2.products_options_name AS products_options_name_po2, po2.products_options_id AS products_options_id_po2 FROM products_options As po1, products_options As po2 WHERE po1.products_options_name='Fitment' AND po1.products_options_id=po2.products_options_id AND po2.language_id='1' [TEP STOP] Adam, any idea of what it is complaining about now? Also, if its a quick thing, could you explain how you figure out what it is complaining about? Thanks!
  3. UniqueDesign

    QBI Quickbooks Import

    Im excited! Thanks Adam. Don't mean to jump the gun but will this new QB require a full uninstall or is it more of a patch? TIA.
  4. UniqueDesign

    QBI Quickbooks Import

    Yep it does work with the others. I am running PHP Version 5.0.4. Register Globals is On the master and the local value. :D
  5. UniqueDesign

    QBI Quickbooks Import

    ^ Thanks for the reply Adam. I am pretty sure I have had this issue before the patch but I to be honest I didn't really use it too much b/c I was getting everything else setup. I also merged the patch with my existing files with Beyond Compare and anything with the QBI Contrib code merged over into the new files so I think it should be acting similar to how it was before the patch. When you click the "All Customers" it seems like it is going to load a page b/c the status bar on the browser goes through its normal process but then nothing happens- No popup to dl. I also didn't see any errors in the server log. Thanks again!
  6. UniqueDesign

    QBI Quickbooks Import

    Hey Adam, Thanks for the info. I am not sure why the line got deleted from the table but I readded a language_id line in the product_options table. I set the default to "1" and I was able to get the products successful. However, I just noticed that when I click to download the "All Customers" I doesn't seem to do anything. I thought this was maybe part of the above problem but it now it seems different. Any ideas on why the customer download is not doing anything when clicked? Also, the patch I installed was for CRE Loaded and it was patch 03. Thanks again for the help and the simple fix.
  7. UniqueDesign

    QBI Quickbooks Import

    Hey Adam, I had this installed fine but after installing a patch I am getting this error when trying to download the product files: 1054 - Unknown column 'po.language_id' in 'where clause' SELECT * FROM products_attributes AS pa, products_options AS po, products_options_values AS pov WHERE pa.products_id='57' AND pa.options_id=5 AND pa.options_id=po.products_options_id AND pa.options_values_id=pov.products_options_values_id AND pov.language_id='1' AND po.language_id='1' ORDER BY options_values_id [TEP STOP] I assumed this error is being thrown b/c po.language_id is not in the qbi_engine_prod file but haven't been able to get it working. Any ideas?
  8. UniqueDesign

    Multi_Vendor_Shipping new thread

    Hey Craig, Will this contrib work if you want to have a setup shipping rate instead of calculated for UPS and Fedex? We have some products that would need to be calculated but others that are just set shipping. I installed the Individual Multiple Shipping contrib but it doesnt seem to calculate into the shopping cart correctly. Thanks let me know. Also, how much do you charge to install the contrib?
  9. UniqueDesign

    Multi_Vendor_Shipping new thread

    Hey Jim, Has this been tested to work on CRE or the like of moddified version of OsCommerce? If not and you would like to get that going, I will be willing to help out. Thanks.
  10. UniqueDesign

    Easy Populate & Products Attributes

    haha. doesnt seem like anyone is going to get helped b/c everyone else is bumping over them... o well... ive given up
  11. UniqueDesign

    Easy Populate & Products Attributes

    ----------------------------------------------------------------------- Well I see everyone else asking questions after this and I keep getting skipped. :( Any help would be great. :thumbsup:
  12. UniqueDesign

    Easy Populate & Products Attributes

    I dont mean to Bump but Im not sure if you saw this which was right above the last question you answered. Any help would be great!
  13. UniqueDesign

    Easy Populate & Products Attributes

    ok so I have decided to use this contrib. to backup my product database so i can uninstall and reinstall a fresh preedited copy of Os 2.2. My questions: 1. In the admin section under catalog I see "Utility Import Export." I click this and get this " Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, webmaster@uniqueeurodesign.com and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request" What can I do to get this resolved and get my new database done and is this an alright way to do this? PS. Woudl the Admin Access contrib effect this? Sry. if this has been answered but I tried seraching and read alot of this super long thread.
  14. UniqueDesign

    QBI Quickbooks Import

    Thanks for the reply. When I type that in I get a page not responding error. I didnt need to run these sql files through PhpMyAdmin right? I really have no idea what is wrong b/c I felt I did everything correct and multiple times at that. :dunno: thanks for the help though :)
  15. UniqueDesign

    Basic Design Pack Support

    Hi Nick, After installing those replacement pictures I seem to get a red x for the notification icon. I confirmed that there is indeed an image account_notifications.gif. Also, I am not sure if this is related but when you click on the little arrow that is next to the text "Notifications" I receive an error. This happens when both logged in as a member and when not logged in. Im not sure if this is relevant but it seems to try to access the page via my shared ssl b/c this is what was in the address bar: https://mysharedsslip/myusername/FILENAME_P...ea8eef080cbe596. Any ideas? TIA.
×