next »

[aldo]

Not everyone can afford or just don't want to pay for MySQL activation... Although I HATE phpBB with a passion I guess I should help those with how to install phpBB3 on SQLite until SMF 2.0 comes out

Step 1:
Download phpBB3 here: http://www.phpbb.com/downloads/

Step 2:
Either unzip then upload or upload then unzip into your desired directory.

Step 3:
Access your phpBB3 directory in your browser and click on the INSTALL Tab

Step 4:
Click Proceed to next step button, then make sure all your files are writable if so Click Start Install.

Step 5:
Where there is the database type selection box, choose SQLite... Now a little thing off to the side... make a file called SOMETHING.db now make sure this is a SUPER random name! I mean super random! like djskdjkijekh321398178w.db and upload it to a place not in the phpBB3 directory! (As phpBB3 wont allow it... Or for me at least), make sure to CHMOD the db to 777, then where it says Enter Database hostname or DSN put in the path to the .db file (So like /www/110mb.com/{YOUR_PATH}/htdocs/{PATH_TO.DB} Look in 110MBPanel for your htdocs path ) then hit Proceed to next step.

WARNING! It MUST be the path to the file! (EG: /www/110mb.com/{YOUR_STUFF}/htdocs/{TO_DB} or it WILL not WORK! Login to the 110MBPanel and in the sidebar click the link that says server and path info. Click it, and there will be your path to your htdocs

Step 6:
If it says Test Successful, hit proceed again... then proceed with your installation as you would a MySQL installation

Easy wasn't it?
Now if you have .htaccess support put this in your .htaccess file the directory of you .db

Code:

<Files "{YOUR_DBNAME}.db">
Order Allow,Deny
Deny from All
</Files>

So there you have it =]

I'll say it here, SQLite has a huge downside (a couple)
1) Anyone can access your db file without proper pre-cautions you can either stop it or help the chance of no one getting to it.
  - You can buy .htaccess support and do the .htaccess thing I showed...
  - Or you can make the db file name super random...
  - Rename your db file every so often. (Be sure to make changes in config.php file though too!)
2) It can be slow. After time and you getting more members, posts or whatever your database gets bigger and bigger. My default installation file was already ~576Kb so imagine 100 posts and members running on that. The reason is, its nothing like MySQL. With MySQL it can go in and go right to a certain row, table column etc, and ignore the rest, as if it doesn't exist. Now with SQLite... its a different story. Every time something is loaded, it has to haul out your db file, find it and do whats needed. So the bigger it is the longer it takes for it to find something in it and get it out. So its not recommended with big communities.

DEMO: http://northsalemcrew.net/phpBB3/
Please feel free to register on the demo, post, or whatever you please to get the feel of it... (yes, it asks for email, but you dont have any activation thing )

[Mop (Gb)]

Nice. This should help all the people who don't have MySQL.

[Diemux]

Nice tutorials, I hope you don't mind but I added it to help.110mb.com:

http://help.110mb.com/readarticle.php?article_id=44

[aldo]

Nice. This should help all the people who don't have MySQL.

Yeah, someone said you can't install phpBB3 on SQLite... I think though it might be because they were doing the relative path, I believe it has to be the direct path, I tried relative, and it did not like it... It said "Error *something (Nothing important)*, this isn't an error"

Which makes no sense to me. Its an error! but its not :S

Nice tutorials, I hope you don't mind but I added it to help.110mb.com:

http://help.110mb.com/readarticle.php?article_id=44

Of course not :] your free to add all of mine to your site without asking


Also a little side note, at first your forum running on SQLite is very slow, but after awhile the speed picks up. It applies to everyone. As phpBB3 has a built in cache, and you will notice on my demo that at first its a bit slow, but then the speed picks up :] Just wanted to mention it

[KOLZ]

This is really a fantastic guide. It should be a sticky. I was able to add my phpBB forum to my site thanks to this guide. I was so damn confused the night I was doing it, but got through it. So thanks again aldo for making it.

[soren121]

Nice. This should help all the people who don't have MySQL.

Yeah, someone said you can't install phpBB3 on SQLite... I think though it might be because they were doing the relative path, I believe it has to be the direct path, I tried relative, and it did not like it... It said "Error *something (Nothing important)*, this isn't an error"

Look here:

Note: if you are installing using SQLite, you should enter the full path to your database file in the DSN field and leave the username and password fields blank. For security reasons, you should make sure that the database file is not stored in a location accessible from the web.

[fudge]

very interesting, i had no idea this was possible. thanks for the info.

[Kercyn]

A really big 'Thank you'! I was desperate because I thought I couldn't install a forum without MySQL. Although I got a bit confused, I managed to install my forum at last! 

[RBCFAQS]

Hey, this kinda goes hand in hand with my How to on making a SQLite database. Very nicely done. SMF2 shouldn't need a guide, as the whole SQLite process is automated. I think the last one I set up was 3 mouse clicks.

[aldo]

Hey, this kinda goes hand in hand with my How to on making a SQLite database. Very nicely done. SMF2 shouldn't need a guide, as the whole SQLite process is automated. I think the last one I set up was 3 mouse clicks.

Yeah lol. That tutorial was mainly to show how easy it is. with phpBB, ugh, you NEED a guide

[dejulinnen]

I'm kinda new at this...where do you find your htdocs path in the 110mb panel?

EDIT:nvm I found it!

EDIT: Thanks,now I have my own forum

[psychologymalaysia]

Hello all! I'm a newbie here trying to install phpbb3. I'm stuck at the following step

WARNING! It MUST be the path to the file! (EG: /www/110mb.com/{YOUR_STUFF}/htdocs/{TO_DB} or it WILL not WORK! Login to the 110MBPanel and in the sidebar click the link that says server and path info. Click it, and there will be your path to your htdocs

I'm confused about the 'your_stuff' anf 'To_db'. Is the 'your stuff' included already in the link found at the control panel?
As for 'to_db', let's say I create the random file as 'adhkahfueafcn' and put it in 'hello' directory. how would the link look like?

Thanks in advance!

[RBCFAQS]

Example:

/www/110mb/com/h/e/l/l/h/o/u/n/htdocs/unreadable/database.db/ (Doesn't exist)

                        ^^^^^^^^^^ That's my {YOURSTUFF} off of my hellhoundspool.110mb.com account. You'll have to find it in the CP.

[psychologymalaysia]

Do I need to replace the '/unreadable/database.db'?

or as below?
/www/110mb.com/p/s/y/c/h/o/l/o/psychologymalaysia/htdocs/unreadable/database.db

[psychologymalaysia]

Anyone help to resolve the problem? I cant proceed without the path. ><

[aldo]

Do I need to replace the '/unreadable/database.db'?

or as below?
/www/110mb.com/p/s/y/c/h/o/l/o/psychologymalaysia/htdocs/unreadable/database.db

Second one seems right, for some odd reason that I do not understand... phpBB3 does not support relative paths of your SQLite DB

[geardawg]

Could not connect to the database, see error message below.
not an error

So I entered the path to the DB. Is the .db file supposed to be blank? because I just saved a blank file out of notepad as a .db file.

[aldo]

Yeah it will be fine... it will be setup as a SQLite file itself.

[Asmar]

means i can work without mysql! GREAT!

[frendz4ever]

Thanx for this guide it was really very useful for me. And i installed mybb forum successfully. Gr8 work.

Site
www.frendz4ever.110mb.com

forum
www.frendz4ever.110mb.com/forum