SQLite Manager - Extension for Firefox, Sunbird, Flock, etc.
-
- Posts: 81
- Joined: June 28th, 2005, 1:38 pm
grikdog wrote:Add/Edit in a View, sorry this lame forum software did not include my subject line.
http://sqlite.org/omitted.html says:
VIEWs in SQLite are read-only. You may not execute a DELETE, INSERT, or UPDATE statement on a view. But you can create a trigger that fires on an attempt to DELETE, INSERT, or UPDATE a view and do what you need in the body of the trigger.
PS: Sorry for the late reply. All the time since your quoted post, I was under the impression that I had already responded.
-
- Posts: 81
- Joined: June 28th, 2005, 1:38 pm
PLEASE DO NOT POST ANYTHING ON THIS TOPIC HERE.
Project homepage: http://sqlite-manager.googlecode.com/
FAQ: http://code.google.com/p/sqlite-manager/wiki/FAQ
Screenshots: http://code.google.com/p/sqlite-manager ... creenshots
Supported Applications: http://code.google.com/p/sqlite-manager ... plications
Google Group for discussion on this extension: http://groups.google.com/group/sqlitemanager
For filing a new bug, you can visit http://code.google.com/p/sqlite-manager/issues/entry
To see the existing bugs, visit http://code.google.com/p/sqlite-manager/issues/list
Project homepage: http://sqlite-manager.googlecode.com/
FAQ: http://code.google.com/p/sqlite-manager/wiki/FAQ
Screenshots: http://code.google.com/p/sqlite-manager ... creenshots
Supported Applications: http://code.google.com/p/sqlite-manager ... plications
Google Group for discussion on this extension: http://groups.google.com/group/sqlitemanager
For filing a new bug, you can visit http://code.google.com/p/sqlite-manager/issues/entry
To see the existing bugs, visit http://code.google.com/p/sqlite-manager/issues/list
-
- Posts: 1
- Joined: March 31st, 2008, 10:28 am
Does not open sqlite database :(
This does not connect to sqlite databases that are auto-created programmatically by a php script created with these privileges:
_www : Read & Write
staff : Read & Write
everyone : Read & Write
Get Info says the sqlite database file is a Unix Executable File.
It bombs saying with the following message:
Alert!
Error in opening file Cache.db - perhaps, this is not an sqlite db file.
Exception name: NS_ERROR_FILE_CORRUPTED.
Exception message: Component returned failure code:
0x8052000b (NS_ERROR_FILE_CORRUPTED)
[mozStorageService.openDatabase]
but whereas SQLiteManager (another app) connects to this database file without any problems. How can I get this plugin to open the above sqlite db file?
_www : Read & Write
staff : Read & Write
everyone : Read & Write
Get Info says the sqlite database file is a Unix Executable File.
It bombs saying with the following message:
Alert!
Error in opening file Cache.db - perhaps, this is not an sqlite db file.
Exception name: NS_ERROR_FILE_CORRUPTED.
Exception message: Component returned failure code:
0x8052000b (NS_ERROR_FILE_CORRUPTED)
[mozStorageService.openDatabase]
but whereas SQLiteManager (another app) connects to this database file without any problems. How can I get this plugin to open the above sqlite db file?
-
- Posts: 81
- Joined: June 28th, 2005, 1:38 pm
Re: Does not open sqlite database :(
screenmates wrote:This does not connect to sqlite databases that are auto-created programmatically by a php script created with these privileges:
_www : Read & Write
staff : Read & Write
everyone : Read & Write
Get Info says the sqlite database file is a Unix Executable File.
It bombs saying with the following message:
Alert!
Error in opening file Cache.db - perhaps, this is not an sqlite db file.
Exception name: NS_ERROR_FILE_CORRUPTED.
Exception message: Component returned failure code:
0x8052000b (NS_ERROR_FILE_CORRUPTED)
[mozStorageService.openDatabase]
but whereas SQLiteManager (another app) connects to this database file without any problems. How can I get this plugin to open the above sqlite db file?
can u pls send the so prepared sqlite db file to me (email address sent in private message) so that I could look into the problem.
Regards,
Mrinal.
PS.: pls do not post here in the future. Relevant links are listed below.
Project homepage: http://code.google.com/p/sqlite-manager/
FAQ: http://code.google.com/p/sqlite-manager/wiki/FAQ
Screenshots: http://code.google.com/p/sqlite-manager ... creenshots
Supported Applications: http://code.google.com/p/sqlite-manager ... plications
Google Group for discussion on this extension: http://groups.google.com/group/sqlitemanager
For filing a new bug, you can visit http://code.google.com/p/sqlite-manager/issues/entry
To see the existing bugs, visit http://code.google.com/p/sqlite-manager/issues/list
Last edited by mrinal.kant on May 1st, 2008, 5:48 am, edited 1 time in total.
-
- Posts: 332
- Joined: October 19th, 2007, 9:29 am
- Location: Montevideo, Uruguay
Re: Does not open sqlite database :(
screenmates wrote:This does not connect to sqlite databases that are auto-created programmatically by a php script created with these privileges:
_www : Read & Write
staff : Read & Write
everyone : Read & Write
Get Info says the sqlite database file is a Unix Executable File.
It bombs saying with the following message:
Alert!
Error in opening file Cache.db - perhaps, this is not an sqlite db file.
Exception name: NS_ERROR_FILE_CORRUPTED.
Exception message: Component returned failure code:
0x8052000b (NS_ERROR_FILE_CORRUPTED)
[mozStorageService.openDatabase]
but whereas SQLiteManager (another app) connects to this database file without any problems. How can I get this plugin to open the above sqlite db file?
http://code.google.com/p/sqlite-manager ... tail?id=16
-
- Posts: 81
- Joined: June 28th, 2005, 1:38 pm
Re: Does not open sqlite database :(
_development wrote:http://code.google.com/p/sqlite-manager/issues/detail?id=16
Thanks for the above link.
- RobertJ
- Moderator
- Posts: 10880
- Joined: October 15th, 2003, 7:40 pm
- Location: Chicago IL/Oconomowoc WI
I've been looking for a BLOB editor (take an image file in PNG, ... format) and turn it into a BLOB in an SQLite database. These are built into some SQLite managers that run on Win but I use a Mac. When I saw your add-on I thought I had a solution; however, it doesn't seem to offer an BLOB editing capability. Anything in the planning?
Cheers
Cheers
FF 92.0 - TB 78.13 - Mac OSX 10.13.6
-
- Posts: 81
- Joined: June 28th, 2005, 1:38 pm
RobertJ wrote:I've been looking for a BLOB editor (take an image file in PNG, ... format) and turn it into a BLOB in an SQLite database. These are built into some SQLite managers that run on Win but I use a Mac. When I saw your add-on I thought I had a solution; however, it doesn't seem to offer an BLOB editing capability. Anything in the planning?
Cheers
Yes, I am halfway in implementing blob handling. It would be nice if you could go to http://code.google.com/p/sqlite-manager/issues/list and add a new issue.
- RobertJ
- Moderator
- Posts: 10880
- Joined: October 15th, 2003, 7:40 pm
- Location: Chicago IL/Oconomowoc WI
At that link this is the message
Also, call me paranoid but I don't want to create a google account. I'll check your add-on page to watch for a blob capability.
.
sqlite-manager/issues/list wrote:The web interface for wiki content is currently READ-ONLY for maintenance.
Also, call me paranoid but I don't want to create a google account. I'll check your add-on page to watch for a blob capability.
.
FF 92.0 - TB 78.13 - Mac OSX 10.13.6
-
- Posts: 81
- Joined: June 28th, 2005, 1:38 pm
RobertJ wrote:At that link this is the messagesqlite-manager/issues/list wrote:The web interface for wiki content is currently READ-ONLY for maintenance.
Also, call me paranoid but I don't want to create a google account. I'll check your add-on page to watch for a blob capability.
.
OK. I appreciate ur concerns.
-
- Posts: 1
- Joined: June 2nd, 2008, 4:33 am
- Location: New York City
sqlite manager on xulrunner
My objective is to adapt useful tools to the OLPC (One Laptop Per Child) hardware. They have a software stack which includes xulrunner, but not firefox.
I've been struggling, unsuccessfully, for a while. I've set up venkman, tried "xul explorer", loaded "sqlite manager" into komodo ide, trying to get some sort of diagnostic messages about what is happening. I'm not getting any jsconsole messages, but I'm still getting a blank SQLite Manager window, or a silent exit leaving the jsconsole active.
How to think about the problem? Does an XUL screen fail to populate if the css is not found? Any suggestions on how to get some diagnostic info?
I've been struggling, unsuccessfully, for a while. I've set up venkman, tried "xul explorer", loaded "sqlite manager" into komodo ide, trying to get some sort of diagnostic messages about what is happening. I'm not getting any jsconsole messages, but I'm still getting a blank SQLite Manager window, or a silent exit leaving the jsconsole active.
How to think about the problem? Does an XUL screen fail to populate if the css is not found? Any suggestions on how to get some diagnostic info?
- RobertJ
- Moderator
- Posts: 10880
- Joined: October 15th, 2003, 7:40 pm
- Location: Chicago IL/Oconomowoc WI
george.hunt you're asking this question in the wrong place. You might try going here
http://groups.google.com/group/sqlitemanager/topics
.
http://groups.google.com/group/sqlitemanager/topics
.
FF 92.0 - TB 78.13 - Mac OSX 10.13.6