| Anonymous | Login | Signup for a new account | 2010-09-10 04:18 CEST |
| Main | My View | View Issues | Change Log | Roadmap | Docs | My Account |
| Viewing Issue Simple Details [ Jump to Notes ] | [ View Advanced ] [ Issue History ] [ Print ] | ||||||
| ID | Category | Severity | Reproducibility | Date Submitted | Last Update | ||
| 0000137 | [sqliteman] SQL engine | minor | always | 2008-07-17 04:51 | 2008-07-17 13:03 | ||
| Reporter | jwhendy | View Status | public | ||||
| Assigned To | subzero | ||||||
| Priority | normal | Resolution | fixed | ||||
| Status | closed | Product Version | 1.0 | ||||
| Summary | 0000137: Databases not recognized | ||||||
| Description |
I downloaded sqliteman so that I could interact graphically with databases, which is a bit easier than using sqlite3 from the command line. My problem is that I can indeed interact with a couple of files using the CLI and sqlite3, but trying to open them using sqliteman yields, "Unable to open or create file [insert name]. It is probably not a database" Perhaps it is truly not, but I don't get an error using sqlite3 [insert file name], and I can use .table, .dump [table name], etc... Is this a me issue or sqliteman? Please forgive me if this is poorly categorized or not your fault! I just wanted some help and didn't see a forum. Thanks! John |
||||||
| Additional Information |
- Using Mac OS X Leopard 10.5.4 - Using sqliteman 1.01 as installed from macports 7/14/08 - Specific files I tried: an iBank file (IGG Software financial program) and iCal Calendar cache file. - For *.ibank, I type: :~sqlite3 Test.ibank :~.table and get a list of all tables (ZBUDGET, ZBUDGETITEM, ZCURRENCY, etc.) - For Calendar cache I type: :~sqlite3 Calendar\ Cache :~.table and get a list of all tables (ZALARM, ZATTACHMENT, ZATTENDEE, etc.) Let me know if there's anything else you need to know. The app opens fine and as far as I know looked like a clean compile & install using MacPorts. qt4 took a long time and I just let it putt-putt and went to bed. In the morning sqliteman launched right up. |
||||||
| Tags | No tags attached. | ||||||
| Attached Files | |||||||
|
|
|||||||
 Relationships |
|
|
Notes |
|
|
(0000238) subzero (administrator) 2008-07-17 08:29 |
John, don't worry. You're right here. And now to the problem. Can you create new blank database with Sqliteman? In the case you cannot, try to check if is your Qt4 (qt4-mac) built with sqlite support (it's library located at /usr/lib/qt4/plugins/sqldrivers/libqsqlite.so on linux but I don't know where it is on mac). See http://qt4-mac.darwinports.com/ [^] Variant: sqlite description "Include support for SQL via sqlite driver" { configure.args-delete -no-sql-sqlite configure.args-append -qt-sql-sqlite -plugin-sql-sqlite } Let me know your results then. |
|
(0000239) subzero (administrator) 2008-07-17 08:30 |
Reminder sent to: dersh Adam, can you check what I wrote above (qt4-mac sqlite issue propably). Thanks. |
|
(0000240) jwhendy (reporter) 2008-07-17 12:33 |
Thanks for the reply. I apologize, as right after I posted I became aware that previous 'tickets' were available for viewing.. I was new to the site at first and didn't catch this. I searched for my error and found exactly what I was looking for. I had to run: :~sudo port deactivate qt4-mac :~sudo port install qt4-mac +sqlite Now I can open the two files I referred to as well as create a new database. I can also double click a table and edit rows. This is great! I was quite surprised at the lack of GUI interfaces for sqlite tables. I'm very new to sqlite and while I don't have a problem with the command line, I do find that in this case the command line made it pretty tough to grasp the setup/layout of sqlite databases. It's great to be able to see everything laid out vs. hunting through endless table dumps for what I think I'm looking for! Thanks, John |
|
(0000241) subzero (administrator) 2008-07-17 13:03 |
I'm glad it's fixed now |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-07-17 04:51 | jwhendy | New Issue | |
| 2008-07-17 08:29 | subzero | Note Added: 0000238 | |
| 2008-07-17 08:30 | subzero | Issue Monitored: dersh | |
| 2008-07-17 08:30 | subzero | Note Added: 0000239 | |
| 2008-07-17 12:33 | jwhendy | Note Added: 0000240 | |
| 2008-07-17 13:03 | subzero | Status | new => resolved |
| 2008-07-17 13:03 | subzero | Fixed in Version | => 1.1svn |
| 2008-07-17 13:03 | subzero | Resolution | open => fixed |
| 2008-07-17 13:03 | subzero | Assigned To | => subzero |
| 2008-07-17 13:03 | subzero | Note Added: 0000241 | |
| 2008-07-17 13:03 | subzero | Status | resolved => closed |
| Mantis 1.1.7[^] Copyright © 2000 - 2008 Mantis Group |  |
