Does not support WAL
Issue #90
invalid
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)
-
-
``` 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
-
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 -
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
- Log in to comment
``` 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`