Re: [Trac] Re: Sqlite crashing after upgrade from 0.11 to 1.0

[Mete Kural]

Hello there, Thank you for the tips. I examined the pysqlite documentation a little more and figured out that I shall install the latest Windows executable of pysqlite which will automatically fetch a recent version of SQlite. So I downloaded pysqlite-2.6.3.win32-py2.5.exe (as I have Phython 2.5 installed) from here: http://code.google.com/p/pysqlite/downloads/list The installer detected my Python directory properly and completed the installation. Now when I run import trac.db.sqlite_backend as sql and check for sql.sqlite_version, sql.have_pysqlite, and sql.sqlite.version, I get these results respectively: (3, 7, 6, 2) 2 '2.6.3' And I did not really run these commands at any point:  $ mv trac.db trac-old.db  $ LD_LIBRARY_PATH=/opt/sqlite-3.2.8/lib /opt/sqlite-3.2.8/bin/sqlite3 \      trac-old.db .dump | \    LD_LIBRARY_PATH=/opt/sqlite-3.3.4/lib /opt/sqlite-3.3.4/bin/sqlite3 trac.db Trac seems to be running fine , even after restarting the physical server. So do you think I properly upgraded SQlite/Pysqlite for Trac? It seems to me to be so but not having run the above commands leave doubt in my mind. Let me let Trac run like this for a few days and see if it ceases to crash any more or not. Thanks, Mete On 5/22/13 5:24 PM, RjOllos wrote: On Wednesday, May 22, 2013 5:20:26 PM UTC-7, Mete Kural wrote: Thank you very much for that information. Do I need to install the "SQLite tools" in order to upgrade the default SQLite that came within Trac to the latest SQLite then? I have never run that procedure, but it sounds like you need to install the tools. Note in the previous section on "Upgrading SQLite from 2.x to 3.x" says "install both SQLite 2.8 and SQLite 3.x". So I think we can be fairly sure that installation of the SQLite tools is required. -- You received this message because you are subscribed to a topic in the Google Groups "Trac Users" group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/trac-users/KwoWq-FSInc/unsubscribe?hl=en. To unsubscribe from this group and all its topics, send an email to trac-users+unsubscr...@googlegroups.com. To post to this group, send email to trac-users@googlegroups.com. Visit this group at http://groups.google.com/group/trac-users?hl=en. For more options, visit https://groups.google.com/groups/opt_out.     -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscr...@googlegroups.com. To post to this group, send email to trac-users@googlegroups.com. Visit this group at http://groups.google.com/group/trac-users?hl=en. For more options, visit https://groups.google.com/groups/opt_out.