MySQL Error Occurred

[Guest curtishayes123]

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,

[Robsta]

Does the table 'CubeCart_config' exist?

[Guest curtishayes123]

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

[Robsta]

This means you are missing the database prefix (dbprefix) in the global.inc.php file.... add 'cube_'.

[Guest curtishayes123]

Thanks!

[M. Smith]

I think I'm having the same issue.  Where do you add the 'cube_' in the global.inc.php file?

[bsmither]

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_';

[M. Smith]

Cool, got rid of that error!  Still getting the MySQL can't open sessions error, though (sigh).  My brain hurts.

[M. Smith]

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'

[bsmither]

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.

[M. Smith]

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=''

[bsmither]

Sorry, I don't know enough about CC4 to help. Maybe someone at www.cubecartforums.org has a better idea.

[M. Smith]

Okay, thanks so much anyway for your efforts!

[Dirty Butter]

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.