Davefromcornwall Posted May 16, 2008 Share Posted May 16, 2008 Can anyone get this to work on PHP 5 as it only shows the first page and you can't change the line counts or page. I'm getting this problem as well, and I'm running on PHP 5.25. If I have 70 products in a category, I can only edit the first ten. I can't change the "Max. # of lines per page", and next, or clicking another page number, doesn't work. The products do update when I make changes. I'd really like to be able to use this very useful looking contribution, but it is not much use at the moment. I'm using the "Quick Updates 2.7 Full English". Hopefully someone will come up with a fix for this problem. Quote Link to comment Share on other sites More sharing options...
Davefromcornwall Posted May 19, 2008 Share Posted May 19, 2008 As a workaround, for me at least, does anyone know how to set the default "Max. # of lines per page" to 100 instead of 10? As I don't have more than 100 items in any category, this would make the contribution workable. Quote Link to comment Share on other sites More sharing options...
jay2xra Posted June 16, 2008 Share Posted June 16, 2008 this thread seems to be dead... :-( no work around for problem "cannot go to next page".. Quote Link to comment Share on other sites More sharing options...
Davefromcornwall Posted June 16, 2008 Share Posted June 16, 2008 this thread seems to be dead... :-( no work around for problem "cannot go to next page".. I uninstalled Quick Price Updates and installed Product Inventory Editor instead. It only allow me to change price, weight and quantity, but that's better than nothing. All the products in the shop appear on one page, which is OK for me as I only have about 350 products, but it may be a problem for people with huge quantities of products as the page may take ages to load. Quote Link to comment Share on other sites More sharing options...
Jan Zonjee Posted June 16, 2008 Share Posted June 16, 2008 this thread seems to be dead... :-( no work around for problem "cannot go to next page".. Try adding some lines below require('includes/application_top.php') like: require('includes/application_top.php'); if (isset($_GET['row_by_page'])) { $row_by_page = (int)$_GET['row_by_page']; } if (isset($_GET['manufacturer'])) { $manufacturer = (int)$_GET['manufacturer']; } if (isset($_GET['sort_by'])) { $sort_by = $_GET['sort_by']; } if (isset($_GET['page'])) { $page = $_GET['page']; } Quote Link to comment Share on other sites More sharing options...
pbor1234 Posted July 9, 2008 Share Posted July 9, 2008 Jan, Thanks for the fix ;) Latest version seems to be dependant on "register globals".... Paul Quote Link to comment Share on other sites More sharing options...
PiLLaO Posted November 24, 2008 Share Posted November 24, 2008 Can anyone get this to work on PHP 5 as it only shows the first page and you can't change the line counts or page. The problem is the version of oscommerce, in 2.2 RCa doesn't work Quote Link to comment Share on other sites More sharing options...
blr044 Posted March 14, 2009 Share Posted March 14, 2009 I thought I have this before, but can not find it now. I did reinstall the latest ver. And still same issue. I can increase/decrease prices working the the price column. But using value/rate section, I can only increase prices by whole number or %. But I can not decrease prices by whole number or %. I like this mod. Not able to find out why this isn't decreasing the price. So am asking for any help on this issue. Thanks. Quote Link to comment Share on other sites More sharing options...
Peper Posted June 7, 2009 Share Posted June 7, 2009 Thanks for Jan, The file catalog/admin/quick_updates.php add the following below line 25 starting with require('includes/application_top.php'); if (isset($_GET['row_by_page'])) { $row_by_page = (int)$_GET['row_by_page']; } if (isset($_GET['manufacturer'])) { $manufacturer = (int)$_GET['manufacturer']; } if (isset($_GET['sort_by'])) { $sort_by = $_GET['sort_by']; } if (isset($_GET['page'])) { $page = $_GET['page']; } This solves the problem for not displaying the next page Quote Getting the Phoenix off the ground Link to comment Share on other sites More sharing options...
Guest Posted June 27, 2009 Share Posted June 27, 2009 I thought I have this before, but can not find it now. I did reinstall the latest ver. And still same issue. I can increase/decrease prices working the the price column. But using value/rate section, I can only increase prices by whole number or %. But I can not decrease prices by whole number or %. I like this mod. Not able to find out why this isn't decreasing the price. So am asking for any help on this issue. Thanks. I have the same problem and i can´t see where is the error any help for this problem please Quote Link to comment Share on other sites More sharing options...
buso71 Posted July 3, 2009 Share Posted July 3, 2009 Hi, I have been running Quick Price Updates for 1 year. Now I get this 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 '' at line 1 select manufacturers_name from manufacturers where manufacturers_id= [TEP STOP] it happens only when I select a single category or when I "crash" into a product whithout manufacturer I tried using quick_updates.php in version 2.8.2 Also worse: I get no products at all selecting a category. Now I'm running version 2.8 from Oct 27 2008 but it crashes as it gets a product without manufactuer Any Idea?? Quote Link to comment Share on other sites More sharing options...
azer Posted August 6, 2009 Author Share Posted August 6, 2009 is there any way to show the net prices ( price with tva) in the rows and being able to edit it directly ? Quote MS2 Link to comment Share on other sites More sharing options...
jolie102003 Posted August 12, 2009 Share Posted August 12, 2009 (edited) Hi, I have a problem with http://addons.oscommerce.com/info/122 When I input new data and pressing "update" button, I back to admin panel (login.php) :blink:, after I log in again nothing happend <_< . New price wasn't saved. It looks like I can't edit and input new quantity or other like price etc. Please Help... :blush: Edited August 12, 2009 by jolie102003 Quote Link to comment Share on other sites More sharing options...
jolie102003 Posted August 13, 2009 Share Posted August 13, 2009 anyone, please.... Quote Link to comment Share on other sites More sharing options...
wi-fi Posted August 18, 2009 Share Posted August 18, 2009 Hi,I have been running Quick Price Updates for 1 year. Now I get this error it happens only when I select a single category or when I "crash" into a product whithout manufacturer I tried using quick_updates.php in version 2.8.2 Also worse: I get no products at all selecting a category. Now I'm running version 2.8 from Oct 27 2008 but it crashes as it gets a product without manufactuer Any Idea?? Hi I have the same problem in Quick Price Updates 2.8.3 FULL package... did you find any solution? Best regards, David Quote Link to comment Share on other sites More sharing options...
jolie102003 Posted August 20, 2009 Share Posted August 20, 2009 No no one helped me :(, so I changed cont. to http://addons.oscommerce.com/info/558 and I have problem again. I have blank form, no list of product display. When I try click button "update" I back to admin panel and I login again :huh: :huh: and nothing changed :huh: :blink: :blink: So I'm still looking for help :blush: :blush: Quote Link to comment Share on other sites More sharing options...
metafizx Posted October 26, 2009 Share Posted October 26, 2009 thanks for a great contribution! I have 2.8.3 installed and working. Is it possible to configure to allow changes to Product Attibutes ? thanks in advance. Quote Link to comment Share on other sites More sharing options...
bhbilbao Posted November 17, 2009 Share Posted November 17, 2009 I have a problem importing SQL. It gives an error. #1062 - Duplicate entry '1001' for key 1 I tried to to change configuration_id to INT(15), UNSIGNED, AUTO-INCREMENT, etc. I also try REPAIR TABLE configuration QUICK; What is the problem??? Quote Link to comment Share on other sites More sharing options...
fozzo Posted March 21, 2010 Share Posted March 21, 2010 Did anyone solved the problem of prices without VAT? I'd love to use this contr. but still can't manage to show prices with VAT. Any help would be much apreciated. Quote Link to comment Share on other sites More sharing options...
halluzineyt Posted March 26, 2010 Share Posted March 26, 2010 is there a limit of how many can be changed i noice that when i go on 30+ items some wont change i dont know the exact number but there is a limit?? Quote Link to comment Share on other sites More sharing options...
halluzineyt Posted March 27, 2010 Share Posted March 27, 2010 it can only change 16 at a time any fix to make it more?? Quote Link to comment Share on other sites More sharing options...
ozstar Posted April 19, 2010 Share Posted April 19, 2010 Hi, I get this message when I go to the Admin Panel.. I can still get into the other Admin pages but when I click on the Updates link which has been put there okay, and most of the links in the My Store panel, nothing happens. I have version 2.8.3 Full (English). Any ideas please? Shows on top of many pages in Admin.. Warning: include(includes/languages/english/) [function.include]: failed to open stream: No such file or directory in C:\wamp\www\sydneytoner\catalog\admin\includes\application_top.php on line 133 Warning: include() [function.include]: Failed opening 'includes/languages/english/' for inclusion (include_path='.;C:\php5\pear') in C:\wamp\www\sydneytoner\catalog\admin\includes\application_top.php on line 133 The link in teh Catlaog Section works but this line is added in pink on the admin catalog page under that same message above ERROR_CATALOG_IMAGE_DIRECTORY_DOES_NOT_EXIST Really want this to work.. Thanks oz Quote Link to comment Share on other sites More sharing options...
xprsdesign Posted June 14, 2010 Share Posted June 14, 2010 Would it be possible to change product attributes with quick price updates?? Quote Link to comment Share on other sites More sharing options...
spyrotsk Posted August 11, 2010 Share Posted August 11, 2010 (edited) 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. Edited August 11, 2010 by spyrotsk Quote Link to comment Share on other sites More sharing options...
andih123 Posted August 25, 2010 Share Posted August 25, 2010 Hi I have installed the contribution and the update. I get the following error: 1054 - Unknown column 'p.manufacturers_id' in 'on clause' select count(*) as total from products p, products_description pd, products_to_categories pc left join manufacturers m on m.manufacturers_id = p.manufacturers_id where p.products_id = pd.products_id and pd.language_id = '4' and p.products_id = pc.products_id and pc.categories_id = '86' This is when i select a category. Anyone an idea? Thanks Erik Hi Erik For me following hotfix works (if no manufacturers are used): //// 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, " . TABLE_MANUFACTURERS . " m where p.products_id = pd.products_id and pd.language_id = '$languages_id' and p.manufacturers_id = m.manufacturers_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, " . TABLE_MANUFACTURERS . " m where p.products_id = pd.products_id and p.manufacturers_id = m.manufacturers_id and pd.language_id = '$languages_id' $sort_by "; } //Quick Price Update Manfacturers Patch } 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, m.manufacturers_id, manufacturers_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc, ".TABLE_MANUFACTURERS." m where p.products_id = pd.products_id and m.manufacturers_id = p.manufacturers_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{ $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 "; } } 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.