Mark-UK Posted May 9, 2005 Share Posted May 9, 2005 what sql is used when you search for a product in your oscommerce admin please. Quote Link to comment Share on other sites More sharing options...
Procella Posted May 9, 2005 Share Posted May 9, 2005 When trying to import new updates, i get this error: User filename: summer2005 update.txt Size: 7254 | 10 | 10.jpg | Harem - Ea | | 179 | 0,1 | 2005-05-01 | LR Interna | Summer 200 | Dufte | Summer Wom | Moms | Active Updated | 11 11.jp | 12 12.jp | 13 13.jp | 181 181. | 2460 246 | 2461 246 | 2463 246 | 2464 246 | 78 78.jp | 79 79.jp | 80 80.jp | 81 81.jp | 82 82.jp | 2191 219 | 2304 230 | 2465 246 | 2466 246 | 2467 246 | 2469 246 | 4374 437 | 4378 437 | 4379 437 | 4402 440 | 4423 442 | 1931 193 | 1932 193 | 1934 193 | 1935 193 | 1936 193 | 1938 193 | 1940 194 | 1948 194 | 1949 194 | 1954 195 | 1293 129 | 4418 441 | 4419 441 | 4420 442 | 4421 442 | 4403 440 | 4404 440 | 4405 440 | 4406 440 | 4417 441 | 4424 442 | 844 844. | 843 843. | 1059 105 | 1061 106 | 1042 104 | 845 845. | 1258 125 | Data file: datafile My easypopulate is the newest full package from contribs. (v2.76) Quote Timo Jensen Link to comment Share on other sites More sharing options...
deke Posted May 9, 2005 Share Posted May 9, 2005 I am having trouble with inserting an updated file using Easy Populate. I have read through about 30 pages of threads. Thread 1367 was having the same issue as me. They responded as fixing the issue with two patches (thread 1379), but did not specify which ones. Steps to reproduce problem: (1) download complete tab-deblimited file -- contains only one product for testing (2) make change to one product and add a few more (3) insert into db using Easy Populate Result: The change in the first product is recorded, but the second product is not added in. Here is the easy populate insert message: File uploaded. Temporary filename: C:\DOCUME~1\Deke\LOCALS~1\Temp\phpE7.tmp User filename: EP2005May09-1503.txt Size: 2819 | 0501S1 | | Monday, Ma | Please pic | | | | | | | | 212.93 | 0 | | 0000-00-00 | 12 | 1 | Entree 1 | | | 1 | Cakes | | | 0 | 2 | Chips | | | 0 | 2 | Entree 2 | | | 5 | Cakes | | | 0 | 6 | Chips | | | 0 | 3 | Entree 3 | | | 4 | Entree 4 | | | 5 | Entree 5 | | | 6 | | | | | DBD Sessio | May Sessio | | Taxable Go | Active Updated | 0501S1 | 0501S1 | 0508S1 | Steps taken to fix this problem: (1) check temp directory -- placed under catalog (2) check temp variable in configure.php -- points to /catalog/temp/ (3) ensure temp folder is not read-only (4) ensure EOREOR is at end of each excel row Any help is much appreciated. I am using osCommerce 2.2, EP 2.76 - PHP 5.0.3. Thanks, Marty Quote Link to comment Share on other sites More sharing options...
kunal247 Posted May 10, 2005 Share Posted May 10, 2005 Can any one help!! After seraching hi and lo found some info on it in the posts:http://www.oscommerce.com/forums/index.php?sho...c=64945&st=1680 I have tried to add my new fields using this mannor and updated the easypopulate.php page, but every time I try to update a test range of products it just reverts back to my home page. No errors displayed, just pushes to home page. Also wanted to check the new fields I have created are called Brightness, Resolution and Lamp Life. Does that mean I have to write the code in products_brightness, products_resolution, products_lamp_life, or brightness, resolution, lamp_life, Which is the right way 1st or the 2nd one? Hope you can help!!! Kunal <{POST_SNAPBACK}> Quote Link to comment Share on other sites More sharing options...
Guest Posted May 10, 2005 Share Posted May 10, 2005 Can any one help!! <{POST_SNAPBACK}> I havea problem. I can download the database to my temp directory but on uploading, using Easypopulate I get message - File uploaded 40,000 bytes (I can't remember the exact message from last night and the server is down this morning!) I can find the uploaded file on the temp directory, but the database prices haven't changed. Any ideas? Quote Link to comment Share on other sites More sharing options...
Guest Posted May 10, 2005 Share Posted May 10, 2005 OK Server back. The actual message is below- File uploaded. Temporary filename: /tmp/phpcxw2ap User filename: totals.txt Size: 41050 I can find totals.txt on the temp directory, not phpcxw2ap, and the database prices haven't changed. Any ideas? <{POST_SNAPBACK}> Quote Link to comment Share on other sites More sharing options...
Pixy Posted May 10, 2005 Share Posted May 10, 2005 I got an error because my temp file had two // so I went and deleted the temp file in in my file manager and tried to create a new temp file hoping that this will solve the problem but no such luck. So how do I get rid of the // ?? :'( I really need some urgent help with this so any ideas would really be appreciated! Quote Pixy One day at a time - we all have to learn Link to comment Share on other sites More sharing options...
Guest Posted May 10, 2005 Share Posted May 10, 2005 post your admin/includes/configure.php file here, without the database connection info Quote Link to comment Share on other sites More sharing options...
Bigredman74 Posted May 10, 2005 Share Posted May 10, 2005 Wow, I just came across this thread and it sounds like this tweak/mod would be very useful. Is this tweak/mod listed at a contrib? If so, where? If not, where can I get the most recent install instructions. I know the quick answer is this thread, but this thread has almost 1800 posts. If someone could point me to the right post or post the instructions again, I would greatly appreciate it. Thanks in advance. Quote My Published & Modified Contributions Helpful Forum Topics: Basic Design Tips & Tricks | Simple Steps to Better Forum Searching | Speed / Performance Optimizations Link to comment Share on other sites More sharing options...
Guest Posted May 10, 2005 Share Posted May 10, 2005 click on contributions, it is listed in the right column Quote Link to comment Share on other sites More sharing options...
Pixy Posted May 10, 2005 Share Posted May 10, 2005 I just copied it <?php /* osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ // Define the webserver and path parameters // * DIR_FS_* = Filesystem directories (local/physical) // * DIR_WS_* = Webserver directories (virtual/URL) define('HTTP_SERVER', 'http://papercrazy.co.za'); // eg, http://localhost - should not be empty for productive servers define('HTTPS_SERVER', ''); // eg, https://localhost - should not be empty for productive servers define('ENABLE_SSL', false); // secure webserver for checkout procedure? define('HTTP_COOKIE_DOMAIN', 'papercrazy.co.za'); define('HTTPS_COOKIE_DOMAIN', ''); define('HTTP_COOKIE_PATH', '/catalog/'); define('HTTPS_COOKIE_PATH', ''); define('DIR_WS_HTTP_CATALOG', '/catalog/'); define('DIR_WS_HTTPS_CATALOG', ''); define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/'); define('DIR_FS_CATALOG', '/usr/www/users/paperc/catalog/'); define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/'); define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/'); // define our database connection define('DB_SERVER', 'dedi4a.your-server.co.za'); // eg, localhost - should not be empty for productive servers define('DB_SERVER_USERNAME', 'paperc_nos'); define('DB_SERVER_PASSWORD', 'XAbBbJXz'); define('DB_DATABASE', 'paperc_paperc_newoscomm'); define('USE_PCONNECT', 'false'); // use persistent connections? define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql' /* define('DB_SERVER', 'dedi4a.your-server.co.za'); define('DB_SERVER_USERNAME', 'paperc_os'); define('DB_SERVER_PASSWORD', 'XAbBbJXz'); define('DB_DATABASE', 'paperc_oscommerce'); define('USE_PCONNECT', 'false'); define('STORE_SESSIONS', ''); */ ?> Quote Pixy One day at a time - we all have to learn Link to comment Share on other sites More sharing options...
Guest Posted May 10, 2005 Share Posted May 10, 2005 that is not the correct one, need the admin/includes/configure.php if those are you actual db name, password, etc you will now need to change them since you posted them also, in store_sessions set that to 'mysql' Quote Link to comment Share on other sites More sharing options...
Bigredman74 Posted May 10, 2005 Share Posted May 10, 2005 click on contributions, it is listed in the right column <{POST_SNAPBACK}> I have "Easy Populate v2.76 (15 Apr 2005)" already installed. Does this version already have the ability to download all of the attributes of an item, even those made with the "Product Attributes - Option Type Feature v1.71 (17 Nov 2004)" contrib? Quote My Published & Modified Contributions Helpful Forum Topics: Basic Design Tips & Tricks | Simple Steps to Better Forum Searching | Speed / Performance Optimizations Link to comment Share on other sites More sharing options...
Guest Posted May 10, 2005 Share Posted May 10, 2005 have you tried to download your products to see? Quote Link to comment Share on other sites More sharing options...
Pixy Posted May 10, 2005 Share Posted May 10, 2005 that is not the correct one, need the admin/includes/configure.phpif those are you actual db name, password, etc you will now need to change them since you posted them also, in store_sessions set that to 'mysql' <{POST_SNAPBACK}> I hope this is it? <?php /* osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ // Define the webserver and path parameters // * DIR_FS_* = Filesystem directories (local/physical) // * DIR_WS_* = Webserver directories (virtual/URL) define('HTTP_SERVER', 'http://papercrazy.co.za'); // eg, http://localhost - should not be empty for productive servers define('HTTP_CATALOG_SERVER', 'http://papercrazy.co.za'); define('HTTPS_CATALOG_SERVER', ''); define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module define('DIR_FS_DOCUMENT_ROOT', '/usr/www/users/paperc/catalog/'); // where the pages are located on the server define('DIR_WS_ADMIN', '/catalog/admin/'); // absolute path required define('DIR_FS_ADMIN', '/usr/www/users/paperc/catalog/admin/'); // absolute pate required define('DIR_WS_CATALOG', '/catalog/'); // absolute path required define('DIR_FS_CATALOG', '/usr/www/users/paperc/catalog/'); // absolute path required define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/'); define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/'); define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/'); Quote Pixy One day at a time - we all have to learn Link to comment Share on other sites More sharing options...
Guest Posted May 10, 2005 Share Posted May 10, 2005 define('DIR_FS_DOCUMENT_ROOT', '/usr/www/users/paperc/catalog/'); // where the pages are located on the server to define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT); Quote Link to comment Share on other sites More sharing options...
Bigredman74 Posted May 10, 2005 Share Posted May 10, 2005 have you tried to download your products to see? <{POST_SNAPBACK}> To be honest, on this site I'm still working with the original test database and haven't started uploading actual products yet. I did a test and yes, it already works. Thanks your help. Quote My Published & Modified Contributions Helpful Forum Topics: Basic Design Tips & Tricks | Simple Steps to Better Forum Searching | Speed / Performance Optimizations Link to comment Share on other sites More sharing options...
Pixy Posted May 10, 2005 Share Posted May 10, 2005 define('DIR_FS_DOCUMENT_ROOT', '/usr/www/users/paperc/catalog/'); // where the pages are located on the serverto define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT); <{POST_SNAPBACK}> I do not follow any of that?? Should i go change the code ? can you give me more instructions? Sorry but I am not good with this at all. :blush: Quote Pixy One day at a time - we all have to learn Link to comment Share on other sites More sharing options...
Guest Posted May 10, 2005 Share Posted May 10, 2005 change the line to reflect what i posted, this should make it work properly Quote Link to comment Share on other sites More sharing options...
Pixy Posted May 10, 2005 Share Posted May 10, 2005 I do not follow any of that??Should i go change the code ? can you give me more instructions? Sorry but I am not good with this at all. :blush: <{POST_SNAPBACK}> THANK YOU!!! It worked!! Thank you so much for your time! :thumbsup: Quote Pixy One day at a time - we all have to learn Link to comment Share on other sites More sharing options...
Pixy Posted May 10, 2005 Share Posted May 10, 2005 Okay the file uploads and gives me this File uploaded. Temporary filename: /tmp/phpxdgOj0 User filename: EP2005May10-2008.txt Size: 350012 But I do not see the products? Quote Pixy One day at a time - we all have to learn Link to comment Share on other sites More sharing options...
Guest Posted May 10, 2005 Share Posted May 10, 2005 you have something wrong with the data, post a few lines of your data here so we can see. also try to do one or to lines of your products, see if it uploads properly. Quote Link to comment Share on other sites More sharing options...
Pixy Posted May 10, 2005 Share Posted May 10, 2005 The only thing that I thought might be a problem is the images, they are on the system though? This is from the txt file that I tried to import. 25849 25849.jpg Rub-ons Alphabet Mixed Large Muted "Say just about anything anywhere with the versatile Rub-ons Alphabet. Great for quick titles and more, use the enclosed applicator stick to transfer letters onto whatever surface you desire." 0 0 28/06/2005 00:00 06/06/2005 17:56 1000 1 Color 2 Size 3 Model 5 Value 6 43 mb 4 59 mb 5 Version 10 Download: Windows - English 13 Box: Windows - English Making Memories "Chalks, Rub-Ons and Paint" --none-- Active EOREOR 25846 25846.jpg Rub-ons Alphabet Mixed Large White "Say just about anything anywhere with the versatile Rub-ons Alphabet. Great for quick titles and more, use the enclosed applicator stick to transfer letters onto whatever surface you desire." 0 0 29/06/2005 00:00 07/06/2005 17:56 1000 1 Color 2 Size 3 Model 5 Value 6 44 mb 4 60 mb 5 Version 10 Download: Windows - English 13 Box: Windows - English Making Memories "Chalks, Rub-Ons and Paint" --none-- Active EOREOR Quote Pixy One day at a time - we all have to learn Link to comment Share on other sites More sharing options...
Guest Posted May 10, 2005 Share Posted May 10, 2005 remove th quotes Quote Link to comment Share on other sites More sharing options...
Pixy Posted May 10, 2005 Share Posted May 10, 2005 I did and it still does not work Quote Pixy One day at a time - we all have to learn 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.