> I'm wondering how to query our Trac db using sqlite. I created one > ticket just to test it. When I type "sqlite> .tables", there are no > results. Therefore, if I wanted to manually change a ticket # or other > data in any field, I wouldn't know how to do that.
You need 'sqlite3' to access a v3 database. sqlite> .tables attachment node_change session_attribute version auth_cookie permission system wiki component report ticket enum revision ticket_change milestone session ticket_custom Anyway direct access to the database is probably something you want to avoid. You may want to access the database through the Trac API, or through the XmlRpc plugin. HTH, Manu --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~----------~----~----~----~------~----~------~--~---
