On 06/10/2014 01:04 PM, Tiago Sousa wrote:
don´t know if this is what you want:
use neutron;
show columns from routers;
+----------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+--------------+------+-----+---------+-------+
| tenant_id | varchar(255) | YES | | NULL | |
| id | varchar(36) | NO | PRI | NULL | |
| name | varchar(255) | YES | | NULL | |
| status | varchar(16) | YES | | NULL | |
| admin_state_up | tinyint(1) | YES | | NULL | |
| gw_port_id | varchar(36) | YES | MUL | NULL | |
+----------------+--------------+------+-----+---------+-------+
Yep, that's perfect.
I'm looking at my icehouse install that I just created last week. It has
the enable_snat column as the last column:
| enable_snat | tinyint(1) | NO | NULL | |
everything else is the same as your table.
So I don't know how it happened, but when your table was created, it was
done without that last field.
I'd just try adding the field to the routers table and see if that
solves your issue. It will at least fix the SQL query error.
B
_______________________________________________
Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
Post to : [email protected]
Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
