Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

rs2k

Archived
  • Posts

    221
  • Joined

  • Last visited

About rs2k

  • Birthday 04/17/1983

Profile Information

  • Real Name
    Kalyn
  • Gender
    Male
  • Location
    kansas
  • Interests
    Programing, computers in general, flying, fishing... That's about it. =)
  • Website

rs2k's Achievements

  1. What was the thinking behind not using tep_db_functions in seo.class.php? Why was is necessary to create a new class and group of functions when all the functions already existed in OSC? After more digging into the seo.class.php code I finally solved this and one other problem that has been bugging me. I have no clue why it was programmed this way, but the seo.class.php file makes a new connection the the database every time the tep_href_url function is called. It uses its own line to connect instead of what's in application_top.php. This means that if you change the db connection line in the application_top.php file your SEO URLs will break. The reason that the first store was still working was because seo.class.php was connecting to an old database that was the same as the shared database. The second stores old database had 0 products which is why all the URLs were being displayed without the name. I simply commented out the lines in se.class.php that called for the SEO_Database class and changed every instance of $this->db->Function to tep_db_function. This has the great benefit of displaying the seo url queries into the query debug array and not creating new connections to the database every time the tep_href_url function is called. This will make our website more secure by allowing us to re enable mod_evasive because all pages will only call the database once (or twice) instead of 10 - 100 times.
  2. I have an odd error that is driving me insane. I have two highly modified OSC stores running on the same server. These two stores should be EXACTLY the same expect for the URL and the fact that one does not have an SSL cert yet. One store (which is live) is working perfectly. The other store (which is a test store) will only generate URLs like this: http://www.storename.com/-p-232.html Everything else in that store works. All the products information is displayed correctly and caching has been disabled on both stores. I have been trying to trouble shoot this problem all day and cannot find any answers in the forums or online. I see that the URL seems to fill the $string part of the url in the make_url function by using the get_product_name function located in the parse_parameters function, but I cannot for the life of me figure out why only -p-xxx.html is being displayed when the database contains a valid product name. I know all the data in the database is correct because the second store is using the first stores database. Any nudge in the right direction will be greatly appreciated.
  3. Try refreshing your categories cache in admin/tools/cache control.
  4. What you really need to do is download all of those images to your server and then put the image locations into the easy populate file. You could have someone create a script to do all of that for you or even modify EP to do it on the fly, but it would take some custom programming to make it work. I did not find any contribution that does what you ask.
  5. If you have not made any more modifications to 2.76-MS2 I would recommend installing 2.76g-MS2 by surfalot. The header names are slightly different with 2.76g-MS2, but it supports 7 category levels. It also supports adding extra fields to the products and products_description tables.
  6. I assume that a Master Product store simply adds fields to the products and products_descriptions tables that don't exist in a vanilla OSC installation. If that's the case then EP will support that. Our products table is highly modified and all I did was add the extra fields to the EP extra fields section. I have not had very good luck with adding product_description fields with large stores, but it seems to work well with small stores. If the Master Products store has other table changes that you want easypopulate to fill then it will not do that unless you make some major modifications.
  7. I do not see an easypopulate 2.76-MS2 available. Are you sure it's not something like 2.76g-MS2?
  8. Anything is possible, but I have found modifying easypopulate to be more difficult than average. All you have to do is rename the header row in your csv file. If the file does not have a header row then you will have to add one. It's not too hard to create a php script that can do the renaming for you. Or you can create a simple excel macro to do it for you if you use excel. The macro can simply be created by using the macro recorder and making the changes by hand.
  9. Modifications to Ultimate SEO URLS Hello, I've been doing some very heavy modifications to our stores lately and have learned a tremendous amount about osCommerce. I have about 30 contributions I've created for us but I don't know if I'd be helping or hurting by sharing it with others because of how customized some of them are. Some of the more simple mods I've made are to Ultimate SEO URLs to prevent duplicate content and they work very well on our server and store. Would I be stepping on someones toes if I uploaded a contribution to Ultimate SEO URLs? A few of the mods I made rely on FWRs URL validation, but some of them just simply modify .htaccess and parts of the tep_href_link function in html_output.
  10. I had the same problem with an old store of mine. Here was the fix for me: Ultimate SEO works great, but it also adds & to redirects which can mess up some cart functions. I bet if you disable your cookies completely your site will work. That would not be a good idea though, so here is how to get SEO to work correctly with your cart: Find (catalog/includes/classes/seo.class.php).. ------------ CODE SAMPLE ---------- case ($this->attributes['USE_SEO_REDIRECT'] == 'true'): header("HTTP/1.0 301 Moved Permanently"); header("Location: $url"); // redirect...bye bye ----------------------------------- and adjust to .. ------------ CODE SAMPLE ---------- case ($this->attributes['USE_SEO_REDIRECT'] == 'true'): $url = str_replace('&', '&', $url); header("HTTP/1.0 301 Moved Permanently"); header("Location: $url"); // redirect...bye bye ----------------------------------- For good measure find (catalog/includes/functions/general.php) .. ------------ CODE SAMPLE ---------- header('Location: ' . $url); ----------------------------------- Add directly above .. ------------ CODE SAMPLE ---------- $url = str_replace('&', '&', $url); -----------------------------------
  11. I could not get the stock module to work either. This module offers CCV2. I don't know if the stock module offers that or not.
  12. I'm sorry for the lateness of my reply. I just now noticed your reply. I am using Ultimate SEO URLs v2.6. I have also tried 2.4, 2.1 and 2.1d ORIGINAL updated I start to have problems with the products cache at about 60,000 products. The store in questions has 113,000 products. Our stores are on a dual xeon dedicated server with 4 GB of RAM. I am currently using my-huge.cnf. Adding the product cache to begin with manually does not really work. It stops the incredible slowness when the products caching is enabled, but the caching does nothing, so disabling the product caching on store above 60k+ or so products is what I have been doing for now.
  13. OK, the bug only appeared when you were more than 2 categories deep. http://www.myurl.com/catname-c-227_1761.html would redirect to http://www.myurl.com/catname-c-228_1761.html but http://www.myurl.com/catname-c-951_1715_1739_1740_1761.html would not redirect to: http://www.myurl.com/catname-c-952_1715_1739_1740_1761.html I made the following changes (hacks) to my store: In application_top.php I replaced // calculate category path if (isset($HTTP_GET_VARS['cPath'])) { $cPath = $HTTP_GET_VARS['cPath']; } elseif (isset($HTTP_GET_VARS['products_id']) && !isset($HTTP_GET_VARS['manufacturers_id'])) { $cPath = tep_get_product_path($HTTP_GET_VARS['products_id']); } else { $cPath = ''; } // calculate category path // BOE Category validation if (!(isset($cPath))) { // EOE Category validation if (isset($HTTP_GET_VARS['cPath'])) { $cPath = $HTTP_GET_VARS['cPath']; } elseif (isset($HTTP_GET_VARS['products_id']) && !isset($HTTP_GET_VARS['manufacturers_id'])) { $cPath = tep_get_product_path($HTTP_GET_VARS['products_id']); } else { $cPath = ''; } // BOE Category validation } // EOE Category validation and in general.php I replaced ( strpos($_SERVER['REQUEST_URI'], '-p-') ? ($querytype = 'filename_product_info-products_id=' . $get_id_vars) : ( strpos($_SERVER['REQUEST_URI'], '-c-') ? ($querytype = 'filename_default-cPath=' . $HTTP_GET_VARS['cPath']) : ( strpos($_SERVER['REQUEST_URI'], '-m-') ? ($querytype = 'filename_default-manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id']) : ( strpos($_SERVER['REQUEST_URI'], '-pi-') ? ($querytype = 'filename_popup_image-pID=' . $HTTP_GET_VARS['pID']) : ( strpos($_SERVER['REQUEST_URI'], '-t-') ? ($querytype = 'filename_articles-tPath=' . $HTTP_GET_VARS['tPath']) : ( strpos($_SERVER['REQUEST_URI'], '-a-') ? ($querytype = 'filename_article_info-articles_id=' . $HTTP_GET_VARS['articles_id']) : ( strpos($_SERVER['REQUEST_URI'], '-pr-') ? ($querytype = 'filename_product_reviews-products_id=' . $get_id_vars) : ( strpos($_SERVER['REQUEST_URI'], '-pri-') ? ($querytype = 'filename_product_reviews_info-products_id=' . $get_id_vars) : ( strpos($_SERVER['REQUEST_URI'], '-prw-') ? ($querytype = 'filename_product_reviews_write-products_id=' . $get_id_vars) : ( strpos($_SERVER['REQUEST_URI'], '-i-') ? ($querytype = 'filename_information-info_id=' . $HTTP_GET_VARS['info_id']) : ( strpos($_SERVER['REQUEST_URI'], '-links-') ? ($querytype = 'filename_links-lPath=' . $HTTP_GET_VARS['lPath']) : $do_validation = false )))))))))) ); with // BOE Category validation if (isset($HTTP_GET_VARS['cPath'])) { $cPathVar = $HTTP_GET_VARS['cPath']; $bottom_cat = array_pop(tep_parse_category_path($cPathVar)); $parent_categories_query = tep_db_query("select parent_id, categories_id from " . TABLE_CATEGORIES . " where categories_id = '" . $bottom_cat . "'"); while ($parent_categories = tep_db_fetch_array($parent_categories_query)) { if ($parent_categories['parent_id'] == '0') { $cPath = $parent_categories['categories_id']; } else { $categories = array($bottom_cat); tep_get_parent_categories($categories, $bottom_cat); $categories = array_reverse($categories); $cPath = implode('_', $categories); } } } ( strpos($_SERVER['REQUEST_URI'], '-p-') ? ($querytype = 'filename_product_info-products_id=' . $get_id_vars) : ( strpos($_SERVER['REQUEST_URI'], '-c-') ? ($querytype = 'filename_default-cPath=' . $cPath) : ( strpos($_SERVER['REQUEST_URI'], '-m-') ? ($querytype = 'filename_default-manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id']) : ( strpos($_SERVER['REQUEST_URI'], '-pi-') ? ($querytype = 'filename_popup_image-pID=' . $HTTP_GET_VARS['pID']) : ( strpos($_SERVER['REQUEST_URI'], '-t-') ? ($querytype = 'filename_articles-tPath=' . $HTTP_GET_VARS['tPath']) : ( strpos($_SERVER['REQUEST_URI'], '-a-') ? ($querytype = 'filename_article_info-articles_id=' . $HTTP_GET_VARS['articles_id']) : ( strpos($_SERVER['REQUEST_URI'], '-pr-') ? ($querytype = 'filename_product_reviews-products_id=' . $get_id_vars) : ( strpos($_SERVER['REQUEST_URI'], '-pri-') ? ($querytype = 'filename_product_reviews_info-products_id=' . $get_id_vars) : ( strpos($_SERVER['REQUEST_URI'], '-prw-') ? ($querytype = 'filename_product_reviews_write-products_id=' . $get_id_vars) : ( strpos($_SERVER['REQUEST_URI'], '-i-') ? ($querytype = 'filename_information-info_id=' . $HTTP_GET_VARS['info_id']) : ( strpos($_SERVER['REQUEST_URI'], '-links-') ? ($querytype = 'filename_links-lPath=' . $HTTP_GET_VARS['lPath']) : $do_validation = false )))))))))) ); // EOE Category validation
  14. After changing around some of the categories I am having a duplicate content problem with Google. Does this contribution work with categories? Thanks for this great contribution! This contribution is correctly redirecting the products, but the categories aren't working right. For example: http://www.myurl.com/catname-c-228_1761.html and http://www.myurl.com/catname-c-952_1715_1739_1740_1761.html are exactly the same page. If I browse to http://www.myurl.com/wrongcatname-c-228_1761.html it will redirect me to http://www.myurl.com/catname-c-228_1761.html, but it does not readjust the category numbers. Is this a problem with the way I installed the contribution, or does the contribution not redirect you to the proper category numbers?
×
×
  • Create New...