SQLite Manager - Extension for Firefox, Sunbird, Flock, etc.

Announce and Discuss the Latest Theme and Extension Releases.
Post Reply
grikdog
Posts: 2
Joined: February 29th, 2008, 10:18 am

Post by grikdog »

Add/Edit in a View, sorry this lame forum software did not include my subject line.
mrinal.kant
Posts: 81
Joined: June 28th, 2005, 1:38 pm

Post by mrinal.kant »

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.
mrinal.kant
Posts: 81
Joined: June 28th, 2005, 1:38 pm

Post by mrinal.kant »

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
screenmates
Posts: 1
Joined: March 31st, 2008, 10:28 am

Does not open sqlite database :(

Post by screenmates »

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?
mrinal.kant
Posts: 81
Joined: June 28th, 2005, 1:38 pm

Re: Does not open sqlite database :(

Post by mrinal.kant »

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.
_development
Posts: 332
Joined: October 19th, 2007, 9:29 am
Location: Montevideo, Uruguay

Re: Does not open sqlite database :(

Post by _development »

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
mrinal.kant
Posts: 81
Joined: June 28th, 2005, 1:38 pm

Re: Does not open sqlite database :(

Post by mrinal.kant »

_development wrote:http://code.google.com/p/sqlite-manager/issues/detail?id=16


Thanks for the above link.
User avatar
RobertJ
Moderator
Posts: 10880
Joined: October 15th, 2003, 7:40 pm
Location: Chicago IL/Oconomowoc WI

Post by RobertJ »

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
FF 92.0 - TB 78.13 - Mac OSX 10.13.6
mrinal.kant
Posts: 81
Joined: June 28th, 2005, 1:38 pm

Post by mrinal.kant »

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.
User avatar
RobertJ
Moderator
Posts: 10880
Joined: October 15th, 2003, 7:40 pm
Location: Chicago IL/Oconomowoc WI

Post by RobertJ »

At that link this is the message

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
mrinal.kant
Posts: 81
Joined: June 28th, 2005, 1:38 pm

Post by mrinal.kant »

RobertJ wrote:At that link this is the message

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.

.


OK. I appreciate ur concerns.
george.hunt
Posts: 1
Joined: June 2nd, 2008, 4:33 am
Location: New York City

sqlite manager on xulrunner

Post by george.hunt »

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?
User avatar
RobertJ
Moderator
Posts: 10880
Joined: October 15th, 2003, 7:40 pm
Location: Chicago IL/Oconomowoc WI

Post by RobertJ »

george.hunt you're asking this question in the wrong place. You might try going here

http://groups.google.com/group/sqlitemanager/topics

.
FF 92.0 - TB 78.13 - Mac OSX 10.13.6
Post Reply