| mariovaldez.net http://www.mariovaldez.net/webapps/forums/ |
|
| regarding products update.. not found --> products_subima http://www.mariovaldez.net/webapps/forums/viewtopic.php?f=14&t=317 |
Page 1 of 1 |
| Author: | Pierre [ 28 Apr 2006, 04:35 ] |
| Post subject: | regarding products update.. not found --> products_subima |
Perhaps this is in the wrong forum. I installed the version with php-based connection. (0.4.1, build 632). No products found withing the kategories. this field is not found within the db. --> products_subimage1 This is the query.. SELECT products.products_id, products.products_quantity, products.products_model, products.products_price, products.products_weight, products.manufacturers_id, products_description.products_name, products.products_status, products_description.products_description, products_description.products_url, products.products_image, specials.specials_new_products_price, products_description.language_id, products.products_tax_class_id, products_description.products_viewed, DATE_FORMAT( products.products_date_available, "%Y-%m-%d %H:%i:%S" ) , DATE_FORMAT( products.products_date_added, "%Y-%m-%d %H:%i:%S" ) , DATE_FORMAT( products.products_last_modified, "%Y-%m-%d %H:%i:%S" ) , products_subimage1, products_subimage2, products_subimage3, products_subimage4, products_subimage5, products_subimage6 FROM ( products, products_description, products_to_categories ) LEFT JOIN specials ON products.products_id = specials.products_id WHERE products.products_id = products_description.products_id AND products_to_categories.products_id = products.products_id AND products_to_categories.categories_id =51 ORDER BY products_description.products_name LIMIT 0 , 30 |
|
| Page 1 of 1 | All times are UTC - 7 hours |
| Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |
|