Jump to content

sonictrip.net

Members
  • Content count

    216
  • Joined

  • Last visited

Everything posted by sonictrip.net

  1. So, ive got Easy Populate working properly except for one little thing (theres always one) Im able to download the full catalogue as a text file. But when i upload the exact same file back up to the server, everything seems fine until i check a product that has an image link in it. The image links, which only happen in the product description, seem to be given the following format: http://www.bwear.ie/catalog/%22images/pSep...-150x150.jpg%22 Notice the %22 around the part of the url that is in the description, the html looks like this: src="images/pSeppFleece2Tone-150x150.jpg" So, its replacing the quotes with %22 instead. I have checked the easy_populate.php file for the replacing quotes part, and it looks like so: $replace_quotes = false; So, why is it still replacing the quotes? Even though its only the html version of the quote that its replacing it with, how would i change that in the easy_populate.php file? The downloaded file, when viewed in Excel, still has the normal proper quotes "" around the url. It seems to only change them to %22 when the file is uploaded again, so its the uploading process thats changing them. Any ideas, anyone? Thank you
  2. sonictrip.net

    Easy Populate & Products Attributes

    How do i replace them all in Excel? When i try to do a find and replace, it says "formula is too long" Thanks.
  3. sonictrip.net

    Easy Populate & Products Attributes

    Sorry, im not talking about the v_products_image field. They are all fine... Im talking about HTML which points to other images from inside v_products_description in the format <img src="images/blah.jpg"> being renamed to <img src=%22images/blah.jpg%22> This only happens in the v_products_description as that is the only place where there are quotes because of the HTML descriptions ive been using... I also tried removing the product description data and uploading all the other data but it just deletes all product descriptions instead of leaving them the way they are. So there's no work around for it that i can see, know what i mean? The replace_quotes variable is turned off so it really should be leaving the quotes the way they are instead of changing them all to %22. Would it be an excel issue, or the fact that im uploading to a windows server? Thanks for the reply! :)
  4. sonictrip.net

    Easy Populate & Products Attributes

    Ok, seeing as i didnt get a reply to this earlier, i thought i'd post the whole thing here: Im able to download the full catalogue as a text file. But when i upload the exact same file back up to the server, everything seems fine until i check a product that has an image link in it. The image links, which are in the product description, seem to be given the following format: http://www.bwear.ie/catalog/%22images/pSep...-150x150.jpg%22 Notice the %22 around the part of the url that is in the description, the html looks like this: src="images/pSeppFleece2Tone-150x150.jpg" So, its replacing the quotes with %22 instead. I have checked the easy_populate.php file for the replacing quotes part, and it looks like so: $replace_quotes = false; So, why is it still replacing the quotes? Even though its only the html version of the quote that its replacing it with, how would i change that in the easy_populate.php file? The downloaded file, when viewed in Excel, still has the normal proper quotes "" around the url. It seems to only change them to %22 after the file is uploaded again, so its the uploading process thats changing them. Any ideas, anyone? Pixclinic? :) Thank you
  5. ::BUMP:: This forum has gone so quiet compared to how it used to be...
  6. sonictrip.net

    Easy Populate & Products Attributes

    Can anyone please help me with the following Easy Populate problem: http://forums.oscommerce.com/index.php?sho...mp;#entry951767 Thank you!
  7. sonictrip.net

    Easypopulate Basic

    If you're using an earlier version of EP like i was (v2.76), update it to v2.90b and that might fix, it did for me! :)
  8. sonictrip.net

    Easy Populate & Products Attributes

    Wow man, that was a fast reply! :) I think we're almost there, just a parse error thats coming up now when i click the Easy Populate link in the Admin... It's saying there's a parse error on this line: '$v_products_image. '", "' from this snippet: VALUES ( '$v_products_image. '", "' . $v_products_image_med . '", "' . $v_products_image_lrg . '", "' . $v_products_image_sm_1 . '", "' . $v_products_image_xl_1 . '", "' . $v_products_image_sm_2 . '", "' . $v_products_image_xl_2 . '", "' . $v_products_image_sm_3 . '", "' . $v_products_image_xl_3 . '", "' . $v_products_image_sm_4 . '", "' . $v_products_image_xl_4 . '", "' . $v_products_image_sm_5 . '", "' . $v_products_image_xl_5 . '", "' . $v_products_image_sm_6 . '", "' . $v_products_image_xl_6 . '", "'; Any more ideas? Thanks for the help! :)
  9. sonictrip.net

    Easy Populate & Products Attributes

    Hi, thanks for the reply, that makes sense anyway! Im not too sure what needs to be changed on easy_populate.php though, it all looks right to me... Here's a few lines around the part that i think is related, can you tell me what changes i need to make in order for these missing quotes to be included? Thanks // insert into products $sql = "SHOW TABLE STATUS LIKE '".TABLE_PRODUCTS."'"; $result = tep_db_query($sql); $row = tep_db_fetch_array($result); $max_product_id = $row['Auto_increment']; if (!is_numeric($max_product_id) ){ $max_product_id=1; } $v_products_id = $max_product_id; echo "<font color='green'> !New Product!</font><br>"; $query = "INSERT INTO ".TABLE_PRODUCTS." ( products_image, products_image_med, products_image_lrg, products_image_sm_1, products_image_xl_1, products_image_sm_2, products_image_xl_2, products_image_sm_3, products_image_xl_3, products_image_sm_4, products_image_xl_4, products_image_sm_5, products_image_xl_5, products_image_sm_6, products_image_xl_6, products_model, products_price, products_status, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, manufacturers_id) VALUES ( '$v_products_image'," . $v_products_image_med . '", "' . $v_products_image_lrg . '", "' . $v_products_image_sm_1 . '", "' . $v_products_image_xl_1 . '", "' . $v_products_image_sm_2 . '", "' . $v_products_image_xl_2 . '", "' . $v_products_image_sm_3 . '", "' . $v_products_image_xl_3 . '", "' . $v_products_image_sm_4 . '", "' . $v_products_image_xl_4 . '", "' . $v_products_image_sm_5 . '", "' . $v_products_image_xl_5 . '", "' . $v_products_image_sm_6 . '", "' . $v_products_image_xl_6 . '", "'; // unmcomment these lines if you are running the image mods /* $query .= . $v_products_mimage . '", "' . $v_products_bimage . '", "' . $v_products_subimage1 . '", "' . $v_products_bsubimage1 . '", "' . $v_products_subimage2 . '", "' . $v_products_bsubimage2 . '", "' . $v_products_subimage3 . '", "' . $v_products_bsubimage3 . '", "' */ $query .=" '$v_products_model', '$v_products_price', '$v_db_status', CURRENT_TIMESTAMP, $v_date_added, $v_date_avail, '$v_tax_class_id', '$v_products_weight', '$v_products_quantity', '$v_manufacturer_id') "; $result = tep_db_query($query); } else { // existing product, get the id from the query // and update the product data $row = tep_db_fetch_array($result); $v_products_id = $row['products_id']; echo "<font color='black'> Updated</font><br>"; $row = tep_db_fetch_array($result); $query = 'UPDATE '.TABLE_PRODUCTS.' SET products_price="'.$v_products_price . '" ,products_image="'.$v_products_image . '" ,products_image_med="'.$v_products_image_med . '" ,products_image_lrg="'.$v_products_image_lrg . '" ,products_image_sm_1="'.$v_products_image_sm_1 . '" ,products_image_xl_1="'.$v_products_image_xl_1 . '" ,products_image_sm_2="'.$v_products_image_sm_2 . '" ,products_image_xl_2="'.$v_products_image_xl_2 . '" ,products_image_sm_3="'.$v_products_image_sm_3 . '" ,products_image_xl_3="'.$v_products_image_xl_3 . '" ,products_image_sm_4="'.$v_products_image_sm_4 . '" ,products_image_sm_4="'.$v_products_image_xl_4 . '" ,products_image_sm_5="'.$v_products_image_sm_5 . '" ,products_image_xl_5="'.$v_products_image_xl_5 . '" ,products_image_sm_6="'.$v_products_image_sm_6 . '" ,products_image_xl_6="'.$v_products_image_xl_6; // uncomment these lines if you are running the image mods /* $query .= '" ,products_mimage="'.$v_products_mimage. '" ,products_bimage="'.$v_products_bimage. '" ,products_subimage1="'.$v_products_subimage1. '" ,products_bsubimage1="'.$v_products_bsubimage1. '" ,products_subimage2="'.$v_products_subimage2. '" ,products_bsubimage2="'.$v_products_bsubimage2. '" ,products_subimage3="'.$v_products_subimage3. '" ,products_bsubimage3="'.$v_products_bsubimage3; */ $query .= '", products_weight="'.$v_products_weight . '", products_tax_class_id="'.$v_tax_class_id . '", products_date_available= ' . $v_date_avail . ', products_date_added= ' . $v_date_added . ', products_last_modified=CURRENT_TIMESTAMP , products_quantity="' . $v_products_quantity . '" ,manufacturers_id=' . $v_manufacturer_id . ' , products_status=' . $v_db_status . ' WHERE (products_id = "'. $v_products_id . '")'; $result = tep_db_query($query); } // the following is common in both the updating an existing product and creating a new product if ( isset($v_products_name)){ foreach( $v_products_name as $key => $name){ if ($name!=''){ $sql = "SELECT * FROM ".TABLE_PRODUCTS_DESCRIPTION." WHERE products_id = $v_products_id AND language_id = " . $key; $result = tep_db_query($sql); if (tep_db_num_rows($result) == 0) { // nope, this is a new product description $result = tep_db_query($sql); $sql = "INSERT INTO ".TABLE_PRODUCTS_DESCRIPTION." (products_id, language_id, products_name, products_description, products_url) VALUES ( '" . $v_products_id . "', " . $key . ", '" . $name . "', '". $v_products_description[$key] . "', '". $v_products_url[$key] . "' )"; Any ideas? Thanks for the reply! :)
  10. sonictrip.net

    Easy Populate & Products Attributes

    Im having a problem uploading Model/Price/Qty txt files after they are downloaded with EasyPopulate in the first place. I make 1 change to a price to see if it works and it doesnt change anything... Here's the error: I have a few mods installed including Some 6 image mod with htmlarea, Linkmatics Attribute Sets, Who's Online Enhancement, Skype Us mod, CVV mod, plus a couple of others that i cant remember right now... Anyone got any ideas? It's not tab based, not eoreor based, not permissions based or any of those other simple solutions... would a Windows Server be at fault here? Im so sick of them now, im changing to Linux at the next problem that arises...
  11. sonictrip.net

    Easypopulate Basic

    Im getting the exact same error when i try to upload a tab delimited Model/Price/Qty version of the downloaded text file. All i have changed from the downloaded version from the site is 1 price to see if it worked and i got the same error. The server this site is on is a Windows server (Which seems to always cause problems) Any help would be much appreciated! :-"
  12. sonictrip.net

    [Contribution]Skype Contact

    ok, its working now after i removed a ";" after 'SSL') Dunno how that got in there, sorry! :)
  13. sonictrip.net

    [Contribution]Skype Contact

    To last post: EDIT: ok, seems like the original file was called skype_us.php but the code calls that page skype_contact.php so after renaming them to match, im now getting the original secure/unsecure warning that this code was supposed to prevent from showing anyway...?? would IE7 be anything to do with it?
  14. sonictrip.net

    [Contribution]Skype Contact

    Hi, i gave this one a go coz i was getting the same unsecure/secure warning and i inserted the following code as suggested: I needed to stick in the little <? bits for php but it doesnt seem to show at all. Then after looking into it again without even changing anything i started getting the error: The skype_us.php page does exist so dunno why that error would show?? The code is placed in my header.php file coz thats the way this particular template was designed... any ideas? Cheers
  15. sonictrip.net

    [Contribution]Skype Contact

    Hi, i gave this one a go coz i was getting the same unsecure/secure warning and i inserted the following code as suggested: I needed to stick in the little <? bits for php but it doesnt seem to show at all. Then after looking into it again without even changing anything i started getting the error: The code is placed in my header.php file coz thats the way this particular template was designed... any ideas? Cheers
  16. sonictrip.net

    CCCVV_ISSUE_START Selectable W/Blacklist Problem

    With encryption enabled, only new orders will display the proper cc details, old orders that still have cc details in the db will look scrambled if thats any help...
  17. sonictrip.net

    Sales Tax Not Being Entered

    Excellent, i was looking for this too and it works perfectly! :D
  18. sonictrip.net

    Fancier Invoice & Packingslip v1.0

    Hi, i had the address problem on the checkout page and tried Di11on's fix in general.php. That seemed to fix the problem and it looks like its placing orders now, but on the page just after you press the confirm order button, i get the following error: Warning: mail(): SMTP server response: 503 5.5.1 Incorrect command sequence in C:\home\bwear\www\shop\includes\classes\email.php on line 500 Warning: Cannot modify header information - headers already sent by (output started at C:\home\bwear\www\shop\includes\classes\email.php:500) in C:\home\bwear\www\shop\includes\functions\general.php on line 29 When i check the admin end for the orders, they are there but dont appear to have the customers name, address, email or any other info about the customer except their credit card details... Any ideas? cheers :thumbsup:
  19. sonictrip.net

    [Contribution] InfoPages_v0.1

    Im getting a similar error to jailaxmi's: Fatal error: main(): Failed opening required 'DIR_WS_MODULESinfopages/application_top.php' (include_path='.;c:\php4\pear') in C:\home\bwear\www\catalog\admin\includes\application_top.php on line 14 Anyone got any ideas? is there a particular part of the admin/includes/application_top.php file that this bit of code has to be placed for it to work? : // Module: InfoPages require(DIR_WS_MODULES . 'infopages/application_top.php'); Thanks EDIT: Ok, its working when you put the above bit of code at the very end of the admin/includes/application_top.php file just before the ?>
  20. Checkout_confirmation.php and checkout_process.php problems.... When im on the checkout confirmation page, just under billing address, the following is being displayed: Warning: htmlspecialchars() expects parameter 1 to be string, array given in C:\home\bwear\www\catalog\includes\functions\general.php on line 42 Warning: htmlspecialchars() expects parameter 1 to be string, array given in C:\home\bwear\www\catalog\includes\functions\general.php on line 42 Payment Method (Edit) Credit Card So, i press the confirm order button anyway, and it brings me onto the checkout_process.php page and then the following comes up, this is all that is on the page: Warning: mail(): SMTP server response: 503 5.5.1 Incorrect command sequence in C:\home\bwear\www\catalog\includes\classes\email.php on line 500 Warning: Cannot modify header information - headers already sent by (output started at C:\home\bwear\www\catalog\includes\classes\email.php:500) in C:\home\bwear\www\catalog\includes\functions\general.php on line 29 I had the infobox_skin_manager_2.0.zip contribution installed before and working fine. Then when i installed image_html_package_1.2 (i think its this contib, the one with 6 SM and XL extra images plus the htmlarea function) all the problems started happening... Also, when in the admin section, at the bottom of the categories box, there's a link to "Templates". This link has now changed to BOX_HEADING_TEMPLATES, and the links under this category have changed to BOX_TEMPLATES_INFOBOX_MAPPING and BOX_TEMPLATES_INFOBOX. This may have something to do with the checkout problems in general.php Even though errors are coming up at the end of the checkout process, the order does seem to get placed and is coming up in the admin section. Anyone have any idea where to start? The url to the site is www.bwear.ie/catalog Thanks in advance! All help is much appreciated! :)
  21. This may also be related to the same problem above: Im having problems with the Billing and shipping Address. When i click the checkout button, the Delivery Information is displayed. Under "Shipping Address", there is no address being displayed. So, i click the "change address" button and it brings me into a page to enter my address details, with everything being blank. After i enter my details and hit the "continue" button, a blank white page with the following text comes up: 1062 - Duplicate entry '1-4' for key 1 insert into address_book (customers_id, entry_firstname, entry_lastname, entry_street_address, entry_postcode, entry_city, entry_country_id, entry_gender, entry_company, entry_suburb) values ('4', 'Francis', 'Horan', '263 Galloping Green', 'd18', 'dublin', '103', 'm', 'company name', 'Stillorgan Road,') [TEP STOP] This all began happening after i installed the contrib: image_html_package_1.2.zip Thanks for any help! :-"
  22. sonictrip.net

    CC CVV + Encryption + Blacklist v1.0

    Im getting this error as well, can anyone figure it out?
  23. sonictrip.net

    Installing CC_CVV+encryption v1.7 HELP

    All you need to do is look at the file catalog/includes/application_top.php that came with the mod and you'll see where the author has entered the code already on that file... its near the very top.
  24. sonictrip.net

    Easy Populate & Products Attributes

    Nah, its giving me the same error except with catalog//temp/ like so: Warning: move_uploaded_file(C:/home/bwear/www/catalog//temp/EP2004Dec14-1402v3.txt): failed to open stream: Permission denied in C:\home\bwear\www\catalog\admin\easypopulate_functions.php on line 32 Warning: move_uploaded_file(): Unable to move 'C:\PHP\uploadtemp\phpBD04.tmp' to 'C:/home/bwear/www/catalog//temp/EP2004Dec14-1402v3.txt' in C:\home\bwear\www\catalog\admin\easypopulate_functions.php on line 32 File uploaded. Temporary filename: C:\PHP\uploadtemp\phpBD04.tmp User filename: EP2004Dec14-1402v3.txt Size: 128234 Warning: file(C:/home/bwear/www/catalog//temp/EP2004Dec14-1402v3.txt): failed to open stream: No such file or directory in C:\home\bwear\www\catalog\admin\easypopulate.php on line 657 Warning: Invalid argument supplied for foreach() in C:\home\bwear\www\catalog\admin\easypopulate.php on line 680
  25. sonictrip.net

    Easy Populate & Products Attributes

    It's setup as this with chmod 666: $tempdir = "temp/"; $tempdir2 = "temp/"; I tried changing the chmod to 777 but it wont, although i emailed my isp before and asked him to make sure it was 777 and even though he said it was, it was still showing up as 666. I think this was working before with all the same settings... What does the part about easypopulate_functions.php mean? :blush:
×