Jump to content

Recommended Posts

Hello Everyone.

The database for my cubecart 6.0 installation is missing the geo_country table.

File: [cubecart.class.php] Line: [1193] "SELECT * FROM `CubeCart_geo_country` WHERE status > 0 ;" - Table 'jumperman_store.CubeCart_geo_country' doesn't exist

Since we use Stelle's All-in-one-shipping module, it creates a problem where our users see this message when trying to check out.

The following errors were detected:

  • Unfortunately there are no suitable shipping methods available for your order. This may be because the total weight of your order is too high or we cannot ship to your country. Please contact a member of our staff for any further inquiries.
  •  

We hadn't made any change on our end, so we have NO IDEA how the table came to be missing (PHP injection???), but we already checked through phpMyAdmin that the table indeed does not exist.

Would somebody have a .sql.zip file with the countries table, or any other method to fix this problem.

Will greatly appreciate!

 

Link to post
Share on other sites

Please download the latest CC6 package from CubeCart HQ. Unzip the file.

Inside the unzipped folder, find:

/setup/db/install/structure.sql
/setup/db/install/data.sql

Copy and paste only those lines that pertain to the missing table into the SQL Editor window on phpMyAdmin.

 

Link to post
Share on other sites

Hi Bsmither,

While I have no doubts that your solution works (your reputation precedes you), I remembered that I had once cloned this website in a different domain for a project; so I exported and re-imported the specific table.

Should this happen again (or should anyone else experience a similar problem) would you venture to express an opinion on what could have caused the table to just disappear?

Link to post
Share on other sites

Sorry, I do not.

For my development system, I keep the database's General Log enabled. That way, if anything funny happens, I will have a record of it.

Your hosting provider might not be keen to do that, however.

But, just on the outside chance there may be some clue somewhere, drop a note to your hosting provider and ask if anything out of the ordinary happened.

 

Link to post
Share on other sites

We host our site on our own shared VPS, so I have cPanel and WHM access.

I'm not familiar with an option to enable a db general log. Would you care to point to me the way to enable it?

Link to post
Share on other sites

A "shared VPS"... I do not know how far you can get at certain files and folders, and if you can restart services -- being "shared". Or do you have the entire (virtual) server machine to yourself? As in, you can access everything?

In the file my.cnf (maybe located at /etc/mysql/), there is:

general_log_file = /path/to/the/log/location/logname.log
general_log = 1

Restart the database server to make the config changes take effect.

Then you should read about creating a cron job that will "rotate" the log, optionally zipping it, for the month and restart the logging.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...