google-code-export / sqlite-manager

Automatically exported from code.google.com/p/sqlite-manager
1 stars 0 forks source link

Trying to get SQLite Manager and WAMP to use one database #199

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Install WAMP 2.0 (http://www.wampserver.com/en/download.php)
2. Create SQLite database by SQLite Manager
3. Attempt to access database using WAMP 
4. Databases created by WAMP are not accessible by SQLite either

What is the expected output? 
To view and edit databases using WAMP and SQLite Manager.

What do you see instead?
SQLite Manager see WAMP databases as being corrupted.
WAMP doesn't give any errors but nothing in the database appears.

Extension Version = 0.3.16
Application = Firefox 3.0.3
OS = Vista

Original issue reported on code.google.com by davegris...@gmail.com on 2 Nov 2008 at 2:32

GoogleCodeExporter commented 9 years ago
Maybe the sqlite db being created by WAMP has an incompatible version to that 
being
used by Firefox 3. If you could attach a db created by WAMP here, it would help 
me
for figuring out the problem.
On the FAQ page, the following question could be of help too:
I get an error while trying to open/connect to an sqlite db file. Why?

Original comment by mrinal.k...@gmail.com on 4 Nov 2008 at 9:16

GoogleCodeExporter commented 9 years ago
mrinal.kent,

I've been trying to get the Firefox plugin SQLite Manager to present WAMP 
databases
in Firefox and vice versa.
Neither seems to know what is going on with the other...

Attached is a sql db file from the Firefox plugin "SQLite Manager"

Here is a WAMP example:

# SQLiteManager Dump
# Version: 1.2.0
# http://www.sqlitemanager.org/
#
# Host: localhost
# Generation Time: Tuesday 04th 2008f November 2008 08:58 am
# SQLite Version: 2.8.17
# PHP Version: 5.2.6
# Database: tableOne
# --------------------------------------------------------

#
# Table structure for table: WAMP
#
CREATE TABLE WAMP ( Record INTEGER(3) NOT NULL PRIMARY KEY DEFAULT '1', 
firstName
VARCHAR(12) );

#
# Dumping data for table: WAMP
#
# --------------------------------------------------------

Original comment by davegris...@gmail.com on 4 Nov 2008 at 3:04

Attachments:

GoogleCodeExporter commented 9 years ago
I did look at the FAQ.
Looks like the formats aren't compatible.

Below is the error message I get when attempting to import db, made from the 
FireFox
plugin, into WAMP as a SQLite db. Importing as a SQL db doesn't produce positive
results either.

"Error line(s) : 2
Error : SQL logic error or missing database
    near "AUTOINCREMENT": syntax error

Query :

CREATE TABLE "tOne" ("Record" INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL ,
"firstName" VARCHAR);"
"

Original comment by davegris...@gmail.com on 4 Nov 2008 at 3:13

GoogleCodeExporter commented 9 years ago
# SQLite Version: 2.8.17
shows that WAMP is using sqlite2 whereas this extension on Fx3 uses sqlite3

Original comment by mrinal.k...@gmail.com on 4 Nov 2008 at 5:13

GoogleCodeExporter commented 9 years ago
Thanks for getting back to me.

Do you know if the FireFox plugin will support earlier db formats?

Dave

Original comment by davegris...@gmail.com on 5 Nov 2008 at 6:07

GoogleCodeExporter commented 9 years ago
No, this extension will not support earlier formats because it uses the sqlite
library included with firefox.

Original comment by mrinal.k...@gmail.com on 5 Nov 2008 at 6:59