Latest News: (loading..)

smartwork

Members
  • Content count

    196
  • Joined

  • Last visited

  • Days Won

    1

smartwork last won the day on December 31 2012

smartwork had the most liked content!

1 Follower

About smartwork

Profile Information

  • Real Name
    Shaun
  1. My understanding is that PayPal Standard should write the order to the db at checkout_confirmation before sending the customer to PP for payment submission. Mine is writing the order to the db upon leaving checkout_payment, so it's happening before the customer even sees the order review (with shipping/taxes). Ideas on why that's happening? Thank you.
  2. Installed this about a year or so ago (maybe more) and it works great. Question though: Is there a way to get rid of (examples) -c-24_66.html for categories and -p-5743.html for products in order just to end clenaly with the keyworded category/product name? Thanks!
  3. I've been running QPBB with success, but also have the ability for text attributes. Here's what happens: Example: Customer can enter text option of "names" into a text box. If they enter them with spaces, separated by an ampersand, etc. all goes well. If they enter them separated by a comma, ERROR. I get a 1054 column not found error. I thought it might be caused by the joins and needing to edit those for PHP 5, but still cannot get it to work. For some reason, it's taking the second name (that follows the comma) and combining it with product_id. Original select code in includes/classes/PriceFormatter.php: $sql = "select pd.products_name, p.products_model, p.products_image, p.products_id," . " p.manufacturers_id, p.products_price, p.products_weight, p.products_quantity," . " p.products_qty_blocks, p.products_tax_class_id," . " IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price," . " ptdc.discount_categories_id from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on " . " p.products_id = s.products_id left join " . TABLE_PRODUCTS_TO_DISCOUNT_CATEGORIES . " ptdc on " . " p.products_id = ptdc.products_id, " . " ". TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1'" . " and pd.products_id = p.products_id " . " and p.products_id = '" . (int)$product_id . "'" . " and pd.language_id = '". (int)$language_id ."'"; Here's a sample error - note that "mary" which was the second name the customer entered is combined with product_id (see end section of code): 1054 - Unknown column 'mary' in 'where clause' select pd.products_name, pd.products_packaged_components, p.products_model, p.products_image, p.products_id, p.manufacturers_id, p.products_price, p.products_weight, p.products_quantity, p.products_qty_blocks, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, ptdc.discount_categories_id from products p left join specials s on p.products_id = s.products_id left join products_to_discount_categories ptdc on p.products_id = ptdc.products_id, products_description pd where p.products_status = '1' and pd.products_id = p.products_id and p.products_id in (3612, mary) and pd.language_id = '1' Interesting thing too is that if instead of something like tom, mary being entered and you enter tom, 3 there is no problem. If a number follows the comma, no problem. If a letter follows, there's a problem. It still seems related to the handling of that comma, but I can't figure why. I tried editing the join as follows which inserts parentheses to help with PHP 5 without luck: $sql = "select pd.products_name, p.products_model, p.products_image, p.products_id," . " p.manufacturers_id, p.products_price, p.products_weight, p.products_quantity," . " p.products_qty_blocks, p.products_tax_class_id," . " IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price," . " ptdc.discount_categories_id from ((" . TABLE_PRODUCTS . " p ) left join " . TABLE_SPECIALS . " s on " . " p.products_id = s.products_id ) left join " . TABLE_PRODUCTS_TO_DISCOUNT_CATEGORIES . " ptdc on " . " p.products_id = ptdc.products_id, " . " ". TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1'" . " and pd.products_id = p.products_id " . " and p.products_id = '" . (int)$product_id . "'" . " and pd.language_id = '". (int)$language_id ."'"; Can anyone offer some insight? Thank you!
  4. https in category links I've got this installed an appears to work well, however, one thing I noticed is that all category links normally begin with http as they should, but once you enter a secured (https) area, the category links then remain secured (https) until you visit a nonsecured area that then flips them back. Why? And how can this be eliminated? I've examined the tep_href_link function, but haven't found what's causing it in the category links because the same function used for other links does not result in the same result (those work okay). Thanks!
  5. Hi there, We are building a project where shop B will be reading product information (products, categories, etc.) from shop A (older version OSC), but all customer and order info will remain at shop B. We have that operating fine. Prior to this, we installed Ultimate SEO Urls and it works just fine. My question is if you can provide some direction on what we would need to change to convert this add-on to function on the data from shop A. For the rest of the site, we simlpy divided the shop's operations between what is related to "products" and what is related to "customers" and modified/duplicated the functions accordingly. Thanks for any insight. Edited to add: The method we used to split the shop was to add a second server config in includes/configure.php that provides access to shop A for queries relating to products and categories. That is then referenced for the parts of the shop relating to products/categories.
  6. Our host just upgraded to php 5.3 and now we've got this in both catalog/checkout_shipping.php and admin/modules.php Which I believe in in reference to the UPS XML module. Deprecated: Assigning the return value of new by reference is deprecated in /usr/********/classes/xml_5.php on line 25 I've tried the suggestion on the previous page of this thread, but no change. Can someone point me in a direction of the fix? Thank you!
  7. Hi there, Robert While glancing at your link above in referece to the .htaccess code, I saw in that thread where someone else posted about the return of their oscID in their URLs after the installation of USU5 Pro. You referred to their configuration being incorrect just as you did with my inquiry and mentioned that you should "never" have to hide the oscID if things configured correctly. As our oscID was not present before and is after the installation of USU5 Pro, could you elaborate on what you're referring to? Is is the actual configure.php that is incorrect or something else that was generally classified as configuration? We can use the "force cookies" to rid oscID from the URL, but it was absent previously without having to use that option. Thanks for any pointers. -shaun
  8. Agreed on not wishing to use them (session ids)... which we weren't. I just wasn't sure what brought them back after the installation of USU5. We'll sort it out and reconfigure.
  9. I believe the 'freq' and 'priority' tags are not normally in the protocol for the sitemapIndex structure. /** * Create the sitemap index */ $detail = array(); usu5_xml_init( $doc, $root, true ); $path = realpath( dirname( __FILE__ ) . '/../' ) . '/'; $detail = array( 'url' => tep_href_link( 'sitemapCategories.xml' ), 'lastmod' => date( "Y-m-d" ), 'freq' => 'weekly', 'priority' => '0.5' ); usu5_node_create( $doc, $root, $detail, true ); $detail = array( 'url' => tep_href_link( 'sitemapProducts.xml' ), 'lastmod' => date( "Y-m-d" ), 'freq' => 'weekly', 'priority' => '0.5' ); usu5_node_create( $doc, $root, $detail, true ); $detail = array( 'url' => tep_href_link( 'sitemapManufacturers.xml' ), 'lastmod' => date( "Y-m-d" ), 'freq' => 'weekly', 'priority' => '0.5' ); usu5_node_create( $doc, $root, $detail, true ); usu5_xml_exists( $doc, 'sitemapIndex.xml' );
  10. Hi there, Robert Quick question: We've previously run without the session id included in the URL. I see that with USU5 the session id is present. Have you had much feedback about that and/or issues people have run into with having their sites indexed that way. We have Google set to ignore that parameter, but outside of that option where we can hope they ignore it and not count it as duplicate content or cause complications with visitors arriving through that link, are there issues to be expected by having the site indexed with those? Thanks!
  11. Posting back in case anyone else runs into my scenario posted above (delimter error). I reconfigured my includes/configure.php to put a / in the DIR_WS_HTTP_CATALOG definition, but that still didn't resolve the error. It was actually the DIR_FS_CATALOG definition that needed to be changed and hard-coded. It's now resolved. Robert, Your instructions suggested sending along any notes that users found during installation. While doing the manual edit/upload method for 2.2, in step #1 it states that the files being uploaded are new files. When I got to the includes/boxes/languages.php file, that actually over-writes the existing one. It gave me pause, but after examining them, I went ahead and uploaded the new one (saving the original, of course). Not sure if putting a note to installers to overwrite their old file will ease their decision at the point or not. Just a thought. We are SO looking forward to getting this rolling. Thanks so much for all your work on it.
  12. ... continued from my post above: Separate from our production shop, I just did two box-stock OSC 2.2 installations and then added USU5 following the instructions. Install 1: I used the "modified shop" instructions Install 2: I used the "drop-on" instructions Both resulted in the same error that we got when installing into our production shop: Warning: strpos() [function.strpos]: Empty delimiter in /usr/www/users/....../includes/modules/ultimate_seo_urls5/main/bootstrap.php on line 121 (the line number was different by one line as the file was drop on) Is there a server or PHP config that's not enabled that would be causing this?
  13. Thanks for the quick reply. I should have included more info. The same error results with or without the additional line in configure.php If I remove the definition line that I added (which I have), the result is the same. Earlier, I stumbled upon a post on php forum where older versions of php produced this error when a value of ' ' (no space) was being used in certain functions that used "search haystack for needle". We're running php 5.2.11, so I assumed that was not the problem, but I wondered if our DIR_WS_HTTP_CATALOG which then feeds DIR_WS_CATALOG is producing my error because it virtually has an empty value.
  14. Installed USU5 into our shop with version: define('PROJECT_VERSION', 'osCommerce Online Merchant v2.2 RC2a'); Install instructions and presentation was awesome and GREATLY appreciated. When finished, here's what I've got when I load the home page of the shop as instructed: Warning: strpos() [function.strpos]: Empty delimiter in /usr/www/users/..../includes/modules/ultimate_seo_urls5/main/bootstrap.php on line 122 which is: if (DIR_WS_CATALOG != '/' && ( false !== strpos( $rawpath, DIR_WS_CATALOG ) ) ) { // Remove the DIR_WS_CATALOG path $rawpath = str_replace( DIR_WS_CATALOG, '/', $rawpath ); } In my includes/configure.php, our DIR definitions are the following (and completely functional for the shop in the home directory): define('DIR_WS_HTTP_CATALOG', ''); define('DIR_WS_HTTPS_CATALOG', ''); so, I did add the line below for simplicity sake to make the DIR definition and reference match for USU5 - not knowing how many changes would have to be made to the USU5 code if I wanted it to reflect the original DIR config for catalog in configuration.php: define('DIR_WS_CATALOG', ''); Is it the ' ' (no space between quotes) value for DIR that is causing the problem? I tried troubleshooting it putting some conditions in to work around if the DIR value is '', but nothing resulting in a solution. I'm able to resolve the error, but then links only result in an attempted page-load that never is successful or 404s... it just fails to do anything. Can you point me in a direction of a solution? Many thanks...
  15. Two questions: 1. Does PayPal standard write the order to the database before the "real" confirmation page? It appears that when I'm on the confirmation page where you actually click the confirm button, the order has already been written. Not so when using all the other payment options. Is this correct? 2. PP Standard is dropping the customer-input fields on products. Keeps all the drop-down product info. Suggestions on what needs to be inserted into the PP module to transfer the customer-input data? Thanks!