mobisat Posted November 26, 2016 Share Posted November 26, 2016 I was upgrading from 6.0.12 to 6.1.1 and all was going fine until for some reason something went wrong and the installation failed to complete properly. My admin folder was renamed to admin_Zc5U2F and also my admin.php was changed to admin_6gvxG5.php I have changed these back to admin and manually FTPd the 6.1.1 files across. When I try to do the upgrade the system seems to think my CubeCart is version 3.0.20 and just sits there at 80% for hours on end and seems to do nothing. I have attached the error log and obviously I changed my url to mysite.com I hope this is easy to fix? error_log.txt Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 26, 2016 Share Posted November 26, 2016 The errors logged would indicate that the setup routines are not talking to the correct database, or that the database is not giving the user/pass specified permission to make changes. I suspect the former reason. (If I recall) CubeCart setup assumes CC3 if there is no history table (meaning, a request for the latest record in the history table returns false, then this must be CC3). All of the 'is not allowed as a key' messages are from CubeCart being told to access the named columns, but those columns do not exist. When upgrading, I think you are offered a choice to drop all tables - starting fresh. See what you can do about making sure CubeCart is accessing the right database (look at /includes/globals.inc.php), and if so, take note of any backups you have of your database. Quote Link to comment Share on other sites More sharing options...
mobisat Posted November 26, 2016 Author Share Posted November 26, 2016 The database name referred to in /includes/globals.inc.php is correct I've just checked it. Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 26, 2016 Share Posted November 26, 2016 Please use an external database utility such as phpMyAdmin (typically a tool provided in your hosting account's control panel). Directly examine the database for the presence of tables and the content in a few of those tables. For example, CubeCart_seo_urls. Some of the columns in that table will be 'path', 'type', 'item_id', and a few others. Make sure those columns are present. Review the error_log you posted and look for a few of the columns in the tables mentioned to see if they are present. Quote Link to comment Share on other sites More sharing options...
mobisat Posted November 26, 2016 Author Share Posted November 26, 2016 I've checked the first dozen and they are are listed in the columns so I presume the rest are as well Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 26, 2016 Share Posted November 26, 2016 Finally to note, when these error are logged, it could mean that communication to the database was interrupted or denied. Quote Link to comment Share on other sites More sharing options...
mobisat Posted November 26, 2016 Author Share Posted November 26, 2016 I've tried using both 6.0.12 and 6.1.1 and both do exactly the same thing. Database check says OK no errors. Does it look like accessing the database is the issue, is there something I can run to check it? Is there something that can send simple queries to it to prove access to read/write? Quote Link to comment Share on other sites More sharing options...
mobisat Posted November 26, 2016 Author Share Posted November 26, 2016 Also It won't let me log into the admin panel and my storefront has changed to the attached. Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 26, 2016 Share Posted November 26, 2016 Having the Crosshatch skin folder present and showing, when you know that you have chosen a different skin to be used for the storefront, indicates that CubeCart could not get the store's configuration array out of the database, or if the configuration table in the database was accessible, then nothing was in it. Thus, CubeCart will use the first skin name found in the /skins/ folder (alphabetical order). Not being able to log in means your administrative account details are not retrievable to be verified. Elsewhere on the Internet, there are samples of a simple PHP database access script that can be placed and run in your CubeCart main folder. Using the same host/user/pass/database as found in globals.inc.php, this script can independently verify if your settings are correct and that your account has permission to access the database. Quote Link to comment Share on other sites More sharing options...
mobisat Posted November 26, 2016 Author Share Posted November 26, 2016 OK, looks like we are getting somewhere. I used this one https://gist.github.com/M165437/421cd2d23e53a111541a483971f7368b host=localhost Ran the script and it returned the following There are 78 tables. I'm presuming that means that the database can be accessed and the username and password are correct? Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 26, 2016 Share Posted November 26, 2016 I have 71 tables in a stock CubeCart 611, but your extra seven tables shouldn't be an issue. In your test code, what variant of the MySQL connectoid is it using? mysql() family or the mysqli() family? Also, have your hosting provider enable the database server's error log for your account. Let's see if the database is complaining about anything. Quote Link to comment Share on other sites More sharing options...
mobisat Posted November 26, 2016 Author Share Posted November 26, 2016 Database server info attached. I have been using Cubecart since version 3 or 4 with updates along the way so not sure if that accounts for the extra tables? I'll ask for the database server log to be turned on if isn't already. Quote Link to comment Share on other sites More sharing options...
mobisat Posted November 30, 2016 Author Share Posted November 30, 2016 I ended up leaving my host as their storage was still to high. I moved to @havenswift-hosting and I am now working again with a SSL certificate. Thanks for all your help bsmither. Quote Link to comment Share on other sites More sharing options...
havenswift-hosting Posted November 30, 2016 Share Posted November 30, 2016 2 hours ago, mobisat said: I moved to @havenswift-hosting and I am now working again with a SSL certificate. Glad to have you onboard and we can move your site forward from here Ian 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.