lee246 Posted August 4, 2005 Share Posted August 4, 2005 Hi, I have just installed the allprods v4 contribution and all seemed fine until i tried to click on an item, I am now getting the following error: 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 'and c.parent_id = '1' and c.categories_id = cd.categories_id an select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where and c.parent_id = '1' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name [TEP STOP] Does anyone have any ideas? Thanks. Quote Link to comment Share on other sites More sharing options...
lee246 Posted August 4, 2005 Author Share Posted August 4, 2005 Anyone please? Quote Link to comment Share on other sites More sharing options...
lee246 Posted August 4, 2005 Author Share Posted August 4, 2005 Surely someone must have had this problem? Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted August 4, 2005 Share Posted August 4, 2005 There is a problem with the includes/boxes/categories.php file. I've uploaded a new version. You can just copy that file to uprade your version. See if that fixes it for you. Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
lee246 Posted August 5, 2005 Author Share Posted August 5, 2005 That fixed it, thanks a lot Jack. Much appreciated!!! Quote Link to comment Share on other sites More sharing options...
keress Posted September 12, 2005 Share Posted September 12, 2005 I've just installed AllProds and it's working well, with the exception of the subheading, which is reading "HEAD_DESC_TAG_ALLPRODS." The meta tags are similarly worded. It looks like a define is missing, but I can't see what I could have missed. I've doubled checked and I don't seem to have left anything out. Thanks for any help. Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted September 12, 2005 Share Posted September 12, 2005 Find the following in the allprods.php file <tr class="AllProducts"> <td class="AllProducts"><?php echo HEAD_DESC_TAG_ALLPRODS; ?></td> and replace it with <tr class="main"> <td class="main"><?php echo HEADING_SUB_TEXT; ?></td> Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
keress Posted September 14, 2005 Share Posted September 14, 2005 Thanks a MILLION! Now, if I can get one more little thing fixed I'm done with this project. There's the same problem with the header tags. My source code for this page reads: <title>HEAD_TITLE_TAG_ALLPRODS</title> <META NAME="Description" Content="HEAD_DESC_TAG_ALLPRODS"> <META NAME="Keywords" CONTENT="HEAD_KEY_TAG_ALLPRODS"> Did I miss an update or something? How come these things aren't defined? Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted September 15, 2005 Share Posted September 15, 2005 They are defined. You missed a step it seems. See stpes 6 & 7 in the instruction file. Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
keress Posted September 15, 2005 Share Posted September 15, 2005 I just did these two steps, the 7th I found confusing. In the header_tags.php file there were two, almost identical sequences of code. First I added the defining text to the sequence called for in the instructions, nothing changed. My meta tags were still just reading variables. Then I tried filling in the defining text for both sequences, still no change. I've included it here. // ALLPRODS.PHP case (strstr($_SERVER['PHP_SELF'],FILENAME_ALLPRODS) or strstr($PHP_SELF,FILENAME_ALLPRODS) ): $the_category_query = tep_db_query("select cd.categories_name from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . $current_category_id . "' and cd.categories_id = '" . $current_category_id . "' and cd.language_id = '" . $languages_id . "'"); $the_category = tep_db_fetch_array($the_category_query); $the_manufacturers_query= tep_db_query("select manufacturers_name from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . $HTTP_GET_VARS['manufacturers_id'] . "'"); $the_manufacturers = tep_db_fetch_array($the_manufacturers_query); if (HTDA_ALLPRODS_ON=='1') { $tags_array['desc']= HEAD_DESC_TAG_ALLPRODS . 'The finest in collectible, Art Deco, antique, vintage radios in catalin, bakelite and wood, clocks and more ' . HEAD_DESC_TAG_ALL; } else { $tags_array['desc']= HEAD_DESC_TAG_ALLPRODS; } if (HTKA_ALLPRODS_ON=='1') { $tags_array['keywords']= HEAD_KEY_TAG_ALL . 'collectible antique Art Deco vintage old radios catalin bakelite wood clocks ' . HEAD_KEY_TAG_ALLPRODS; } else { $tags_array['keywords']= HEAD_KEY_TAG_ALLPRODS; } if (HTTA_ALLPRODS_ON=='1') { $tags_array['title']= HEAD_TITLE_TAG_ALLPRODS . 'Antique, Art Deco, Vintage Radios, Clocks and more in Catalin, Bakelite and Wood' . HEAD_TITLE_TAG_ALL . " " . $the_category['categories_name'] . $the_manufacturers['manufacturers_name']; } else { $tags_array['title']= HEAD_TITLE_TAG_ALLPRODS; } break; // products_all.PHP case (strstr($_SERVER['PHP_SELF'],FILENAME_PRODUCTS_ALL) or strstr($PHP_SELF,FILENAME_PRODUCTS_ALL) ): $the_category_query = tep_db_query("select cd.categories_name from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . $current_category_id . "' and cd.categories_id = '" . $current_category_id . "' and cd.language_id = '" . $languages_id . "'"); $the_category = tep_db_fetch_array($the_category_query); $the_manufacturers_query= tep_db_query("select manufacturers_name from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . $HTTP_GET_VARS['manufacturers_id'] . "'"); $the_manufacturers = tep_db_fetch_array($the_manufacturers_query); if (HTDA_PRODUCTS_ALL_ON=='1') { $tags_array['desc']= HEAD_DESC_TAG_PRODUCTS_ALL . 'The finest in collectible, Art Deco, antique, vintage radios in catalin, bakelite and wood, clocks and more ' . HEAD_DESC_TAG_ALL; } else { $tags_array['desc']= HEAD_DESC_TAG_PRODUCTS_ALL; } if (HTKA_PRODUCTS_ALL_ON=='1') { $tags_array['keywords']= HEAD_KEY_TAG_ALL . 'collectible antique Art Deco vintage old radios catalin bakelite wood clocks ' . HEAD_KEY_TAG_PRODUCTS_ALL; } else { $tags_array['keywords']= HEAD_KEY_TAG_PRODUCTS_ALL; } if (HTTA_ALLPRODS_ON=='1') { $tags_array['title']= HEAD_TITLE_TAG_PRODUCTS_ALL . 'Antique, Art Deco, Vintage Radios, Clocks and more in Catalin, Bakelite and Wood' . HEAD_TITLE_TAG_ALL . " " . $the_category['categories_name'] . $the_manufacturers['manufacturers_name']; } else { $tags_array['title']= HEAD_TITLE_TAG_PRODUCTS_ALL; } break; Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted September 16, 2005 Share Posted September 16, 2005 Is your All Priducts page et up to use header tags? Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
keress Posted September 18, 2005 Share Posted September 18, 2005 By that do you mean do I have the following code in my allprods.php page? // BOF: WebMakers.com Changed: Header Tag Controller v1.0 // Replaced by header_tags.php if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) { require(DIR_WS_INCLUDES . 'header_tags.php'); } else { ?> <title><?php echo TITLE ?></title> <?php } // EOF: WebMakers.com Changed: Header Tag Controller v1.0 ?> Yes, I do. Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted September 18, 2005 Share Posted September 18, 2005 Please post your english/header_tags.php file. Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
keress Posted September 18, 2005 Share Posted September 18, 2005 I've got it straight. I re-uploaded the header_tags.php, then played around with the header tags admin till I got a better idea how it all works. Thanks! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.