File permissions on a sqlite file

PHP
1

Not really sure if this the right place to post but it is driving me mad and any answers or clues to the solution would be greatly appreciated.

I have installed Zend on my local pc, set it up on xampp, configured php.ini and setup a virtual host.

I am running through the quickstart tutorial and I am running the setup php file from the cmd line but I just get an error, I can create the database file but I can not write to it, and when the file has content, it just deletes it.

I am figuring this is a windows file permissions thing but I can not sort it out to save my life, I am running windows vista btw.

2

One should never “figure”.
There are error messages to inform you of exact problem.
Go for permissions only if you have an error message that says “Permission denied”.

What exact error message you’ve got?

3

It runs my first piece of sql with out error although it does not actually create anything

CREATE TABLE guestbook (
	id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
	email VARCHAR(32) NOT NULL DEFAULT 'noemail@test.com',
	comment TEXT NULL,
	created DATETIME NOT NULL
);

CREATE INDEX "id" ON "guestbook" ("id");

and my second piece of sql

INSERT INTO guestbook (email, comment, created) VALUES
	('example@example.com',
	'Hello this is my test data blah blah etc',
	DATETIME('NOW'));
	
INSERT INTO guestbook (email, comment, created) VALUES
	('example1@example1.com',
	'Two comments in my database',
	DATETIME('NOW'));

this runs but throws the error general error 1: no such table: guestbook

I open the database file and it is blank.

I also get a warning when i try to run this code

chmod($dbFile, 0666);

the error is: Warning: chmod(): no error in: c:/path/to/file

I am following the tutorial from zend: http://framework.zend.com/manual/en/learning.quickstart.create-model.html

and it says ‘On Windows, you will need to create the directories in Explorer and set the permissions to allow anyone to write to the directory.’