nutbags.co.uk Posted January 23, 2014 Share Posted January 23, 2014 Hi on logging in to my admin tonight I had the message that I needed to update to the new 5.2.7 cubecart which I did.Since then I've just had a customer call me to say they were trying to place an order but when trying to check out received a message saying something like " page not visible"? I've gone into my admin and can see her orders sitting in the order box(2 duplicate orders where she's tried again) and if I click on the order and try to update its status to order complete etc,I then get a blank page! any one got any ideas? all working fine before the update.thanks Quote Link to comment Share on other sites More sharing options...
bsmither Posted January 23, 2014 Share Posted January 23, 2014 We would very much like to know if you have access to any error logs? The web server error log? The PHP error log? Is Cubecart's admin Error Logs still viewable? Quote Link to comment Share on other sites More sharing options...
nutbags.co.uk Posted January 23, 2014 Author Share Posted January 23, 2014 admin error log is empty system error log shows this message twice,but from jan 11/12th "File: [cart.class.php] Line: [267] "SELECT `option_id`, `value_id` FROM `CubeCart_option_assign` WHERE `matrix_include` = 1 AND `assign_id` IN () ORDER BY `option_id`, `value_id` ASC " - 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 `option_id`, `value_id` ASC' at line 1" Quote Link to comment Share on other sites More sharing options...
nutbags.co.uk Posted January 23, 2014 Author Share Posted January 23, 2014 ive just tried placing an order myself.i can log in,select items but when I go to checkout I get a blank page. the order is registered in admin. Quote Link to comment Share on other sites More sharing options...
nutbags.co.uk Posted January 23, 2014 Author Share Posted January 23, 2014 i've just restored v 5.2.3 from my back up files.Its all working again now though I have an error log saying this "----- Restore Log from files_5.2.3_08Oct13-175420.zip (23 Jan 2014 - 20:29:17) ----- includes/global.inc.php - Extract Status: write_protected" I'm not updating back to 5.2.7 unless I hear theres a fix!! Quote Link to comment Share on other sites More sharing options...
bsmither Posted January 23, 2014 Share Posted January 23, 2014 Ok, good to know you upgraded from CC523. We can include looking at data in the database that may not have been managed correctly when the update also updated the database. Quote Link to comment Share on other sites More sharing options...
Al Brookbanks Posted January 23, 2014 Share Posted January 23, 2014 I wonder if the error "page not visible" is generated by your browser if there is no data output? I have nothing to go on right now to be helpful. Can we access the store still and reproduce the problem? Our demo store is currently running 5.2.6 which is absolutely identical to 5.2.7 but using the more up to date encoder files which should make no difference. I'm not able to reproduce any errors on there. Keen to help but I need to get my hands on this error in real time. We haven't had any other reports of this yet. Maybe you can tell me which payment and shipping modules you have activated and if you have any 3rd party plugins? Quote Link to comment Share on other sites More sharing options...
bsmither Posted January 23, 2014 Share Posted January 23, 2014 @Al, I think a similar phrase to: "page not visible" would be: "This page cannot be displayed." Probably means the browser is timing out waiting for a response from the server. Any changes to the code as to how a proxy may respond? Can we arbitrarily blame Internet Explorer 11? On the other hand, CC527 is now including a default .htaccess file. Could this problem be similar to: '?do=embed' frameborder='0' data-embedContent>> Quote Link to comment Share on other sites More sharing options...
bsmither Posted January 23, 2014 Share Posted January 23, 2014 @nutbags, Does your CC523 store use an .htaccess file? Is your CC523 store located in a subdirectory where there exists another application in the folder above it, and that application has it's own .htaccess file? Quote Link to comment Share on other sites More sharing options...
nutbags.co.uk Posted January 24, 2014 Author Share Posted January 24, 2014 Hi Al payment mods used are paypal,print order form(i use as pay by bank transfer)plus I've added Robix pay on delivery(used for several years with no issues) I use all in one shipping. no other plug ins used. When I tried placing an order myself,on checking out i didn't get any messages,simply a blank page(ignore the "page not displayed" bit earlier.That's what my customer told me so probably a red herring!)I used google chrome not IE11. My site is hosted by heart internet,I do have two cubecart packages hosted there that are in the same folder.The other website now directs to my nutbags.co.uk site so effectively only one site.I can see a htaccess.file in the main folder but when you start asking me questions about this side of things,its going beyond my level of competance!! now that i've backed up to 5.2.3 its all working again but if you come up with any ideas that need me to upgrade again to 5.2.7 then I will. thanks Quote Link to comment Share on other sites More sharing options...
Al Brookbanks Posted January 24, 2014 Share Posted January 24, 2014 I think this is related to... '?do=embed' frameborder='0' data-embedContent>> Quote Link to comment Share on other sites More sharing options...
nutbags.co.uk Posted January 24, 2014 Author Share Posted January 24, 2014 thanks Al,do you mean I should now reload 5.2.7 and then change those two files ? Quote Link to comment Share on other sites More sharing options...
Al Brookbanks Posted January 24, 2014 Share Posted January 24, 2014 Yes that would be fine. The issue is that your store uses SMTP for email which causes a problem without those file changes this is how the issue slipped though testing as the default value is mail(). That adds up to why you got the blank page when you did in the checkout process. Sorry for any inconvenience caused. Quote Link to comment Share on other sites More sharing options...
nutbags.co.uk Posted January 24, 2014 Author Share Posted January 24, 2014 I just changed my mail sending from SMTP to mail() in my admin pages then updated to 5.2.7 and now it seems fine. I've placed a dummy order on the site, I received all the normal emails and all seems to be ok.I'll monitor orders that come through over the weekend but thanks once again for all the help. Quote Link to comment Share on other sites More sharing options...
Al Brookbanks Posted January 24, 2014 Share Posted January 24, 2014 Great. I upgraded the PHPMailer and did a file comparison between the old one to check for "drop in" replacement issues and didn't find anything. As email was sending I assumed all was find forgetting about the SMTP setting! There is always something! Thanks for your patience and understanding. 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.