katsbits Posted March 15, 2017 Share Posted March 15, 2017 Have an odd problem with a store displaying a completely blank page home page (no source code either) but Admin is fully accessible. Problem seems to have started when domain level redirect to https was implemented (something not previously fully honored by CC), but could also be the result of upgrading to the latest version from and older (v5) install. Looking though the Admin System Error log the only error that crops up has something to do with SQL/database not SSL so not sure what's going on. Any ideas? Thanks in advance. Quote File: [seo.class.php] Line: [904] "SELECT C.cat_id, C.cat_name, C.cat_parent_id, S.path FROM `CubeCart_category` as C LEFT JOIN `CubeCart_seo_urls` as S ON S.item_id=C.cat_id AND S.type='cat' AND S.custom='1' ORDER BY C.cat_id DESC " - Unknown column 'S.custom' in 'on clause' Quote Link to comment Share on other sites More sharing options...
bsmither Posted March 15, 2017 Share Posted March 15, 2017 If the latest CC6 codebase overwrote the CC5 codebase (typical procedure of a CubeCart upgrade), but you did not run to completion the www.mystore.com/setup/index.php process, then the database may not have the necessary structure to successfully run CC6. If you haven't run setup, please do so. Make sure it runs to completion. (Some browsers can have meta-redirect disabled - meaning for each step of the database upgrade sequence, the user will need to click Continue.) I mention this because having the 'custom' column missing in the CubeCart_seo_urls table indicates to me the setup did not run to completion. Quote Link to comment Share on other sites More sharing options...
katsbits Posted March 15, 2017 Author Share Posted March 15, 2017 (edited) Thanks for the quick response. Hmm it's a while ago now but I recall the upgrade running to completion. Same for updates. If this is just a missing column shouldn't manually added that to the DB fix the problem? As a last resort a clean install could be performed but as the DB has already been modified by 6.xx isn't that likely to cause more issues? [update] original install was 5.2.16, upgraded to 6.0.10, then subsequent 6.xx versions. Don't recall a failed install but that must have happened resulting in this longstanding issue. Edited March 15, 2017 by katsbits Quote Link to comment Share on other sites More sharing options...
bsmither Posted March 15, 2017 Share Posted March 15, 2017 (edited) The 'missing column' situation should not be causing the Homepage to not display. That particular query simply gets a "friendly" version of a link to a category page. If there is no result from the query, CubeCart should not crash. If a blank Homepage is still an issue, please create the error_log and maybe there is a clue we can explore. Edited March 15, 2017 by bsmither Quote Link to comment Share on other sites More sharing options...
katsbits Posted March 15, 2017 Author Share Posted March 15, 2017 (edited) There are two issues; 1) script conflict with ini_set() being disabled (for security) 2) and two persistent errors in seo.class.php (below) - PHP Warning: Invalid argument supplied for foreach() in /[path to install]/classes/seo.class.php on line 905 - PHP Fatal error: Call to undefined function mb_strtolower() in /[path to install]/classes/seo.class.php on line 1015 Edited March 15, 2017 by katsbits Quote Link to comment Share on other sites More sharing options...
bsmither Posted March 16, 2017 Share Posted March 16, 2017 The Warning, not so much of a critical issue. The call to mb_strlower() is necessary for CC615 (and maybe a couple earlier versions). If you are hosted by a commercial operation, you will need to have them change to a more recent version of PHP, or to somehow add the Multi-Byte library to PHP. This may involve re-compiling PHP from its source with Multi-Byte capability included in the options. (On Linux systems, apparently it's fairly easy to compile PHP with whatever optional capabilities are needed.) The command ini_set() being disabled is a critical concern. Even the admin side of CubeCart wants to use ini_set(). So why admin works is a mystery. Why CC5 worked is a mystery. If there are only some settings that can't be overridden, maybe that's what is going on. But this is a critical issue that must be resolved with your hosting provider. Quote Link to comment Share on other sites More sharing options...
katsbits Posted March 16, 2017 Author Share Posted March 16, 2017 (edited) Thanks for the info. The problem appears to have been the multibyte module, it was missing. Once installed the store appeared. I'll double check ini_set() was part of the problem given the fact that, as you point out, if disabled it would seem odd that part of the site worked but another didn't. Will post back momentarily. [edit] yep problem was definitely multibyte.. disabling ini_set() has no effect so that's good. Many thanks for your help with this issue! Edited March 16, 2017 by katsbits Quote Link to comment Share on other sites More sharing options...
bsmither Posted March 16, 2017 Share Posted March 16, 2017 If the command ini_set() is still disabled, the consequences -- not seen as yet -- will come back to bite you in the .... 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.