Does not support WAL

Issue #90 invalid
Former user created an issue

Originally reported on Google Code with ID 90

With SQLite 3.7.0 write-ahead logging (WAL) was introduced. 
What steps will reproduce the problem?
1. Attempt to open database with WAL set
2.
3.

What is the expected output? What do you see instead?
Expect to see tables. Result 'No tables in database'

What version of the product are you using? On what operating system?
1.9.1 on Linux. SQLite 3.7.6.2

Please provide any additional information below.
Need to turn off WAL in order to view database.

Reported by gregj.johnstone on 2012-02-15 01:13:20

Comments (4)

  1. Dane Iracleous

    ``` Just to be clear, you are toggling WAL with the statements:

    PRAGMA journal_mode=WAL;

    and

    PRAGMA journal_mode=DELETE;

    ? ```

    Reported by `diracleo` on 2012-06-02 08:23:59 - Status changed: `Accepted`

  2. Christopher Kramer

    ``` Dane, were you able to reproduce this? I wasn't.

    Which Database Extension causes the problem? PDO/SQLiteDatabase/SQLiteDatabase3?

    I think this might be an issue of the DB extension, rather than phpLiteAdmin itself. ```

    Reported by `crazy4chrissi` on 2012-06-02 20:47:27

  3. dreadnaut
    Just opened a WAL database without trouble. If we don't have more information on this,
    we could close it as Invalid.
    

    Reported by dreadnaut on 2013-03-19 01:06:00

  4. Christopher Kramer
    Agreed. As we didn't get any feedback regarding this for quite a while and nobody is
    able to reproduce it, I will close it invalid.
    
    If somebody has problems with WAL, please comment here and I will reopen the issue.
    If you have problems, please include the DB extension (PDO/SQLite3/Sqlite) in your
    comment. You can find it at the overview (structure) page of your database.
    

    Reported by crazy4chrissi on 2013-03-19 16:58:53 - Status changed: Invalid

  5. Log in to comment