Dr. Rolex Posted August 15, 2014 Author Share Posted August 15, 2014 I checked into some things. First yes the PHP version is definitely 5.217. Now I have a problem in that I have another domain on that account that is stuck on Joomla! 1.526 because there are custom components I had built that would all have to changed if I were to upgrade Joomla! and that is simply too expensive to get coded. I know from the Joomla! forums that that website would definitely not work with PHP 5.4. - It's a working site that earns money. I am with HostMonster and there is no option to change the PHP to 5.3 - only 5.2 or 5.4 Anyway I went to the PHP error logs (on the same page but underneath the main error logs) and they are sorted by directory. There are no php error logs at all for the directory where this OSCommerce install is, absolutely none... I did a Ctrl+F on the page and that directory isn't there. I tried to access the /admin/get_table.php a couple of times, went back to the php_error page and still nothing at all... I'm at a loss as to what to do now.. This is still a test site so no business is being lost as yet but unless I can batch print invoices then it will be useless for my purposes. The site is for Groupon offers and the ability to be able to run off lots of invoices in one batch is crucial.. Is there another way to get around this? Thanks Yes, there is a way. You can enable a PHP directive so the error messages are displayed on screen but it doesn't always work. Change this code in admin/includes/application_top.php error_reporting(E_ALL & ~E_NOTICE); To this error_reporting(E_ALL); ini_set('display_errors', '1'); And then check the get_table.php page again and reply with any messages that are displayed. You should also check if you get any javascript errors in the browser console. In google chrome press CTRL + SHIFT + J to bring up the console and then go to get_table.php and reply with whatever messages you might have. Quote osC OpenSSL Encryption with jCryptionSupport Forum jQuery/Ajax Advanced Statistics 2.3Support Forum jQuery/Ajax Advanced Order Handler 2.3.3Support ForumjQuery/Ajax Advanced Caching System 2.3.3Support ForumjQuery/Ajax Fast checkout/Shopping Cart/Login/Create Account 2.3.3Support ForumjQuery/Ajax Shopping Cart 2.3.3Support ForumjQuery/Ajax Dynamic Checkout 2.3.3Support ForumjQuery/Ajax Mini Cart for osCommerce 2.3.3Support ForumjQuery Cycle What's New InfoboxAuto Out Of Stock CSS Image OverlayjQuery-UI Autocomplete Product Search with Links & MySQLi support for osCommerce 2.X Link to comment Share on other sites More sharing options...
Guest Posted August 15, 2014 Share Posted August 15, 2014 (edited) Thanks very much for trying to help me - wow that brought up some errors and they seem to be largely related to the Discount Coupon module I installed which does actually work (when the site is in normal mode and not reporting like crazy :-)) - I thought this was a current addon - in fact pretty sure it is.. Here we go: Notice: Use of undefined constant FILENAME_DISCOUNT_COUPONS - assumed 'FILENAME_DISCOUNT_COUPONS' in /home2/helpandi/public_html/uncoolthreads.co.uk/admin/includes/boxes/catalog.php on line 48Notice: Use of undefined constant BOX_CATALOG_DISCOUNT_COUPONS - assumed 'BOX_CATALOG_DISCOUNT_COUPONS' in /home2/helpandi/public_html/uncoolthreads.co.uk/admin/includes/boxes/catalog.php on line 49Notice: Use of undefined constant FILENAME_DISCOUNT_COUPONS - assumed 'FILENAME_DISCOUNT_COUPONS' in /home2/helpandi/public_html/uncoolthreads.co.uk/admin/includes/boxes/catalog.php on line 50Notice: Undefined variable: SID in /home2/helpandi/public_html/uncoolthreads.co.uk/admin/includes/functions/html_output.php on line 48Notice: Use of undefined constant FILENAME_STATS_DISCOUNT_COUPONS - assumed 'FILENAME_STATS_DISCOUNT_COUPONS' in /home2/helpandi/public_html/uncoolthreads.co.uk/admin/includes/boxes/reports.php on line 33Notice: Use of undefined constant BOX_REPORTS_DISCOUNT_COUPONS - assumed 'BOX_REPORTS_DISCOUNT_COUPONS' in /home2/helpandi/public_html/uncoolthreads.co.uk/admin/includes/boxes/reports.php on line 34Notice: Use of undefined constant FILENAME_STATS_DISCOUNT_COUPONS - assumed 'FILENAME_STATS_DISCOUNT_COUPONS' in /home2/helpandi/public_html/uncoolthreads.co.uk/admin/includes/boxes/reports.php on line 35Notice: Undefined variable: SID in /home2/helpandi/public_html/uncoolthreads.co.uk/admin/includes/functions/html_output.php on line 48 Is it some kind of clash between the two addons? The code the first 3 lines are referring to in catalog.php are: ///kgt - discount coupons array( 'code' => FILENAME_PRODUCTS_EXPECTED, 'title' => BOX_CATALOG_PRODUCTS_EXPECTED, 'link' => tep_href_link(FILENAME_PRODUCTS_EXPECTED) ), array( 'code' => FILENAME_DISCOUNT_COUPONS, 'title' => BOX_CATALOG_DISCOUNT_COUPONS, 'link' => tep_href_link(FILENAME_DISCOUNT_COUPONS) ) //end kgt - discount coupons In fact those error messages appear whatever you click on in the OSC backend Edited August 15, 2014 by uncoolthreads Quote Link to comment Share on other sites More sharing options...
Guest Posted August 15, 2014 Share Posted August 15, 2014 java script console reported: Use of getUserData() or setUserData() is deprecated. Use WeakMap or element.dataset instead. requestNotifier.js:63SyntaxError: syntax error ckeditor.js:1ReferenceError: CKEDITOR is not defined jquery.js:5ReferenceError: goOnLoad is not defined get_table.php:1 thanks Russ Quote Link to comment Share on other sites More sharing options...
♥joli1811 Posted August 15, 2014 Share Posted August 15, 2014 ///kgt - discount coupons array( 'code' => FILENAME_PRODUCTS_EXPECTED, 'title' => BOX_CATALOG_PRODUCTS_EXPECTED, 'link' => tep_href_link(FILENAME_PRODUCTS_EXPECTED) ), array( 'code' => FILENAME_DISCOUNT_COUPONS, 'title' => BOX_CATALOG_DISCOUNT_COUPONS, 'link' => tep_href_link(FILENAME_DISCOUNT_COUPONS) ) //end kgt - discount coupons ) ); ?> Quote To improve is to change; to be perfect is to change often. Link to comment Share on other sites More sharing options...
Dr. Rolex Posted August 15, 2014 Author Share Posted August 15, 2014 (edited) java script console reported: Use of getUserData() or setUserData() is deprecated. Use WeakMap or element.dataset instead. requestNotifier.js:63 SyntaxError: syntax error ckeditor.js:1 ReferenceError: CKEDITOR is not defined jquery.js:5 ReferenceError: goOnLoad is not defined get_table.php:1 thanks Russ Well, there's your error anyway. There's something wrong with ckeditor.js. You can try with temporarily removing the line that loads that file (it's probably located in admin/includes/template_top.php) and then try again and see if you are still getting any errors. Expand each line in the console to see which file that is the culprit. But likely, they're all attributed to ckeditor.js. The line you're looking for will probably be something similar to this <script type="text/javascript" src="js/ckeditor.js"></script> An alternative to removing it would be to change it to something like this <?php if (basename($PHP_SELF) != 'get_table.php') { ?> <script type="text/javascript" src="js/ckeditor.js"></script> <?php } ?> Also, don't forget to switch back the PHP display_errors directive to 0 since the order_handler most probably will not work when you're displaying log messages in the layout. The messages you posted from the PHP log are only Notices and can be ignored. Edited August 15, 2014 by Dr. Rolex Quote osC OpenSSL Encryption with jCryptionSupport Forum jQuery/Ajax Advanced Statistics 2.3Support Forum jQuery/Ajax Advanced Order Handler 2.3.3Support ForumjQuery/Ajax Advanced Caching System 2.3.3Support ForumjQuery/Ajax Fast checkout/Shopping Cart/Login/Create Account 2.3.3Support ForumjQuery/Ajax Shopping Cart 2.3.3Support ForumjQuery/Ajax Dynamic Checkout 2.3.3Support ForumjQuery/Ajax Mini Cart for osCommerce 2.3.3Support ForumjQuery Cycle What's New InfoboxAuto Out Of Stock CSS Image OverlayjQuery-UI Autocomplete Product Search with Links & MySQLi support for osCommerce 2.X Link to comment Share on other sites More sharing options...
Guest Posted August 15, 2014 Share Posted August 15, 2014 ///kgt - discount coupons array( 'code' => FILENAME_PRODUCTS_EXPECTED, 'title' => BOX_CATALOG_PRODUCTS_EXPECTED, 'link' => tep_href_link(FILENAME_PRODUCTS_EXPECTED) ), array( 'code' => FILENAME_DISCOUNT_COUPONS, 'title' => BOX_CATALOG_DISCOUNT_COUPONS, 'link' => tep_href_link(FILENAME_DISCOUNT_COUPONS) ) //end kgt - discount coupons ) ); ?> Hi John, yes my catalog.php ends with those closing brackets and the end of php sign too: Like this: //end kgt - discount coupons ) ); ?> Above in the previous post I was just quoting the 3 lines mentioned in the error messages, 48-49-50. Is that what you meant? Quote Link to comment Share on other sites More sharing options...
♥joli1811 Posted August 16, 2014 Share Posted August 16, 2014 Hi John, yes my catalog.php ends with those closing brackets and the end of php sign too: Above in the previous post I was just quoting the 3 lines mentioned in the error messages, 48-49-50. Is that what you meant? yeah just wanted to be sure easy to make mistake with those quotes :thumbsup: Quote To improve is to change; to be perfect is to change often. Link to comment Share on other sites More sharing options...
♥joli1811 Posted August 16, 2014 Share Posted August 16, 2014 (edited) Hi don't really like mixing in as no idea with the order handler but maybe if you are using JohnAtYM site wide install instructions for the ckeditor you should change to a manual install just including the specific text fields that you need . The site wide install is actually a bad idea especially for SEO reasons and seems to be conflicting with the order editor as well you really only need the html editor for category desc/product desc and maybe newsletter extra pages info etc. Below you see the product description field targeted in admin category.php ('class="ckeditor") I think one of the very first uploads has a nice manual install guide been meaning to update for 2.3. just no time at the minute. Basically you are adding the ckditor class to whatever tep_draw_textarea_field you want to use html <!-- <td class="main"><?php //echo tep_draw_textarea_field('products_description[' . $languages[$i]['id'] . ']', 'soft', '70', '15', (empty($pInfo->products_id) ? '' : tep_get_products_description($pInfo->products_id, $languages[$i]['id']))); ?></td>/--> <td class="main"><?php echo tep_draw_textarea_field('products_description[' . $languages[$i]['id'] . ']', 'soft', '70', '15', (empty($pInfo->products_id) ? '' : tep_get_products_description($pInfo->products_id, $languages[$i]['id'])), 'class="ckeditor"'); ?></td> This is what I have in my template.top.php to call the editor <?php if (!defined('USE_CKEDITOR_ADMIN_TEXTAREA')) { tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, set_function) values ('', 'Use CKEditor', 'USE_CKEDITOR_ADMIN_TEXTAREA','true','Use CKEditor for WYSIWYG editing of textarea fields in admin',1,99,now(),'tep_cfg_select_option(array(\'true\', \'false\'),' )"); define ('USE_CKEDITOR_ADMIN_TEXTAREA','true'); } if (USE_CKEDITOR_ADMIN_TEXTAREA == "true") { ?> <script type="text/javascript" src="<?php echo tep_href_link('ext/ckeditor/ckeditor.js'); ?>"></script> <script type="text/javascript" src="<?php echo tep_href_link('ext/ckeditor/adapters/jquery.js'); ?>"></script> <?php } ?> Regards John PS: Think Burt as also an alternative install guide on his blog clubosc http://www.clubosc.com/easiest-install-ever-fck-editor.html Edited August 16, 2014 by joli1811 Quote To improve is to change; to be perfect is to change often. Link to comment Share on other sites More sharing options...
Guest Posted August 16, 2014 Share Posted August 16, 2014 ok I think I understand John but like I said I'm no programmer :-( I have noticed the ckditor loading in places where it wasn't needed. On Monday I'll reverse all the instructions for the ckditor install and then first of all see if Order Handler works - Once I have sorted that (if I do) then I'll look for this manual install of ckditor and try that out. Phew! (so much for just trying to sell something online with a one click install from Cpanel!! ;) Thanks for your input John and also thanks to Jonas Russ My guess is these posts will continue B) Quote Link to comment Share on other sites More sharing options...
♥joli1811 Posted August 16, 2014 Share Posted August 16, 2014 Well who said it was easy to make a million :D hahah the devil in me . Quote To improve is to change; to be perfect is to change often. Link to comment Share on other sites More sharing options...
OyKus Posted August 16, 2014 Share Posted August 16, 2014 Hi Dr. Rolex, Im new to OSC, thanks for your addon, it helps alot!I got OSC 2.3.4 & Order Handler v3(28/7) fresh installed with no problem, then I did some test both on Chrome/Firefox, and got few issues:1. Under Firefox only: right click on order table, the context menu pop up with 5 actions(Expand Order, Edit, Duplicate, Send Mail and Delete), but it doesnt do anything when you click on any of the action, I got the error message from firebug:"Error: ReferenceError: event is not definedSource File: ....01_order_handler_rev3.min.js"Seems like it caused by "if(0!==event.button){return false}" as Firefox doesnt read "event" like Chrome or IE.2. Under Firefox only: during action "Expand Order", when I changing price for any items, the column "Order Total" value from order table changes to "undefined" (Chrome works fine).3. Under both Chrome/Firefox: right click on order table, click "Expand Order" from context menu then close that expand panel, click "Expand Order" again with same order from context menu, but the expand panel will not show up again.4. Under Chrome only: I made 3 orders for testing, with status "Pending" "Processing" and "Delivered", when I open the main page(get_table.php), Firefox showing all orders with no problem, but Chrome only showing 1 order with status "Pending".5. Whatever how many times you updated status and append comments, when refresh the main page, the column "Comments" will always show the first/earlist comments.Not sure if these issues just for me or not, please have a look, thanks again! Quote Link to comment Share on other sites More sharing options...
Guest Posted August 18, 2014 Share Posted August 18, 2014 Hi guys well I restored to previous state before CKeditor and Order Handler. Then re-installed Order Handler. There is still a blank page there as before even without CKEditor so although there may have been problems with CKEditor it seems that's not the only problem I have. :( In the Browser Console it now shows this: GET http://www.uncoolthreads.co.uk/admin/get_table.php [HTTP/1.1 200 OK 437ms] GET http://toolbarqueries.google.com/tbr [HTTP/1.1 200 OK 78ms] GET http://xml.alexa.com/data [HTTP/1.1 200 OK 140ms] Error in parsing value for 'background-image'. Declaration dropped. 01_order_handler_rev3.min.css:21Expected 'none' or URL but found 'progid'. Error in parsing value for 'filter'. Declaration dropped. 01_order_handler_rev3.min.css:21Unknown property '-moz-border-radius'. Declaration dropped. 01_order_handler_rev3.min.css:21Unknown property '-moz-background-clip'. Declaration dropped. 01_order_handler_rev3.min.css:21Unknown property '-moz-background-origin'. Declaration dropped. 01_order_handler_rev3.min.css:21Unknown property '-moz-background-size'. Declaration dropped. 01_order_handler_rev3.min.css:21Expected 'none' or URL but found 'alpha('. Error in parsing value for 'filter'. Declaration dropped. 01_order_handler_rev3.min.css:21Unknown property 'transformtransform'. Declaration dropped. 01_order_handler_rev3.min.css:21Unknown property 'transformopacitytransform'. Declaration dropped. 01_order_handler_rev3.min.css:21Unknown property 'opacitytransformtransform'. Declaration dropped. 01_order_handler_rev3.min.css:21Unknown property 'opacity-moz-transform-moz-transform'. Declaration dropped. 01_order_handler_rev3.min.css:21Unknown property '-moz-box-shadow'. Declaration dropped. 01_order_handler_rev3.min.css:21Unknown property 'zoom'. Declaration dropped. 01_order_handler_rev3.min.css:21Expected declaration but found '*'. Skipped to next declaration. 01_order_handler_rev3.min.css:21Unknown property 'user-select'. Declaration dropped. 01_order_handler_rev3.min.css:21Error in parsing value for 'background'. Declaration dropped. 01_order_handler_rev3.min.css:21Expected media feature name but found '-webkit-min-device-pixel-ratio'. 01_order_handler_rev3.min.css:21Expected media feature name but found '-o-min-device-pixel-ratio'. 01_order_handler_rev3.min.css:21Unknown property '-moz-border-radius-topleft'. Declaration dropped. 01_order_handler_rev3.min.css:21Unknown property '-moz-border-radius-topright'. Declaration dropped. 01_order_handler_rev3.min.css:21Unknown property '-moz-border-radius-bottomleft'. Declaration dropped. 01_order_handler_rev3.min.css:21Unknown property '-moz-border-radius-bottomright'. Declaration dropped. 01_order_handler_rev3.min.css:21Unknown pseudo-class or pseudo-element '-o-prefocus'. Ruleset ignored due to bad selector. 01_order_handler_rev3.min.css:21Unknown property 'behavior'. Declaration dropped. 01_order_handler_rev3.min.css:21Unknown property 'opacity-webkit-transform-ms-transformtransformopacity'. Declaration dropped. 01_order_handler_rev3.min.css:21Keyframe rule ignored due to bad selector. 01_order_handler_rev3.min.css:21Expected 'none' or URL but found 'Alpha('. Error in parsing value for 'filter'. Declaration dropped. jquery-ui-1.10.4.min.css:7Expected 'none' or URL but found 'alpha('. Error in parsing value for 'filter'. Declaration dropped. jquery-ui-1.10.4.min.css:7Error in parsing value for 'cursor'. Declaration dropped. stylesheet.css:46Unknown property '-moz-border-radius'. Declaration dropped. stylesheet.css:87Error in parsing value for 'cursor'. Declaration dropped. stylesheet.css:198Error in parsing value for 'cursor'. Declaration dropped. stylesheet.css:203GET http://www.uncoolthreads.co.uk/admin/get_table.php [HTTP/1.1 200 OK 281ms] GET http://toolbarqueries.google.com/tbr [HTTP/1.1 200 OK 62ms] GET http://xml.alexa.com/data [HTTP/1.1 200 OK 140ms] GET http://www.uncoolthreads.co.uk/admin/includes/stylesheet.css [HTTP/1.1 304 Not Modified 327ms] Unknown property '-moz-osx-font-smoothing'. Declaration dropped. 01_order_handler_rev3.min.css:21Unknown property '-moz-transform-moz-transform'. Declaration dropped. 01_order_handler_rev3.min.css:21Unknown pseudo-class or pseudo-element '-webkit-inner-spin-button'. Ruleset ignored due to bad selector. 01_order_handler_rev3.min.css:21Unknown pseudo-class or pseudo-element '-webkit-search-cancel-button'. Ruleset ignored due to bad selector. 01_order_handler_rev3.min.css:21Expected color but found 'auto'. Expected color but found '-webkit-focus-ring-color'. Expected end of value but found '-webkit-focus-ring-color'. Error in parsing value for 'outline'. Declaration dropped. 01_order_handler_rev3.min.css:21Expected end of value but found '\9 '. Error in parsing value for 'margin-top'. Declaration dropped. 01_order_handler_rev3.min.css:21Unknown pseudo-class or pseudo-element '-ms-input-placeholder'. Ruleset ignored due to bad selector. 01_order_handler_rev3.min.css:21Unknown pseudo-class or pseudo-element '-webkit-input-placeholder'. Ruleset ignored due to bad selector. 01_order_handler_rev3.min.css:21GET http://www.uncoolthreads.co.uk/admin/get_table.php [HTTP/1.1 200 OK 546ms] GET http://toolbarqueries.google.com/tbr [HTTP/1.1 200 OK 93ms] GET http://xml.alexa.com/data [HTTP/1.1 200 OK 140ms] POST https://safebrowsing.google.com/safebrowsing/downloads [HTTP/1.1 200 OK 140ms] GET https://safebrowsing-cache.google.com/safebrowsing/rd/ChVnb29nLWJhZGJpbnVybC1zaGF2YXIQARidiAIgsIgCKgUwhAAAATIHHYQAAP__Bw [HTTP/1.1 200 OK 125ms] GET https://safebrowsing-cache.google.com/safebrowsing/rd/ChVnb29nLWJhZGJpbnVybC1zaGF2YXIQABiv5AEguOQBKgU2cgAABzIFMHIAAD8 [HTTP/1.1 200 OK 31ms] GET https://safebrowsing-cache.google.com/safebrowsing/rd/ChNnb29nLW1hbHdhcmUtc2hhdmFyEAEY1dMIIOjTCCoF5SkCAA8yB9UpAgD__wA [HTTP/1.1 200 OK 47ms] GET https://safebrowsing-cache.google.com/safebrowsing/rd/ChNnb29nLW1hbHdhcmUtc2hhdmFyEAAY6Y8JIJCQCSoJ7EcCAP____8fMgXpRwIABw [HTTP/1.1 200 OK 46ms] GET http://toolbarqueries.google.com/tbr [HTTP/1.1 403 Forbidden 63ms] GET http://xml.alexa.com/data [HTTP/1.1 200 OK 218ms] GET http://toolbarqueries.google.com/tbr [HTTP/1.1 403 Forbidden 47ms] GET http://xml.alexa.com/data [HTTP/1.1 200 OK 125ms] GET http://toolbarqueries.google.com/tbr [HTTP/1.1 403 Forbidden 63ms] GET http://xml.alexa.com/data [HTTP/1.1 200 OK 141ms] GET http://toolbarqueries.google.com/tbr [HTTP/1.1 403 Forbidden 63ms] GET http://xml.alexa.com/data [HTTP/1.1 200 OK 141ms] GET http://toolbarqueries.google.com/tbr [HTTP/1.1 403 Forbidden 47ms] GET http://xml.alexa.com/data [HTTP/1.1 200 OK 125ms] GET http://toolbarqueries.google.com/tbr [HTTP/1.1 403 Forbidden 62ms] GET http://xml.alexa.com/data [HTTP/1.1 200 OK 140ms] GET http://tromboneforum.org/index.php [HTTP/1.1 200 OK 422ms] GET https://chat.banckle.com/livechat/monitor.do [HTTP/1.1 200 OK 1108ms] GET https://chat.banckle.com/livechat/monitor.do [HTTP/1.1 200 OK 936ms] GET https://chat.banckle.com/livechat/monitor.do [HTTP/1.1 200 OK 983ms] GET https://chat.banckle.com/livechat/monitor.do [HTTP/1.1 200 OK 1186ms] GET http://toolbarqueries.google.com/tbr [HTTP/1.1 200 OK 78ms] GET http://xml.alexa.com/data [HTTP/1.1 200 OK 234ms] GET http://www.uncoolthreads.co.uk/admin/modules.php [HTTP/1.1 200 OK 499ms] GET http://toolbarqueries.google.com/tbr [HTTP/1.1 200 OK 78ms] GET http://xml.alexa.com/data [HTTP/1.1 200 OK 124ms] GET http://www.uncoolthreads.co.uk/admin/includes/stylesheet.css [HTTP/1.1 304 Not Modified 171ms] GET http://www.uncoolthreads.co.uk/admin/images/pixel_trans.gif [HTTP/1.1 304 Not Modified 375ms] GET http://www.uncoolthreads.co.uk/admin/images/icon_arrow_right.gif [HTTP/1.1 304 Not Modified 344ms] GET http://www.uncoolthreads.co.uk/admin/get_table.php [HTTP/1.1 200 OK 452ms] GET http://toolbarqueries.google.com/tbr [HTTP/1.1 200 OK 78ms] GET http://xml.alexa.com/data [HTTP/1.1 200 OK 125ms] GET http://toolbarqueries.google.com/tbr [HTTP/1.1 403 Forbidden 78ms] GET http://xml.alexa.com/data [HTTP/1.1 200 OK 235ms] Don't know what any of this means.. Quote Link to comment Share on other sites More sharing options...
Dr. Rolex Posted August 19, 2014 Author Share Posted August 19, 2014 Hi guys well I restored to previous state before CKeditor and Order Handler. Then re-installed Order Handler. There is still a blank page there as before even without CKEditor so although there may have been problems with CKEditor it seems that's not the only problem I have. :( rev.jpg In the Browser Console it now shows this: Don't know what any of this means.. You need to filter the console output. :) If you're using Firefox, disable all logging except Javascript (JS) -> Errors and then try again. Or you can try Chromes console instead, it will filter by default. Quote osC OpenSSL Encryption with jCryptionSupport Forum jQuery/Ajax Advanced Statistics 2.3Support Forum jQuery/Ajax Advanced Order Handler 2.3.3Support ForumjQuery/Ajax Advanced Caching System 2.3.3Support ForumjQuery/Ajax Fast checkout/Shopping Cart/Login/Create Account 2.3.3Support ForumjQuery/Ajax Shopping Cart 2.3.3Support ForumjQuery/Ajax Dynamic Checkout 2.3.3Support ForumjQuery/Ajax Mini Cart for osCommerce 2.3.3Support ForumjQuery Cycle What's New InfoboxAuto Out Of Stock CSS Image OverlayjQuery-UI Autocomplete Product Search with Links & MySQLi support for osCommerce 2.X Link to comment Share on other sites More sharing options...
Dr. Rolex Posted August 19, 2014 Author Share Posted August 19, 2014 Hi Dr. Rolex, Im new to OSC, thanks for your addon, it helps alot! I got OSC 2.3.4 & Order Handler v3(28/7) fresh installed with no problem, then I did some test both on Chrome/Firefox, and got few issues: 1. Under Firefox only: right click on order table, the context menu pop up with 5 actions(Expand Order, Edit, Duplicate, Send Mail and Delete), but it doesnt do anything when you click on any of the action, I got the error message from firebug: "Error: ReferenceError: event is not defined Source File: ....01_order_handler_rev3.min.js" Seems like it caused by "if(0!==event.button){return false}" as Firefox doesnt read "event" like Chrome or IE. You can comment or remove that line and see what happens. So in the unminified file ./admin/includes/modules/order_handler/js/01_03_order_handler_rev3_module.js comment this line if ( 0 !== event.button ) return false; Or just remove/comment the code from the minified file (the code you mentioned in your post above). 2. Under Firefox only: during action "Expand Order", when I changing price for any items, the column "Order Total" value from order table changes to "undefined" (Chrome works fine). Find this code in ./admin/includes/modules/order_handler/js/01_03_order_handler_rev3_module.js newPrice = $( products_total_html ).find( "#ot_total_value" )[0].innerText; Replace With: newPrice = $( products_total_html ).find( "#ot_total_value" )[0].innerHTML; 3. Under both Chrome/Firefox: right click on order table, click "Expand Order" from context menu then close that expand panel, click "Expand Order" again with same order from context menu, but the expand panel will not show up again. Yeah, I'm aware of this bug. I don't know why it's behaving like this. Since I don't use the right click menu myself I haven't bothered to fix it but I'll take a look at it when I can. 4. Under Chrome only: I made 3 orders for testing, with status "Pending" "Processing" and "Delivered", when I open the main page(get_table.php), Firefox showing all orders with no problem, but Chrome only showing 1 order with status "Pending". The order handler saves your previous selection in a cookie, so if you had the "Sort orders" drop down to "Pending" before then it will be there next time you visit the page as well. 5. Whatever how many times you updated status and append comments, when refresh the main page, the column "Comments" will always show the first/earlist comments. Yep, that's the way I want it. ;) If you want to display e.g. the latest comment instead then you can change the statement in ajax_update.php that fetches all the orders $orders_query_raw = "SELECT o.orders_id, o.customers_id, o.customers_name, o.customers_company, o.delivery_street_address, o.delivery_suburb, o.delivery_city, o.delivery_postcode, o.delivery_state, o.delivery_country, o.customers_telephone, o.customers_email_address, o.date_purchased, o.orders_status, o.payment_method, MIN(osh.comments) as comments, ot.text AS order_total, (SELECT orders_status_name FROM orders_status WHERE orders_status_id = o.orders_status AND language_id = ?) as orders_status_name, (SELECT SUM(products_quantity) FROM orders_products WHERE orders_id = o.orders_id GROUP BY orders_id) as products_quantity FROM orders o JOIN orders_status_history osh USING (orders_id) JOIN orders_total ot USING (orders_id) WHERE ot.class = 'ot_total' $status $specific GROUP BY orders_id ORDER BY $order_by $page_limit"; Replace with $orders_query_raw = "SELECT o.orders_id, o.customers_id, o.customers_name, o.customers_company, o.delivery_street_address, o.delivery_suburb, o.delivery_city, o.delivery_postcode, o.delivery_state, o.delivery_country, o.customers_telephone, o.customers_email_address, o.date_purchased, o.orders_status, o.payment_method, MAX(osh.comments) as comments, ot.text AS order_total, (SELECT orders_status_name FROM orders_status WHERE orders_status_id = o.orders_status AND language_id = ?) as orders_status_name, (SELECT SUM(products_quantity) FROM orders_products WHERE orders_id = o.orders_id GROUP BY orders_id) as products_quantity FROM orders o JOIN orders_status_history osh USING (orders_id) JOIN orders_total ot USING (orders_id) WHERE ot.class = 'ot_total' $status $specific GROUP BY orders_id ORDER BY $order_by $page_limit"; This should display the latest comment, but I haven't tried it myself. It might need some additional fix to work. Quote osC OpenSSL Encryption with jCryptionSupport Forum jQuery/Ajax Advanced Statistics 2.3Support Forum jQuery/Ajax Advanced Order Handler 2.3.3Support ForumjQuery/Ajax Advanced Caching System 2.3.3Support ForumjQuery/Ajax Fast checkout/Shopping Cart/Login/Create Account 2.3.3Support ForumjQuery/Ajax Shopping Cart 2.3.3Support ForumjQuery/Ajax Dynamic Checkout 2.3.3Support ForumjQuery/Ajax Mini Cart for osCommerce 2.3.3Support ForumjQuery Cycle What's New InfoboxAuto Out Of Stock CSS Image OverlayjQuery-UI Autocomplete Product Search with Links & MySQLi support for osCommerce 2.X Link to comment Share on other sites More sharing options...
Guest Posted August 19, 2014 Share Posted August 19, 2014 (edited) You need to filter the console output. :) If you're using Firefox, disable all logging except Javascript (JS) -> Errors and then try again. Or you can try Chromes console instead, it will filter by default. ok I opened get_table.php in chrome - this time there was just one message Uncaught ReferenceError: goOnLoad is not defined On clicking the link on the right that said get_table.php it brought up some code and then I think it is referring to the <body onload="goOnLoad();"> ?? Edited August 19, 2014 by uncoolthreads Quote Link to comment Share on other sites More sharing options...
Dr. Rolex Posted August 19, 2014 Author Share Posted August 19, 2014 ok I opened get_table.php in chrome - this time there was just one message On clicking the link on the right that said get_table.php it brought up some code and then I think it is referring to the <body onload="goOnLoad();"> ?? This is probably "leftover" code from CKEditor or some other Add-On. Look in your admin/includes/template_top.php for <body onload="goOnLoad();"> and change it to <body> Quote osC OpenSSL Encryption with jCryptionSupport Forum jQuery/Ajax Advanced Statistics 2.3Support Forum jQuery/Ajax Advanced Order Handler 2.3.3Support ForumjQuery/Ajax Advanced Caching System 2.3.3Support ForumjQuery/Ajax Fast checkout/Shopping Cart/Login/Create Account 2.3.3Support ForumjQuery/Ajax Shopping Cart 2.3.3Support ForumjQuery/Ajax Dynamic Checkout 2.3.3Support ForumjQuery/Ajax Mini Cart for osCommerce 2.3.3Support ForumjQuery Cycle What's New InfoboxAuto Out Of Stock CSS Image OverlayjQuery-UI Autocomplete Product Search with Links & MySQLi support for osCommerce 2.X Link to comment Share on other sites More sharing options...
Guest Posted August 19, 2014 Share Posted August 19, 2014 This is probably "leftover" code from CKEditor or some other Add-On. Look in your admin/includes/template_top.php for <body onload="goOnLoad();"> and change it to <body> I looked through my addons folder and I added this code instead of the standard body tag when installing AJAX Attribute Manager which is great for adding attributes in the create product window. I'm assuming AJAX Attribute Manager won't work if I change it back to <body> (otherwise why change it?) - Jonas I know this isn't your addon and your concern is with Order Handler but is there a code fix that would allow both to work? thanks Russ Quote Link to comment Share on other sites More sharing options...
Guest Posted August 19, 2014 Share Posted August 19, 2014 I looked through my addons folder and I added this code instead of the standard body tag when installing AJAX Attribute Manager which is great for adding attributes in the create product window. I'm assuming AJAX Attribute Manager won't work if I change it back to <body> (otherwise why change it?) - Jonas I know this isn't your addon and your concern is with Order Handler but is there a code fix that would allow both to work? thanks Russ I made the quick change in template-top just to see if it would get Order Handler to work but I'm still looking at the same blank page. phew... Quote Link to comment Share on other sites More sharing options...
♥joli1811 Posted August 19, 2014 Share Posted August 19, 2014 yes you do not have to use onload="goOnLoad();"> will check there is an alternative Quote To improve is to change; to be perfect is to change often. Link to comment Share on other sites More sharing options...
♥joli1811 Posted August 19, 2014 Share Posted August 19, 2014 Look maybe still not the right place but an Attribute Manager manager install without the goony show is ********AJAX ATTRIBUTE MANAGER INSTALL********** ********Upload the yellow attributeManager folder to admin ********* it should be at the same level as the yellow image folder and yellow includes folder etc..... ********Open********* /catalog/admin/categories.php********** *** FIND *** Approx line 255 tep_db_perform(TABLE_PRODUCTS, $sql_data_array, 'update', "products_id = '" . (int)$products_id . "'"); } *******BELOW ADD********* //BOF - Zappo - Option Types v2 - AttribManager - ONE LINE - AJAX Attribute Manager plugin require_once('attributeManager/includes/attributeManagerUpdateAtomic.inc.php'); *** FIND *** Approx line 544 <tr bgcolor="#ebebff"> <td class="main"><?php echo TEXT_PRODUCTS_PRICE_GROSS; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_price_gross', $pInfo->products_price, 'onkeyup="updateNet()"'); ?></td> </tr> *******BELOW ADD********* <!-- BOF - Zappo - Option Types v2 - AttribManager - AJAX Attribute Manager plugin //--> <tr> <td colspan="2"><?php require_once( 'attributeManager/includes/attributeManagerPlaceHolder.inc.php' )?></td> </tr> <!-- EOF - Zappo - Option Types v2 - AttribManager - AJAX Attribute Manager plugin //--> *******Open********* /catalog/admin/includes/template_top.php *** FIND *** Approx line 43 <script type="text/javascript" src="includes/general.js"></script> *******BELOW ADD********* //BOF - Zappo - Option Types v2 - AttribManager - ONE LINE - AJAX Attribute Manager plugin <?php require_once( 'attributeManager/includes/attributeManagerHeader.inc.php' )?> ************************************************************************************************************************************************* attributeManager.zip Quote To improve is to change; to be perfect is to change often. Link to comment Share on other sites More sharing options...
♥joli1811 Posted August 19, 2014 Share Posted August 19, 2014 (edited) Now no idea if it helps it is just an alternative install You will have to replace the yellow attributeManager folder or it will not work Edited August 19, 2014 by joli1811 Quote To improve is to change; to be perfect is to change often. Link to comment Share on other sites More sharing options...
Dr. Rolex Posted August 19, 2014 Author Share Posted August 19, 2014 I made the quick change in template-top just to see if it would get Order Handler to work but I'm still looking at the same blank page. phew... Did you get any errors in Chrome console? Quote osC OpenSSL Encryption with jCryptionSupport Forum jQuery/Ajax Advanced Statistics 2.3Support Forum jQuery/Ajax Advanced Order Handler 2.3.3Support ForumjQuery/Ajax Advanced Caching System 2.3.3Support ForumjQuery/Ajax Fast checkout/Shopping Cart/Login/Create Account 2.3.3Support ForumjQuery/Ajax Shopping Cart 2.3.3Support ForumjQuery/Ajax Dynamic Checkout 2.3.3Support ForumjQuery/Ajax Mini Cart for osCommerce 2.3.3Support ForumjQuery Cycle What's New InfoboxAuto Out Of Stock CSS Image OverlayjQuery-UI Autocomplete Product Search with Links & MySQLi support for osCommerce 2.X Link to comment Share on other sites More sharing options...
Dr. Rolex Posted August 20, 2014 Author Share Posted August 20, 2014 3. Under both Chrome/Firefox: right click on order table, click "Expand Order" from context menu then close that expand panel, click "Expand Order" again with same order from context menu, but the expand panel will not show up again. To fix this, find this line in 01_03...module.js $( this ).find( "span.expand_order" ).click(); Replace with $( this ).find( "td.expand_order" ).find( "span" ).click(); Quote osC OpenSSL Encryption with jCryptionSupport Forum jQuery/Ajax Advanced Statistics 2.3Support Forum jQuery/Ajax Advanced Order Handler 2.3.3Support ForumjQuery/Ajax Advanced Caching System 2.3.3Support ForumjQuery/Ajax Fast checkout/Shopping Cart/Login/Create Account 2.3.3Support ForumjQuery/Ajax Shopping Cart 2.3.3Support ForumjQuery/Ajax Dynamic Checkout 2.3.3Support ForumjQuery/Ajax Mini Cart for osCommerce 2.3.3Support ForumjQuery Cycle What's New InfoboxAuto Out Of Stock CSS Image OverlayjQuery-UI Autocomplete Product Search with Links & MySQLi support for osCommerce 2.X Link to comment Share on other sites More sharing options...
Guest Posted August 20, 2014 Share Posted August 20, 2014 Did you get any errors in Chrome console? no there are now no errors at all but I'm still looking at a blank page.. Quote Link to comment Share on other sites More sharing options...
Guest Posted August 20, 2014 Share Posted August 20, 2014 I'd like to thank you and Joli for your help but I have decided to go for a different option to OSCommerce. I have spent 2 weeks configuring addons and still am nowhere near a finished result. I believe most of these addons should simply be part of the core and not require changing so many files and causing conflicts between different addons etc. I just wanted an independent online shop for my existing busy eBay business not a new career configuring this. I have spent so long on this I am neglecting my active business and that can't be a good idea. Again thanks for your help and advice, you have both been extremely helpful. 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.