Jump to content

Troyski

Members
  • Content count

    33
  • Joined

  • Last visited

Profile Information

  • Real Name
    Troy
  • Location
    West Midlands - UK
  • Website
  1. Troyski

    [Contribution] Purchase Order V2.3

    Hehe - got it working guys - missed some vital lines :) One question if i may? If i disable the credit account status for a customer (for instance if they have gone overdue on their account) when they go to purchase another item they get the following message: Credit Account Error! You do not have a purchase order credit account with us. Please contact us at 1-800-743-4302 if you wish to open a purchase order credit account. I know i can change the text issued here, but where is it located? - i need to change it to something along the lines of "Please contact us on *********** to update your account" - where the ******* is our telephone number or email address (we're in the UK so the 1-800 ****** number is not relevant) Much appreciated - brilliant contribution - thanks to all those who have worked had on it. Me being a beginner can't work out where the text is located! Cheers in advance :)
  2. Troyski

    [Contribution] Purchase Order V2.3

    Hi Guys, I've installed this contribution and when i go into the admin section for customers, i can edit the customers account, but i get this appearing at the top of the screen: Warning: reset() [function.reset]: Passed variable is not an array or object in C:\wamp\www\oscommerce-2.2ms2-051113\catalog\admin\includes\classes\object_info.php on line 17 Warning: Variable passed to each() is not an array or object in C:\wamp\www\oscommerce-2.2ms2-051113\catalog\admin\includes\classes\object_info.php on line 18 Any ideas as to what is causing this problem? I've had a nose through this contribution forum, but not come across anything. Help please!!
  3. Troyski

    Contrib, 2208 Sitemap 2.2MS2: Question

    Very helpful! Care to share the info?
  4. Hi, Thanks to Larry & Todd last night for their efforts in getting my code corrected - it works a treat! :) Now i have it installed, is there an easy way of defining the text style and size for the boxes in the featured boxes as the particular style i have selected (and like!) show the text much bigger than that of the left column I've had a nose round the files, but i'm at a loss on where to look I thought perhaps it might be in stylesheet.css, but not found anything. Any help much appreciated! Regards Troy
  5. :D OMG OMG OMG!!! You are both STARS!!!!! :) :) :) Thank you Sooooooooo much!!!! I'd have been sat there for weeks and weeks on this guys! / jumping up and down for joy Now i can get adding my catalog!!! So appreciated!!! Brilliant contribution - many thanks to all involved!!:):) :)
  6. Right.... Tried your first change to the code - got the same 1054 error. When i changed the code to your secnd suggestion i get this: 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 ' manufacturers_info mi on p.manufacturers_id = mi.manufacturers_id where p.produ' at line 1 select p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_name, pd.products_description, pd.products_short, p.products_image, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.manufacturer_featured_until, mi.manufacturers_id, mi.languages_id, mi.manufacturers_url from products p, products_description pd left join specials s on pd.products_id = s.products_id left join manufacturers m, manufacturers_info mi on p.manufacturers_id = mi.manufacturers_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = mi.manufacturers_id and mi.languages_id = '1' and m.manufacturer_featured = '1' order by rand() DESC limit 3 [TEP STOP] Looking through the posts to see if there's any further info Much appreciated! By the way, this 1064 error code is appearing on the index page - unlike the post in # 46 If i navigate to any of the categories or select a manufacturer i get the original (?) code error: 1054 - Unknown column 'p.products_id' in 'on clause' SELECT distinct p.products_id, pd.products_name, p.products_image, p.products_tax_class_id, pd.products_description, pd.products_short, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and (p2c.categories_id = '1' OR p2c.categories_id = '4' OR p2c.categories_id = '5' OR p2c.categories_id = '6' OR p2c.categories_id = '7' OR p2c.categories_id = '8' OR p2c.categories_id = '9' OR p2c.categories_id = '16' OR p2c.categories_id = '17') and p.products_status = '1' and p.products_featured = '1' order by rand() DESC limit 6 [TEP STOP] Confused now!!
  7. Hi Todd, I followed the changes in the coding to featured_sets.php as in post 44 but i'm still getting the error. So, i'll try your changes to see if that makes any difference (my thoughts being that perhaps the changes in post 44 were more to my problem - no offence!) All new to me - brilliant piece of coding, just hope i can get it working hehe! Posting my findings in a few mins (if you're still around) Many thanks Troy
  8. Ok Larry, This is what i've done: installed new fresh oscommerce ms2- 05113 with default catalog (dvd's and a couple of pc components) installed the open feature sets (by dragging and replacing the relevent files in each area) Ran the newinstall query through phpadmin Loaded the webpage up - get this error on the front (index page): 1054 - Unknown column 'p.products_id' in 'on clause' select p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_name, pd.products_description, pd.products_short, p.products_image, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.manufacturer_featured_until, mi.manufacturers_id, mi.languages_id, mi.manufacturers_url from products p, products_description pd, manufacturers m, manufacturers_info mi left join specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = mi.manufacturers_id and mi.languages_id = '1' and m.manufacturer_featured = '1' order by rand() DESC limit 3 If i navigate away from the front page to Hardware, this is what i get: 1054 - Unknown column 'p.products_id' in 'on clause' SELECT distinct p.products_id, pd.products_name, p.products_image, p.products_tax_class_id, pd.products_description, pd.products_short, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and (p2c.categories_id = '1' OR p2c.categories_id = '4' OR p2c.categories_id = '5' OR p2c.categories_id = '6' OR p2c.categories_id = '7' OR p2c.categories_id = '8' OR p2c.categories_id = '9' OR p2c.categories_id = '16' OR p2c.categories_id = '17') and p.products_status = '1' and p.products_featured = '1' order by rand() DESC limit 6 [TEP STOP] (with the default oscommerce images such as cdrom drives, graphics cards... etc above the error message) If i do a search by manufacturer "canon" for instance: Let's See What We Have Here There are no products to list in this category. 1054 - Unknown column 'p.products_id' in 'on clause' select c.categories_id, c.categories_image, c.parent_id, c.categories_featured_until, cd.categories_name, p.products_id, p.products_price, p.products_tax_class_id, p.products_image, pd.products_name, pd.products_description, pd.products_short, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from categories c, categories_description cd, products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where c.categories_featured = '1' and cd.language_id = '1' and c.categories_id = cd.categories_id and c.categories_id = p2c.categories_id and cd.categories_id = p2c.categories_id and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' order by rand() DESC limit 6 [TEP STOP] Any ideas? I'll post the relevent coding if you need it I use dreamweaver 8 to edit the code /Frontpage if needed. Many thanks!
  9. Hi Larry, I appreciate the quick response! I don't have winmerge (although i could try it i s'pose!) I've tried both a fresh install of oscommerce and installing both wolfen and the open featured sets (not at the same time obviously lol) but each time i try, i get an error 1054 - - blah blah blah Unfortunately i can't post the code as i've got that fed up with it, i've decided to do a fresh install again (still got my original catalog and backup on a flash drive so i can go back to it if need be) As you've probably gathered, i'm rather new to this, (html no problem, but php and sql are a headache to me) I'll install the open sets feature again on a fresh database, and post the errors i get - if that would help? Appreciate your help! - i've been working towards getting an online site for the last few months (previous attempt was with evolve 4.1 - load of rubbish in my opinion, but i didn't spend the ?600 - it was my boss!! hehe) Thanks in advance :)
  10. Hi there. I've been trying both this contribution and the wolfen contribution - both to no availe. I get either the 1054 error or the one you wre getting. Just out of interest, what arre you using on your system? I use wamp 5 and the oscommerce ms2 latest update Wondering if this is the reason i am getting the errors! I'd really love to incorporate this contribution (my install isn't fresh unfortunately) I have tried with a completely fresh install but still got those errors Confused and got a headache!! :(
  11. Troyski

    Wolfen Featured Sets SUPPORT

    :blink: Hi Steve, I've read through this contribution and i must say it looks wicked - if only i could get it to work I've installed it on a clean oscommerce-2.2ms2-051113 installation, followed the the instructions (i think) but i am getting the dreaded 1054 error Unknown column 'p.products_id' in 'on clause' select p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_name, pd.products_description, pd.products_short, p.products_image, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.manufacturer_featured_until, mi.manufacturers_id, mi.languages_id, mi.manufacturers_url from products p, products_description pd, manufacturers m, manufacturers_info mi left join specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = mi.manufacturers_id and mi.languages_id = '1' and m.manufacturer_featured = '1' order by m.manufacturers_id DESC limit 2 I use wamp 5 on a windows xp box for developing my site, and wondered if the issues were due to my version of sql installed. I've looked at various fixes regarding this error - none of which work Could you point me in the right direction - either where my code is going wrong, or perhaps suggest another means of working with mysql and php - any earlier versions available? Thanks in advance!
  12. Troyski

    Problems with Easy Populate

    Have you split the file as it will only read the first 300 records before it times out. There's an option in easypopulate (2nd option down i think) that will do the job Once you've split the file into manageable chunks, you can import the split files. Hope that helps!
×