# Add column: Error executing SQL not supported. FIXME!!: near "not": syntax error

**URL:** <https://forum.liquibase.org/t/add-column-error-executing-sql-not-supported-fixme-near-not-syntax-error/2253>\
**Category:** General Discussion\
**Created:** [April 23, 2013, 5:43am UTC](https://forum.liquibase.org/t/add-column-error-executing-sql-not-supported-fixme-near-not-syntax-error/2253 "2013-04-23T05:43:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [April 23, 2013, 5:43am UTC](https://forum.liquibase.org/t/add-column-error-executing-sql-not-supported-fixme-near-not-syntax-error/2253/1 "2013-04-23T05:43:00Z")

</div>

Hi

&nbsp;

I am trying to add a column. But I get an error like this:

&nbsp;

SEVERE 23-04-13 00:30:liquibase: Change Set C:/Users/liquibase/changelog/db.changelog  
-1.0.xml::2::jf failed. Error: Error executing SQL not supported. FIXME!!: near  
 “not”: syntax error  
liquibase.exception.DatabaseException: Error executing SQL not supported. FIXME!  
!: near “not”: syntax error

&nbsp;

&nbsp;

**My changelog file looks like:**

&nbsp;

\<?xml version="1.0" encoding="UTF-8"?\>  
  
\<databaseChangeLog  
&nbsp; xmlns="[http://www.liquibase.org/xml/ns/dbchangelog](http://www.liquibase.org/xml/ns/dbchangelog)"  
&nbsp; xmlns:xsi="[http://www.w3.org/2001/XMLSchema-instance](http://www.w3.org/2001/XMLSchema-instance)"  
&nbsp; xsi:schemaLocation="[http://www.liquibase.org/xml/ns/dbchangelog](http://www.liquibase.org/xml/ns/dbchangelog)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd](http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd)"\>  
&nbsp;  
&nbsp;  
&nbsp;  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;   
&nbsp;&nbsp;&nbsp;   
&nbsp;  

&nbsp;

&nbsp;

**Here is the error log:**

&nbsp;

INFO 23-04-13 00:30:liquibase: Successfully acquired change log lock  
INFO 23-04-13 00:30:liquibase: Reading from DATABASECHANGELOG  
INFO 23-04-13 00:30:liquibase: Reading from DATABASECHANGELOG  
SEVERE 23-04-13 00:30:liquibase: Change Set C:/Users/liquibase/changelog/db.changelog  
-1.0.xml::2::jf failed.&nbsp; Error: Error executing SQL not supported. FIXME!!: near  
&nbsp;“not”: syntax error  
liquibase.exception.DatabaseException: Error executing SQL not supported. FIXME!  
!: near “not”: syntax error  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:109  
1)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabas  
e.java:1075)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27  
)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.Liquibase.update(Liquibase.java:114)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at module.dbmaintain.liquibase.Changelog.updateChangelog(Changelog.java:  
32)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at \_jsp.\_test.\_updatedb\_\_jsp.\_jspService(\_updatedb\_\_jsp.java:36)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.caucho.jsp.JavaPage.service(JavaPage.java:61)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.caucho.jsp.Page.pageservice(Page.java:578)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.caucho.server.dispatch.PageFilterChain.doFilter(PageFilterChain.j  
ava:195)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain  
.java:187)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocatio  
n.java:265)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:273  
)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.caucho.server.port.TcpConnection.run(TcpConnection.java:682)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.caucho.util.ThreadPool$Item.runTasks(ThreadPool.java:743)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at com.caucho.util.ThreadPool$Item.run(ThreadPool.java:662)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.Thread.run(Thread.java:662)  
Caused by: java.sql.SQLException: near “not”: syntax error  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.sqlite.DB.throwex(DB.java:288)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.sqlite.NestedDB.prepare(NestedDB.java:115)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.sqlite.DB.prepare(DB.java:114)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.sqlite.Stmt.execute(Stmt.java:82)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInSta  
tement(JdbcExecutor.java:92)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; … 19 more  
INFO 23-04-13 00:30:liquibase: Successfully released change log lock  
INFO 23-04-13 00:30:liquibase: Successfully released change log lock

&nbsp;

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [April 23, 2013, 5:43am UTC](https://forum.liquibase.org/t/add-column-error-executing-sql-not-supported-fixme-near-not-syntax-error/2253/2 "2013-04-23T05:43:00Z")

</div>

More info:

&nbsp;

I am using sqlite.

&nbsp;

It works fine when I am using the SQL element:

ALTER TABLE ticket ADD name varchar(150)

&nbsp;

&nbsp;