thejudge99 Posted April 23, 2012 Author Share Posted April 23, 2012 (edited) Hi ilyadgonbad this addon is written for 2.3.1 - i pressume you're trying it for an older version , one that doesnt have this function. If that is the only error you have you could try hard coding the complette URL <!-- start Product Fields group tab --> <link rel="stylesheet" type="text/css" href="PATH_TO_MY_CSS/ext/jquery/ui/redmond/jquery-ui-1.8.19.custom.css"> <!-- end Product Fields group tab --> where PATH_TO_MY_CSS is probably "catalog" - having never used an older version cannot say if that is the case. If you do indeed have other errors then i would suggest upgrading your oscommerce. Jules Edited April 23, 2012 by thejudge99 Quote Link to comment Share on other sites More sharing options...
ce7 Posted August 10, 2012 Share Posted August 10, 2012 Hi Julian I got the error message as below: 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 'select p.products_id, pd.products_name, p' at line 1 select count(*) as total select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price_cost, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p2c.categories_id, p.products_fields_group_id , pfgn.products_fields_group_name from products p, products_description pd, products_to_categories p2c , products p LEFT JOIN products_fields_groups_names pfgn on p.products_fields_group_id = pfgn.products_fields_group_id and pfgn.language_id = '1' where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and pd.products_name like '%test 182%' also when I tried to edit product with product field group, and save it, I can see it at the back end, but it doesn't show one website. I can PM you my web if you need to have a look. Thanks Lyn Quote Link to comment Share on other sites More sharing options...
thejudge99 Posted August 12, 2012 Author Share Posted August 12, 2012 (edited) hi - could you tell me where exactly you get this error edit: you have 2 selects on the 1st line try removing the select count(*) as total Edited August 12, 2012 by thejudge99 Quote Link to comment Share on other sites More sharing options...
thejudge99 Posted August 12, 2012 Author Share Posted August 12, 2012 (edited) ok replace as total select with as total , replace from products p, products_description with from products_description you also have a p.products_price in there which i assume is part of another addon the main actual query you will find in 6h catalog/admin/categories.php jules Edited August 12, 2012 by thejudge99 Quote Link to comment Share on other sites More sharing options...
ce7 Posted August 26, 2012 Share Posted August 26, 2012 Hi Jules, Sorry for late reply. I was trying to solve problem with product image. I had tried to modify the admin/categories.php as you suggested and it works great now. Thank you so much for your help! regards, Lyn (the error happen when I tried to search product in categories/products, after comment out the products p, it works great!) Quote Link to comment Share on other sites More sharing options...
srirahandcraft Posted September 28, 2012 Share Posted September 28, 2012 Hi Jules, I have a small problem and have not been able to find it. After adding a new language, the review tab doesn't pick up this language (I already checked in the source view and the language variable for the new language isn't there), this results in jumping back to the index page when clicking on the review tab. Other languages are fine and the contribution is running fine too. I appreciate your help, Thanks. Gerhard Quote Addons installed on my website: - Addons Installed - Advanced Special Offer Discounts - AJAX-Attribute Manager for osc 2.3.1 - Banner box v1.1.1 - Dutch Language Pack - Extra Pages-info box with admin for OSC2.3 - German Language Pack - Login Box - Multi-language Support for Configuration - Multiple products manager - Order Editor - OSC PDF Catalogue 2.1 - PDF-Datasheet - product Field Groups - Quickly Update Product Stock - Unit of weight - YAG (Yet another Guestbook) Link to comment Share on other sites More sharing options...
thejudge99 Posted September 28, 2012 Author Share Posted September 28, 2012 the script is taking the value of IMAGE_BUTTON_REVIEWS found in includes/languages/xxxxxxxx.php which is Reviews in english.php - which creates a link with Reviews as title <li><a href="xxxxx" title="Reviews">Reviews(4)</a></li> and the matching div <div id="Reviews">XXXXXXXXXXXXXXXX</div> If you check your source the title tag of the link should match the ID of the div. This is what links them together. Do you have some special character for IMAGE_BUTTON_REVIEWS ? This may or may not effect it - i havent tried that. What you can do is replace the 2 occurences of IMAGE_BUTTON_REVIEWS with something hardcoded - which would be the same regardless of language in products_info.php replace <li><a href="/product_reviews_pfg.php?Tc=<? echo (int)$groups_tms_count?>&products_id=<? echo (int)$HTTP_GET_VARS['products_id']?>" title="<? echo IMAGE_BUTTON_REVIEWS ;?>" ><? echo IMAGE_BUTTON_REVIEWS . (($reviews['count'] > 0) ? ' (' . $reviews['count'] . ')' : '') ;?></a></li> with <li><a href="/product_reviews_pfg.php?Tc=<? echo (int)$groups_tms_count?>&products_id=<? echo (int)$HTTP_GET_VARS['products_id']?>" title="reviews" ><? echo IMAGE_BUTTON_REVIEWS . (($reviews['count'] > 0) ? ' (' . $reviews['count'] . ')' : '') ;?></a></li> and replace <div id="<? echo IMAGE_BUTTON_REVIEWS ;?>"></div> with <div id="reviews"></div> This can only be a mismatch between the 2 tags Jules Quote Link to comment Share on other sites More sharing options...
srirahandcraft Posted September 29, 2012 Share Posted September 29, 2012 Hi Jules, Thanks for your quick answer. The special characters were the problem (Thai language). For the moment I just changed the Thai translation into English. This is for "review" not a big problem as Thai also use the word "review" literally translated into Thai. But is it possible to let the script work with these characters? The reviews themselves show correct, also in Thai. Thanks, Gerhard. Quote Addons installed on my website: - Addons Installed - Advanced Special Offer Discounts - AJAX-Attribute Manager for osc 2.3.1 - Banner box v1.1.1 - Dutch Language Pack - Extra Pages-info box with admin for OSC2.3 - German Language Pack - Login Box - Multi-language Support for Configuration - Multiple products manager - Order Editor - OSC PDF Catalogue 2.1 - PDF-Datasheet - product Field Groups - Quickly Update Product Stock - Unit of weight - YAG (Yet another Guestbook) Link to comment Share on other sites More sharing options...
thejudge99 Posted September 29, 2012 Author Share Posted September 29, 2012 Im not exactly sure wether this is a browser issue or a jquery issue - my script generates the needed tab code in the correct format - but jquery handles the actual tabbing . I wouldnt actually change your Thai equivalent to reviews - this word will still be used / seen by your customers - i would change only the title tag and the ID tag - by following the above instuctions. This would be transparent to your customers. Jules Quote Link to comment Share on other sites More sharing options...
srirahandcraft Posted September 29, 2012 Share Posted September 29, 2012 Hi Jules, Thanks a lot, I hadn't thought about that. It's working perfect now. Gerhard Quote Addons installed on my website: - Addons Installed - Advanced Special Offer Discounts - AJAX-Attribute Manager for osc 2.3.1 - Banner box v1.1.1 - Dutch Language Pack - Extra Pages-info box with admin for OSC2.3 - German Language Pack - Login Box - Multi-language Support for Configuration - Multiple products manager - Order Editor - OSC PDF Catalogue 2.1 - PDF-Datasheet - product Field Groups - Quickly Update Product Stock - Unit of weight - YAG (Yet another Guestbook) 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.