Mailing List Archive: error saving pages (new and existing)

error saving pages (new and existing)

Jul 22, 2004, 10:36 PM

Post #1 of 3 (897 views)

Hello-

I have a newly installed version of Trac (0.6.1) and I am occasionally
receiving an error message when I save a new or existing page.

Here is the text of the message:

Oops...

Trac detected an internal error:

columns name, version are not unique

Traceback (most recent call last):
File "/usr/lib/python2.2/site-packages/trac/trac.py", line 254, in main
real_main()
File "/usr/lib/python2.2/site-packages/trac/trac.py", line 208, in real_main
module.run()
File "/usr/lib/python2.2/site-packages/trac/Module.py", line 38, in run
self.render()
File "/usr/lib/python2.2/site-packages/trac/Wiki.py", line 677, in render
self.page.commit ()
File "/usr/lib/python2.2/site-packages/trac/Wiki.py", line 538, in commit
self.authname, self.remote_addr, 0, self.text)
File "/usr/lib/python2.2/site-packages/sqlite/main.py", line 255, in execute
self.rs = self.con.db.execute(SQL % parms)
IntegrityError: columns name, version are not unique

I am sorry if this is a duplicate. I searched the mailing list archives
and found one similar article, but nothing exactly the same as the
behavior I am experiencing.

This is occurring under Fedora Core 1, using Python 2.2 and Apache
2.0.49 I believe.

Please let me know if any more info would help...

Chris

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Christopher Glidden
Manager, Implementation and Content Primedia/ChannelOne
Chris.Glidden@Primedia.com 1440 Broadway
W: 212-204-3827 New York, NY 10018
F: 212-204-3996
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

error saving pages (new and existing) [ In reply to ]

jonas at edgewall

Jul 22, 2004, 10:36 PM

Post #2 of 3 (889 views)

Permalink

Christopher Glidden wrote:

> Hello-
>
> I have a newly installed version of Trac (0.6.1) and I am occasionally
> receiving an error message when I save a new or existing page.
>
> Here is the text of the message:
>
> Oops...
>
> Trac detected an internal error:
>
> columns name, version are not unique
>
> Traceback (most recent call last):
> File "/usr/lib/python2.2/site-packages/trac/trac.py", line 254, in main
> real_main()
> File "/usr/lib/python2.2/site-packages/trac/trac.py", line 208, in
> real_main
> module.run()
> File "/usr/lib/python2.2/site-packages/trac/Module.py", line 38, in run
> self.render()
> File "/usr/lib/python2.2/site-packages/trac/Wiki.py", line 677, in render
> self.page.commit ()
> File "/usr/lib/python2.2/site-packages/trac/Wiki.py", line 538, in commit
> self.authname, self.remote_addr, 0, self.text)
> File "/usr/lib/python2.2/site-packages/sqlite/main.py", line 255, in
> execute
> self.rs = self.con.db.execute(SQL % parms)
> IntegrityError: columns name, version are not unique
>
> I am sorry if this is a duplicate. I searched the mailing list archives
> and found one similar article, but nothing exactly the same as the
> behavior I am experiencing.
>
> This is occurring under Fedora Core 1, using Python 2.2 and Apache
> 2.0.49 I believe.
>
> Please let me know if any more info would help...
>

sqlite 2.8.13 has a known problem in it's max() function. The
Trunk and 0.6-stable branch version of Trac contains a workaround for
this problem.
You can either downgrade to an older version of sqlite or replace
trac/Wiki.py with this file:

http://svn.edgewall.com/repos/trac/branches/0.6-stable/trac/Wiki.py

(don't forget to run ./setup.py install afterwards)

The next Trac release (probably 0.7) will contain this workaround.

/ Jonas
--
Jonas Borgstr?m | Edgewall Software
jonas@edgewall.com | Professional GNU/Linux & Open Source Consulting.
| http://www.edgewall.com/

error saving pages (new and existing) [ In reply to ]

alex at halogen-dg

Jul 22, 2004, 10:36 PM

Post #3 of 3 (889 views)

Permalink

Hi Christopher,

I have experienced the same problem with latest track release.
Since I did not want to use 'development' Subversion sources
I come to track subversion browser and copied the lines with SQL
query around the lines:
/usr/lib/python2.2/site-packages/trac/trac.py", line 254,

so, this solved the prob.

Alex

On Fri, 30 Apr 2004, Christopher Glidden wrote:

> Hello-
>
> I have a newly installed version of Trac (0.6.1) and I am occasionally
> receiving an error message when I save a new or existing page.
>
> Here is the text of the message:
>
> Oops...
>
> Trac detected an internal error:
>
> columns name, version are not unique
>
> Traceback (most recent call last):
> File "/usr/lib/python2.2/site-packages/trac/trac.py", line 254, in main
> real_main()
> File "/usr/lib/python2.2/site-packages/trac/trac.py", line 208, in real_main
> module.run()
> File "/usr/lib/python2.2/site-packages/trac/Module.py", line 38, in run
> self.render()
> File "/usr/lib/python2.2/site-packages/trac/Wiki.py", line 677, in render
> self.page.commit ()
> File "/usr/lib/python2.2/site-packages/trac/Wiki.py", line 538, in commit
> self.authname, self.remote_addr, 0, self.text)
> File "/usr/lib/python2.2/site-packages/sqlite/main.py", line 255, in execute
> self.rs = self.con.db.execute(SQL % parms)
> IntegrityError: columns name, version are not unique
>
> I am sorry if this is a duplicate. I searched the mailing list archives
> and found one similar article, but nothing exactly the same as the
> behavior I am experiencing.
>
> This is occurring under Fedora Core 1, using Python 2.2 and Apache
> 2.0.49 I believe.
>
> Please let me know if any more info would help...
>
> Chris
>
> --
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Christopher Glidden
> Manager, Implementation and Content Primedia/ChannelOne
> Chris.Glidden@Primedia.com 1440 Broadway
> W: 212-204-3827 New York, NY 10018
> F: 212-204-3996
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> _______________________________________________
> Trac mailing list
> Trac@lists.edgewall.com
> http://lists.edgewall.com/mailman/listinfo/trac
>
>

--
Alex V. Koval
http://www.halogen-dg.com/
http://www.zwarehouse.org/