Guest curtishayes123 Posted March 23, 2012 Share Posted March 23, 2012 Hi all - new to the forums and i have a question. I'm seeing a MySQL error that reads the following: MySQL Error Occurred Error Message: 1146: Table 'market_database.CubeCart_config' doesn't exist SQL: SELECT array FROM CubeCart_config WHERE name = 'config' This may have to do with the configuration file inside phpMyAdmin? Thanks, Link to comment Share on other sites More sharing options...
Robsta Posted March 23, 2012 Share Posted March 23, 2012 Does the table 'CubeCart_config' exist? Link to comment Share on other sites More sharing options...
Guest curtishayes123 Posted March 26, 2012 Share Posted March 26, 2012 No, it doesn't. A table called cube_CubeCart_config is running, however. Basically, all of the tables are cube_CubeCart_tablename ... Let me know what can be done here. Thanks Link to comment Share on other sites More sharing options...
Robsta Posted March 26, 2012 Share Posted March 26, 2012 This means you are missing the database prefix (dbprefix) in the global.inc.php file.... add 'cube_'. Link to comment Share on other sites More sharing options...
Guest curtishayes123 Posted March 28, 2012 Share Posted March 28, 2012 Thanks! Link to comment Share on other sites More sharing options...
M. Smith Posted May 1, 2013 Share Posted May 1, 2013 I think I'm having the same issue. Where do you add the 'cube_' in the global.inc.php file? Link to comment Share on other sites More sharing options...
bsmither Posted May 1, 2013 Share Posted May 1, 2013 There will be a series of statements that start with: $glob['xyz'] One of those will be $glob['dbprefix'] It must have the database tables prefix in quotes: $glob['dbprefix'] = 'cube_'; Link to comment Share on other sites More sharing options...
M. Smith Posted May 1, 2013 Share Posted May 1, 2013 Cool, got rid of that error! Still getting the MySQL can't open sessions error, though (sigh). My brain hurts. Link to comment Share on other sites More sharing options...
M. Smith Posted May 1, 2013 Share Posted May 1, 2013 Oops! That's not right. Disregard my last comment. Here's what I had before I added 'cube_' in the global.inc.php file: Warning: Invalid argument supplied for foreach() in /homepages/38/d121554869/htdocs/battlemart/store/includes/functions.inc.php on line 1019 MySQL Error Occured Error Message: 1054: Unknown column 'sessId' in 'field list' SQL: SELECT sessId FROM CubeCart_sessions WHERE sessId='' Now I have (after adding the prefix): MySQL Error Occured Error Message: 1146: Table 'db468447140.cube_CubeCart_config' doesn't exist SQL: SELECT array FROM cube_CubeCart_config WHERE name = 'config' Link to comment Share on other sites More sharing options...
bsmither Posted May 2, 2013 Share Posted May 2, 2013 There is no line 1019 in the file functions.inc.php. But there is in the functions file for CubeCart v4. Would you please restate what version of CC you are running. Restore the global.inc.php file to what it was. The statement, SELECT sessId FROM CubeCart_sessions WHERE sessId='' comes from CC4. If you think you have upgraded from CC4 to CC5, something went wrong. Link to comment Share on other sites More sharing options...
M. Smith Posted May 2, 2013 Share Posted May 2, 2013 Yes, I'm sorry! I'm still using CC4 on this site. I forgot that my tagline was referring to another site that I have. I restored the global.inc.php file, and now I'm back to this: Warning: Invalid argument supplied for foreach() in /homepages/38/d121554869/htdocs/battlemart/store/includes/functions.inc.php on line 1019 MySQL Error Occured Error Message: 1054: Unknown column 'sessId' in 'field list' SQL: SELECT sessId FROM CubeCart_sessions WHERE sessId='' Link to comment Share on other sites More sharing options...
bsmither Posted May 2, 2013 Share Posted May 2, 2013 Sorry, I don't know enough about CC4 to help. Maybe someone at www.cubecartforums.org has a better idea. Link to comment Share on other sites More sharing options...
M. Smith Posted May 2, 2013 Share Posted May 2, 2013 Okay, thanks so much anyway for your efforts! Link to comment Share on other sites More sharing options...
Dirty Butter Posted May 2, 2013 Share Posted May 2, 2013 Since this forum is only for v5 I have locked this thread. Hopefully you will get the help you need on the 3rd party forum. Link to comment Share on other sites More sharing options...
Recommended Posts