RoninS14 Posted February 23, 2008 Share Posted February 23, 2008 My actual problem is that I can't upload using my version of 2.76 EP with QTpro support. I recently switched hosting company and my new host uses php5/mysql5. I've been encountering a lot of problems trying to figure out what will work on php5/mysql5. All of my installed contributions have been giving me errors and warning messages since I switched. So I was trying to figure out what my best course of action would be to get everything back to normal. Quote Link to comment Share on other sites More sharing options...
denseboy Posted February 24, 2008 Share Posted February 24, 2008 I've looked and haven't been able to find a solution to what I think is a pretty basic problem regarding CSV imports and attributes. If I download a CSV file using EP, then change the price of a product option (attribute) and import the CSV back in, everything seems to go fine. I get no errors and the message tells me that the product has been updated. I can even see the new price in the appropriate field on the admin page after the import. When I go to the store however, the old price is still there - no change. This happens with new products as well. On import, everything appears to be fine and I can see all the appropriate fields on the admin page. When I go to the store, the new product is there but no attributes. I think this is the last piece I need to make my 3000+ item store run silky smooth. Can anyone help? Here's what my settings say: EP vers: 2.76f-MS2 r1 Temp Dir: /home/.ruri/lichius/stfrancisdesales.com/newsite/catalog/temp/ Temp Dir is Writable Magic Quotes is: off register_globals is: off Split files on: 300 records Model Num Size: 12 Price with tax: false Calc Precision: 2 Replace quotes: false Field seperator: comma Excel safe output: true Preserve tab/cr/lf: false Category depth: 7 Enable attributes: true SEF Froogle URLS: false More Pics: false Unknown Pics: false HTC: false SPPC: false Extra Fields: false I am using the Option-Type contrib as well. Could that be having an effect? Thanks! I'm not sure exactly how I did it, but I did manage to get this working. For anyone else having the same trouble, I deleted all of the options, option values, and attributes via the admin panel and re-uploaded everything using the CSV file. It didn't work at first but once I started recreating the options on the admin side (being sure to match all the ID numbers with those in my CSV file), subsequent uploads started populating products and options the way I was expecting them to. Eh- I think i just got lucky this time... Quote Link to comment Share on other sites More sharing options...
surfalot Posted February 25, 2008 Share Posted February 25, 2008 Hi, Is there already a solution for the 'move product' issue? I still cannot find Easy Populate very useful when there is no such thing as a 'move product' feature. When I move my product on my sheet Easy Populate will duplicate this product into the new assigned category. if you are using one of my latest versions, you can use a delete status to remove from one cat, then on a second line, or subsequent import, add back the product to the moved-to cat. Quote Link to comment Share on other sites More sharing options...
surfalot Posted February 25, 2008 Share Posted February 25, 2008 Hi could one of you point me to the version of easy populate that will work with ms2.2 rc2a please. I don't see any significant changes in the database, any version that suits your contribution updates should be fine. my latest version seems to be the most stable. Quote Link to comment Share on other sites More sharing options...
surfalot Posted February 25, 2008 Share Posted February 25, 2008 I've installed EP 2.76 sucsessfully, but the exported .csv file is not "tabbed" into columns. What's the problem? v2.76 doesn't have .csv support, you must have meant one of the sub-versions. CSV is Comma Separated Values. No tabs. should open with excel in columns. please see the manual if you would like to change the settings to tab separators. Quote Link to comment Share on other sites More sharing options...
the.nightfly Posted February 26, 2008 Share Posted February 26, 2008 I've installed 2.76, and working the export and import function, BUT when I import data (the changed Pric)e , the message is "Array Updated" but no change in the database !!!!! what's the problem? Quote Link to comment Share on other sites More sharing options...
Guest Posted February 27, 2008 Share Posted February 27, 2008 if you are using one of my latest versions, you can use a delete status to remove from one cat, then on a second line, or subsequent import, add back the product to the moved-to cat. The biggest problem is that the product will get a new ID. That means that Google cannot find the product anymore. When I use the move function that is in osCommerce my SEO will notice that the product is moved and redirects to the correct category. So.. Is it possible to integrate the move function of osCommerce into you're code? Quote Link to comment Share on other sites More sharing options...
rs2k Posted February 28, 2008 Share Posted February 28, 2008 I have been using EP 1.76f for a while now. Since I have added more products to my store I have found a problem. It seems the maximum file size I can download is 146 KB (149,567 bytes). It doesn't matter what options I choose. Every time I try to "download on the fly" I get a file that is 146 KB (149,567 bytes) in size. Any ideas? I get a 404 error if I try to create the file in the temp directory first. Quote Link to comment Share on other sites More sharing options...
surfalot Posted February 29, 2008 Share Posted February 29, 2008 The biggest problem is that the product will get a new ID. That means that Google cannot find the product anymore.When I use the move function that is in osCommerce my SEO will notice that the product is moved and redirects to the correct category. So.. Is it possible to integrate the move function of osCommerce into you're code? I'm sure it is possible with any of the versions. Quote Link to comment Share on other sites More sharing options...
surfalot Posted February 29, 2008 Share Posted February 29, 2008 I have been using EP 1.76f for a while now. Since I have added more products to my store I have found a problem. It seems the maximum file size I can download is 146 KB (149,567 bytes). It doesn't matter what options I choose. Every time I try to "download on the fly" I get a file that is 146 KB (149,567 bytes) in size. Any ideas? I get a 404 error if I try to create the file in the temp directory first. ask you host about a time limit on your web space for PHP scripts. you may be able to circumvent that with this code near the top of the easypopulate file: // set_time_limit(330); change it to set_time_limit(0); for future help, please see the Support section of the EP manual that came with that version on how to ask for help. If you can't provide that information, I can't help much. Quote Link to comment Share on other sites More sharing options...
Guest Posted February 29, 2008 Share Posted February 29, 2008 (edited) I'm sure it is possible with any of the versions. Ok.. added to the Feature list? (I am not that good in programming PHP) :thumbsup: Edited February 29, 2008 by grijo Quote Link to comment Share on other sites More sharing options...
rs2k Posted February 29, 2008 Share Posted February 29, 2008 ask you host about a time limit on your web space for PHP scripts. you may be able to circumvent that with this code near the top of the easypopulate file: // set_time_limit(330); change it to set_time_limit(0); for future help, please see the Support section of the EP manual that came with that version on how to ask for help. If you can't provide that information, I can't help much. I have uncommented the line and have also tried I tried setting it to 3300. MY server is not in PHP safe mode. I also tried changing the php.ini file to 3300. I also tried increasing the memory from 32M to 64M using php.ini. Besides, it only takes about 3 seconds to reach 149KB, not 330 seconds or even 3300 seconds. I also noticed that the error only occurs on my sub domain. For example, when I go to newstore.mysite.com/admin/easypopulate.php I can only download 149kb. When I go to mysite.com/easypopulate.php I can download at least 700K. I can probably do more than 700K but as it is a live store I can't test that theory. Quote Link to comment Share on other sites More sharing options...
the.nightfly Posted February 29, 2008 Share Posted February 29, 2008 I've installed 2.76, and working the export and import function, BUT when I import data (the changed Pric)e , the message is "Array Updated" but no change in the database !!!!! what's the problem? nobody? PLS! Quote Link to comment Share on other sites More sharing options...
djkubus Posted February 29, 2008 Share Posted February 29, 2008 <_< Im puzzled an need help.. 1st want to say that i love the contrib :thumbsup: the problem that im having is that when i import using EP_v2_76e about the second category is starts to make the category over and over... example I have a category called "appliance" and withing that category i have 2 more "appliance 2" and "appliance 3" but when i import i creates like 70 of "appliance" categories and it places a product in each one. All my products have a unique product number i even tried using tab vs CSV and it does the came thing. Another problem that i have is that the icons in the sub menus that usually apear on top disappear on most of the subcategories. Im using im using OSC 2.2RC2a Thanx in advance for help Quote Link to comment Share on other sites More sharing options...
surfalot Posted March 1, 2008 Share Posted March 1, 2008 nobody? PLS! you might want to look at the forum rules.... Bumping postings to the top of the forum channel listing, made to get more attention to the post, is not allowed. When no one has replied to a posting you have made it is recommended to reply in the same thread with more information that may help in resolving the issue. You might also look at the EP manual's support section about "how to ask for help" since I suspect you are using one of the version I added that section to. I don't think you have even given the full version number of the version you are using, as I elluded to in a reply to your other post at the bottom of the last page. And, as I suggested to rs2k above... for future help, please see the Support section of the EP manual that came with that version on how to ask for help. If you can't provide that information, I can't help much. How's that for a reply? ;) Quote Link to comment Share on other sites More sharing options...
surfalot Posted March 1, 2008 Share Posted March 1, 2008 <_< Im puzzled an need help.. 1st want to say that i love the contrib :thumbsup: the problem that im having is that when i import using EP_v2_76e about the second category is starts to make the category over and over... example I have a category called "appliance" and withing that category i have 2 more "appliance 2" and "appliance 3" but when i import i creates like 70 of "appliance" categories and it places a product in each one. All my products have a unique product number i even tried using tab vs CSV and it does the came thing. Another problem that i have is that the icons in the sub menus that usually apear on top disappear on most of the subcategories. Im using im using OSC 2.2RC2a Thanx in advance for help welcome to the osC forums! post a link to a segment of your upload file. don't just paste the data into a post. you should try the latest version I have uploaded. the images issue may be a bug that was fixed. Quote Link to comment Share on other sites More sharing options...
rs2k Posted March 1, 2008 Share Posted March 1, 2008 (edited) And, as I suggested to rs2k above... for future help, please see the Support section of the EP manual that came with that version on how to ask for help. If you can't provide that information, I can't help much. How's that for a reply? ;) readme.txt III. SUPPORT ------------------------------------------------- See the /docs/EasyPopulate_Manual.txt file for the support location. EasyPopulate_Manual.txt Remember that this was written by volunteers, if you have questions, post in the forums, don't email any of the authors involved, since they may not be supporting the script any longer! Lives change and people contribute and move on :) Before you ask a question in the support thread, please, please, read the entire docs AND at least the last 4-5 pages of the support thread. Then, search the the thread for your answer. If you don't understand what a setting is or does, please ask. Only after that, should you ask for help with an error or problem USING this contribution. If it isn't obvious you have exhausted all resources to find a solution, you may not get an answer. (please make a little effort) Support for this release is provided in this thread: http://www.oscommerce.com/forums/index.php?showtopic=162244 Am I missing something here? I have completed all of these steps listed in the code boxes above. I have read a lot more than the last 4-5 pages and have tried at least 20 different search strings. In fact, I was able to learn so much about easy populate while trying to fix it that I was able to modify it to add 5 other fields to my database. (Both the original code and my modified one have the same problem.) What other information would you like me to provide? I am happy to help you help me. Thanks. Edited March 1, 2008 by rs2k Quote Link to comment Share on other sites More sharing options...
djkubus Posted March 1, 2008 Share Posted March 1, 2008 welcome to the osC forums! post a link to a segment of your upload file. don't just paste the data into a post. you should try the latest version I have uploaded. the images issue may be a bug that was fixed. Thanx for the reply here is the link to the csv file http://www.globecomtechnologiesinc.com/csv.csv the latest version i found is Easy Populate 2.76f-MS2 (with attributes) r1 is this correct?? if so i have upgraded from 76e and im still having the same problem with the images and the importing. Only changes i have made to EP.php is model to 18 from 12 (changed in mysql table as well) and sub cat to 3 from 7. thanx again :rolleyes: Quote Link to comment Share on other sites More sharing options...
PJ2006 Posted March 2, 2008 Share Posted March 2, 2008 I have installed this and can download the csv no problem but when I try to upload it and select insert into db - nothing happens, I get no messages and any changes do not occur. I have spent a few days reading through the 300+ pages on this support thread but I'm just getting increasingly confused. Quote Link to comment Share on other sites More sharing options...
PJ2006 Posted March 2, 2008 Share Posted March 2, 2008 I have installed this and can download the csv no problem but when I try to upload it and select insert into db - nothing happens, I get no messages and any changes do not occur. I have spent a few days reading through the 300+ pages on this support thread but I'm just getting increasingly confused. I've had my hosting company track the error logs and this is what they get: [sun Mar 2 17:55:27 2008] [error] [client 74.6.28.18] mod_security: Access denied with redirect to [/]. Pattern match "<(.|\\\\n)+>" at REQUEST_URI [id "XSS_Check"] [severity "EMERGENCY"] [hostname "www.skatevid.net "] [uri "/upload/uu_finished.php?tmp_sid=599044c507e118dca00c8c620a8d91e3&temp_dir=<marquee><h1><hr><i><u>pwnd</u></i><br>by<br>agentsteal<h3><hr><img><hr><input%20value=pwnd_by_agentsteal><hr><select><option>pwnd<option>by<option>agentsteal</select><hr><iframe%20src="] But this references a site which is not even mine! - www.skatevid.net Any ideas? Quote Link to comment Share on other sites More sharing options...
surfalot Posted March 3, 2008 Share Posted March 3, 2008 Am I missing something here? I have completed all of these steps listed in the code boxes above. I have read a lot more than the last 4-5 pages and have tried at least 20 different search strings. In fact, I was able to learn so much about easy populate while trying to fix it that I was able to modify it to add 5 other fields to my database. (Both the original code and my modified one have the same problem.) What other information would you like me to provide? I am happy to help you help me. I congratulate you for doing the reading! :thumbsup: What I am trying to point out is that section called "how to ask for help" that you have conveniently clipped from your post. I had to download the v2.76f again just to make sure its not just me going loosing my mind. :blink: Obviously since you have a download problem, #4 can be omitted. Maybe you can help me. What would make that section clearer? Clearly its not clear since 1 in 1000 actually follows through. :blush: As if I'm psychic and I know how everyone has there server and settings setup !! :lol: At the moment I can't come up with any scenario in which the problem you are reported would develop, which of course it the main reason you didn't get a further reply. If it only happens on your subdomains, you should be talking to your host about apache/php restrictions that may be causing this. That is, if it works in one place, but not another, on the same host with the same data, I'd be talking with the host. Quote Link to comment Share on other sites More sharing options...
surfalot Posted March 3, 2008 Share Posted March 3, 2008 Thanx for the reply here is the link to the csv file http://www.globecomtechnologiesinc.com/csv.csv the latest version i found is Easy Populate 2.76f-MS2 (with attributes) r1 is this correct?? if so i have upgraded from 76e and im still having the same problem with the images and the importing. Only changes i have made to EP.php is model to 18 from 12 (changed in mysql table as well) and sub cat to 3 from 7. thanx again :rolleyes: What I see when I try to import this is that you are using really long category names. Only the long names are being duplicated when I try the import. The reason is that the default osC shop has a limit of 32 chars for cat names. So if a cat name is truncated when it is created, then any subsequent import for that cat won't be found since the database now contains a truncated cat name. You should be able to fix this by increasing the length of the categories_name field of the categories_description table of your database. Quote Link to comment Share on other sites More sharing options...
surfalot Posted March 3, 2008 Share Posted March 3, 2008 I've had my hosting company track the error logs and this is what they get: [sun Mar 2 17:55:27 2008] [error] [client 74.6.28.18] mod_security: Access denied with redirect to [/]. Pattern match "<(.|\\\\n)+>" at REQUEST_URI [id "XSS_Check"] [severity "EMERGENCY"] [hostname "www.skatevid.net "] [uri "/upload/uu_finished.php?tmp_sid=599044c507e118dca00c8c620a8d91e3&temp_dir=<marquee><h1><hr><i><u>pwnd</u></i><br>by<br>agentsteal<h3><hr><img><hr><input%20value=pwnd_by_agentsteal><hr><select><option>pwnd<option>by<option>agentsteal</select><hr><iframe%20src="] But this references a site which is not even mine! - www.skatevid.net Any ideas? good call to have your host track the error. If in fact that error is referring to the upload, they should have been able to tell you it is a problem with their mod_security rules. The only way to rectify this is to ask your host to make an exception for easypopulate.php script in their mod_security rules. promise them that this script is safely behind a login/password in your admin and would never be abused from public exposure. you can circumvent this problem by uploading your import to your temp folder via FTP and doing the "Import EP file from Temp Dir". If it works this way, the problem is definitely the error you've posted and only your host can fix it by setting an exception for the EP script file. Quote Link to comment Share on other sites More sharing options...
surfalot Posted March 3, 2008 Share Posted March 3, 2008 Another problem that i have is that the icons in the sub menus that usually apear on top disappear on most of the subcategories. define "most". specifically which? (in reference to the import file you posted) Quote Link to comment Share on other sites More sharing options...
djkubus Posted March 4, 2008 Share Posted March 4, 2008 What I see when I try to import this is that you are using really long category names. Only the long names are being duplicated when I try the import. The reason is that the default osC shop has a limit of 32 chars for cat names. So if a cat name is truncated when it is created, then any subsequent import for that cat won't be found since the database now contains a truncated cat name. You should be able to fix this by increasing the length of the categories_name field of the categories_description table of your database. Thanx I will try that.. In the meantime i just downloaded the .sql file and imported the data to the tables manualy and yes i did notice the 32 character limit and I have changed it. next time i need to update iwl use the EP app again and see what happens but anyhow my 10074 product store is finally up and running. As far as the immage thing i think its a problem with OSC in general cause even after i imported the data to the tables manually im having the same symptoms but thats not that important to me. Anyhow thanx a lot for your time and help :thumbsup: Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.