Failed to upgrade environment after installing

[j.huppertz@…]

hi there!

I followed all of the installation steps, but when I tried to upgrade my environment, it says:

Command failed: near "ALTER": syntax error

I am using trac 0.9.6 and the latest discussionplugin

thanks for any help!

regards, Julian Huppertz

[Radek Bartoň]

What is your sqlite version please?

[j.huppertz@…]

it's 2.8.17

[Radek Bartoň]

So here is the problem. I think that Track version 0.9 should run on sqlite version 3.x. Anyway old version of sqlite doesn't have ALTER TABLE ... RENAME TO ... statement support. Please upgrade to version 3.x.

[Radek Bartoň]

Sorry, ALTER TABLE ... ADD COLUMN statement.

[j.huppertz@…]

okay, I hope I can figure it out how to do that.. Thanks for the quick answer!

[Radek Bartoň]

So this is invalid.

[marcellglx]

sqlite-3.1.2-3 sqlite-devel-3.1.2-3 python-sqlite-1.1.6-1 trac-0.9.5

trac-admin /var/trac/projects/test/ upgrade Command failed: near "ADD": syntax error

[Radek Bartoň]

I'm only guessing but your pysqlite version is too late than mine (2.3.1). I'm not sure if upgrade help but you could try it to investigate where is problem. You can try if your sqlite installation support ALTER TABLE <table> ADD COLUMNT <name> <type>; statement in command line tool and check if forum table exists.

[marcellglx]

Replying to Blackhex:

I'm only guessing but your pysqlite version is too late than mine (2.3.1). I'm not sure if upgrade help but you could try it to investigate where is problem. You can try if your sqlite installation support ALTER TABLE <table> ADD COLUMNT <name> <type>; statement in command line tool and check if forum table exists.

I have Linux Fedora Core 4, so I try to install ​'pysqlite2'
yum install python-sqlite2

So now I have these versions: python-2.4.1-2
mod_python-3.1.4-2
python-sqlite-1.1.6-1
python-sqlite2-2.0.7-1.fc4
sqlite-3.1.2-3

I can't remove pysqlite 1.1.6-1 because:
error: Failed dependencies:

python-sqlite is needed by (installed) yum-2.3.2-7.noarch

Although I have python-sqlite2, upgrade of Trac project failed.

First trac-admin command:
trac-admin /var/trac/projects/test/ upgrade
Command failed: near "ADD": syntax error

Every next trac-admin command:
trac-admin /var/trac/projects/test/ upgrade
Command failed: table forum_group already exists


sqlite3:
sqlite> create table test (name integer);
sqlite> alter table test add columnt value integer;
SQL error: near "add": syntax error


What should I do ?

[Radek Bartoň]

At first try again ALTER TABLE test ADD COLUMNT value integer; but instead of COLUMNT type COLUMN :-). If it will succseed then problem is probably with pysqlite version and then you have to create tables manually (I'll tell you how if needed). If it won't succeed then problem is with sqlite itself. I don't know what version exactly comes with ALTER TABLE statement but it should be version 3. I'm using 3.3.6. There is no table existance cheking so when you fail with upgrade you have to drop any created tables (forum_group, forum, topic, message).

[marcellglx]

Replying to Blackhex:

At first try again ALTER TABLE test ADD COLUMNT value integer; but instead of COLUMNT type COLUMN :-). If it will succseed then problem is probably with pysqlite version and then you have to create tables manually (I'll tell you how if needed). If it won't succeed then problem is with sqlite itself. I don't know what version exactly comes with ALTER TABLE statement but it should be version 3. I'm using 3.3.6. There is no table existance cheking so when you fail with upgrade you have to drop any created tables (forum_group, forum, topic, message).

OK. I have download and install ​http://www.sqlite.org/download.html sqlite-3.3.6.tar.gz
./configure --prefix=/usr
make && make install

/usr/bin/sqlite3 -version
3.3.6

than I make delete.discuss.sql:
delete from system where name="discussion_version";
drop table forum;
drop table forum_group;
drop table topic;
drop table message;

and run:
sqlite3 /var/trac/projects/test/db/trac.db
.read delete.discuss.sql


Than command:
trac-admin /var/trac/projects/test/ upgrade
exit with no error, AND I HAVE MY DISCUSSION !!! :-)


Thanks for help !!!