Guest Posted January 28, 2004 Share Posted January 28, 2004 Thanks for help so far...Im moving along. I emptied my store and have access to my EP admin page. I feel like I should introduce a file to EP page...where it says upload.. what is my target file here, I mean, which file am I supposed to edit and upload. Thanks! Link to comment Share on other sites More sharing options...
Guest Posted January 28, 2004 Share Posted January 28, 2004 why not do it the opposite way first, and enter a product manually, then go into the admin section, and dodwnload the easy populate file. this way you can look at what is necessary for uploading. Link to comment Share on other sites More sharing options...
Guest Posted January 28, 2004 Share Posted January 28, 2004 Eggsellent Idea! :unsure: Link to comment Share on other sites More sharing options...
Guest Posted January 28, 2004 Share Posted January 28, 2004 I see what you mean...about reverse method say...any idea what this is saying when I edited and tried to upload? 1054 - Unknown column 'p.products_master' in 'field list' Thanks Link to comment Share on other sites More sharing options...
peterr Posted January 29, 2004 Share Posted January 29, 2004 Hi, 1054 - Unknown column 'p.products_master' in 'field list' Yes, I was just testing the latest version of EP, and got the same message, in quite a few of the functions that I tried. There is no column in the products table called "products_master" Peter Link to comment Share on other sites More sharing options...
peterr Posted January 29, 2004 Share Posted January 29, 2004 Hi, Oops, I should have read _all_ of the details on the Easy Populate downloads at http://www.oscommerce.com/community/contributions,500 The very latest release: 01/20/2004 - Easypopulate v2.73-MS2/MASTER PRODUCT SUPPORT Author: Erik Chumley Contains 1file only (easypopulate.php) please download the previous version for the full install & read me. Easypopulate v2.73-MS2/MASTER PRODUCT SUPPORT allows you to set all your master product variables using easypopulate MUST HAVE MASTER PRODUCTS INSTALLED Simply replace easypopulate.php with this one. BACK UP YOURFILES I unzipped version v2.73-MS2, then replaced the file easypopulate.php, just as the above quote states, but didn't comprehend this part Easypopulate v2.73-MS2/MASTER PRODUCT SUPPORT allows you to set all your master product variables using easypopulate MUST HAVE MASTER PRODUCTS INSTALLED I don't have 'Master products' installed, hence the message, so next time maybe I'll read ALL the details. :D Peter Link to comment Share on other sites More sharing options...
Guest Posted January 29, 2004 Share Posted January 29, 2004 Ditto Ditto Same Prob, still...same error message... Did EP update...but still 1054 - Unknown column 'p.products_master' in 'field list' what am I missing... did you ever get your own products to upload via the txt upload? or do you still get 1054 - Unknown column 'p.products_master' in 'field list' tha tha tha thanks! Link to comment Share on other sites More sharing options...
Guest Posted January 29, 2004 Share Posted January 29, 2004 list all the steps you did to install. list all the sql queries you 'ran' against the database while doing the install (put the actual queries here). or you can search your sql queries for products_master . .. Link to comment Share on other sites More sharing options...
Guest Posted January 29, 2004 Share Posted January 29, 2004 Hi. Im a newbie to osCommerce and im helping out a friend to open a webstore, but im getting the same problem as above, i downloaded the 2 latest files and i did exactly what it told me to do. So whats the MASTER PRODUCTS ? What have i missed ? I have not run any sql files to update the tabel so im thinking that i have forgot some file but there is no sql file included in the 2.73 rls. What is the MASTER PRODUCTS INSTALLED, some addon or something within osCommerce ? Link to comment Share on other sites More sharing options...
Guest Posted January 29, 2004 Share Posted January 29, 2004 Yes, Master Products is add on You can download from contributions section of osCommnunity Link to comment Share on other sites More sharing options...
Guest Posted January 29, 2004 Share Posted January 29, 2004 the instructions for installation show you exactly what you need to do Link to comment Share on other sites More sharing options...
peterr Posted January 29, 2004 Share Posted January 29, 2004 Hi davinci & madTrax, 1. If you have "Master Products" installed, then you will need http://oscommerce.sunsite.dk/contributions/EP_v2_73_MS2.zip plus http://oscommerce.sunsite.dk/contributions...terproducts.zip overwrite the file "easypopulate.php" from easypopulate4masterproducts.zip 2. If you do NOT have "Master products" installed, you only need http://oscommerce.sunsite.dk/contributions/EP_v2_73_MS2.zip .... otherwise, you will get the error message. Peter Link to comment Share on other sites More sharing options...
Guest Posted January 31, 2004 Share Posted January 31, 2004 Thanks Peter got rid of the error message... now if i can just get my pop up to display..the "larger" image, instead of displaying the same picture in the thumbnail...you know... waaaah! waaaah! Link to comment Share on other sites More sharing options...
peterr Posted January 31, 2004 Share Posted January 31, 2004 Hi, now if i can just get my pop up to display..the "larger" image, instead of displaying the same picture in the thumbnail...you know... If I'm at http://www.yourwebsite/catalog/product_inf...&products_id=59 , the image size is 100 x 80, then when I either click the link to 'enlarge', or click on the image, the popup size is 500 x 383 Isn't that the larger picture ? I've probably misunderstood what you meant though. :) Peter Link to comment Share on other sites More sharing options...
Guest Posted January 31, 2004 Share Posted January 31, 2004 Thanks... Yeah...the large will pop up...but my concern is that the thumb is not really a small image. it looks small I have to admit...lol but i believe its just skwoze into the small frame..see...in other words...i believe 53K is in that little frame. at least when I view properties of thumb...it says 53K a 53K thumb? ive tried dumping my cache...etc...still same. that no good! it appears that you have 2 pictures for your sources... thumb.jpg enlargment.jpg but sounds like you're saying...the one large file got shrunk and created the small thumb...you said "how'd they do that" Link to comment Share on other sites More sharing options...
ADK Posted January 31, 2004 Share Posted January 31, 2004 I cant get it too work either. To download file it?s no probel but when I try to uppload it I got this error: Warning: move_uploaded_file(/home/mysite/public_html/estore/catalog//catalog/temp/EP2004Jan31-1212.txt): failed to open stream: No such file or directory in /home/mysite/public_html/estore/catalog/admin/easypopulate_functions.php on line 32 Warning: move_uploaded_file(/home/mysite/public_html/estore/catalog//catalog/temp/EP2004Jan31-1212.txt): failed to open stream: No such file or directory in /home/mysite/public_html/estore/catalog/admin/easypopulate_functions.php on line 32 Warning: move_uploaded_file(): Unable to move '/tmp/phpDljkwx' to '/home/mysite/public_html/estore/catalog//catalog/temp/EP2004Jan31-1212.txt' in /home/mysite/public_html/estore/catalog/admin/easypopulate_functions.php on line 32 File uploaded. Temporary filename: /tmp/phpDljkwx User filename: EP2004Jan31-1212.txt Size: 12103 Warning: file(/home/mysite/public_html/estore/catalog//catalog/temp/EP2004Jan31-1212.txt): failed to open stream: No such file or directory in /home/mysite/public_html/estore/catalog/admin/easypopulate.php on line 651 Warning: Invalid argument supplied for foreach() in /home/mysite/public_html/estore/catalog/admin/easypopulate.php on line 674 Link to comment Share on other sites More sharing options...
peterr Posted February 1, 2004 Share Posted February 1, 2004 Hi, Yeah...the large will pop up...but my concern is that the thumb is not really a small image. it looks small I have to admit...lol but i believe its just skwoze into the small frame..see...in other words...i believe 53K is in that little frame. at least when I view properties of thumb...it says 53K a 53K thumb? ive tried dumping my cache...etc...still same. that no good! it appears that you have 2 pictures for your sources... thumb.jpg enlargment.jpg but sounds like you're saying...the one large file got shrunk and created the small thumb...you said "how'd they do that" Well, the one I was using as an example has been deleted (no product info), so this makes it a bit hard to help if the goal posts keep gettting shifted. :D Anyway, the page I'm looking at is http://www.davincisvise.com/catalog/produc...&products_id=67 View the image properties, for that _small_ image, and it is only 2083 bytes, the dimensions are 57 x 80. View the source code that does this ............ <script language="javascript"><!-- document.write('<a href="javascript:popupWindow(\'http://www.davincisvise.com/catalog/popup_image.php?pID=67\')"><img src="images/imagecache/AUCDBP_large.jpg" border="0" alt="AUCDBP" title=" AUCDBP " width="57" height="80" hspace="5" vspace="5"><br>Click to enlarge</a>'); //--></script> <noscript> <a href="http://www.davincisvise.com/catalog/images/AUCDBP_large.jpg" target="_blank"><img src="images/imagecache/AUCDBP_large.jpg" border="0" alt="AUCDBP" title=" AUCDBP " width="57" height="80" hspace="5" vspace="5"><br>Click to enlarge</a></noscript> Notice the image source is "<img src="images/imagecache/AUCDBP_large.jpg" , and not the (usual) image path, ......... that's how they do it. :) The real size of the image is 59.182 bytes, but it is resized, as a thumbnail, because you would have specified 57 x 80 in the admin configuration. When you either click on the link "Click to enlarge", or click on the actual (small/thumbnail) image, then a Javascript function is run, called "popupWindow", which is at the top of the source code ............. <script language="javascript"><!-- function popupWindow(url) { window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res izable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,le ft=150') } //--></script> ...... and the image is it's natural (large) size. Hope that has explained it. Peter Link to comment Share on other sites More sharing options...
zip1 Posted February 1, 2004 Share Posted February 1, 2004 Warning: move_uploaded_file(/home/mysite/public_html/estore/catalog//catalog/temp/EP2004Jan31-1212.txt) /catalog//catalog/temp is your problem At the top of the easypopulate file you need to edit the temp file location $tempdir = "temp/"; $tempdir2 = "temp/"; these have been changed to match ms2 Tom Link to comment Share on other sites More sharing options...
ADK Posted February 1, 2004 Share Posted February 1, 2004 THX Now it works but all out of stock ithem ar markt "inactive" it would bee better to hide the "BUY NOW" button. Link to comment Share on other sites More sharing options...
Guest Posted February 6, 2004 Share Posted February 6, 2004 Why not go a step further...and where quantites are zero...I dont think they will even show up on product page. I think its self leveling Link to comment Share on other sites More sharing options...
charleyshipman Posted February 6, 2004 Share Posted February 6, 2004 This has been a very helpful thread. I now have easy populate working in both directions. Thanks! Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.