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!

Tracking copied text using Javascript, jQuery, and PHP

Everyone knows that most web site usage statistics are tracked by web servers, including user local, operating systems, page views, unique visits, etc. However, if you’re really serious about tracking your user’s activity, you’ll use an analytics solution such as WebTrends, which is used by the New York Times to log on-screen actions which cannot be tracked by traditional means. Using the WebTrends dcsMultiTrack function, it’s possible to capture virtually any event that can trigger a JavaScript function, whether it’s on a static HTML page or inside a flash application.
(more…)

Joomla 1.0 to 1.5 Migration Issues

I have a good number of my clients running Joomla on their web sites, many of them large organization web sites with hundreds of articles and some of the most data-intensive extensions. I had been following the development progress of Joomla 1.5 for several months after its release, at which point I was still chained to the 1.0.x series for most existing sites because compatible extensions hadn’t been released. Now that most of the extensions that matter are at the very least compatible in legacy mode, I’ve been slowly working over the summer to get my clients migrated from the 1.0.x series to 1.5. It’s not the easiest process, in fact I think it’s the most complicated, rage-inducing software upgrade I’ve ever had to deal with… However it has gotten easier as I’ve encountered some common issues that can be (sometimes easily) avoided. (more…)

Goodbye Expression Engine, Hello WordPress.

I recently got the itch to renew a never-ending project that will keep me up nights and threaten to steal my focus from money-making endeavors; therefore there is a somewhat updated look here at DTH as well as a completely different publishing platform… Don’t get me wrong, I love Expression Engine. I just couldn’t get over the numerous blogging features and addons that WordPress has over EE. For certain projects I would definitely pick EE over WordPress just as I would even choose Joomla over both for many applications. Anyway, recently I’ve developed a few web sites professionally using WP and I think that as far as blogging software is concerned, it is pretty hard to beat.
(more…)

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