According to the manual the second and third parameters of sqlite_open
are optional and apparantly the mode value is ignored. Out of
interest, I tried them anyway and; running via CLI fails again with;
''Call to undefined function: sqlite_open()'
But running via apache this time fails with;
'Wrong parameter count for sqlite_open()'
I did a syntax check (lint) and all is ok. I'm running on an ext3
partition with php version 4.4.0.
Thanks,
Eoin.
On 10/31/05, Jackson <captaincracker@xxxxxxxxx> wrote:
> Also, I just took a closer look at your syntax. I'm not familiar with sqlite
> query syntax, but I think you may have some syntax errors. -Jackson
>
>
>
> On 10/31/05, Jackson <captaincracker@xxxxxxxxx> wrote:
> >
> > Eoin, I'm wondering if the problem isn't in your sqlite_open function. If
> I recall rightly, it can take more parameters, specifically, a mode
> parameter in octal. Zend.com manual on sqlite functions recommends a mode
> value of 0666. Also on the Zend site is a tip about running SQLite databases
> on NFS paritions. I don't know what sort of server configuration you've got,
> but apparently NFS causes locking problems that can prevent you from even
> opening the database. That you're getting errors about calls to unknown
> functions is concerning, but I don't have a good offering about it, just
> seems like PHP is not supporting your sqlite functions. Are you running PHP
> 4 or 5? If I recall, SQLite functions are not part of PHP 4. Maybe that's
> the problem? I really don't know.
> >
> > Good luck!
> > Jackson
> >
> >
> >
> >
> > On 10/30/05, Eoin Hennessy <eoin.hennessy@xxxxxxxxx > wrote:
> > > Ahh, I'm not very familiar with php, should have looked into the
> > > effects of the '@' symbol. Once removing the symbols, running via CLI,
> > > it fails with;
> > >
> > > 'Call to undefined function: sqlite_open()'
> > >
> > > whereas, running via apache, it fails with;
> > >
> > > 'Call to undefined function: sqlite_query()'
> > >
> > > I have sqlite and sqlite_php installed and enabled in php.ini (there's
> > > an entry under phpinfo()).
> > >
> > > Any ideas why it may be failing? Thanks again.
> > >
> > > On 10/30/05, JeRRy < jusa_98@xxxxxxxxx> wrote:
> > > >
> > > > Hi,
> > > >
> > > >
> > > >
> > > > Errors are more than likely not being produced because of the '@'
> symbol. Try removing this and see how you go. Also check your code for
> syntax errors. These will be produced within the errors.
> > > >
> > > >
> > > >
> > > > J
> > > >
> > > >
> > > >
> > > > ---------------------------------------------start of
> message-------------------------------------------
> > > >
> > > >
> > > > Hello, I have the following very basic sqlite test harness:<?php
> $dbconn = @sqlite_open('testdb'); if ($dbconn) { @sqlite_query($dbconn,
> "CREATE TABLE test_table (test_id INT);");
> @sqlite_query($dbconn, "INSERT INTO test_table VALUES
> (100)"); $result = @sqlite_query($dbconn, "SELECT test_id FROM
> test_table"); var_dump(@sqlite_fetch_array($result,
> SQLITE_ASSOC)); } else { print "Connection to database failed!\n";
> }?>When running via CLI the script goes into 'sqlite_open', but nevercomes
> out, i.e. none of the rest of the code is hit. When running viaapache and
> mod_php, it gets out of 'sqlite_open' with a validconnection but never comes
> out of the first 'sqlite_query' call.It does this without any errors or
> warnings. The database file ispresent with correct permissions. I'm running
> a standard php install.I am using: php 4.4.0 sqlite 3.2.7 sqlite-php
> 0.0.5Any ideas where things are going wrong? Or perhaps tips on
> improvingdebug output. Any help would be
> > > > appreciated,Eoin.
> > > >
> > > > ------------------------end of message-------------------
> > > >
> > > >
> > > >
> > > > ---------------------------------
> > > > Do you Yahoo!?
> > > > Find a local business fast with Yahoo! Local Search
> > > >
> > >
> > > --
> > > PHP Database Mailing List ( http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> > >
> > >
> >
> >
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
