I am using Geomanager for storing MultiPolygon data.
I have below tables:
il
class Customer(gismodels.Model):
is_active = models.CharField(max_length=15, default="Inactive", choices= ACTIVE_CHOICES)
name = models.CharField(max_length=255)
organisation_name = models.CharField(max_length=100, blank = True)
rating = models.CharField(max_length=25,choices=RATING_CHOICES,null=True, blank=True)
description = models.TextField(max_length=255, blank=True)
email_primary = models.EmailField(max_length=1000 ,null=False, default="test_RT@gmail.com")
email_secondary = models.EmailField(max_length=1000 ,null=True, blank=True)
phone_primary = models.CharField(max_length=1000)
phone_secondary = models.CharField(max_length=1000, null=True, blank=True)
address = models.CharField(max_length=2000, blank=True)
has_shop = models.CharField(max_length=128, verbose_name="Does he have a shop?", choices=[('Yes', 'Yes'),('No', 'No')],blank=True)
working_hours_start = models.CharField(max_length=12,blank=True,verbose_name="What is the
website = models.URLField(blank=True, null=True)
expertise = models.CharField(max_length=2000, blank=True)
experience = models.CharField(max_length=12, null=True, blank=True)
city = models.ForeignKey(City, null=True)
country = models.CharField(max_length=255,choices=COUNTRY_CHOICES,null=True, blank=True)
multi_poly = gismodels.MultiPolygonField(srid=4326, null=True, blank=True,verbose_name="Service Locations")
objects = gismodels.GeoManager()
class Meta:
db_table = 'customer'
verbose_name = 'Customer'
verbose_name_plural = 'Customers'
class Logs(models.Model)
'''logs Info'''
merchant = models.ForeignKey(Merchant, verbose_name='Merchant')
message = models.TextField(max_length=255, blank=True)
created_at = models.DateTimeField(auto_now_add=True)
updated_at = models.DateTimeField(auto_now=True)
So from shell when i try to access merchant from logs object i get error
Traceback (most recent call last):
File "<console>", line 1, in <module>
File "/home/web/Search/local/lib/python2.7/site-packages/django/db/models/fields/related.py", line 572, in __get__
rel_obj = qs.get()
File "/home/web/Search/local/lib/python2.7/site-packages/django/db/models/query.py", line 351, in get
num = len(clone)
File "/home/web/Search/local/lib/python2.7/site-packages/django/db/models/query.py", line 122, in __len__
self._fetch_all()
File "/home/web/Search/local/lib/python2.7/site-packages/django/db/models/query.py", line 966, in _fetch_all
self._result_cache = list(self.iterator())
File "/home/web/Search/local/lib/python2.7/site-packages/django/db/models/query.py", line 265, in iterator
for row in compiler.results_iter():
File "/home/web/Search/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 700, in results_iter
for rows in self.execute_sql(MULTI):
File "/home/web/Search/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 786, in execute_sql
cursor.execute(sql, params)
File "/home/web/Search/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 81, in execute
return super(CursorDebugWrapper, self).execute(sql, params)
File "/home/web/Search/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 65, in execute
return self.cursor.execute(sql, params)
File "/home/web/Search/local/lib/python2.7/site-packages/django/db/utils.py", line 94, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/home/web/Search/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 65, in execute
return self.cursor.execute(sql, params)
File "/home/web/Search/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 128, in execute
return self.cursor.execute(query, args)
File "/home/web/Search/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
self.errorhandler(self, exc, value)
File "/home/web/Search/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1054, "Unknown column 'customer.city_id' in 'field list'")
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/910f8f8d-c2c3-4a72-b95e-3edbd96eafc4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment