Jump to content

discxpress

Members
  • Content count

    909
  • Joined

  • Last visited

  • Days Won

    6

Everything posted by discxpress

  1. discxpress

    Header Tags SEO

    Jack, I think I got it fixed. First I installed the latest version of Header Tags SEO. I had version 3.0.1 installed. After I replaced all the old files with the new, I used the uninstall file to uninstall it then I used the install file to re-install Header Tags SEO. Since I have a large store I filled the category tags first then filled the product tags afterwards. It seem to work fine. Now I have to get accustomed to the new features. Thanks for your help.
  2. discxpress

    Header Tags SEO

    Hello Jack, I have a very large shop (over 400,000 products). I also have FWR Security Pro installed. When I run the installation, it runs for a few minutes then it sends me to a blank page. I read somewhere in this thread you said Security Pro uses an IP blocker, so I disabled it in admin. Also, I updated php.ini in admin to allow more memory. I run the installation again, same result. What else could be causing the problem? I'm afraid if I uninstall Security Pro, I may get a querystring attack. Thanks.
  3. Hello, When I have SEO urls enabled, my site doesn't load. When it's disabled, it will load. Where should I check for the problem? There are no errors or anything. Thank you.
  4. discxpress

    Google XML Sitemap SEO

    Nevermind Jack! I solved the issue by putting my php.ini file in the 'googlesitemap' directory on the server and I get this result: I guess the php.ini file is needed in every directory that runs a script of that kind. If you can elaborate on this it may help others. Thank you.
  5. discxpress

    Google XML Sitemap SEO

    Jack, I've got it to get this far: That's what happens when I run googlesitemap/index.php (of course you know that). What can I do about that fatal error? Tweak some code? Get host to make adjustments? Thank you for your help.
  6. discxpress

    Google XML Sitemap SEO

    Jack, I did increase the memory limit in php.ini file and that didn't work. So I found the php sleep line that you referenced in one of your posts. I used 'sleep (5);' in code breaks above the error line. That seemed to work. I guess. Because when I run the script in Firefox and IE, it doesn't give me an error but it gives me a blank page. Is there a way to determine if I resolved the issue successfully? I know I'm getting close. Thanks
  7. discxpress

    Google XML Sitemap SEO

    Hello, I installed the contribution per instructions. Here is the error that was displayed when I ran the index file: Fatal error: Allowed memory size of 419430400 bytes exhausted (tried to allocate 503316480 bytes) in /home4/discxpre/public_html/includes/classes/seo.class.php(1703) : eval()'d code on line 349526 Here is the area of code around line 1703 in seo.class.php: function get_cache($name = 'GLOBAL', $local_memory = false){ $select_list = 'cache_id, cache_language_id, cache_name, cache_data, cache_global, cache_gzip, cache_method, cache_date, cache_expires'; $global = ( $name == 'GLOBAL' ? true : false ); // was GLOBAL passed or is using the default? switch($name){ case 'GLOBAL': $this->cache_query = $this->DB->Query("SELECT ".$select_list." FROM cache WHERE cache_language_id='".(int)$this->languages_id."' AND cache_global='1'"); break; default: $this->cache_query = $this->DB->Query("SELECT ".$select_list." FROM cache WHERE cache_id='".md5($name)."' AND cache_language_id='".(int)$this->languages_id."'"); break; } # end switch ($name) $num_rows = $this->DB->NumRows($this->cache_query); if ( $num_rows ){ $container = array(); while($cache = $this->DB->FetchArray($this->cache_query)){ $cache_name = $cache['cache_name']; if ( $cache['cache_expires'] > date("Y-m-d H:i:s") ) { $cache_data = ( $cache['cache_gzip'] == 1 ? gzinflate(base64_decode($cache['cache_data'])) : stripslashes($cache['cache_data']) ); switch($cache['cache_method']){ case 'EVAL': // must be PHP code eval("$cache_data"); break; case 'ARRAY': $cache_data = unserialize($cache_data); case 'RETURN': default: break; } # end switch ($cache['cache_method']) if ($global) $container['GLOBAL'][$cache_name] = $cache_data; else $container[$cache_name] = $cache_data; // not global } else { // cache is expired if ($global) $container['GLOBAL'][$cache_name] = false; else $container[$cache_name] = false; }# end if ( $cache['cache_expires'] > date("Y-m-d H:i:s") ) if ( $this->keep_in_memory || $local_memory ) { if ($global) $this->data['GLOBAL'][$cache_name] = $container['GLOBAL'][$cache_name]; else $this->data[$cache_name] = $container[$cache_name]; } } # end while ($cache = $this->DB->FetchArray($this->cache_query)) unset($cache_data); $this->DB->Free($this->cache_query); switch (true) { case ($num_rows == 1): if ($global){ if ($container['GLOBAL'][$cache_name] == false || !isset($container['GLOBAL'][$cache_name])) return false; else return $container['GLOBAL'][$cache_name]; } else { // not global if ($container[$cache_name] == false || !isset($container[$cache_name])) return false; else return $container[$cache_name]; } # end if ($global) case ($num_rows > 1): default: return $container; break; }# end switch (true) } else { return false; }# end if ( $num_rows ) } # end function get_cache() Thanks for any help in advance.
  8. discxpress

    Automatically send data feed to Froogle

    Hello, I uploaded the latest version (V2.3). And I keep getting 'Error the data base does not exist'. What must I do to solve this issue? Thanks in advance
  9. discxpress

    Header Tags SEO

    Thanks Jack. One more question. Which products edit page are you referring to? Then I believe I can take it from there. Thanks again.
  10. discxpress

    Header Tags SEO

    I'm sorry Jack I guess I didn't ask the question correctly. What I'm seeking is to place a products info such as UPC number or other information in the description so bots can capture them. The search engine bots index my products' descriptions. Looking at Google analytics and similar websites listings for the same products, UPC numbers along with manufacturer/label info are keywords. They are ranked higher [in the top 10]. I know that alone doesn't increase pagerank but it helps when a surfer uses UPC numbers to shop. Please lead me in the right direction if possible. Thanks
  11. discxpress

    Header Tags SEO

    Hello Jack and all, I need to get UPC numbers in the description area. Is it possible for Header Tags SEO to combine the description and UPC fields or will they have to be combined via spreadsheet? If so, what code needs to be modified and how? I appreciate any help.
  12. Surfalot, Actually I must give credit to reading the documentation as the reason for solving the first issue. Once I tried the suggestion that was in the documentation and it actually worked. I got so excited that I didn't bother reading the rest. Also, I ran out of time. Thank you for all your continued support of EP.
  13. Surfalot, I have progress. I have solved the problem of EP not creating new categories and products by checking the header of my upload spreadsheet. Instead of v_categories_name_1_1, my header had v_categories_name_1. When I corrected that typo, I was able to upload my spreadsheet. Categories and products were created. I have only 2 important issues now. One is when I upload a spreadsheet, EP creates the same category multiple times. I am dealing with that issue with the Multiple Products Manager. The other issue is when I attempt to download a complete file to edit, I get a 500 Internal Server error. I will check with my host about the suggestions you made above. Thanks a million.
  14. Hello surfalot, I've tried the latest version of Easy Populate and a clean install of admin/categories.php with Header Tags SEO installed. I'm still unsuccessful at getting EP to create new products and categories on my website. The products are created in the database. What else should I look at to see why EP is not receiving queries from the database?
  15. I have a localhost database. If it would help any, my host migrated my site to a new server a couple of months ago and now easy populate won't pull all info from the database. For example, when I attempt to download a complete file to edit, I get this error: 2013-Lost connection to mysql server during query. Or when I upload products to the database, the new products will appear in the new products section and the last four on the spreadsheet will appear on the index page. However, new categories not being made and new products can't be found when using a specific keyword search. If I understand my problem correctly, the easy populate script can send information to the database but it can't receive information from the database. What should I have my host to check? They said they were going to look at mysql_slow_queries log files to check which queries were taking too long. They told me to look at the files but I don't understand those files. Here's a reply from an upper level tech: Dear Customer, Thanks for contacting us. We apologize for the trouble you've been having. What database is the script pulling information from, and how much information is it trying to retrieve from the database? If the script is taking a lot of information and the database has not been regularly maintained the query may be taking too long and may be timing out. To see if you have MySQL queries that are taking too long you can read the log files for slow queries, those can be found by opening your cpanel file manager to your home directory the going to ~/tmp/mysql_slow_queries. To have me look into this further I will need to have you validate your account by providing either the password on the account or the last four digits of the credit card on file. I hope this will help you to help me and others. Thanks for a prompt reply.
  16. This sums up my problems with Easy Populate. I can input items manually but that takes too much time. I'm guessing easypopulate.php won't query the database. Please help someone.
  17. Hello, I would also like to note that the server that my host has my site on has PHP version 4.4.9 and MySQL version 5.0.75. I get a "2013 Lost connection to MySQL during query" error. Is Easy Populate compatible with these versions? If not, what changes need to be made to the easypopulate file?
  18. Hello everyone. I need help figuring out why new products won't appear on the website, in the admin nor in search results. Also Easy Populate won't create new categories and doesn't appear in the breadcrumb either. The last four products on the spreadsheet will appear on the index page. I'm using version 2.6g and I have header tags SEO installed. I've tried turning HTC support on but still no difference.
  19. Thanks for the fast reply. That's exactly what I did. The overall file is a little over 14mb. I broke the files into about 2500 products and everything goes smooth. So, your theory about the about the file upload max may be true. When I talked to my host they told me that I could adjust any limitations on file uploads adjusting the max upload variables php.ini and copy it to every directory that EP exist in. In this case, it is only the admin directory. When I checked the php.ini file in the admin directory, the max upload variable was set at an amazing 2MBs! So, I adjusted it to a reasonable number. While I was making adjustments, I also adjusted the memory that a script may consume and the server timeouts to 600. At the moment, I don't have the time to tell you the results of the adjustments. Maybe what I just explained will help someone else with similar complications.
  20. Hello Surfalot, I've exhausted all my options. I have a store with 20,000 products. So, I know I must split the files manually or with EP. I chose to split files by EP. However, I can't get Easypopulate to Upload and Split files as it should. I have EP_EXCEL_SAFE_OUTPUT set to true so I saved as CSV (MS-DOS) per the instructions. Now I've compared the paths of the temp folder In Tools>Files to the path in the error messages. I don't see anything obvious that I could be missing something. (1) Here's the the paths of what's in the error messages and Tools->temp Tools->temp: /home/discxpre/public_html/temp/ Error messages: Warning: fopen(/home/discxpre/public_html/temp/EP2008Sep28-0303.csv) [function.fopen]: failed to open stream: No such file or directory in /home/discxpre/public_html/admin/easypopulate.php on line 1223 Warning: fgets(): supplied argument is not a valid stream resource in /home/discxpre/public_html/admin/easypopulate.php on line 1226 Creating file EP_Split1.csv ... Warning: fgets(): supplied argument is not a valid stream resource in /home/discxpre/public_html/admin/easypopulate.php on line 1236 Added 0 records and closing file... Warning: fclose(): supplied argument is not a valid stream resource in /home/discxpre/public_html/admin/easypopulate.php on line 1263 You can download your split files in the Tools/Files under /home/discxpre/public_html/temp/ (2) Here's a screenshot of my settings: These are the problems I experienced when trying to upload and split with Easypopulate. If you need anyomre info, please let me know. Thanks for reading and any help you provide.
  21. Hello, I installed this contribution with ease. No errors appeared. However, I get errors in Webmaster Tools about too many redirects. Also, I my category and product pages load very slow. It takes about 5 minutes to load. Maybe I've overlooked something As a precaution, I turned this contribution off until I receive advice on what to do. Thanks for reading.
  22. discxpress

    Header Tags SEO

    You're right. That would be a customization. I'll just go through the code and figure out how to get the title to append to the description tag just as it does to the keywords tag. Thanks for your reply.
  23. discxpress

    Header Tags SEO

    I guess another way of asking this would be: If possible, can the title be appended to the description tag? Sorry for any confusion.
  24. First, I would like to say great work! I know this will help with our duplicate content issues. I have two requests. I will wait on an update. (1) Whenever you have time, could you adjust the code so the page numbers could appear after the title? ALSO (2) Take a look at the All Products contribution, the duplicate content issue is partially solved there. What I mean is there are A through Z links that are at the top of allprods.php. All products group products alphabetically. Here is the code for allprods.php: <?php /* $Id: allprods.php,v 4.4 2006/09/18 20:28:47 Mgx Co. Exp $ All Products v4.3 MS 2.2 with Images http://www.oscommerce.com/community/contributions,1501 osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2004 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); include(DIR_WS_LANGUAGES . $language . '/' . FILENAME_ALLPRODS); $breadcrumb->add(HEADING_TITLE, tep_href_link(FILENAME_ALLPRODS, '', 'NONSSL')); $firstletter=$HTTP_GET_VARS['fl']; if (!$HTTP_GET_VARS['page']){ $where="where pd.products_name like '$firstletter%' AND p.products_status='1' "; }else { $where="where pd.products_name like '$firstletter%' AND p.products_status='1' "; } ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <?php if (!isset($lng) || (isset($lng) && !is_object($lng))) { include(DIR_WS_CLASSES . 'language.php'); $lng = new language; } reset($lng->catalog_languages); while (list($key, $value) = each($lng->catalog_languages)) { ?> <link rel="alternate" type="application/rss+xml" title="<?php echo STORE_NAME . ' - ' . BOX_INFORMATION_RSS; ?>" href="<?php echo FILENAME_RSS, '?language=' . $key; ?>"> <?php } ?> <?php // BOF: WebMakers.com Changed: Header Tag Controller v2.55 // Replaced by header_tags.php if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) { ob_start(); require(DIR_WS_INCLUDES . 'header_tags.php'); $preventDuplicates->checkTarget(ob_get_clean()); echo $preventDuplicates->finalMeta . "\n"; } else { ?> <title><?php echo TITLE ?></title> <?php } // EOF: WebMakers.com Changed: Header Tag Controller v1.0 ?> <base href="<?php echo (getenv('HTTPS') == 'on' ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="3" cellpadding="3"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <td class="col_left"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </td> </table></td> <!-- body_text //--> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <?php if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) {?> <td><h1><?php echo HEADING_TITLE; ?></h1></td> <?php } else { ?> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <?php } ?> <td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_products_new.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> <tr> <td class="main"><?php echo HEADING_SUB_TEXT; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> </table></td> </tr> <tr> <td align="center" class="smallText"><?php $firstletter_nav= '<a href="' . tep_href_link("allprods.php", 'fl=A', 'NONSSL') . '"> A |</A>' . '<a href="' . tep_href_link("allprods.php", 'fl=B', 'NONSSL') . '"> B |</A>' . '<a href="' . tep_href_link("allprods.php", 'fl=C', 'NONSSL') . '"> C |</A>' . '<a href="' . tep_href_link("allprods.php", 'fl=D', 'NONSSL') . '"> D |</A>' . '<a href="' . tep_href_link("allprods.php", 'fl=E', 'NONSSL') . '"> E |</A>' . '<a href="' . tep_href_link("allprods.php", 'fl=F', 'NONSSL') . '"> F |</A>' . '<a href="' . tep_href_link("allprods.php", 'fl=G', 'NONSSL') . '"> G |</A>' . '<a href="' . tep_href_link("allprods.php", 'fl=H', 'NONSSL') . '"> H |</A>' . '<a href="' . tep_href_link("allprods.php", 'fl=I', 'NONSSL') . '"> I |</A>' . '<a href="' . tep_href_link("allprods.php", 'fl=J', 'NONSSL') . '"> J |</A>' . '<a href="' . tep_href_link("allprods.php", 'fl=K', 'NONSSL') . '"> K |</A>' . '<a href="' . tep_href_link("allprods.php", 'fl=L', 'NONSSL') . '"> L |</A>' . '<a href="' . tep_href_link("allprods.php", 'fl=M', 'NONSSL') . '"> M |</A>' . '<a href="' . tep_href_link("allprods.php", 'fl=N', 'NONSSL') . '"> N |</A>' . '<a href="' . tep_href_link("allprods.php", 'fl=O', 'NONSSL') . '"> O |</A>' . '<a href="' . tep_href_link("allprods.php", 'fl=P', 'NONSSL') . '"> P |</A>' . '<a href="' . tep_href_link("allprods.php", 'fl=Q', 'NONSSL') . '"> Q |</A>' . '<a href="' . tep_href_link("allprods.php", 'fl=R', 'NONSSL') . '"> R |</A>' . '<a href="' . tep_href_link("allprods.php", 'fl=S', 'NONSSL') . '"> S |</A>' . '<a href="' . tep_href_link("allprods.php", 'fl=T', 'NONSSL') . '"> T |</A>' . '<a href="' . tep_href_link("allprods.php", 'fl=U', 'NONSSL') . '"> U |</A>' . '<a href="' . tep_href_link("allprods.php", 'fl=V', 'NONSSL') . '"> V |</A>' . '<a href="' . tep_href_link("allprods.php", 'fl=W', 'NONSSL') . '"> W |</A>' . '<a href="' . tep_href_link("allprods.php", 'fl=X', 'NONSSL') . '"> X |</A>' . '<a href="' . tep_href_link("allprods.php", 'fl=Y', 'NONSSL') . '"> Y |</A>' . '<a href="' . tep_href_link("allprods.php", 'fl=Z', 'NONSSL') . '"> Z</A> ' . '<a href="' . tep_href_link("allprods.php", '', 'NONSSL') . '"> FULL</A>'; echo $firstletter_nav; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td> <?php // create column list $define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL, 'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME, 'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER, 'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE, 'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY, 'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT, 'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE, 'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW); asort($define_list); $column_list = array(); reset($define_list); while (list($column, $value) = each($define_list)) { if ($value) $column_list[] = $column; } $select_column_list = ''; for ($col=0, $n=sizeof($column_list); $col<$n; $col++) { if ( ($column_list[$col] == 'PRODUCT_LIST_BUY_NOW') || ($column_list[$col] == 'PRODUCT_LIST_NAME') || ($column_list[$col] == 'PRODUCT_LIST_PRICE') ) { continue; } } // listing all products $listing_sql = "select p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id $where order by pd.products_name"; if (ALL_PRODUCTS_DISPLAY_MODE == 'true') include(DIR_WS_MODULES . 'product_listing.php'); //display in standard format else include(DIR_WS_MODULES . 'allprods.php'); ?> </td> </tr> </table></td> <!-- body_text_eof //--> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- right_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_right.php'); ?> <!-- right_navigation_eof //--> </table></td> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> <br> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> Thanks for reading.
  25. Thanks for refreshing my memory! I found that contrib the other night but remembered being tired and sleepy so it slipped my mind. I will install and hope it works. You've been contributing some great projects lately. Thanks again.
×