Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Eaviator

Pioneers
  • Posts

    68
  • Joined

  • Last visited

1 Follower

About Eaviator

  • Birthday 06/01/1955

Profile Information

  • Real Name
    Doug Burt
  • Gender
    Male
  • Location
    West Vancouver, BC ~ Lotus Land Liver ~
  • Interests
    Radio controlled model aircraft, computer's, web design, Jack Russell Terriers

Eaviator's Achievements

  1. Hi Kevin, QPBPP v2.3.1 is definitely a full package, go ahead and install it as written, it's great. My problems occured because of conflict's with another add-on and some lines of code which had to be merged. QPBPP works great, no problems whatsover for a plain install though. Just back everything up first so in the event of problem you can resolve it quickly without any grief. Hope this helps... Cheers, Doug
  2. The Category Description v.1.8 add-on could possibly be changed so that this could be done in the Admin Cpanel, as an add-on selection to the Categories/Products - Products section. I think it should be fairly easy to add it to the admin section and then let your client configure it from there. Is your client able to access and use the Admin Cpanel OK already, John? Would that be what you're looking for as far as a better add-on goes? Cheers, DougB
  3. Sounds Good Jack, again many thanks for all your help here, it's been a pain at times but I finally got the hang of this one, with a lot of your help that is...! Cheers, DougB
  4. Jack, please ignore my previous post, I've just downloaded the latest version v3.2.6 and lo and behold right there in front of me is exactly what I was missing...It's now in and the add-on is working great. Now all I can do is scratch my head wondering where the heck I got the original instructions I was using from...damn. Next question is should I follow the whole installation through one more time to insure I get the updates. At this point I haven't yet started populating the site with products so that will make it pretty easy. Or will just running the new database changes do it for me? Much appreciated again as usual... Cheers DougB
  5. Funny the first step in my installation instructions in Install_Catalog.txt actually refer's to changes to the index.php, not the template_top.php file at all... As a matter of fact there are no changes noted to the template_top.php file anywhere's in the Install_Catalog section. The only set of instructions even remotely associated with anything like template_top.php files are in the Admin side of the instructions at Step 8 (admin/includes/template_top.php). Did I get a bad set of instructions out of this somehow and if so, where can I get the good set to download? Thanks again Jack, it really is appreciated more than you'll know. Cheers, DougB
  6. I just noticed something here, in the Install_Admin instructions Step 8) it say's "In admin/includes/template_top.php" but you didn't say that in the post above, you said "includes/template_top.php"...is there a mixup in your instructions or did you actually mean admin/includes/template_top.php, because if so there are no instructions in either the Catalog or Admin install that says for us to do this? Cheers, DougB
  7. Hey Jack, Here's the code from my head section in the admin/includes/template_top.php file. Is this correct? <?php /* $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2010 osCommerce Released under the GNU General Public License */ ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <meta name="robots" content="noindex,nofollow"> <title><?php echo TITLE; ?></title> <base href="<?php echo HTTP_SERVER . DIR_WS_ADMIN; ?>" /> <!--[if IE]><script type="text/javascript" src="<?php echo tep_catalog_href_link('ext/flot/excanvas.min.js'); ?>"></script><![endif]--> <link rel="stylesheet" type="text/css" href="<?php echo tep_catalog_href_link('ext/jquery/ui/redmond/jquery-ui-1.8.6.css'); ?>"> <script type="text/javascript" src="<?php echo tep_catalog_href_link('ext/jquery/jquery-1.4.2.min.js'); ?>"></script> <script type="text/javascript" src="<?php echo tep_catalog_href_link('ext/jquery/ui/jquery-ui-1.8.6.min.js'); ?>"></script> <?php if (tep_not_null(JQUERY_DATEPICKER_I18N_CODE)) { ?> <script type="text/javascript" src="<?php echo tep_catalog_href_link('ext/jquery/ui/i18n/jquery.ui.datepicker-' . JQUERY_DATEPICKER_I18N_CODE . '.js'); ?>"></script> <script type="text/javascript"> $.datepicker.setDefaults($.datepicker.regional['<?php echo JQUERY_DATEPICKER_I18N_CODE; ?>']); </script> <?php } ?> <script type="text/javascript" src="<?php echo tep_catalog_href_link('ext/flot/jquery.flot.js'); ?>"></script> <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> <script type="text/javascript" src="includes/general.js"></script> <?php /*** Begin Header Tags SEO ***/ switch (HEADER_TAGS_ENABLE_HTML_EDITOR) { case 'CKEditor': echo '<script type="text/javascript" src="./ckeditor/ckeditor.js"></script>'; break; case 'FCKEditor': break; case 'TinyMCE': if (HEADER_TAGS_ENABLE_HTML_EDITOR != 'No Editor' && (HEADER_TAGS_ENABLE_EDITOR_META_DESC == 'true' || HEADER_TAGS_ENABLE_EDITOR_CATEGORIES == 'true' || HEADER_TAGS_ENABLE_EDITOR_PRODUCTS == 'true')) { if ($action == 'new_product' || $action == 'new_category' || $action == 'edit_category') { // No need to put JS on all pages. $languages = tep_get_languages(); // Get all languages // Build list of textareas to convert $str = ''; for ($i = 0, $n = sizeof($languages); $i < $n; $i++) { if (HEADER_TAGS_ENABLE_EDITOR_META_DESC == 'true') $str .= "products_head_desc_tag[".$languages[$i]['id']."],"; if (HEADER_TAGS_ENABLE_EDITOR_CATEGORIES == 'true') $str .= "categories_htc_description[".$languages[$i]['id']."],"; if (HEADER_TAGS_ENABLE_EDITOR_PRODUCTS == 'true') $str .= "products_description[".$languages[$i]['id']."],"; } //end for each language $mce_str = rtrim ($str,","); // Removed the last comma from the string. // You can add more textareas to convert in the $str, be careful that they are all separated by a comma. echo '<script language="javascript" type="text/javascript" src="includes/javascript/tiny_mce/tiny_mce.js"></script>'; include "includes/javascript/tiny_mce/general.php"; } } break; default: break; } /*** End Header Tags SEO ***/ ?> </head> As I've said I've gone through literally everything you've told us to do with this install meticulously from end to end. At this point I'm ready to pull it down and start again, which is quite a bit of work as you can imagine. I don't know...what do you think, should I go this route or is there another way of solving it? Thanks Jack I appreciate your help here... DougB
  8. Hi Jack, No I never saw the "Replace me in Page Control" at any time during the installation. When I type something in the Page Control title and then go to the page and view source it hasn't changed. I followed the instructions to the letter, right from the start. The only one glitch I had in the install was that the QPBB file and Header Tags used the same line in two instance in the admin/categories file as was previously noted here in this thread but after the SQL probelms were corrected everything seemed to be operating OK or at least so I thought. As I'm using osC v.2.3.1, I used the set of instructions for v2.3.+ and the non-new install version as I already had set up the QBPP add-on. As noted, prior to this I'd literally gone through every file in the install a second time, comparing the original files to the modified ones and in every instance the files have been correct as per the instructions...At this point I don't know where to turn, what do you suggest doing?. Many thanks in advance Jack... Cheers, DougB
  9. Afternoon Everyone, I'm having really problems with my installation of Header Tags SEO, it's not populating the meta tags, product descriptions etc. in the <head> section of my site. It's v2.3.1 with Quantity Price Breaks code installed prior to this. No other modifications to the stock code. I've tested the install, using the Test function in Header Tags SEO and it tells me "product_info.php is missing Header Tags code or it is not installed correctly. Verify that Fill Tags has been ran and that the root checkbox or the default checkboxes have been checked in Page Control." I've just today finished going through every single piece of the installation once more. I've verified that every single page is accurate to the instructions given, all files are located in their correct folder's and that the database was un-installed and then re-run, just to make sure everything was correct before yelling for help. I've also followed the install directions to run the "Fill Tag's function, and then checked that the default checkboxes in Page Control were also checked. I've gone through this installation sideways, forwards and backwards now, trying to fix it myself and I'm lost....can anyone out there help me please..... Cheers, DougB
  10. The problem for me was it involved merging of two lines of code from two different add-on's, your's and a quantity price breaks one that I had already inserted. Part of your code also involved two of the same lines of code QPBB used for their add-on. Unfortunately for me, although I have WinMerge I can't use it worth crap, so I wasn't sure which was the correct way to merge the two files. I finally took a shot at doing it manually and ended up with the mess I now have. I still have both original files handy (there were two instances of code overlap) though if you'd like to take a crack at it, (I know you use WinMerge all the time and probably would get the right results instead of my mangled version). Here's the original codes that were modified from the stock v.2.3.1 catalog/admin/categories.php file to the QPBB add-on: Instance 1 code: $product_query = tep_db_query("select pd.products_name, pd.products_description, / pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag, pd.products_url,/ p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_qty_blocks, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id, ptdc.discount_categories_id from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_TO_DISCOUNT_CATEGORIES . " ptdc on p.products_id = ptdc.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'"); Here's what Header Tag SEO code needed to be installed into this line: $product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, /p.products_qty_blocks/, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'"); Instance 2 code: (original QPBB modified code) $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_qty_blocks, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id, ptdc.discount_categories_id, dc.discount_categories_name from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_TO_DISCOUNT_CATEGORIES . " ptdc on p.products_id = ptdc.products_id left join " . TABLE_DISCOUNT_CATEGORIES . " dc using(discount_categories_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'"); and what Header Tags SEO code needed to be added into this line: $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'"); Anyone willing to take a shot at it is welcome to help out, I'd really appreciate any help you care to throw my way in getting this mess sorted out...thank's Jack, and everyone else too of course ... DougB
  11. Hey Jack, thanks for the find, now do I remove the first instance of the code or the second... or does it make any difference to the running of the program? Thanks a million in advance, much appreciated indeed... DougB
  12. OK, I now have run into a problem. While I was checking my SEO for a product and was editing it I have run into this code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from products p left join products_to_discount_categories ptdc on p.products_id ' at line 1 select pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_qty_blocks, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from products p, ptdc.discount_categories_id from products p left join products_to_discount_categories ptdc on p.products_id = ptdc.products_id, products_description pd where p.products_id = '39' and p.products_id = pd.products_id and pd.language_id = '1' [TEP STOP] Can someone help me figure out what's causing it. I suspect that it's the catalog/admin/categories.php query that I asked about a couple of pages back because this is where the code resides, can someone help me figure out what I've done wrong here? Many thanks in advance all, much appreciated. DougB
  13. Sorry Jack, Oh geez, I've just have realized this may not be part of your add-on at all now but rather the site. What I meant was regarding the Category name overall, where it's shows within the "Categories Box" on my site it's name is shortened to a total of 32 character's overall, I'd like for that to show at least 40 character's in length. The second question regards the layout within that same Categories box, I'd like to place a horizontal rule directly beneath each of the Category names shown, is there any way to do this? Sorry to be so confusing, I didn't really think about how I worded this question to you...a real D'oh moment I guess. If you're able to help that would be great, thanks in advance. DougB
  14. Hey Jack, I have two, probably dumb, questions for you. It concerns a couple of slight modifications I'd like to make to your Header Tag's SEO add-on. First, I would like to be able to add about 10 more character's into the Description title field. I'm assuming that would be done in the database but I couldn't find the appropriate section to do this too. Whoops I just saw it above in one of the previous posts, would this code be applicable for the change using a SQL query?: drop table if exists categories_description; create table categories_description ( categories_id int(11) default '0' not null , language_id int(11) default '1' not null , categories_name varchar(40) not null , categories_htc_title_tag varchar(80) , categories_htc_desc_tag longtext , categories_htc_keywords_tag longtext , categories_htc_description longtext , PRIMARY KEY (categories_id, language_id), KEY idx_categories_name (categories_name) ); Now still secondly, I'd like to be able to add a horizontal rule under each of the descriptions, right at the very end. Can you help show me the way to do this? Many thanks indeed. DougB
  15. Good Morning Jack, Just wanted to show my appreciation and say thanks for helping me walk through this contribution's installation, everything now works slick as a whistle, much in part due to your help, many thanks again. The merged lines of code worked flawlessly, although I couldn't get WinMerge to work properly for me, 'nother learning curve there I expect but that's for another day. As long as I got it done the hard way and it's working, that's fantastic and my SEO problems, at least for this site are now solved as well. Much thanks amigo... Cheers, DougB
×
×
  • Create New...