Table 'psadmin_drupal.ad_geoip_ads_city' doesn't exist
mennonot - July 29, 2008 - 15:58
| Project: | Ad GeoIP |
| Version: | 5.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Jeremy@kerneltrap.org |
| Status: | closed |
Jump to:
Description
When editing an individual ad, I get the following error 4 times at the top of the page:
user warning: Table 'psadmin_drupal.ad_geoip_ads_city' doesn't exist query: SELECT city, format FROM ad_geoip_ads_city WHERE aid = 17556 in .../includes/database.mysql.inc on line 172.
I looked in the database and this table doesn't exist and it doesn't show up in ad_geoip.install either. Here's the GEOIP listing from my status report:
GEO-106FREE 20080301 GeoIP Country Edition; GEO-533LITE 20080701 GeoIP City Edition, Rev 0; GEO-533LITE 20080701 GeoIP City Edition, Rev 1

#1
Thanks for the bug report. The table was only being created if you upgraded from an earlier version. I checked in a fix to the development branch and will roll a 1.1.1 release as this affects anyone trying to use 1.1.0.
#2
Automatically closed -- issue fixed for two weeks with no activity.