spyrotsk 0 Posted September 10, 2010 Hi All, I need to change one features, I need to update the price of products with this module, alredy has implemented this function, but I need change include the special price, even if possibile with one variable (true or false, in the admin panel) for enable this feature. I don't have great experience with php and mysql, for this I need your help! Thanks for your time and have a nice day! spyrotsk. Please, i need help! Does anyone know how to do? Thanks! SpyroTSK Share this post Link to post Share on other sites
pleasureidea 0 Posted January 21, 2011 Looks like the error with "select manufacturers_name from manufacturers where manufacturers_id=" happens when one or more products has no manufacturer assigned in DB. Is there anybody can help to make code corrections, so it will be also working without manufacturer assigned? I have products with manufacturers and without. When the correct manufacturer chosen, everything works just fine. When "all manufacturers" chosen the "select manufacturers_name from manufacturers where manufacturers_id=" error happens. Your help is appreciated. Regards, Oleg Share this post Link to post Share on other sites
-Buggi- 0 Posted June 15, 2011 I would very much like to expanded the boxes for the product and model name so that you can see all the text if you - like I - have long model numbers. Can anybody help me? :blush: Share this post Link to post Share on other sites
dstebo 1 Posted July 13, 2011 I downloaded version (Quick Updates 2.8.3 Full-PT) when I change the price, the prices do not change this in the DB What can be? Share this post Link to post Share on other sites
partsace 1 Posted October 24, 2011 Here's a good one for you... I have 2 sites using the Quick Price Updates and both are working just fine, but I do not have the "<< Page 1 of 27 >>" at the bottom of one of the sites. One has it and the other one doesn’t! What am I missing? I've made sure that the "Location of Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)" is on. I've also been using this for years (Great add-on), just can't figure this one out. I've even put up the lastest version and still have the same problem. Scott Share this post Link to post Share on other sites
Psytanium 15 Posted August 1, 2012 alright, a BIG THX for this contribution, its saving me time. i have 2 questions: 1- how can i change the (Max. # of lines per page) by default ? its 20 lines, i want to make it 1000 2- the print button is printing the whole page, is there a way to make it print only the list of products ? Share this post Link to post Share on other sites
Psytanium 15 Posted August 1, 2012 alright, a BIG THX for this contribution, its saving me time. i have 2 questions: 1- how can i change the (Max. # of lines per page) by default ? its 20 lines, i want to make it 1000 2- the print button is printing the whole page, is there a way to make it print only the list of products ? i figured how to set the default number of lines per page. i change "MAX_DISPLAY_SEARCH_RESULTS" to 100 or any integer number. but still can't solve my 2nd problem about printing. Share this post Link to post Share on other sites
twindaddy 0 Posted August 19, 2012 (edited) i have the latest version i can see the prices, but i cannot change them. Does anybody have a solluiton for this? Thank you Edited August 19, 2012 by twindaddy Share this post Link to post Share on other sites
dculley 8 Posted May 25, 2014 my fist issue with the Quick Update. I had just sorted by manufacturer and then sorted by item #. All went well until I wanted to chance page to work on another set. I received the following: 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 'order by p.products_model ASC limit 21, 21' at line 1 select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id from products p, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.manufacturers_id = 11 order by order by p.products_model ASC limit 21, 21 I have no idea what the syntax problem is, I'm not a programmer. Help Please Share this post Link to post Share on other sites
burt 3,848 Posted May 25, 2014 You have two "order by" p.manufacturers_id = 11 order by order by p.p........... Somewhere buried in the code of the addon is problematic or you have introduced a problem. This is a signature that appears on all my posts. IF YOU MAKE A POST REQUESTING HELP...please state the exact version of osCommerce that you are using. THANKS Get the latest Responsive osCommerce CE (community edition) here Share this post Link to post Share on other sites
dculley 8 Posted May 27, 2014 I've done a file search in admin/quick_updates.php for the "two order by" could not bring it up. Search for p.manufactures_id to look for the = 11 and could not find it. Share this post Link to post Share on other sites
♥geoffreywalton 139 Posted May 27, 2014 Try searching for "order". HTH G Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Share this post Link to post Share on other sites
dculley 8 Posted May 27, 2014 searched "order" in admin/quick_update.php found 4 lines: Line 19 - " order by tax_class_title" Line 27 - " order by manufacturers_name" Line 37 - " m order by m.manufacturers_name ASC" Line 400 - $sort_by = 'order by '.$sort_by Share this post Link to post Share on other sites
dculley 8 Posted May 27, 2014 line 25 - 47 ////Info Row pour le champ fabriquant $manufacturers_array = array(array('id' => '0', 'text' => NO_MANUFACTURER)); $manufacturers_query = tep_db_query("select manufacturers_id, manufacturers_name from " . TABLE_MANUFACTURERS . " order by manufacturers_name"); while ($manufacturers = tep_db_fetch_array($manufacturers_query)) { $manufacturers_array[] = array('id' => $manufacturers['manufacturers_id'], 'text' => $manufacturers['manufacturers_name']); } // Display the list of the manufacturers function manufacturers_list(){ global $manufacturer; $manufacturers_query = tep_db_query("select m.manufacturers_id, m.manufacturers_name from " . TABLE_MANUFACTURERS . " m order by m.manufacturers_name ASC"); $return_string = '<select name="manufacturer" onchange="this.form.submit();">'; $return_string .= '<option value="' . 0 . '">' . TEXT_ALL_MANUFACTURERS . '</option>'; while($manufacturers = tep_db_fetch_array($manufacturers_query)){ $return_string .= '<option value="' . $manufacturers['manufacturers_id'] . '"'; if($manufacturer && $manufacturers['manufacturers_id'] == $manufacturer) $return_string .= ' SELECTED'; $return_string .= '>' . $manufacturers['manufacturers_name'] . '</option>'; } $return_string .= '</select>'; return $return_string; } Share this post Link to post Share on other sites
♥geoffreywalton 139 Posted May 27, 2014 Well it is not any of those. Are you sure it is in that file select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id from products p, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.manufacturers_id = 11 order by order by p.products_model ASC limit 21, 21 What is the url displayed when the error is displayed? Try looking for select p.products_id, p.products_image, in that file. HTH G Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Share this post Link to post Share on other sites
burt 3,848 Posted May 27, 2014 (edited) Line 400 - $sort_by = 'order by '.$sort_by Here the code ask that $sort_by gets prefixed with `order by ` It is likely that in some (or all) circumstances $sort_by already contains an `order by` clause, so when this line of code prefixes it with another `order by`, well it's going to break. Edited May 27, 2014 by burt This is a signature that appears on all my posts. IF YOU MAKE A POST REQUESTING HELP...please state the exact version of osCommerce that you are using. THANKS Get the latest Responsive osCommerce CE (community edition) here Share this post Link to post Share on other sites
dculley 8 Posted May 27, 2014 in admin/quick_updates found //// select categories if ($current_category_id == 0){ if($manufacturer){ $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '$languages_id' and p.manufacturers_id = " . $manufacturer . " $sort_by "; }else{ $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '$languages_id' $sort_by "; } } else { if($manufacturer){ $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc where p.products_id = pd.products_id and pd.language_id = '$languages_id' and p.products_id = pc.products_id and pc.categories_id = '" . $current_category_id . "' and p.manufacturers_id = " . $manufacturer . " $sort_by "; }else{ if(tep_has_category_subcategories($current_category_id)){//if - check subcategory existence $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc where p.products_id = pd.products_id and pd.language_id = '$languages_id' and p.products_id = pc.products_id and pc.categories_id IN (select categories_id from categories where parent_id = '" . $current_category_id . "') $sort_by "; }else{ $products_query_raw = "select p.products_id, p.products_image, p.products_model, pd.products_name, p.products_status, p.products_weight, p.products_quantity, p.manufacturers_id, p.products_price, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc where p.products_id = pd.products_id and pd.language_id = '$languages_id' and p.products_id = pc.products_id and pc.categories_id = '" . $current_category_id . "' $sort_by "; }//if - check subcategory existence } } also looked in quick_inventory.php for order, found 5 Line 90 “ p order by p.products_model” Line 145 " m order by m.manufacturers_id" Line 171 "%' order by p.products_model limit $limit_search_to" Line 175 language_id = $languages_id order by p.products_model limit $limit_search_to" Line 180 $languages_id order by p.products_model limit $limit_search_to" Share this post Link to post Share on other sites
dculley 8 Posted May 27, 2014 how would you fix line 400 //// control string sort page if ($sort_by && !preg_match('/^[a-z][ad]$/',$sort_by)) $sort_by = 'order by '.$sort_by ; Share this post Link to post Share on other sites
dculley 8 Posted May 27, 2014 you asked What is the url displayed when the error is displayed? after sellecting the manufactor and sort the item # first page url: /quick_updates.php?cPath=0&sort_by=p.products_model ASC&page=&row_by_page=21&manufacturer=11 next page (errors) url is: quick_updates.php?&cPath=0&sort_by=order by p.products_model ASC&row_by_page=21&manufacturer=11&page=2 Share this post Link to post Share on other sites
dculley 8 Posted June 11, 2014 Still having the same problem is there a fix yet? Share this post Link to post Share on other sites
alladin76ro 0 Posted June 9, 2015 Hi, I upgraded to osCommerce Online Merchant v2.3.4 and my Quick Updates is not updating the Qty. of the products. Can anyone help? Thank You. Share this post Link to post Share on other sites
dculley 8 Posted September 7, 2015 I have updated a few months to osc234 w/ bootstrap. I have installed the add on Quick updates and just trying to use it for the first item. In calling up Quick Update, I wanted to change the (add) to the descriptions on some items. When I clicked on update I got the following error. Warning: mysql_query(): Access denied for user 'ladyXXXXXXXXX'@'localhost' (using password: NO) in /home/ladyXXXXXX/public_html/admxxxxxx/quick_updates.php on line 80 Warning: mysql_query(): A link to the server could not be established in /home/ladyXXXXXX/public_html/adminlb/quick_updates.php on line 80 Warning: mysql_query(): Access denied for user 'ladyXXXXXXXXX'@'localhost' (using password: NO) in /home/ladyXXXXXX/public_html/admxxxxxx/quick_updates.php on line 81 Warning: mysql_query(): A link to the server could not be established in /home/ladyXXXXXX/public_html/admxxxxxx/quick_updates.php on line 81 Quick Update How to correct? Share this post Link to post Share on other sites
dculley 8 Posted September 14, 2015 I still haven't been able to fix this one. All the other programs seems to be hitting the SQL data base just fine. Is it a bootstrap thing? Maybe this program is not ready for bootstrap? Share this post Link to post Share on other sites
dculley 8 Posted September 20, 2015 @@geoffreywalton Geoffrey, just reach out. Can you help me with the error I posted in #97? I'm stilled stumped. Share this post Link to post Share on other sites
♥kymation 629 Posted September 21, 2015 It appears that this program is not ready for osCommerce 2.3.4. The errors you posted above show that it is trying to use mysql_query() when it should be using mysqli_query(). Actually it should probably be using the osCommerce database functions which would have prevented this problem. Regards Jim See my profile for a list of my addons and ways to get support. Share this post Link to post Share on other sites