Home » Forums » Ubercart » Support

please help: I'm wedged trying to install with UC_regions and UC_worldquote

Submitted by dkashen on Sun, 03/02/2008 - 17:04
dkashen
Posts: 69
 Joined: 08/08/2007
Internationalizationizer

Here's the error:
user warning: Unknown column 'countries' in 'field list' query: SELECT countries FROM uc_regions WHERE id = 1 in ../includes/database.mysql.inc on line 172.

I'm getting this same error with 3 distinct, "scratch" installs:

drupal 5.7 , ubercart B3
drupal 5.6 , ubercart B6
drupal 5.6, ubercart B3

The last case is the most frustrating, because the author of uc_worldquote "zmove" reports that it's working fine under those versions.

Any tips or help are appreciated.
permalink #1 Sun, 03/02/2008 - 21:47
half_brick

Posts: 34
 Joined: 02/04/2008

Hi dkashen,
Looks like you maybe have installed the version of uc_regions that I modified to use a join table (http://www.ubercart.org/contrib/850#comment-12421), but you maybe have installed a version of uc_regions that is still trying to use the old database schema.
In your database do you have "uc_regions" and "uc_regions_countries" tables, or just a "uc_regions" table?

Cheers,
Toby

permalink #2 Mon, 03/03/2008 - 09:14
dkashen
Posts: 69
 Joined: 08/08/2007
Internationalizationizer

Thanks for getting back!

looks like I have both
uc_regions
AND
uc_regions_countries

the .zip I'm installing into modules/ubercart/shipping
is uc_regions_v3.zip (5.11Kb).

I found it via the bottom of the thread you mentioned:
http://www.ubercart.org/contrib/850#comment-12421

extra observations
1 I'm installing from scratch so there shouldn't be any legacy issues. However if you could tell me exactly which version to use and what I should see in the DB that would be great.

2 when defining a region for the first time you can select the countries; However, I'm finding that the countries I select for a region don't show up in the summary of that defined region. I have to edit the region for the country(ies) to be included. I can send along some screen shots if this is a problem.

Thanks again,
DK

permalink #3 Mon, 03/03/2008 - 10:30
dkashen
Posts: 69
 Joined: 08/08/2007
Internationalizationizer

ok,
I went back to that thread and installed
uc_regions_v1.zip
along with drupal 5.6
which seems to work
then I upgraded to dr 5.7 and it still worked

thanks for the tip!