views:

612

answers:

0

I'm using MySQL

my table model :

class Offer(models.Model):
...
    additional=models.CharField('Dodatkowe informacje',max_length="100",choices=ADDITIONAL_CHOICES.items(),blank=True)
...

my form: class OfferForm(forms.ModelForm): additional=forms.MultipleChoiceField(label='dodatkowe informacje',choices=ADDITIONAL_CHOICES.items(),required=False) class Meta: model=Offer

while saving form i receive this error : (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), description = 'sagas', local_h = '12.3450000000', local_w = '45.0940000' at line 1")

sql looks like this: 'UPDATE offers_offer SET cat_id = 2, type = 2, estate_type = 3, created = \'2009-03-17 01:58:31\', area = \'3245.000\', city = \'sdfghksdj\', district = \'gksdgj\', price = \'235252.000\', additional = ("\'1\'",), description = \'sagas\', local_h = \'12.3450000000\', local_w = \'45.0940000000\', gmapimg = \'\', title = \'dgsg\', meta = \'sdgs\', publish = 1 WHERE offers_offer.id = 3 '

when I used postgre I didn't this error :/ now I work with MySQL and have no ideas maybe i should use other fild type than vchar ?