QuickStart and creating a SQLite database

[Steve Horejsi]

 I am getting a failure while trying to create the demo database:

Writing Database Guestbook in (control-c to cancel):
AN ERROR HAS OCCURED:
SQLSTATE[HY000] [14] unable to open database file

 I can't seem to find any logs anywhere that would tell me what is failing. I have he perms on the whole QuickStart directory tree set so that Apache is the Group owner and has read/write.

 Where next?

[Steve Horejsi]

 Nothing quite like answering your own posts.

 I got this figured out; you need to create the directory structure where the database file will land and give it the correct permissions. Neither the directory structure nor the perms were in the tutorial.

 So now I have worked my way through the complete tutorial and I am left with several questions.

 First, the QuickStart was less than 'turnkey'. If the intent was to lead people by the hand through the whole process, it did not completely succeed. There were several places where this was true:

 - Example code that did not say what file name (or file path) to place it in.

 - Directory and permission issues like the SQLite database creation challenge.

 - Did not mention that both PDO and PDO_SQLITE would be necessary.

 On the other hand, these omissions DID force me to dig into the documentation and examine the traces to resolve my own problems. I learned a lot more about ZF than I would have by simply copying code into files and watching it magically work.  That said, had I not been the cantankerous sort who refused to let a little demo code derail my attempts, I might well have given up and written it off as incomplete or unusable.

 So the end result is that while I am convinced that ZF is a great product and right for my needs, I am torn as to whether the QuickStart documentation needs to be 'fixed' or whether it is exactly the right degree of 'broken'...


        -=[ Steve ]=-

Steve Horejsi wrote:

 I am getting a failure while trying to create the demo database:

Writing Database Guestbook in (control-c to cancel):
AN ERROR HAS OCCURED:
SQLSTATE[HY000] [14] unable to open database file

 I can't seem to find any logs anywhere that would tell me what is failing. I have he perms on the whole QuickStart directory tree set so that Apache is the Group owner and has read/write.

 Where next?

[SeanG]

Hi Steve,

I have to agree with you that the Quickstart isn't totally perfect. In particular, there were places where code was added but not referenced until a step or two later. And there were a few times where I had to open up the source code of the example project to see just what I was supposed to do, and what was going on. Another example of this sort of issue was that one of the database queries used "->where(1)", and didn't explain why.

All that being said, the Quickstart is the best tutorial I've found on ZF so far. It seems like ZF still has a ways to go in terms of documentation and tutorials.

Steve Horejsi wrote:

 First, the QuickStart was less than 'turnkey'. If the intent was to lead people by the hand through the whole process, it did not completely succeed. There were several places where this was true:

[zig]

Hello,

you must create these files (in my configuration):
touch /var/www/QuickStart/data/db/guestbook.db
touch /var/www/QuickStart/data/db/guestbook-dev.db
touch /var/www/QuickStart/data/db/guestbook-testing.db
a+

Steve Horejsi wrote:

 I am getting a failure while trying to create the demo database:

Writing Database Guestbook in (control-c to cancel):
AN ERROR HAS OCCURED:
SQLSTATE[HY000] [14] unable to open database file

 I can't seem to find any logs anywhere that would tell me what is failing. I have he perms on the whole QuickStart directory tree set so that Apache is the Group owner and has read/write.

 Where next?

[d.taylor]

Yes I totally agree with the comments here, it is very time consuming to get things to actually work, tutorials need to be QA... also, I had to figure that the data.sqllite.sql and the schema.sqlite.sql need to be inside the library so that they are at the same level as the Zend folder.

thank for you answer I was having that exact creation issue..

DT

Steve Horejsi wrote:

 I am getting a failure while trying to create the demo database:

Writing Database Guestbook in (control-c to cancel):
AN ERROR HAS OCCURED:
SQLSTATE[HY000] [14] unable to open database file

 I can't seem to find any logs anywhere that would tell me what is failing. I have he perms on the whole QuickStart directory tree set so that Apache is the Group owner and has read/write.

 Where next?

[weierophinney]

-- d.taylor <danielsltaylor@...> wrote
(on Wednesday, 03 June 2009, 06:49 PM -0700):
> Yes I totally agree with the comments here, it is very time consuming to get
> things to actually work, tutorials need to be QA... also, I had to figure
> that the data.sqllite.sql and the schema.sqlite.sql need to be inside the
> library so that they are at the same level as the Zend folder.

They shouldn't need to be -- they were tested in the location where they
currently reside. Can you give me some details on your OS and PHP
version?

> thank for you answer I was having that exact creation issue..
>
> DT
>
>
> Steve Horejsi wrote:
> >
> >  I am getting a failure while trying to create the demo database:
> >
> > Writing Database Guestbook in (control-c to cancel):
> > AN ERROR HAS OCCURED:
> > SQLSTATE[HY000] [14] unable to open database file
> >
> >  I can't seem to find any logs anywhere that would tell me what is
> > failing. I have he perms on the whole QuickStart directory tree set so
> > that Apache is the Group owner and has read/write.
> >
> >  Where next?

--
Matthew Weier O'Phinney
Project Lead            | matthew@...
Zend Framework          | http://framework.zend.com/