Latest News: (loading..)


  • Content count

  • Joined

  • Last visited


About toasty

  • Birthday 01/01/1908

Profile Information

  1. Hi - just passing through! The line identified (underlined) above is returning an empty list [this is shown as: IN (,) in your error]. I'm guessing MySQL does'nt like it. I have not looked at this extension to ASP so cannot help further - suggest contacting the author of that piece OR revert to an earlier version of ASP that works. cheers Chris. ps: or - another guess - is your database empty? Maybe it works when you have data (products and attributes) in it and the author of the extension did not account for it being empty?. Just a thought! Good luck.
  2. Hi FOR THE ADVENTUROUS IN NEED OF AN EASY STOCK LOAD SOLUTION: If you have some understanding of php you may be able to do this yourself. If not this reminder (I have posted this previously - over a year ago) may help. On this link you will find the rudimentary code I used to achieve what you are asking for. It is a bit of a hack but it worked extremely well for me. I effectively had a 1-Click stock loading system from my PC and never had one problem with it. It holds the advantage that if you need to do any updates, any system wide changes or if any glitches occur you can reload the system in one go and always be sure it is all correct. i.e. all the combined advantages of EP and ASP in one. Personally I think controlling 200o products from the Osc admin acapability must be a nightmare. Essentially this code uses the Easy Populate contribution (an old version) and imports a spreadsheet of your entire stock with attributes and sets. There is also some advice on how to implement a rudimentary filter if you wanted to import only a category (for example). The spreadsheet to use can be found by installing the EP contrib and exporting your current database of products.. The logic is not that difficult to comprehend if you have idea about this sort of thing. Here is the link: asp screenshots + Increase Size and EP Extensions (look for the easy_populate_Xtra.txt link at the bottom, but do read all the notes above.) cheers Chris (Author of re-engineered ASP many moons ago!)
  3. ASP does not 'require' alteration the Core catalog code [there is an optional sort for catalog] and the manner of implementing the Admin code has not proven to conflict with any other package, provided the 'other' package behaves! ASP does not alter any core database tables. So....I don't the answer but considering osC's 'module unfriendly' architecture ASP is well behaved! We have had no reports of conflicts caused by ASP so far. cheers Chris.
  4. Will Hope you are making good progress. Copy and paste the SQL code into the 'SQL' text box (on the SQL tab) in phpmyadmin (or use the Browse button to load the file from your client) and click Go. Check by looking at the list of tables in your database. If you have the required tables then as we say in England 'Bob's your Uncle'....(if your not English then don't ask!) cheers Chris.
  5. Hi futura I have answered below as best I can. My comments start ==> The idea is to have an album for sale as one item but also if needed to have all the individual tracks available for purchase individually if required. A great example of this in practice is located at this store From what I can see of the standard OS commerce attributes settings, it is more geared up to things such as 'Colour' or 'Size' that would share similarities across multiple products. In this case I need effectively a 'Sub Product' option where by the sub product is a part of the main product and can be purchased individually if required. Please can you tell me if your contribution would allow me to achieve this goal? ==> You imply yours does not have similarity across different products but it does. EG: You have one attribute: <Tracks> Attibutes options are <name of track1>, <name of track 2>, <name of track 3>. Is this the best way of doing it - not sure - have to research a bit to conclude that. Using standard osC and ASP you would be able to crate something like: ...where Lens Choice = your Tracks and the drop list = your track titles with prices. You could display them as radio buttons (option types contribution) in a list (instead of the drop list). As a workaround you could make the master product zero priced and then have the first option as Whole Album - just a thought.... I think there is some sort of contribution out there already to support sub-products - worth a look at the contributions section ==> If you have any number of products I would HIGHLY recommend a stock control system outside osC (excel and easypopulate are a good place to start)as you have a lot of unique data with your requirements. I used a system like this to create my products with all attributes and options in a Master Catalog set in Excel and then it took a couple of minutes to shoot the whole lot into osC whenever I made any changes. Also this may be a bit off topic but I love the way the tables of products are drawn out on the shop I mentioned do you know how this can be achieved as I think this makes the look of this shop very different to the usual Shopping Cart style designs I see. ==> Yes it can be achieved but I would have to take a little time to actually work out the easiest way for you (which I don't have! - I have to focus on fee payers to feed the kids - sorry!) If you have no display type contributions you could look for one - or if you are hands on php,html,css it's done fairly easily in product_info.php hope that helps a little - good luck! regards Chris.
  6. Another quick note for those seeking support - I have just realised why I was not getting emails about your posts (I think). It looks like the board 'unsubscribes' me if the support thread gets no posts for 30 we must have a really quiet summer!....and the code must be working!! regards to all, Chris.
  7. For anyone still looking for screen shots of ASP there is a permanent example available here with explanation. If the link below disappears for any reason then google 'linkmatics asp' and you will find it! The page will provide you with: 1. Example screenshots of ASP 2. Code replacement to support editing of existing attributes sets (unsupported but I hear it works!) 3. Code to integrate ASP with Easy Populate (unsupported, and an older version of easypopulate, but those in the know will get the gist!) Note: Support for this contribution is via the oscommerce forum only, this link is provided as a courtesy only and the code offered comes without any warranty whatsoever. Use at your own risk (as always!).
  8. I'm only guessing but it looks like you haven't put all the contribution code in correctly. Looks like you need to define the table names - go check the install instructions on step 5 regarding database_tables.php cheers Chris.
  9. Thanks Heather - it's nice to be appreciated sometimes! I do hope it saves you some time. Have you tried easy populate with excel spreadsheets for your stock control - you can work wonders - it's a world away from struggling with the standard osc code. Enjoy!
  10. Well this is a new one. I have a hunch it is to do with your process for adding the products - it is highly unlikely that it is anything to do with ASP. Is the tax class set up correctly on the product? The only pricing involvement from ASP is to include the 'attributes' price (if required) - the core product information (ie Tax) is not effected by ASP. regards Chris.
  11. Attributes Sets Plus Support Announcement It is two and a half years since I launched ASP and I believe all issues that will arise have already arisen and been dealt with somewhere in this thread. It is now time for me to back off and withdraw from supporting this contribution. I will still be available for contact and I may pop in now and again but it will be on the back burner. Enjoy ASP and if anyone would like offer their ongoing support for this contribution please go ahead. my best to all Chris. :thumbsup:
  12. Hi Sorry for delay - I don't keep up with this as much as I used too (as most issues are coverred now!). I have option type feature working with ASP (it's great by the way - recommend to everyone!); however I seem to remember (this is going back 2 or 3 years!) I did have some issues similar to your description and had to jig the code a little. I cannot see how ASP would effect OTF though, as ASP does not change any standard code in the catalog at all (apart from a little display work that is optional anyway and effects nothing else) and certainly changes nothing in the checkout process. If you let me know which file is giving you the issue (provide url) maybe I can provide something for you to compare if that helps - but my code may have custom changes (although normally commented). cheers Chris.
  13. Hmmmm.....don't expect premium support, my time in here is out of the goodness of my heart - praise accepted and cheques too! As for your question you have a table definition missing, which is nothing to do with this contribution. Have you installed another contrib? You need to define this table constant (TABLE_PAGES) in one of your files. FYI: This table is not part of standard osC (as far as I can see), but if this is RC1 I don't now either way. One thing is for sure - its nothing to do with ASP. Good luck Chris.
  14. Hi Dave This query was never overly optimised for performance (because the shop it was designed for was small)- it could be as simple as an indexing issue. Firstly check that the tables (in the troublesome queries) all have indexes as per original install. If you are not SQL savvy then the quick fix is to do without the Sort (which is all the ASP code in product_info.php provides). My advice would be to replace it with the original osC code and see how that fares. If nothing else it will identify the actual ASP SQL scripting as the issue. The original osC code orders by the id, ie. the order you added to the DB (if I remember correctly). The alternative, if sorting is required, is to ask someone with SQL skills to look more closely at the query and the tables indexes. If you have a very large database then it may be that the query needs shortening by a slight table redesign. I'm afraid this goes beyond my free support due to time required. This is all assuming you do not have a corrupt table or DB of course. You can check this by running mysql check tables commands (see mysql manual!) - suggest you check the db rather than just the tables for ASP. You are the first to identify an issue so perhaps it is a local issue or you are doing something unusual? Maybe some of that will help....or not! PLease do report back with findings/thoughts. cheers Chris.
  15. Hi Darkman69' How about Lightman - sounds less dodgy! 1. I can add more atributes to a SET, if i have to do it, i DO have to create a new set, :( Please see this page for supplemental support information about this issue: 2. The sort order doesn't work for me ether ... does anyone have a solution for it ? See my above response. No change I'm afraid.