Drupal 6.x Countries_api – Data too long for column ‘iso3′ at row 1 query: INSERT INTO countries_api_countries
Well well, here we are again with the next Drupal error. Having just downloaded the Drupal 6.x module countries_api all I did then was to tick the box in the modules section to activate it.
Lo and behold here we have our next error sequence to resolve. I must say though that it is quite rare to be able t activate a Drupal module without regretting having ever been born! (lol)
I love Drupal but make no mistake it’s by no means smooth sailing…

Problems activating the countries_api module for Drupal 6.x
It would appear from this that the simple answer is that the database field that defines the length of the column iso3 is simply not large enough. I’m going to have a look and get back to you in a jiffy…
So far I have just ignored this error. I was just trying to activate the Google Analytics module (along with charting, charting_api and system) It hasn’t caused me any problems so far, but it has yet to be seen if there are any real problems caused by this.
If you have any further information of the effect of this, please let me know in the comments.
Simon
* UPDATE *
After all that, I’ve now had a proper chance to look at Drupal’s ‘Google Analytics Module’ and I’ve decided to uninstall it…
My reasoning is that Google Analytics looks a lot nicer and has all the features, it also doesn’t require 5 modules to be installed namely:
Google Analytics
Google Analytics API
Countries
Countries_API
Services
I’ll now just use the JavaScript code in my page.tpl.php file until something nicer comes along. I would however only like to call the stats for users that aren’t me because I call up my sites all the time when I’m developing them and so the reports would be very wonky indeed.
Related posts:
- Beginning Drupal
- How to check if Google Analytics is working correctly.
- Ultimate GA doesn’t work with my WordPress theme – Missing urchin.js|Missing _uacct|Missing urchinTracker
- If your Drupal Admin pages are slow, here’s the fix.
- Helping out mates.
- Drupal mailhandler smtp localhost error
- Drupal Gmail Module – Solved.
Tags: drupal
Leave a Reply
Hot Topics
- Creating a Drupal 6 custom login form – Step by Step tutorial.
- WordPress Contact Form 7 & WP-Mail-SMTP problem solved
- imagecache wrong path – SOLVED!
- 7129/6105195 Edward Leedskalnin’s anti-gravity – How he built Coral Castle.
- How to take Ownership of a Drive, Folder or File in Windows 7
- WordPress widgets not saving or dragging?
- Firefox – update favicon.ico (SOLVED)
- IE emulator for FireFox
- Site off-line The site is currently not available due to technical problems. Please try again later. Thank you for your understanding. (SOLVED!)
- Access denied – Drupal 6.x
Archives
- February 2012
- November 2011
- September 2011
- August 2011
- June 2011
- January 2011
- December 2010
- November 2010
- October 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- January 2009
- December 2008
- August 2008
- June 2008
