<div dir="ltr">great!<div><br></div><div>adding that row solved it. (but still don´t know how it wasn´t there in the first place) oh well</div><div><br></div><div>Thanks for the help Brian!</div></div><div class="gmail_extra">
<br clear="all"><div>Cumprimentos,<br>Tiago Sousa</div>
<br><br><div class="gmail_quote">On Tue, Jun 10, 2014 at 8:39 PM, Brian Jarrett <span dir="ltr"><<a href="mailto:celttechie@gmail.com" target="_blank">celttechie@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="">On 06/10/2014 01:04 PM, Tiago Sousa wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
don´t know if this is what you want:<br>
<br>
use neutron;<br>
show columns from routers;<br>
+----------------+------------<u></u>--+------+-----+---------+----<u></u>---+<br>
| Field          | Type         | Null | Key | Default | Extra |<br>
+----------------+------------<u></u>--+------+-----+---------+----<u></u>---+<br>
| tenant_id      | varchar(255) | YES  |     | NULL    |       |<br>
| id             | varchar(36)  | NO   | PRI | NULL    |       |<br>
| name           | varchar(255) | YES  |     | NULL    |       |<br>
| status         | varchar(16)  | YES  |     | NULL    |       |<br>
| admin_state_up | tinyint(1)   | YES  |     | NULL    |       |<br>
| gw_port_id     | varchar(36)  | YES  | MUL | NULL    |       |<br>
+----------------+------------<u></u>--+------+-----+---------+----<u></u>---+<br>
</blockquote>
<br></div>
Yep, that's perfect.<br>
<br>
I'm looking at my icehouse install that I just created last week. It has the enable_snat column as the last column:<br>
<br>
| enable_snat    | tinyint(1)    | NO   | NULL    |        |<br>
<br>
everything else is the same as your table.<br>
<br>
So I don't know how it happened, but when your table was created, it was done without that last field.<br>
<br>
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.<div class="HOEnZb"><div class="h5"><br>
<br>
B<br>
<br>
______________________________<u></u>_________________<br>
Mailing list: <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack" target="_blank">http://lists.openstack.org/<u></u>cgi-bin/mailman/listinfo/<u></u>openstack</a><br>
Post to     : <a href="mailto:openstack@lists.openstack.org" target="_blank">openstack@lists.openstack.org</a><br>
Unsubscribe : <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack" target="_blank">http://lists.openstack.org/<u></u>cgi-bin/mailman/listinfo/<u></u>openstack</a><br>
</div></div></blockquote></div><br></div>