Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

EricK

Pioneers
  • Posts

    310
  • Joined

  • Last visited

Everything posted by EricK

  1. John, Use this to manually create the table using phpMyAdmin. CREATE TABLE `cache` ( `cache_id` varchar(32) NOT NULL default '', `cache_language_id` tinyint(1) NOT NULL default '0', `cache_name` varchar(255) NOT NULL default '', `cache_data` mediumtext NOT NULL, `cache_global` tinyint(1) NOT NULL default '1', `cache_gzip` tinyint(1) NOT NULL default '1', `cache_method` varchar(20) NOT NULL default 'RETURN', `cache_date` datetime NOT NULL default '0000-00-00 00:00:00', `cache_expires` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`cache_id`,`cache_language_id`), KEY `cache_id` (`cache_id`), KEY `cache_language_id` (`cache_language_id`), KEY `cache_global` (`cache_global`) ) TYPE=MyISAM; Regards, EricK
  2. Follow-up to duplicate links created by Site Map MS2-2.2 ... It looks like the Site Map Category Tree is built using tep_href_link(), on line 51, catalog/includes/classes/category_tree.php <a href="' . tep_href_link(FILENAME_DEFAULT, 'cPath=' . $category_link) . '"> But the problem is all sub-category links are not SEO'd. (same problem as YASU). Has anyone looked into or solved this? Thanks, EricK
  3. Bobby, Thank you for the Ultimate SEO contribution :-D it is truly awesome! I have two questions for you about duplicate URLs: 1. Froogle Data Feed Does your Data Feed contribution submit stock osC URLs for product pages, similar to the basic Froogle Exporter? If so, it there a way to submit Ultimate SEO URLs? 2. Site Map MS2-2.2 (abstracted from 2.2-MS3 CVS snapshot) This excellent Site map displays sub-category URLs as standard osC format, Example: Pens Site Map I tried including sitemap.php in your .htaccess, but it did not change anything. Does a reference to Ultimate SEO need to be included in the classes file used for building the category tree " included/classes/category_tree.php"? Again, many thanks for your contributions. With kind regards, EricK
  4. Hello, Does anyone have YASU working with the SiteMap.php MS2.2 contribution? After installing YASU, the SiteMap.php (nested) links for sub-categories link to the base URL (home page), not to the sub-category page. According to the author, SiteMap.php is the sitemap from the MS3(snapshot) and was re-written for MS2-2.2 YASU uses the following mod-rewrite in .htaccess, that I think causes this problem. Do you see what should be added/changed to make SiteMap.php work with YASU? Options +FollowSymLinks RewriteEngine on RewriteBase / RewriteRule admin - [L] RewriteRule ^$ /index.php [R,L] RewriteRule ^/$ /index.php [R,L] RewriteCond %{REQUEST_URI} !-d RewriteCond %{REQUEST_URI} !^/$ RewriteRule !\.(gif|php|css|jpg)$ /rewrite.php Thank you for the great contributions, and your help. Kind regards, Eric Kagerer
  5. olby, That did not work, but thanks to you kindly pointing me in the right direction, this works for me. Line 135: 'field' => stripslashes($HTTP_POST_VARS['cc_owner'])), Thanks again! :)
  6. Olby, Many thanks, that fixes the lastname apostrophy error ... except on checkout_confirmation.php where the slash is displayed in the lastname under Payment Information, Credit Card Owner: In the generic cc module, should stripslashes go somewhere? Thanks again, EricK
  7. My solution to PWA's 'fatal flaw' is to use the guest flag code from Guest Account v2.0 with PWA. This flags PWA accounts with '@_' before the lastname and email address, therefore: - removal of PWA accounts is easy, they are flagged and listed first, - repeat PWA is possible, - creation of accounts after PWA is possible, - PWA after an abandoned cart is possible. This works great, and the only bug I found is a SQL error if the customer's lastname has an apostrophy (i.e., O'Conner). This is also a bug in Guest Account v2.0, apparently caused by this code: // Guest Account Start if ($guest_account) $sql_data_array['guest_flag'] = '1'; tep_db_query("update " . TABLE_CUSTOMERS . " set customers_email_address = '@_" . $email_address . "' where customers_email_address = '" . $email_address . "' and guest_flag = '1'"); tep_db_query("update " . TABLE_CUSTOMERS . " set customers_lastname = '@_" . $lastname . "' where customers_email_address = '@_" . $email_address . "'"); // Guest Account End As soon as I can fix this bug, I will share the combined PWA/Guest Account solution as a contribution. Any help with the fix is greatly appreciated. :) Regards, EricK
  8. Hi Olby, Thanks for your work on Guest Accounts. Do you know how to fix the Guest Accounts bug when customer's lastname contains an apostrophy? Try using O'Conner as a last name, do you also get a SQL error? Thanks, EricK
  9. All Guest Account mods have this bug. This corrects the SQL error: change this about line 40: $lastname = tep_db_prepare_input($HTTP_POST_VARS['lastname']); to this: $lastname = tep_db_prepare_input(addslashes($HTTP_POST_VARS['lastname'])); however the lastname displays the slashes .. O\\'Conner Has anyone fixed this bug? - Eric
  10. Finally tracked this down ... A lastname such as O'Conner causes the dreaded apostrophe SQL syntax error for the Guest Accounts mod due to the '@_" . $lastname . "' flag. Here is the error message for name Mike O'Conner: Here is the code in create_account.php, about line 208: // Guest Account Start if (!$guest_account) $sql_data_array['guest_flag'] = '0'; tep_db_query("update " . TABLE_CUSTOMERS . " set customers_email_address = '@_" . $email_address . "' where customers_email_address = '" . $email_address . "' and guest_flag = '1'"); tep_db_query("update " . TABLE_CUSTOMERS . " set customers_lastname = '@_" . $lastname . "' where customers_email_address = '@_" . $email_address . "'"); // Guest Account End I've tried unsuccessfully to addslashes like this, but it does not work. set customers_lastname = addslashes('@_" . $lastname . "') Can a SQL guru please point me in the right direction? Thanks, EricK
  11. No, unfortunately this only works with a customized version of osCommerce. :(
  12. heliosquare, The new .zip file appears to be empty.
  13. I also could not get this to work. Is something missing from the readme, and has anyone had success?
  14. Steps to remove duplicate products using MS Excel. 1. Open Excel, click Data, Get External Data, Import Text File then import your "froogle.txt" file 2. click Data, Filter, Advanced Filter, OK Select one column to filter, in my case the "name" column, from B5 to B555. Action = Filter the list, in-place List Range: Sheet1!$B$5:$B$555 Criteria range: Sheet1!$B$5:$B$555 Unique records only = yes Confirm that your duplicate products have been removed. 3. Highlight all fields, Copy, open Sheet2, Paste into Sheet 2 4. File, Save As, Text (Tab delimited), OK, No Now FTP your new froogle.txt file per your instructions to Google. EricK :P
  15. As many already know, the 'suburb' address field in the Order Editor contribution, that is also used by the Step-By-Step Manual Order Entry contribution contains a bug. Anything in the 'suburb' address field is deleted when Update is clicked on the admin/edit_orders.php page. Here is the fix for edit_orders.php - v1.2b2, updated 11-14-03 by Steve Mattis. Line numbers may be different for older versions of edit_orders.php. Bug: The word 'suburb' is mis-spelled on lines 539, 614 and 667. Fix: on line 539, replace: 'input name='update_customer_surburb' with input name='update_customer_suburb' on line 614, replace: input name='update_delivery_surburb' with: input name='update_delivery_suburb' on line 667, replace: input name='update_billing_surburb' with: input name='update_billing_suburb' FYI, I'm using osC2.2 MS2, snapshot dated 9-15-03. Cheers, EricK
  16. I just noticed this same thing ... however the 'Suburb' field does update correctly in Admin, Customers, Customers, Edit. Not sure why it does not update correctly in edit_orders.php, please let me know if you figure this out. Thanks, EricK
  17. Has anyone written a PHP script to import OSC order data directly into the Worldship Addressbook? Thanks, EricK
  18. Dr DK: The Credit Class & Gift Voucher contribution allows you to include a discount code in the new account email, or send discount codes via email from the cart's admin. You can assign expiration dates to the various discount codes. It's a relatively involved contribution to install, particularly on a heavily customized cart. HTH
  19. How do you automate the UPS shipping label process? Is it possible to export the shipping information from osCommerce to UPS WorldShip? Thanks, Eric
  20. Tim, I also have the duplicate products problem. Did you modify the script, or delete them manually? Thanks, EricK
  21. My Question is ... :unsure: how do you make Free Shipping (freeamount.php) the default when it's available? My default goes to the next option (button) when Free Shipping is available, the sort orders are correct, but Free Shipping is not the default option. Thanks, EricK
  22. If you installed the freeamount.php contribution, go to Modules, Order Total, Shipping, Edit, and set Allow Free Shipping = false. Then configure freeamount.php in Modules, Shipping, Free Shipping w/ Minimum Order and configure the settings. HTH, EricK
  23. rein, I solved the abandoned checkout problem by adding the flag feature from Guest Accounts to my PWA contribution. Basically I installed both contributions, then changed the Guest flag to work with PWA. It's not pretty , but it works :rolleyes: . HTH, EricK
  24. Brian - Your checkout works great for me, congratulations! Jack - I placed a note in the GV description to let people know they must create an account, and that it's an electronic GV, not something we will mail to them, and so far that's solved the problem. Here is my GV description ... The perfect gift for that special person! Note: You must create an online Profile at "My Store" to purchase and send electronic Gift Certificates. After checkout, your Gift Balance will display in your shopping cart. Click the "Send Gift Certificate" link in your shopping cart to Email your online Gift Certificate to that special person. - EricK
  25. Brian: I like your site, but can't get past "Order_Info.php" ... is your Sessions / Recreate Sessions / set to False? Also I get "This page contains both secure and nonsecure items. Do you want to display the nonsecure items?" I think caused by your Livehelp link. Jack: I have PWA working with the GV contribution, the only prob. is you need to create an account to purchase/send your GV balance. HTH, EricK :)
×
×
  • Create New...