MozillaZine

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

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

Post Posted February 29th, 2008, 11:28 am

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 Posted March 3rd, 2008, 5:20 am

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 Posted March 9th, 2008, 10:28 am

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

Post Posted March 31st, 2008, 10:45 am

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

Post Posted March 31st, 2008, 11:07 am

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

Post Posted March 31st, 2008, 3:24 pm

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

Post Posted March 31st, 2008, 11:29 pm

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


Thanks for the above link.

RobertJ
Moderator

User avatar
 
Posts: 10163
Joined: October 15th, 2003, 7:40 pm
Location: Chicago IL/Oconomowoc WI

Post Posted April 13th, 2008, 12:53 pm

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 57.0b9 - FF 56.0 - Palemoon 27.3.0 - TB 52.4 - Mac OSX 10.12.6 Quad-Core Intel Xeon 5500
Computers I've used: IBM 7094/UNIVAC 1108/IBM 360/DEC PDP11/DEC VAX-11 780/DEC VAXstation 8000/Sun SPARCstation 2/Mac from 1984 to 2017

mrinal.kant
 
Posts: 81
Joined: June 28th, 2005, 1:38 pm

Post Posted April 24th, 2008, 5:19 am

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

User avatar
 
Posts: 10163
Joined: October 15th, 2003, 7:40 pm
Location: Chicago IL/Oconomowoc WI

Post Posted April 24th, 2008, 8:51 am

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 57.0b9 - FF 56.0 - Palemoon 27.3.0 - TB 52.4 - Mac OSX 10.12.6 Quad-Core Intel Xeon 5500
Computers I've used: IBM 7094/UNIVAC 1108/IBM 360/DEC PDP11/DEC VAX-11 780/DEC VAXstation 8000/Sun SPARCstation 2/Mac from 1984 to 2017

mrinal.kant
 
Posts: 81
Joined: June 28th, 2005, 1:38 pm

Post Posted April 25th, 2008, 8:39 am

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

Post Posted June 2nd, 2008, 4:46 am

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?

RobertJ
Moderator

User avatar
 
Posts: 10163
Joined: October 15th, 2003, 7:40 pm
Location: Chicago IL/Oconomowoc WI

Post Posted June 2nd, 2008, 6:43 am

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

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

.
FF 57.0b9 - FF 56.0 - Palemoon 27.3.0 - TB 52.4 - Mac OSX 10.12.6 Quad-Core Intel Xeon 5500
Computers I've used: IBM 7094/UNIVAC 1108/IBM 360/DEC PDP11/DEC VAX-11 780/DEC VAXstation 8000/Sun SPARCstation 2/Mac from 1984 to 2017

Return to Extension/Theme Releases


Who is online

Users browsing this forum: mommabear and 1 guest