Database

[r36283]

I decided to make some improvements to the web interface (although I think that it is pretty good - great job guys!!, just wanted to add a few features). Since the main language I know is php, I decided to write it in that.

Here are my questions -
The database gbpvr uses is SQLite...correct? Which is the gbpvr.db3 file in the directory correct?

That being said, I tried to connect to it with php and it acts like it is an invalid format. The warning is:
Warning: sqlite_open() [function.sqlite-open]: file is encrypted or is not a database in C:\Documents and Settings\Media\Desktop\Server\xampplite\htdocs\test.php on line 4

The code that I am using to connect to it (or at least the part that errors out) is:
$db = sqlite_open("gbpvr.db3");
(and just to cover something, I already made a copy of the gbpvr.db3 and put it in the correct folder)

Any ideas or suggestions would be really helpful - sorry if these questions have already been answers, I tried my best searching the forum, wiki, and google and didn't turn up too much that is helpful (and its my first post in here... so be gentle!!)

[sub]

Yes, gbpvr.db3 is the database file.

From that error message it sounds like the php library is built for a different version of sqlite.

[r36283]

Just wanted to reply to my own problem with a solution (because I always hate when I find a forum with someone with the same exact problem as me but they don't post the solution - at most they just say thanks.. which doesn't help the rest of the world)

Although I am sure that I am not using the correct terminology - here is the solution.

Sub was right, it does have to do with versions. PHP has to be compiled with sqlite 3 pdo "enabled". I wasn't installing or compiling php but getting a pre-built package that includes apache, mysql, etc. called xampp. The problem was that they didn't have it setup right. The quick solution was to use a package called easyphp instead http://sourceforge.net/projects/quickeasyphp/ which has support for sqlite 3 already setup. The documentation on using the pdo for sqlite is found here http://us.php.net/manual/en/ref.pdo-sqlite.php

Thanks again for your help sub and I hope this little bit of information helps other people (not just people working on gbpvr stuff) out.

And keep up the great work with gbpvr everyone!!!!!

[sub]

Thanks for posting the follow up.