Jump to content

MySQL Error Occurred


Guest curtishayes123

Recommended Posts

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,

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 1 year later...

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

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

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

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

Guest
This topic is now closed to further replies.
×
×
  • Create New...