Jump to content

discxpress

Members
  • Content count

    844
  • Joined

  • Last visited

  • Days Won

    6

Everything posted by discxpress

  1. 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?
  2. 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.
  3. 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.
  4. 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?
  5. 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.
  6. 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.
  7. 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.
  8. 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.
  9. 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.
  10. 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.
  11. 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.
  12. 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.
  13. Hello, Any files you download are downloaded in the .zip format. So you would need a program such as Winzip to unzip the downloaded file. Once unzipped you be able to open the folder and find all files you need including instructions. Hope that helps.
  14. discxpress

    Header Tags SEO

    I apologize for being vague in my question. If you follow this link below and view the page source with your browser, hopefully you would be able to see what I'm talking about. I was just wondering if the page title could be auto generated in the description and keywords meta tags. I know it is possible to place page title in the keyword tags with Header Tags SEO because I accomplished that by making adjustments in text control. http://www.cduniverse.com/productinfo.asp?...;cart=775224046 After viewing page source, you should notice that the artist name and album title are mentioned 3 times in the meta tags. Also, the artist name and album title is saturated throughout the page, so the text does support the meta tags. Selling media is a more detailed approach than selling general items. I have my work cut out. In the description meta tag, the artist name is mentioned first followed by some other text. I was wanting know if HT SEO could do the same with some minor code tweaking. More importantly, I would have to get album titles and artist names to echo several times throughout the page. I'm not trying to beat out the competition yet. I'm seeking to perform better in the search engine results. Thanks for taking a look and fast replies.
  15. Hello everyone, I have Ultimate SEO Urls installed and some of my pages are being flagged for duplicate content i.e. duplicate meta descriptions and duplicate title tags. I've just discovered that categories with multiple pages are the main ones getting flagged. Urls like: http://www.mysite.com/-c-3.html & http://www.mysite.com/-c-3.html?page=2&amp...=2a&op=list are being flagged for duplicate titles and thus duplicate descriptions. They are indeed different pages, but with the use Header Tags SEO, same titles are generated. My goal is to have Category Page 1, Category Page 2 as titles for multiple pages. Is there any fix so Ultimate SEO Urls can handle 'page=2&sort=2a&op=list' better and give a better title in Header Tags SEO? Please help or post a link to a possible solution. I have searched all over this thread but I'm a php novice and don't know if I found the remedy or not. Thanks for reading and any help given.
  16. discxpress

    Header Tags SEO

    After studying the reasons that my pages were flagged for duplicate title tags: (1) Categories that have more than one page. The link has page=2&sort=2a&opt=list appended. I have Ultimate SEO Urls by Chemo installed. This also evident with All Products, if you have that installed. (2) Sub-categories with the same name but listed under different categories. For example, Sub-cat "action" under Movies category would have the same title as sub-cat "action" under the Video Games category. Reasons I believed for being flagged for Duplicate meta descriptions: (1) Products that appear in a list besides its product page would be flagged because it has 'op=list' appended to the url and would indeed have the same description. (2) More than one product that have the same description such as 'No description available'. I should have known that was a no-no. My conclusion is Ultimate SEO Urls have a minor issue with how category urls are rendered & it maybe cause a minor conflict with Header Tags SEO. Hopefully I have shed some light to those who have Ultimate SEO Urls & Header Tags SEO installed. I acknowledge this may be the wrong place to post this issue so I will create a post in tips & tricks to this post so it may help others.
  17. discxpress

    Header Tags SEO

    Hello Jack, Is this scenario possible with Header Tags SEO? On most competitor's websites that sell the same products as myself, I've noticed the same things when I view the page source. This is how their meta tags are set up or generated: <title>Artist CD Title</title> <meta name="description" content="Artist CD Title on sale for $9.99 at [website] then it gives an excerpt from the actual description"> <meta name="keywords" content="Artist CD Title followed by a list of keywords"> (1) To me that is a strange generation of meta tag content (2) Obviously it works because all the competitor's I compared were on the first two pages of Google's search results. I used to have better or just as good placement. I know that doesn't substitute for well written content and good page structure. I guess another question would be how SE bots read webpage content? Left to right, top to bottom as humans do or in some specially programmed manner. Would that be a possible solution to the duplicate content issue I've been concerned about in the other forum? I'm trying to get my website ready for the holiday season and want it to be in good shape. Also, it seems my website is being visited by googlebot often and its constantly updating content daily. Thanks for any help and/or guidance.
  18. discxpress

    SEO Assistant

    Adding that feature would be great and make others feel better. Google being the leading SE, most SEO efforts and modifications are built around Google's policies. Maybe one day you could place a feature in SEO Assistant first that could find which pages are flagged by Google as Duplicate Content. This may help others: Log in to your Google account if you have one and go to Webmaster tools. Click on the website for which you have submitted a sitemap. Once there, click on 'content analysis'. If you have any pages flagged for duplicate content, they would be found there. At the moment I have pages flagged for duplicate meta descriptions, short meta descriptions, missing title tags, and duplicate title tags. I included this information so it may help someone solve these isses they may be experiencing. Also, hopefully Jack can add features to both Header Tags SEO and SEO Assistant to help us out with these issues. Thanks for any help and comments.
  19. discxpress

    SEO Assistant

    Thanks for the reply. I was simply giving the link to the article to get a better understanding for myself and others who may be intimidated by Google's policies on duplicate content. After installing this contribution and Header Tags SEO, I'm more comfortable about the content of my pages. I believe it solved my duplicate content issue. One thing is for sure, SEO is an going process. Maybe after Googlebot crawls my site again some of the flagged pages would get 'de-flagged'. The contribution you referred me to is kind of vague in its purpose to me or my lack of knowledge of SEO could be the factor. I may install and draw my own conclusion. I installed SEO Assistant and none of my pages are in the supplimental index so I believe my rankings in search results have suffered due to Lack of content and lack of keyword distribution. I installed both SEO Assistant & Header Tags SEO. Great work. Please forgive me for sounding like a dunce in my previous post. I was just alarmed. Thanks for responding.
  20. discxpress

    SEO Assistant

    Hello Jack (or anyone that supports the idea) The following url leads to an article that talks about Google saying that no sites will be penalized for duplicate content but they will be affected. After looking in Webmaster Tools in my Google account I found that Google flagged several pages for duplicate content, titles and meta tags. http://www.lilengine.com/news/google-dupli...this-issue-480/ How can this be fixed? Is there any way to use Header Tags Controller to avoid duplicate content? Sounds like a job for Jack! Can a contribution be made to avoid duplicate content? Thanks for any thoughts and comments.
  21. discxpress

    Manual Order Maker

    Thanks for the reply. I was figuring maybe placing a field at the top of create_order.php, for example, "admin id". Also, the admin should nt be able to proceed until a correct ID Then after that, link that to the monthly sales report contribution so sales data can be exported in excel. I have some ideas but I'm quite a novice at PHP. I know how to install contribs and solve errors. Maybe add a field to the SQL query in an update version or the database table name admin_id. I hope this can be accomplished in th near future. Thanks again.
  22. discxpress

    Manual Order Maker

    Hello, I've installed this contrib and it works great so far. At the moment, I haven't installed the latest update. I'm planning on taking phone orders soon. I'm wondering if you could add some code that would have the salesperson to enter a name or code when taking an order that would allow me to determine which salesperson entered an order. I need this in case if there is a problem with an order and I know who to ask about it. And for salesperson tracking purposes such as commission and other activities. And of course generate a report. If possible, later I would like to link this to a multi level contrib. Basically, I would like to create a new user with limited admin access and create a code for that person if he/she takes an order over the phone. Thanks. Hope I was clear enough with my request.
  23. Has anyone seen any success with this contribution? I'm wondering if this will help with page ranking and thus help avoid being sandboxed by Google. I know when you're in the sandbox your organic results visitors will suffer. This sounds like a great solution to SEO headaches. What about performance in organic search results? Any improvements? Thanks for your comments.
  24. Hello, I have version 2.76e installed. When I try to download a text file to edit I get this error: Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /home/discxpre/public_html/admin/easypopulate.php on line 600 Here is the line of code the error is referring to: $row2 = array_merge($row2, tep_db_fetch_array($result2)); It also happens when I try to download to temp directory. I've read that it could be the array_merge function is incompatible with PHP5. If anyone can help with this code, please do. Any help is appreciated. Or should I download the latest best version?
  25. discxpress

    Dynamic SiteMap

    I have this same problem. Does anyone have a fix for this? I think Google has a problem with the ? because it says that the ? means the page is dynamic. Thanks for any help.
×