civicrm_contact_type doesn’t exist, 1146

If you’ve tried upgrading to CiviCRM 3.1.3 in Joomla, you may have run into the following error:

DB Error: no such table
Database Error Code: Table ‘your_database.civicrm_contact_type’ doesn’t exist, 1146

The solution is really simple, just follow these instructions, expertly provided by Deepak Srivastava over at the CiviCRM community forums:

Workaround – 1
==========
As soon as you see the error, doing a page reload should bring the upgrade screen back. And hitting upgrade button should work normally.

- OR -

Workaround – 2
==========
Before installing the new codebase increase the session lifteime, so that session doesn’t expire between installing the new codebase and hitting the upgrade.
Note: Session lifetime could be increased from Global Configuration >> Session Settings >> Session Lifetime. Change the session timeout back to previous one, once you done with upgrade.

Other than that, follow the official instructions, and you should be home-free!

Need help installing, configuring, or upgrading CiviCRM? I manage several large CiviCRM installations for national groups and NPOs. Don’t hesitate to contact me if you need help with yours!
Share this Post
  • Facebook
  • Twitter
  • Digg
  • Tumblr
  • Google Bookmarks
  • del.icio.us
  • LinkedIn
  • email

About Josh

Joshua Wood is a Web designer/developer located in Portland, OR. He is currently self-employed by Hint Media. Follow him on Twitter @joshuap.

No comments yet. Care to leave one? »

Leave a comment

Copyright © Hint Media

What’s this?

Distance to Here is a blog by web designer/developer/entrepreneur Joshua Wood, featuring the best in off-beat music, design, and culture.

I'm always interested in discovering new and interesting things, so if you have something you think I might like, feel free to let me know.

Close