I went to try to uninstall and re-install this module and when I uninstalled it, it gave me this fatal first:

Fatal error: require_once() [function.require]: Failed opening required '/var/www/vhosts/drupal-7.net/httpdocs/sites/all/modules/contrib/commerce/modules/customer/includes/commerce_customer_profile.controller.inc' (include_path='.:') in /var/www/vhosts/drupal-7.net/httpdocs/includes/bootstrap.inc on line 2811

When this error happens the site does not even load.

However when I add the module again the site comes up but I get this error instead:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'droopadoopseven.edutech_commerce_tax_rate' doesn't exist: SELECT * FROM {commerce_tax_rate}; Array ( ) in commerce_tax_ui_commerce_tax_rate_info() (line 347 of /var/www/vhosts/drupal-7.net/httpdocs/sites/all/modules/contrib/commerce/modules/tax/commerce_tax_ui.module).

And I still cannot get back in to do anything. Again I am not sure what went wrong or even how to fix it. :(

Comments

nsantillo’s picture

nsantillo commented

I forgot to attach the website that I am working on. http://edutechnologysales.com ... sorry about that.

rszrama’s picture

rszrama commented

Is the table indeed missing from your database?

nsantillo’s picture

nsantillo commented
Status: Active » Closed (fixed)

It is not now. We went in and manually flushed the database. (I could not do it before now) And now my site is back up and the error is gone. However thank you for replying. This issue is no longer an issue for my site.

elpino’s picture

elpino commented
Version: 7.x-1.x-dev » 7.x-1.0-rc1
Category: support » bug
Priority: Critical » Major
Status: Closed (fixed) » Active

I am having the same trouble from a fresh install.

Finished installing commerce module then proceeded to install administration menu, wysiwyg and cke editor. After installing these the same fatal error appeared.

I have no idea if the table existed in the first place. But the error is right as it doesn't exist in the DB.

The fresh installation came from the commerce kickstart profile, which itself didn't install correctly. I had to manually copy the module files from the profiles/commerce_kickstart/modules subdirectory into sites/all/modules. All this was done on a local server on my PC, memory limits may be an issue during installation but all commerce modules had been already installed without issues before the fatal error started appearing. No module was configured, or content created since the installation.

j0rd’s picture

j0rd commented

@elpino, are you using database table prefixes as well?

I did a kickstart install today and I just checked. The commerce_tax_rate is in fact in my database. I do not use database table name prefixes.

rszrama’s picture

rszrama commented

The profile installed correctly; that directory is a valid modules directory and the default place the Drupal packaging script drops module files included in a distribution. I'm not sure what would have allowed your Tax module to be installed without the table being created... are you not using MySQL?

rszrama’s picture

rszrama commented
Status: Active » Closed (cannot reproduce)

We can't really do anything without more information here. I don't know of any issue that would prevent a table from being created, and I've installed from a vanilla Kickstart hundreds of times by now. It's likely a system issue if anything.

elpino’s picture

elpino commented

I'm sorry I didn't respond promptly.

What happened is that for some reason the distribution couldn't install at all, I don't remember the error given but most probably it had to do to hardware limitations. My solution was to move the modules from the profile directory to the all/modules as if installing by hand each one separately. By installing one module at a time, I didn't have any problems.

The problem came after. I suspect installing either administration menu, wysiwyg or cke editor modules somehow messed with the tables. But I don't know if or how this is possible.

I'll try and do a vanilla Kickstart as you say on a server and report if I have any more troubles. It could be a system issue as you mentioned.

rszrama’s picture

rszrama commented

Cool. I'll be happy to help if you turn anything up. : )

elpino’s picture

elpino commented

Installed from Kickstart on server then installed the modules that I was working with when I initially had my problems and now similar problems arose.

So yeah, system issue.

What is funny though is why would other modules' failed or problem installation affect Commerce DB tables? or was it a fluke?

rszrama’s picture

rszrama commented

I'm really not sure. Technically they shouldn't have anything to do with it, and I haven't seen a module yet that corrupts other tables on install.

misael78’s picture

misael78 commented
Issue summary: View changes

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'practicar.commerce_tax_type' doesn't exist: SELECT * FROM {commerce_tax_type}; Array ( ) in commerce_tax_ui_commerce_tax_type_info() (line 235 of C:\Misael Dubon\Xampp servidor\htdocs\practicar\sites\all\modules\commerce\modules\tax\commerce_tax_ui.module).
The website encountered an unexpected error. Please try again later.

please i need help with this