How to setup with SQLite? Thanks a lot!

[msibm]

I'm using a share hosting. The folowing is my Database Configuration. Is it right?

Database type: SQLite

Database server hostname or DSN:

Database server port:

Database name: /data/home/ug6aa1/sqlite/phpbb.sqlite
(I have moved sqlite.php to this directory. It's out of the web-accessible location.)

Database username:

Database password:

Prefix for tables in database:


But encounter this error:

Fatal error: Cannot instantiate non-existent class: dbal_sqlite in /data/home/ug6aa1/htdocs/phpBB/install/install_install.php on line 1627

Who can help me? Thanks a lot.

[Graham]

sqlite.php should remain exactly where it is in the download. By moving it, you have caused the error you describe

[msibm]

sqlite.php should remain exactly where it is in the download. By moving it, you have caused the error you describe

If remain it in the original derectory, there will be another error:
The database file specified is within your forum directory tree. You should put this file in a non web-accessible location.

I'm using share/virtue hosting.

[msibm]

The install directory of phpBB is:
/data/home/ug6aa1/htdocs/phpBB/

Is it in the same forum directory tree?

[msibm]

Database type: SQLite
Database server hostname or DSN: /data/home/ug6aa1/htdocs/sqlite/my.db
(phpBB is installed in /data/home/ug6aa1/htdocs/phpBB/)
Database server port:
Database name:
Database username:
Database password:
Prefix for tables in database: phpbb_

Setuping above, I can go to the next step of installation, but on the stage of creat table, it's error that can not find the server.

[Eelke]

I think this error message:

The database file specified is within your forum directory tree. You should put this file in a non web-accessible location.

is about the data file of your database, not the PHP file from phpBB that's accessing it.

However,

Database name: /data/home/ug6aa1/sqlite/phpbb.sqlite

I am not familiar with SQLite, but I think this is the database file in question. It would seem that the error message is incorrectly complaining about its location, because it is clearly not within your forum directory tree and, assuming /data/home/ug6aa1/htdocs is your webroot, also not in a web-accessible location.

Remember this is a beta version, things may not always go as you expect. As a computer user, you may have developed a natural reflex to assume that you're doing something wrong when you encounter errors. With beta versions, things are not that simple I think in this case, the error message is wrong (or at least misleading) and something else is going on.

Try and troubleshoot this a bit further and see whether you can find out where this error message is produced and whether you can get a finger behind the problem that is occurring there. Then, submit a bug report. Maybe you want to have a flick through the bug tracker before you do so to find out whether it has been reported before and/or download a recent nightly build to see whether the problem occurs with that too.

[msibm]

Eelke,
Thanks a lot for your kindly and detailed help. I will wait for the gold version.

[itunes66]

you should not have moved sqlite.php at all, it stays in place, the sqlite database needs to be in a non-web accessible location though