Guest PurpleWay Posted July 4, 2007 Share Posted July 4, 2007 I had upgraded to V3.0.16 and all was working well. I had taken over as webmaster to get the cart and site working that had been dorment for a year. The client wanted to change hosting providers,so I followed instructions at CubeCart on transferring the db and all files. First, the db would not show in php,yadmin, but that has since been fixed by a tech at the new hosting company. I had errors in the cart itself, so decided to install a fresh CubeCart. Although I will need to do some edits to the index.php file and some other files, I can't figure out why no existing products are showing....I've lost the inventory, although the db exists. Can anyone help? - Frank Quote Link to comment Share on other sites More sharing options...
Guest Posted July 4, 2007 Share Posted July 4, 2007 My best bet would be to make sure your settings match your new hosts information in global.inc.php. This is usually the cause of database problems. Otherwise, you might try doing a repair on the database thru phpmyadmin. Quote Link to comment Share on other sites More sharing options...
Guest PurpleWay Posted July 5, 2007 Share Posted July 5, 2007 Mysty, The database is intact...and the global.inc.php file is populated with "localhost" as database server. Could it be that the original database passeord is stored in the database itself, and I should not have reset to a different password? I kept the original db name, but assigned myself as the user with a different password than that which was used on the original hosting provider. I'm not keen on database management, but I'm trying to determine what's wring. I did purchase support from CubeCart, just waiting to hear from them. Thanks, -Frank My best bet would be to make sure your settings match your new hosts information in global.inc.php. This is usually the cause of database problems. Otherwise, you might try doing a repair on the database thru phpmyadmin. Quote Link to comment Share on other sites More sharing options...
Guest Posted July 5, 2007 Share Posted July 5, 2007 I would check with your hosting company and make sure they use localhost as the database path. Some use an ip address or other information. As long as you set the password thru mysql, it would match. Quote Link to comment Share on other sites More sharing options...
bsmither Posted July 5, 2007 Share Posted July 5, 2007 decided to install a fresh CubeCart. In this fresh installation, (page 3 of the install script) did you keep the checkbox setting to "Drop existing tables?" I don't think I'm wrong when I say that (due to personal experience), with this box checked, existing tables with the same name are deleted and fresh, empty tables are created. At least you don't get server or script errors saying "Unable to access database." Quote Link to comment Share on other sites More sharing options...
Guest PurpleWay Posted July 8, 2007 Share Posted July 8, 2007 I'm still having problems with database issues. Moved hosting to a new provider. Upload of db to phpmyadmin. Cart shows products, but no product pictures. Can't login to admin with original login. Getting this error: MySQL Error Occured 1054: Unknown column 'failLevel' in 'where clause' QUERY = SELECT adminId FROM CubeCart_admin_users WHERE username = 'admin' AND password = 'c5d165ef07098607df97943d95588781' AND failLevel < 5 AND blockTime < 1183874462 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.