Vicious_Pucca Posted November 6, 2003 Share Posted November 6, 2003 Double check with this code In catalog/products_info.php find the the following code: <?php ?} else { ? ?$product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); ? ?$product_info = tep_db_fetch_array($product_info_query); and change to <?php ?} else { ? ?$product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, ?p.products_availability_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); ? ?$product_info = tep_db_fetch_array($product_info_query); You didn't put that part in installation guide. *double checks* yup. you didn't, at least in 1.02a documentation. Quote Link to comment Share on other sites More sharing options...
lopes_andre Posted November 7, 2003 Share Posted November 7, 2003 if found the error now!but i cannot correct it easily. the problem was/is: the contrib is in english. we use english and german. the file products_availability was just filled with the delivered english sql, so of course no german-availability can show/can be read if it is not in the database... :-( i tried to add the german info, but.... can it be that all you people run your shop in english only? seems to me there is 'error in logic' in the construction of the file products_availability ? PRIMARY KEY? (`products_availability_id`), how should i add the german info? i cannot just change: INSERT INTO `products_availability` VALUES (1, 1, 'Usually ships in 24 hours', now(), NULL);INSERT INTO `products_availability` VALUES (4, 1, 'Usually ships in 1-2 business days', now(), NULL); to: INSERT INTO `products_availability` VALUES (1, 2, 'innerhalb von 24 Stunden', now(), NULL);INSERT INTO `products_availability` VALUES (4, 2, 'innerhalb von 1-2 Arbeitstagen', now(), NULL); because the key (1, 4, ...) is already existing... i guess the key should either be an automatically increasing number, or should consist of a combination of key+languages_id what solution do you propose? Thanks for your efforts! I am with the same problem, I have 3 languages in my website, and the values for non english languages are not store in database. How to solve this problem? Best Regards Andre. Quote Link to comment Share on other sites More sharing options...
crash3903 Posted November 7, 2003 Share Posted November 7, 2003 translate the entries in admin Quote Regards Mark A Reynolds Link to comment Share on other sites More sharing options...
lopes_andre Posted November 7, 2003 Share Posted November 7, 2003 (edited) The problem is in the database, and how the PHP code works with SQL, I think. The admin of this contribution is based on the manufactors "module" And Lena should be right, the manufactors SQL code for 3 laguages in my case is this: ## Dumping data for table `manufacturers_info` # INSERT INTO `manufacturers_info` VALUES (1, 1, 'http://www.matrox.com', 0, NULL); INSERT INTO `manufacturers_info` VALUES (2, 1, 'http://www.microsoft.com', 0, NULL); INSERT INTO `manufacturers_info` VALUES (3, 1, 'http://www.warner.com', 0, NULL); INSERT INTO `manufacturers_info` VALUES (4, 1, 'http://www.fox.com', 0, NULL); INSERT INTO `manufacturers_info` VALUES (5, 1, 'http://www.logitech.com', 0, NULL); INSERT INTO `manufacturers_info` VALUES (6, 1, 'http://www.canon.com', 0, NULL); INSERT INTO `manufacturers_info` VALUES (7, 1, 'http://www.sierra.com', 0, NULL); INSERT INTO `manufacturers_info` VALUES (8, 1, 'http://www.infogrames.com', 0, NULL); INSERT INTO `manufacturers_info` VALUES (9, 1, 'http://www.hewlettpackard.com', 0, NULL); INSERT INTO `manufacturers_info` VALUES (1, 2, 'http://www.matrox.com', 0, NULL); INSERT INTO `manufacturers_info` VALUES (2, 2, 'http://www.microsoft.com', 0, NULL); INSERT INTO `manufacturers_info` VALUES (3, 2, 'http://www.warner.com', 0, NULL); INSERT INTO `manufacturers_info` VALUES (4, 2, 'http://www.fox.com', 0, NULL); INSERT INTO `manufacturers_info` VALUES (5, 2, 'http://www.logitech.com', 0, NULL); INSERT INTO `manufacturers_info` VALUES (6, 2, 'http://www.canon.com', 0, NULL); INSERT INTO `manufacturers_info` VALUES (7, 2, 'http://www.sierra.com', 0, NULL); INSERT INTO `manufacturers_info` VALUES (8, 2, 'http://www.infogrames.com', 0, NULL); INSERT INTO `manufacturers_info` VALUES (9, 2, 'http://www.hewlettpackard.com', 0, NULL); INSERT INTO `manufacturers_info` VALUES (1, 3, 'http://www.matrox.com', 0, NULL); INSERT INTO `manufacturers_info` VALUES (2, 3, 'http://www.microsoft.com', 0, NULL); INSERT INTO `manufacturers_info` VALUES (3, 3, 'http://www.warner.com', 0, NULL); INSERT INTO `manufacturers_info` VALUES (4, 3, 'http://www.fox.com', 0, NULL); INSERT INTO `manufacturers_info` VALUES (5, 3, 'http://www.logitech.com', 0, NULL); INSERT INTO `manufacturers_info` VALUES (6, 3, 'http://www.canon.com', 0, NULL); INSERT INTO `manufacturers_info` VALUES (7, 3, 'http://www.sierra.com', 0, NULL); INSERT INTO `manufacturers_info` VALUES (8, 3, 'http://www.infogrames.com', 0, NULL); INSERT INTO `manufacturers_info` VALUES (9, 3, 'http://www.hewlettpackard.com', 0, NULL); Lena, do you tried to do the INSERTS? It works? Regards Andre'. Edited November 7, 2003 by lopes_andre Quote Link to comment Share on other sites More sharing options...
lopes_andre Posted November 7, 2003 Share Posted November 7, 2003 I "think" I know the problem. I have see the working of the /admin/manufacturers.php and how it works, this module is based on this manufacturers.php. The manufacturers.php works with 2 SQL tables. Table "manufacturers_info" relates "manufacturers_id" with "languages_id" And Table "manufacturers" relates "manufacturers_id" with "manufacturers_name" In the SQL modification of this contribution(Product Availability) I think we have to create another Table to have other languages... relating "products_availability_id" with "laguages_id", in this contribution we have only one table created. I will be wait for Steve solution, i am not a programmer :) Best Regards Andre'. Quote Link to comment Share on other sites More sharing options...
Snowman Posted November 9, 2003 Author Share Posted November 9, 2003 Updated version now availablem, which fixes a few bugs and allows for multiple languages. DOWNLOAD HERE Quote Link to comment Share on other sites More sharing options...
lopes_andre Posted November 9, 2003 Share Posted November 9, 2003 (edited) Thank you Steve. One more time. The mod is now installed and working in 3 languages :D Regards, Andre. Edited November 9, 2003 by lopes_andre Quote Link to comment Share on other sites More sharing options...
Snowman Posted November 9, 2003 Author Share Posted November 9, 2003 Ah great...im glad to here ive finally got it right :) Ok onto the next mod :) Quote Link to comment Share on other sites More sharing options...
TerryK Posted December 14, 2003 Share Posted December 14, 2003 Hi Steve, Thanks for this mod! I've got it working correctly in my store, BUT in the /admin/localization area, when I click on 'Product Availability' it tries to link to this URL: https://www.mydomain.com/catalog/admin/FILE...TS_AVAILABILITY which returns a 404/Page Not Found error. I have no idea what's causing this. What should this be linking to? (admin/products_availability.php?) Any ideas on how I can fix this? Many thanks in advance! TerryK Quote Terry Kluytmans Contribs Installed: Purchase Without Account (PWA); Big Images, Product Availability, Description in Product Listing, Graphical Infobox, Header Tags Controller, Login Box, Option Type Feature, plus many layout changes & other mods of my own, like: Add order total to checkout_shipment Add order total to checkout_payment Add radio buttons at checkout_shipping (for backorder options, etc.) Duplicate Table Rate Shipping Module Better Product Review Flow * If at first you don't succeed, find out if there's a prize for the loser. * Link to comment Share on other sites More sharing options...
Snowman Posted December 14, 2003 Author Share Posted December 14, 2003 you havent added the file identification to the admin/includes/filenames.php file :) Quote Link to comment Share on other sites More sharing options...
TerryK Posted December 15, 2003 Share Posted December 15, 2003 Thanks, Steve!!! (Actually, I *had* added it, but not to the file in my working directory... duh). Thanks again -- this is a great mod! Terry Quote Terry Kluytmans Contribs Installed: Purchase Without Account (PWA); Big Images, Product Availability, Description in Product Listing, Graphical Infobox, Header Tags Controller, Login Box, Option Type Feature, plus many layout changes & other mods of my own, like: Add order total to checkout_shipment Add order total to checkout_payment Add radio buttons at checkout_shipping (for backorder options, etc.) Duplicate Table Rate Shipping Module Better Product Review Flow * If at first you don't succeed, find out if there's a prize for the loser. * Link to comment Share on other sites More sharing options...
TerryK Posted December 16, 2003 Share Posted December 16, 2003 Now that this is working the way it's supposed to, I have one more question: Is there any way to carry the availability text over to the shopping cart checkout page, so the customer can see at a glance what's in and what's not? (Just in case they have a memory as short as mine is!) TIA, Terry Quote Terry Kluytmans Contribs Installed: Purchase Without Account (PWA); Big Images, Product Availability, Description in Product Listing, Graphical Infobox, Header Tags Controller, Login Box, Option Type Feature, plus many layout changes & other mods of my own, like: Add order total to checkout_shipment Add order total to checkout_payment Add radio buttons at checkout_shipping (for backorder options, etc.) Duplicate Table Rate Shipping Module Better Product Review Flow * If at first you don't succeed, find out if there's a prize for the loser. * Link to comment Share on other sites More sharing options...
tuca Posted February 10, 2004 Share Posted February 10, 2004 I' ve installed "product availability v. 1.03" and all works fine, just a little problem: when i change the availability options and click "update" the status of the product change in "off". Who have any ideas? ThankYou! Quote Link to comment Share on other sites More sharing options...
tuca Posted February 10, 2004 Share Posted February 10, 2004 Sorry, i made a little error all is ok now. Quote Link to comment Share on other sites More sharing options...
yoko Posted February 11, 2004 Share Posted February 11, 2004 This is a fantastic mod, but I have an error, if I try to launch any product_info.php 1146 - Table 'digilabor_net_-_oscommerce.TABLE_PRODUCTS_AVAILABILITY' doesn't exist select e.products_availability_name from TABLE_PRODUCTS_AVAILABILITY e where e.products_availability_id = '0' and e.language_id = '1' [TEP STOP] Any idea? Quote Link to comment Share on other sites More sharing options...
yoko Posted February 11, 2004 Share Posted February 11, 2004 Sorry for this, everything's fine! Forget my post above! [just forgot to upload database_tables.php] Quote Link to comment Share on other sites More sharing options...
xtinexoop Posted March 10, 2004 Share Posted March 10, 2004 Hi Is there a way to change the product listing so that instead of QTY it would show availability. I have successfully configured the availability module and it displays when you click on the product - but I would like where you get a list of products rather than to see Qty to see 'in stock', 'out of stock', 'special order' etc I can't actually work out where it defines the titles and columns for that display. Christine Quote Link to comment Share on other sites More sharing options...
kittidid Posted August 1, 2004 Share Posted August 1, 2004 Can anyone help me here please. I would really appreciate it. my post about Product Availability V1.3 Kitti Quote Link to comment Share on other sites More sharing options...
FM Posted October 2, 2004 Share Posted October 2, 2004 Cool contribution. Is there a way to combine this and Stock Status ? That way the status of the product that goes to zero quantity would automatically be marked as 'out of stock'. That would be very handy especially for the people who come to the product page from search engine or outside link even if the product is out of stock. They would see 'out of stock' instead of 'shipping in 2 days' for example. Quote Link to comment Share on other sites More sharing options...
Rick Sample Posted October 2, 2004 Share Posted October 2, 2004 Is their any screenshots or live sites where this mod if visiable? Thanks, Quote Link to comment Share on other sites More sharing options...
Scotty Posted November 29, 2004 Share Posted November 29, 2004 (edited) I am getting the following error message when I try to edit a product from the admin section. I have carefully uploaded all the files, updated the db and double checked my installation to match the installation instructions: 1146 - Table 'abcmed_osc1.TABLE_PRODUCTS_AVAILABILITY' doesn't exist select products_availability_id, products_availability_name from TABLE_PRODUCTS_AVAILABILITY order by products_availability_name [TEP STOP] I have checked my database and the table products_availability does exist. I appreciate any help. Scotty Edited November 29, 2004 by Scotty Quote Link to comment Share on other sites More sharing options...
Snowman Posted November 30, 2004 Author Share Posted November 30, 2004 I am getting the following error message when I try to edit a product from the admin section. I have carefully uploaded all the files, updated the db and double checked my installation to match the installation instructions: 1146 - Table 'abcmed_osc1.TABLE_PRODUCTS_AVAILABILITY' doesn't exist select products_availability_id, products_availability_name from TABLE_PRODUCTS_AVAILABILITY order by products_availability_name [TEP STOP] I have checked my database and the table products_availability does exist. I appreciate any help. Scotty <{POST_SNAPBACK}> Check the database.php files to make sure youve added the database tables into them. I will be revisiting this module shortly and will be releasing a bugfixed version shortly afterwards. Quote Link to comment Share on other sites More sharing options...
movieseller Posted March 12, 2006 Share Posted March 12, 2006 Usefull contribution this, thanks. can it be used in EasyPopulate? Is so, how is it done? Quote Link to comment Share on other sites More sharing options...
blissedgirl Posted August 2, 2006 Share Posted August 2, 2006 Hi, can anyone point me in the right direction? I get this error when I try to add an availability option through my admin: 1054 - Unknown column 'languages_id' in 'field list' insert into products_availability (products_availability_name, products_availability_id, languages_id, date_added) values ('h', '', '1', now()) [TEP STOP] What file(s) do I need to be looking into to find an error? Or...alternatively, can I manually create new availability options in the database somehow..? thanks for any help or enlightenment! :D Quote Beautiful design is everything...the rest is just details!! Link to comment Share on other sites More sharing options...
Guest Posted January 9, 2007 Share Posted January 9, 2007 Is there meant to be a product availability option in the admin tree? 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.